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