Parameter prompt is displayed before showing the report

[maas]

Hello team,

I need your assistant in stopping the report no. parameter prompt in my main report. In my report, I am having a table which it is called {engine}.It has a field called {rptno} which it auto generates the report no. once it is running. I defined a parameter called “ReportNumber” and its type is Number and then in the select expert I defined that

{engine.rptno} = {?ReportNumber}



However, when I am running the report, it is prompting me to enter the ReportNumber parameter. I tried to remove the parameter and to run the report, however it worked fine, but I need to pass the rptno.



So, can you please assist me in solving the issue and I am using crystal report 2011.

 

[kray4660]

I am seriously confused. A parameter is designed so that you can pass a value to the report (either just for display purposes, for a filter, to be used in a formula, etc.), thus before the report is generated, it prompts you for a value.

 

[maas]

Yes I am passing the report no. to the report so it will display the proper values which is generated from the engine table

 

[kray4660]

I am not certain, but I think you just need to do some table linking or at worst case, have a main report and a sub report where the values for the sub report are supplied from the {engine} table.

 

[pmax9999]

Like kray4660, I am also confused. If you need to run the report for a specific {engine.rptno}, and that {engine.rptno} can only be determined at the time of running the report, a parameter is the appropriate approach but, of necessity will always prompt the user at run time.

I think you need to explain more about exactly what you are trying to achieve, and in particular what actually determines the {engine.rptno} for which the report needs to be run.



Cheers
Pete