Crystal Reports - reads all records before applying filter

Hi,

Is it a subreport or the report itself?

If it is the report itself you just have to create a query with the right “where” clause. If it is a subreport you can use the subreport link option.

Regards

Servet

Thanks for your reply….

This is in the main report itself.  And I am using CR2016, and I have a parameter prompt for filter conditions….however…..when I ‘show SQL query’ it does not put in all the parameter filters.

Any additional help as to where and how I can make sure the SQL query is passing all the ‘WHERE’ conditions?

~JV

It sounds like you have created a parameter, but haven’t actually linked it to anything?

You can use Select Expert - but I personally find it easier to use selection formulas.

CallumW wrote:

Looks to me as though you have created a parameter, but you will need to link in the parameter to the record selection formula. 

 

 

 

I have looked at this and there is code there to use for the filter.  It just does not show when looking at the SQL query.  It’s like it has a mind of it’s own to exclude the code.  This is the problem when looking at existing reports created by someone else.  :( 

If you could upload your report file in a zipped folder I could take a look.- or send me a message and ask for my Email address. (Albeit I will not be able to actually run the report if its using custom views/ials) (ensure all company related information is removed from formulas/text fields and ‘File → Save Data With Report’ is not selected before saving)

If this is not possible then the only other suggestions are as follows:.

1. Check all database links are correct and Crystal Reports hasn’t automatically added a link which isn’t correct.
2. File → Report Options  & select ‘Convert Database NULL Values to Default’ and see if that makes a difference
3. Check the selection formula to make sure it makes sense with all brackets in the correct places.

Thanks for your responses.  I am going back to find out the report needs and might just attempt to create a new one or just a SQL query.  The CR was a mess and half the data didn’t make sense to me anyway.