View Complete Post
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.
Is it possible to declare separate report parameters in SSRS 2005 as Date and Time?
I want the user to be able to enter a date and a time.
When I declare the parameters in my stored procedure as datetime, in SSRS the parameter just shows as a Date only.
I have a question.
How do we define date output parameters for a stored procedure?
before you answer,I should mention that I am not referring to the sql syntax definition ,which is @mydate datetime output.
This is ok,what i am asking is HOW DO I SPECIFY IT IN LINQ WHEN I NEED TO CALL THE STORED PROCEDURE IN THE SERVER SIDE CODE.
I am repeating that I do I am not referring to the sql definition .
I would appreciate your help.
Hello, I have a database field that I am pulling that is type string, but the format of each value is mm/dd/yyyy. I want to convert this to a datetime format (minus the time) so that i can compare this value to a parameter date range (begin date and
end date) that are type datetime so that i can use the calendar control in my report. i've tried in my select statement to use select.....convert(datetime, stringfieldname, 101), but I get an error that says "Conversion failed when converting datetime
to character string".
I am also open to converting the datetime parameters to strings to do the comparison, but not sure the best way to do this either.
Can we change the date format in the default parameters pane.(For eg : When we create a new parameter and select datatype as date time in report parameters.)
Default settings for this date picker control is mm/dd/yyyy.
I need to change the date to dd/mm/yyyy.
Is it possible to the change this date format to dd/mm/yyyy or any other custom format?
Thanks in Advance.