Report variable and interactive sort

• Joey Braaten

  Mr or Mrs. 500

  Points: 549

  More actions

  December 18, 2009 at 9:26 am

  #217717

  I would like to display the names of the shared data source in the report header that a particular report points to. I found that if I use the expression DataSources("DataSource1").DataSourceReference it gets me close. Here's the problem.

  1. Create a report with data source, DataSource1, pointing to a shared data source called "Test".

  2. Create a text box in a report header with the following expression, DataSources("DataSource1").DataSourceReference.

  3. Deploy report to report manager and point report to shared data source called "Prod".

  4. Execute report. Data source textbox shows "Prod" as expected.

  5. Hit a toggle button, interactive sort, etc. to find the Data source textbox now shows "Test".

  Now I thought I would try to be clever and create the expression as a report variable. Then have the report header textbox reference the variable. This solves the problem with it showing "Test" when I hit a toggle. However, the problem still exists when I choose any interactive sorting.

  Have I misunderstood how report variables work? I'm under the impression that the variable is captured only at the initial runtime. And before anybody asks, I do have the DeferVariableEvaluation property set to False.

  Thanks,

  JB

• Joey Braaten

  Mr or Mrs. 500

  Points: 549

  More actions

  February 11, 2010 at 2:16 pm

  #1117774

  Any thoughts on this? We are still struggling for a solution.

  Thanks,

  jb

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  February 23, 2010 at 11:53 am

  #1123800

  Hi,

  I am not sure what ur looking for exactly ,i hope below url gives basic info on report variables..

  http://blogs.msdn.com/sqlrsteamblog/archive/2008/07/21/group-variables-in-reporting-services-2008.aspx

  Thanks

  Veeren..

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉