SSRS Report Subscription Parameters based on Type (Monthly, Daily)
I created a new parameter DateIntervalType as mentioned in the post http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a44e023c-ac37-4060-bc01-d7096626b276/ When I tried to use that I am getting an error "An error occurred during local report processing. arg_begin_date" In the arg_begin_date properties for the "default values", I have this expression defined.. =Switch( Parameters!DateIntervalType.Value="D",ToDay(), Parameters!DateIntervalType.Value="M",ToDay().AddDays(-30) ) What is wrong with this?
June 4th, 2012 6:15pm

Hi There I could not regenerate your issue in my test environment. I hope if you deploy this report this report might work on report server. The date format in Preview mode in Report Designer is determined by the culture of the operating system, while the date format in the report manager depends on the culture of the browser. Please have a look on this thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/32b62d3c-9a32-41bd-b7ad-95c3b89a7668 If you have any questions please ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2012 7:03pm

I tried to publish it and I get an error arg_begin_date (rsReportParameterProcessingError) My other parameter arg_begin_date is of type Date/Time and date format is MM/dd/yyyy.
June 4th, 2012 11:48pm

Hi There can you please try this one =Switch( Parameters!DateIntervalType.Value="D",Now.Date(), Parameters!DateIntervalType.Value="M",Now.Date().AddDays(-30) ) =Switch( Parameters!DateIntervalType.Value="D",Now.Date(), Parameters!DateIntervalType.Value="M",Now.Date().AddDays(-30) ) Please also see What is the detailed error message in the logs of the report server. Please make sure that the date format in report Server is same as the MM/dd/yyyy. You may try a SQL statement on report server to check it. Many Thanks Syed
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2012 11:56pm

I see this error Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: arg_begin_date, ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: arg_begin_date chunks!ReportServer_0-2!cc0!06/05/2012-08:15:08:: w WARN: Rolling back shared chunk transaction for snapshot 'e933febb-12aa-4ee7-8e72-d88ab69b32e3', Permanent=True.
June 5th, 2012 9:29am

Just to verify my switch statement, I tried this and it worked fine.. =Switch("D"="D",ToDay(), "D"="M",ToDay().AddDays(-30) )
Free Windows Admin Tool Kit Click here and download it now
June 5th, 2012 1:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics