AspWebSolution Forums » Products » ASP Report Wizard v2 » pass multiple parameters from one report to anothe

index | search | no replies | posting guidelines | help

» »

:: pass multiple parameters from one report to anothe :: (2)

Dec 26 2006, 11:16 AM

pass multiple parameters from one report to anothe

holyschmidt

from: Florida User selects a start date and end date for a summary report of sales of a product. I want the product to link to another report for the detail. The product can be a link to another report but only gives me the option of one parameter. How can i pass the summary start date and end date to the linked report?

Dec 28 2006, 6:15 AM

Re: pass multiple parameters from one report to...

Post a Reply

ghost

from: Washington, DC Parameters are added to a report using the report filters as shown here

http://aspwebsolution.com/products/report_wizard/t_params.htm

To connect to a report that has parameters from another report, you will have to format the field name using the Insert Hyperlink as the text format in the Add Field Captions Screen of the Report Builder Wizard.

When prompted for the the link url, enter it as follows:

REPORTS_FILE_NAME?rid=REPORT_ID&n_PARAM1={{FieldName1}}&n_PARAM2={{Another FIeld Name}}

e.g.reports.asp?rid=Orders&n_custid={{CustomerID}}&n_empid={{EmployeeID}}

Note that the parameter names are prefixed with an underscore "_"

-------------------------
Ghost

Pages: (1) [1]