Application need Date without Time

Hello,

We are managing industry standard application for solvent business need and it is working fine as per requirement but after replication we got some problem with date type data.

We have stored date data through application in dd/mm/yy format only, we didn't used time data so it is truncated in overall application but after implementation for replication (Merge Model) from multiple location some date field automatically get time with date value, so some time application not retrieving data from database owing to stored time with date.

How I can resolve this issue I didn't get any solution in short way.

Thanks in advance to every particapetience.

R.MallYou do know that datetime data always stores both. right?

If no time is supplied the default time is 0, or midnight.

Append two results in MDX

I have a requirement where I need to display the total count of the population by Gender and Race (both dimensions) in one report. The layout will look something similar to …

Count1

Count2

…

Male

Female

American Indian or Alaska Native

Asian or Pacific Islander

Black, non-Hispanic

Hispanic

White, non-Hispanic

In simple SQL terms this can be achieved by UNION ALL clause,

Select Gender, Count1, Count2…From Table1 Group by Gender

UNION ALL

Select Race, Count1, Count2…From Table1 Group by Race

How can I get similar results in MDX or Reporting Service?

Thanks

In MDX you cannot mix different members in one column, so you would have to end up at a set that looked like the following:

Count1

Count2

…

Male - All Races

Female - All Races

All Genders - American Indian or Alaska Native

All Genders -Asian or Pacific Islander

All Genders -Black, non-Hispanic

All Genders - Hispanic

All Genders - White, non-Hispanic

Which you would do with a query like:

SELECT {Measures.Count1, Measures.Count2} ON COLUMNS

{

[Gender].[Gender].[Gender].Members * {[Race].[Race].[All] }

,{[Gender].[Gender].[All]} * [Race].[Race].[Race].Members

} ON ROWS

FROM [Cube]

append date to exporting file name in SQL reporting service

When exporting a report to another format, say excel,PDF; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to pdf, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services ?

example : Report name : Testreport

Exported file should be : Testingreport-November-22-2007.pdf

please help me in this

Thanks
sukuTry here:

http://www.codeproject.com/sqlrs/PDFUsingSQLRepServices.asp|||I would suggest placing the timestamp inside of the report.
ie. "Report was generated November 22 2007 11:01am".
This way the client cannot change the "report date".

Because it is a PDF and thus you won't be editing the document you can sort it by "Date Modified" in explorer if you want to sort the files.

append date to exporting file name in SQL reporting service

When exporting a report to another format, say excel,PDF; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to pdf, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services ?

example : Report name : Testreport

Exported file should be : Testingreport-November-22-2007.pdf

please help me in this

Thanks
suku

Quote:

Originally Posted by sukumaster

When exporting a report to another format, say excel,PDF; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to pdf, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services ?

example : Report name : Testreport

Exported file should be : Testingreport-November-22-2007.pdf

please help me in this

Thanks
suku

Please post the over all operation you are trying to perform?
Are you trying to use shell script to ftp the file to any other server?
If Yes, then renaming a file would become easy!!