subreport linking

[nikol]

I'm trying to link my main report to subreports through a"static" parameter field. Its not working but if I link with dynamic parameter field it works fine. Is there anything I need to do to link subreports with static parameter field?

 

[Turkbear]

Hi,
Please explain what you mean by a 'static' parameter.

Parameters are designed to pass varying information to be used in some way by the report..a 'static' parameter seems like a contradiction...






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[nikol]

I have a column CITY in my table. I have used this column as a "Statis Prompt" in parameter field.I had created a list of cities in text like:
ALL Cities
Campbell
Cupertino
Fremont
Los Altos
Los Gatos
Milpitas
Morgan Hill
Mountain View
Palo Alto
San jose
Santa Clara
Saratoga
Sunnyvale & imported this in parameter fields.
In Select expert I created the formula:

if {?my Parameter} = 'All Cities'
then
1=1
else
{command.city} = {?my Parameter}

So when I refresh this report it will ask me for city prompt When I select "All Cities" from lov it will give me all the clients in all cities otherwise only selected city clients. My report is working fine but if I link this report with main report Its only giving me 1 client for "all cities" ..
I hope this will help you/

 

[nikol]

My subreports r working fine with the city prompt but main report is not
Any help..

 

[Turkbear]

Hi,
Try placing the parameter in the Main report and use it to link to the sub..insted of the other way around.











To Paraphrase:"The Help you get is proportional to the Help you give.."