Can't Link a Sub-report that uses a command object

[alexfromuno]

My problem is kind of like the problem displayed in thread766-836891.

Using CR 9.2 ……………Oracle 9i

I have a very complex SQL statement imbedded in a Command Object in a sub-report. It took me many hours to write this SQL, since it uses some very ‘hairy’ logic. Anyway, the parameter for this SQL is a number. (I re-verified after reading thread above.) The parameter in the main report is a number. When I click go to Change Sub-report links and click on the parameter in the Main Report to use it to link to the parameter in the sub-report, I do not see the parameter in the sub-report as an option to select. I’ve tried putting the parameter in the sub-report in the Report Header; I’ve tried putting the parameter on the Detail line. It does NOT show up in the list of fields to choose from. Period. The fields that do show up are all number fields, which is very strange.

Anyone have any suggestions? I’m stumped.

Alex

 

[satinsilhouette]

Try building a secondary formula only to display the field you need to link on, see if you can see that. Then do the parameter link on it.

 

[alexfromuno]

satinsilhouette,

I tried that early in the process. When I fire off the main report I still get under 'Enter Parameter Values' 2 parms to input. Parm # 1 for the main report and parm # 2 for the sub-report.

What am I still doing wrong?

alex

 

[lbass]

I've seen something like this happen when the number formats didn't match (if I'm remembering correctly), and I think it may have happened to me once when I copied a parameter from another report. I would try removing the parameter from the main report, deleting it, and recreating it. Then try to link again. Not sure it will help, but it might.

I did just set up a quick report with a number parameter in a commmand in a subreport and successfully linked it to a number parameter in a main report, although this was in XI.

-LB

 

[alexfromuno]

Thanks for the input. Unfortunately, that didn't work either.

I'm at my wits end of how to make this work. I guess I could try and import the whole report into XI and see what I get.

alex

 

[satinsilhouette]

I have seen this also. XI is not releasing the first Parm from the reports even though you have deleted them.

Did you save and close the report after you had deleted the parameter, then closed completely out of Crystal, gone back in, for some reason this clears RAM. You might be able to recover and build a new parm.

 

[alexfromuno]

satinsilhouette,

Thanks for your input. I tried all the above in CR9 and STILL nothing. I even went so far as to create a formula called passed_parm that just has the input_parm_id in it as the only entry and removed the input_parm_id entry in the parm area. Still doesn't work!!!

at wit's end,

alex

 

[lbass]

Try a new report containing a parameter and where you copy your existing command into a new command object in a subreport. Then see if the linking it works. I've had trouble when adding number parameters to existing commands which have multiple parameters, and sometimes recreating the command from scratch works.

-LB