Changing where clause dynamically in crystal report

[Rajesh99]

I am new to crystal report. I have some old reports done in
Oracle report, I am trying to convert them to CR. I pass some parameters form JSP page. The user may pass any of the five parameters and the report should print data based on parameters passed. In oracle report I can change where clause dynamically. How do I do this in CR. I tried to run report seems I need to set parameters, but problem is that I may not pass all parameters. How do i set this up. This
must be a very standard feature. Please help. Is there a way I can view complete SQL generated by CR?

 

[Katy44]

Which version of CR? The option to view the SQL is usually in the Database menu.
What is probably better is if you look at the Record selection formula (hopefully in the Report menu).
The way we got round this when passing in parameters from a page was that if the user had made no selection (i.e. didn't wish to restrict that field) then the page passed in ALL available values for that field

Hope this helps

 

[Rajesh99]

Thanks. Tha is what I was looking for. Two more qusetions please:
1. How do I suppress parameter promptf from showing up, as I am really goin to pass this from an front end application
that has capability of invoking CR.
2. If I need to deploy this on web, that is where my fron end is hosted(JSP), do I need more than what I have now. I am running right now version 8.0.0.1 on my PC and soon when I am done with this I need to copy this report on web. What are the configuration pieces on web and client side(user browser) needed for this. I believe the version I have is an old one and may not work!


Thanks

 

[Katy44]

I'm not the best person to answer this as I'm doing it in ASP.NET. It uses a CrystalViewer, which allows you to pass parameters in, and the application fails if they aren't.
Hopefully there's something similar for JSP - help someone?!