Skip to Content
0
Former Member
Aug 01, 2009 at 07:16 AM

reg Parameter .

40 Views

Hi.

This is ranganadh,

i am generating very simple report, but under laying it has very huge table and lot of joins .. but i have a proper indexing to get results much faster ..

i have taken new report, and given oracle command for data source, i wanted to make some fields are as a parameters to that report. let us take ..

i have a query like ..

select phoneno,contactno ... from contacts where phoneno =1000 some thing

i wanted to make phone no as a parameter to the report, so that i removed where class for the phoneno=100 .. and put it in record selection formula ..

but report is taking ages to run, i am thinking that report is trying to get all the data from query after on-words it is puting filter operations.

is there any way some thing like, pass a report parameters as a query parameters to the database from Crystal report.

some kind of feature is allredy there in SQL server reporting tools, just i want to know that is there any feature in crystal reports like that ..

pls reply ASAP