Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport links - parameter prompted twice

Status
Not open for further replies.

rw409168

Programmer
Jul 16, 2009
95
GB
Greetings,

I've migrated a series of pre-written reports over to another server (exact same version CR XII, R2). Whereas 99% of them run fine by uploading them and making sure I export the business view I have one with a subreport issue.

The reports contains several subreports which link onto parameters on the main reports.

For all but one field this works perfect, however one param when previewing the report from CMC or Scheduler you are prompted for a value, previewing the main reports with the subreports in reports designer does not prompt for this value.

This is both expected and unexpected, unexpected as if it works from one server it should run fine on another.

Expected as the sub report links dont appear to be setup correct for this one parameter.

The other paramters are linked to parameter name and not the ?pm-Fieldname which I believe resolves the prompting issue.

Why would this field not have the choice and only ?pm-Fieldname is in the Sub report patameter field to use list?

Also are the pm-Fieldnames created by default? I tried simply renaming the sub report parameter, this then gives two choices but prompts for the ?pm-Fieldname value?

I tried to delete the sub report parameter, removed ref in record expert selection but it states its used elsewhere but I cant see any other reference.

Any hint or tips would be appreaciated, thanks!
Rob






 
Are you saying that the dropdown in the lower left corner of the subreport linking expert does not show {?fieldname}? Do you see {?fieldname} in the subreport? Is it used in the selection formula in the subreport?

-LB
 
You should also make sure that the parameters are of the same datatype in both main and subreport.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top