create vbscript query

[vilaine]

Ok, from what I understand I think should be able to use vbscript to create a SQL query to get my information from my db. But I can't find anything that tells me how or where to write this code. It would start out with the user selecting the particular parameter values they want to search on, state, zip code, or area code and optionally restrict the sales amount. My query needs to have conditional code (if..then statements) determining which selection the user picked and then create the SQL query based on those parameters. This is how I created the asp version, but now the client wants Crystal Reports. Is there a better way to do this for CR?

Thanks,
Jessica Hill

 

[devinder]

Hi Vilaine!!
I'm building an application in which I need to pass values from the browser to the CR.Do I have to pass it via ASP?And if that is the case then how?
Thanks
Dev

 

[vilaine]

To pass values to a Crystal Report, I did use ASP, but I guess you could probably use a regular HTML form or ColdFusion or whatever. Just name the form fields as prompt0, prompt1, prompt2, etc. depending on what order it asks for them in the report. So if you run your report in CR and find that it's asking for year first and then zip code, then the name for the year textbox/dropdown/radio button field would be prompt0 and the zip code field would be prompt1. Does that make sense? The form page is where you're giving these form items these names like prompt0, prompt1. Then the action page of the form is your crystal report.

I'm certainly not an expert, but I think I could help you out. Let me know

Jessica Hill