Post reply

Is there any Generic option for passing values to all reports in the report project

  • October 29, 2008 at 9:29 am

    #200414

    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.

  • October 29, 2008 at 10:14 am

    #891340

    Don't think so, but perhaps there's a workaround. You could potentially have all reports run the same query to get "variables" from a table. Something like

    create table ReportVars

    ( vartype varchar(10)

    , varvalue varchar(80)

    )

  • October 30, 2008 at 9:37 am

    #891914

    Hi,

    I got solution for this.

    Use the Built-in fields in the report.

    ex: Reportserverurl

    expression: =Globals!Reportserverurl/Globals!Reportfolder/Globals!ReportName+ "&rs:Format=Excel"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply