Winforms.ReportViewer NOT evaluating expressions - Webforms.ReportViewer IS evaluating expressions - please help!

• Mike Forrest

  Newbie

  Points: 5

  More actions

  June 7, 2011 at 4:55 pm

  #241038

  Hello there,

  Long time listener - first time caller!

  I've got an issue where a .RDL report (remote processing) running on SSRS 2005 will render with expression evaluated when viewed via web browser:

  eg. http://my-server/ReportServer/Pages/ReportViewer.aspx?/Group%20Reports/Report_Lines&rs:Command=Render

  ...however... when run inside a C# app (via Microsoft.Reporting.WinForms.ReportViewer control) seemingly the report renders WITHOUT evaluating the expressions built into the report.

  *of note:*

• myReportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
• The expressions are generally of a conditional formatting nature - color changing dependant on value etc etc.
• As far as I can tell (I've spent a few hours Googling / MSDN / looking here etc) the issue is down to trust / credentials when running the expression eval at the server end.
• Also, here are the differences in ReportServer_.log when calling the report:

WEBforms

-=-=-=-=-

w3wp!library!7!06/07/2011-11:10:47:: Call to GetPermissionsAction(/Scorecard Reports/Report_Lines).

w3wp!library!7!06/07/2011-11:10:48:: Call to GetPermissionsAction(/Scorecard Reports/Report_Lines).

w3wp!library!7!06/07/2011-11:10:48:: Call to GetPermissionsAction(/Scorecard Reports/Report_Lines).

w3wp!library!7!06/07/2011-11:10:48:: Call to GetPermissionsAction(/Scorecard Reports/Report_Lines).

w3wp!library!7!06/07/2011-11:10:48:: Call to GetPermissionsAction(/Scorecard Reports).

w3wp!library!7!06/07/2011-11:10:49:: Call to GetPermissionsAction(/Scorecard Reports/Report_Lines).

w3wp!library!7!06/07/2011-11:10:49:: Call to GetPropertiesAction(/Scorecard Reports/Report_Lines, PathBased).

w3wp!library!7!07/06/2011-11:10:59:: i INFO: Call to RenderFirst( '/Scorecard Reports/Report_Lines' )

w3wp!library!7!07/06/2011-11:11:01:: i INFO: Call to RenderNext( '/Scorecard Reports/Report_Lines' )

w3wp!cache!7!07/06/2011-11:11:01:: i INFO: Session live: /Scorecard Reports/Report_Lines

w3wp!library!1!07/06/2011-11:11:03:: i INFO: Call to RenderNext( '/Scorecard Reports/Report_Lines' )

w3wp!cache!1!07/06/2011-11:11:03:: i INFO: Session live: /Scorecard Reports/Report_Lines

w3wp!library!1!07/06/2011-11:11:03:: i INFO: Call to RenderNext( '/Scorecard Reports/Report_Lines' )

w3wp!cache!1!07/06/2011-11:11:03:: i INFO: Session live: /Scorecard Reports/Report_Lines

w3wp!library!1!07/06/2011-11:11:04:: i INFO: Call to RenderNext( '/Scorecard Reports/Report_Lines' )

w3wp!cache!1!07/06/2011-11:11:04:: i INFO: Session live: /Scorecard Reports/Report_Lines

w3wp!library!1!07/06/2011-11:11:31:: i INFO: Call to RenderFirst( '/Scorecard Reports/Report_Lines' )

-=-=-=-=-

...vs...

WINforms

-=-=-=-=-

w3wp!library!7!06/07/2011-11:13:08:: i INFO: Call to RenderFirst( '/Scorecard Reports/Scorecard_Report' )

w3wp!webserver!7!06/07/2011-11:13:08:: i INFO: Processed report. Report='/Scorecard Reports/Scorecard_Report', Stream=''

-=-=-=-=-

Basically, I'm happy to go log trawling for more info - but am stuck as to where to look.

Has anyone got a clue for me on where to look next?

tl;dr: Winforms.ReportViewer NOT evaluating expressions - Webforms.ReportViewer IS evaluating expressions - please help!

Cheers.

Mike