need urgent help

[kgaurav1305]

Hi I am new to crystal reports, I am trying to create static prompts as i do not have tabale for these fields. I have two fields state and city. Now I have to ask user state as input then based on that prompt next prompt which is city should be selected. i mean that if i select say Illinois as state city prompt should give me only cities of ilinois state. I know that its possible with dynamic prompt, but can we do it with static parameters.


My second Question is :

I have two static parameter prompts i want to make them optional, user can select any one of them,but second prompt should be disabled or when already one prompt is selcted nad he tries to select other one i need to convey some message that you have selected state now you can not select city and would not allow to selcet both parameters at the same time,

Note that i have to use only crystal report only no other language to create UI. I am using crytal report XI. Please some one help me out i need this urgently. Please Please help me guys.

 

[kgaurav1305]

There are 13 views but no suggestions.. Guys please help.

 

[Srinvb]

Iam not sure which version of Crystal reports you are using but

for Crystal reports XI

My Idea would be creating a command object with an sql,there could be other ideas also

i.e
if you are using SQL Server as your database then(since you are saying it as a static parameter make it dynamic by giving in a query)

Create a command object
and give the sql Statements as follows for ex:
Select <State1>,<city1> [for oracle Select <State1>,<city1> from DUAL]
union
Select <State1>,<city2>
union
Select <State2>,<city1>
union
Select <State2>,<city2>

now after creating the command object

go to the parametres and create new parameter and Select the parameter as dynamic
select the first parameter as the state and the second parameter as the city for the same parameter.
this will create a cascading parameter.So when selecting a state the respective cities are filtered.

try this.