I am using SSRS 2005 with Enesys Add on Tool for reports.
I have used date format as "dd-MMM-yyyy" in the application and used the same in the report.
Issue : 1
I want to convert this format into a format where i can sort the date fields as and when exported to excel sheets.
Issue : 2
Some of the values are null and when exported to excel cant see the null values. I am using Format function in the conversion so that if the value is nothing, show nothing or show the value.
Need to resolve this as when the report is exported to excel i can see null values or squares in the columns when applying filters.
Issue : 3
The input paremeters are refreshed everytime i select a new value in other parameters. There is no dependency on the input parameters.
Please help me out in resolving these issues ASAP.
Need to submit these today EOD.
Thanks in Advance.
View Complete Post