RE-Using passed parameters

Hot Topic

Upgrading a Search Procedure
Retrieving a piece of datalogged equipment by most recent time
distributed transaction query with a loopback linked server: limitation
International Characters
Add Temp Parameters to a function
Date dimension Sort order
Merge disparate queries into raw file
Do I really need a snapshot (to initialize transactional replication, in SQL2000)?
password expiry with HTTPS merge replication
Upgrade msdb database from CTP April build

SQL Server

Quick Question Importing
surface area configuration won't run
Timeout expires when deploying assemblies in SQL Server 2005 June CTP
Semi-additive measures in AS2005 Standard Edition
SSIS issues
SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call
What are the current best practices for standardizing report layout and appearance?
RDA Pull Error table
SP1 Database Services failed to install
How do you return query results in a streaming table-valued function?

RE-Using passed parameters

Hi All

 I link to a report passing parm a,b,c (3 parms) a (Hidden), B(Multi Selection), C(Single selection), the report display correctly  and the parm selection boxes display with available options.

I would like to be able to choose from the selection boxes and replace the initial (passed parameters) B and C would have a new value, and display the same report using the selected criteria.

Thank you

Trentino

 

 



Answer this question

RE-Using passed parameters

  • EddieBear

    I can't understand what you are asking. You want to link to the same report with new parameter values Or you want to just select different values Maybe another example would help.

  • EmilioFerreira

    Hello Brian,

     

    I've read your previous reply about forward dependencies and I was hoping you'd hear my plee.

    I am using Visual Studio 2005 and I'm passing a single parameter (a unique string called AuditGUID) to a report and this single parameter is part of a multivalue list (select box) of many AuditGUID's. This returns a lot of information related to that unique AuditGUID.

    When I set the parameter to use a select box, the error says the following:

    [rsInvalidReportParameterDependency] The report parameter ‘Audit_GUID_par’ has a DefaultValue or a ValidValue that depends on the report parameter “Audit_GUID_par”. Forward dependencies are not valid.

    But, when I change the select box to a textbox, where the user  would have to enter a Audit_GUID (which is a very long and complicated string), then the report compiles successfully and works...but I can't allow users to have to go through this, I'd rather let them select it from a list (selectbox). Could you help me with this please

    Thank you for your time and I look forward to hearing from you.

    Jean

  • MrNoBody

    Hi Brian

    I like to select different values.

    report A link to report B using parm1 and parm2.

    Parm1 passes value 'A', parm2 is spaces (space is interpreted as select all records

    matching the other criteria, ex. if there are 5 records all of them will be retieved), the new report storedProc  retrieve the data that I would like to use to initialize parm2.

    I cannot initialize parm2 with the result value from  the SP (5 records value), I get forward dependencies are not valid.

    Currently I created a new parm3, initialize it with the SP values, I can select 1 or more of the 5 displayed records (multi value box) and that work ok.

    Is there a way to re-use parm2 without adding parm3 so no changes need to be done to the SP

    Hope this help you understand, thank you for your time.

    Trentino

  • Charlotte L

    You probably have based the Valid Values list query used for parm 2 dependent on parm2. This is a circular reference. You need to have the 3rd report parameter and you use the second one as a seed value.

  • RE-Using passed parameters
Answer this question