Adding parameter values to report. 1

[ps32208]

Hi,

I have set a few reports up on my database from queries which have parameters. Does anyone know how to add the parameter value to the report so that when the report is run it can be seen on the report which parameters were chosen and therefore what parameters the report represents...

Any suggestions would be welcomed greatly.


Pete.

 

[lupins46]

If your query has a parameter such as [Enter value] then in the query grid add an extra column.

param1:[Enter value]

Make sure the text between the [ ] is exactly the same as it is in the criteria cell.

 

[ps32208]

Thanks, I have just tried your suggestion but it returns -1 in the report:

param1: [Enter Start Date (Jan 2004 = 200401)] And [Enter End date (March 2004 = 200403)]

I want this to work on a chart report type but can not activate the field list box to insert the field param1...

 

[PHV]

param1: [Enter Start Date (Jan 2004 = 200401)] & " And " & [Enter End date (March 2004 = 200403)]


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ps32208]

thanks, that worked in a table format report.

However, I want to show the values in a chart report, so I only want to show this Parameter value once. How do I add the fields Param1:... if I can't open the field list?