SSRS Report - Changing Start Date Parm Causes Failure

Dom 751

I have an SSRS report that is set up to run with a default START date of the first of this year.

=DateAdd("d",-DatePart(DateInterval.DayOfYear,Today,0,0)+1,Today)

Works fine. User wants it now to start at 01.01.2014. Sounds soooo simple but I have spent hours to no avail. If I run the report from the SSRS portal and then change the start date manually to 01.01.2014, it runs just fine. In VS, I open the RDL and go to modify the Start parm as follows:

=cdate("01/01/2014")

I get this ridiculous error :

2023-03-25 19_15_39-Window

It successfully changes the parm, but I am not willing to deploy until I can see successful results. Again, running the report from the SSRS portal with the exact same parameters works fine. Please advise how to correct.

Tianyu Sun-MSFT 27,356 Reputation points Microsoft Vendor

2023-03-27T09:16:47.2566667+00:00

Hello @Dom,

Welcome to Microsoft Q&A forum.

Maybe there’s too much data. If you try to set the start time to a date closer to now, or if you set to another date, will this error appear?
Dom 751 Reputation points

2023-03-27T14:21:32.46+00:00

Very strange. Yes it will run in VS with a shorter date range. Yet, I can run the full date range if I submit from the SSRS web portal. It is usually the other way around - a report will fail on the portal and I have to run it from within VS. Is this a function of the memory on my PC or a limitation of VS itself?
Tianyu Sun-MSFT 27,356 Reputation points Microsoft Vendor

2023-03-28T08:55:49.8533333+00:00

Hi @Dom,

Thanks for your reply.

I don’t think VS itself has such a limitation. The error message does mention "The server did not provide a …", I am considering if some settings are needed to modify on server side, perhaps for memory usage settings.

Besides, is this document: Configure Available Memory for Report Server Applications helpful?
Dom 751 Reputation points

2023-03-28T13:06:21.24+00:00

Thanks. Our server is managed by an outside company so I don't have access to those settings. I'll reach out to them.
Tianyu Sun-MSFT 27,356 Reputation points Microsoft Vendor

2023-03-29T09:56:51.12+00:00

Sure, feel free to let us know if there’s any update.