Generic option for passing value in allreports of a report project

• santhu_smily

  Say Hey Kid

  Points: 696

  More actions

  October 29, 2008 at 9:24 am

  #214641

  Hi,

  I created a report which will give you data of charts in excel format of report by using 'Export to excel' render functionality directly by clicking on a text in the main report.

  In detail:

  Let us report-A is having 3 charts. i have to get data of these charts.

  so, i created report-B having the data of these charts .

  Now, i wrote an expression for a text box in report-A which will render the export to excel of report-B directly clicking on this text in report-A.

  Expression:

  ="http://reportserver?/reportfolder/reportname&Parameter1=" + Parameters!Parameter1.Value + "&rs:Format=Excel"

  Problem:

  Now i have multiple reports and may use different servers in using this functionality.

  Is there any generic option( like ..passing a global variables for all reports) to limit the rework (changing reportserver,reportfolder for every report before deploying )in developing the reports.

  something like...

  =variable1.value//reportname&Parameter1=" + Parameters!Parameter1.Value + "&rs:Format=Excel"

  Thanks in advance,

  santhu.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 29, 2008 at 9:48 am

  #891310

  Duplicate post. Please answer here: http://www.sqlservercentral.com/Forums/Topic593709-1063-1.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question