sql server reporting services: Report Fails on Server but Works In Designer -- sql server reporting services

Report Fails on Server but Works In Designer

Mike Harbinger
5/26/2006 8:17:24 AM

sql server reporting services:

Using SQL RS 2000

My report runs fine in the designer but when deployed to the server it will
only display the first page. When move to page 2 or the last page it gives
the error:
"An unexpected error occurred in Report Processing. (rsUnexpectedError) "

The RS log shows it to be failing here:
Call to RenderNext.....
ASSERT: Assertion failed!.....

Also, the report calls a subreport and if I remove the subreport it works
fine. What could be different between the execution in the Designer vs the
web server?

Thanks

(Sorry for the double post)

Re: Report Fails on Server but Works In Designer

Mike Harbinger
5/26/2006 12:21:08 PM

I found the problem and apparently this is a bug in RS where if your report
has any textbox 'hiding duplicates' AND the report is calling a subreport,
it will fail as indicated below.

My solution was to remove the use of "hiding duplicates" and instead add the
following to Visibility\Hidden property of each TB you want to suppress; the
scope is the current group
=Iif(Rownumber("table1_grPaymentID") <> 1, True,False)

This will then display the textbox only for the fist row in the group

Hope this helps someone.

[quoted text, click to view]