Is there a way to have multiple search criteria in a report? So that you can select records using one critera, save the search criteria and create another search that can be uploaded.
I want to see a different record sets, but in the same report. The record set would be different, but the format would be the same. For example, I have a report that produces a comprehinsive set of audit data where I agree with the audit and where I think that there are errors. The report selects data based on the following criteria:
if
{qryDepreciation.TaxYear} = 2003 and
{qryAddresses.Sec/Unsec} = "secured" then
{qryDepreciation.AssrRevised} <> "STRUCT" and
{qryDepreciation.AssrRevised} <> "land impr" else if
{qryDepreciation.TaxYear} = 2003 and
{qryAddresses.Sec/Unsec} = "unsecured" then
{qryDepreciation.AssrRevised} <> "land impr"
In this particular instance, I only want to see data in 2003, excluding items when it is secured, but if it is unsecured, I want to exclude a different category.
If I want to select a different record set, but keep the same report, can I create a second selection criteria save to a file call it up so I don't have to delete the first selection criteria to get a different record set? What I am trying to do is avoid having to create multiple report files and deleting selection criteria and having to redo selection criteria.
Why not use a main report as a container report and use sub-reports to handle each different search criteria then you can use a parameter to display which sub-reports the user chooses by conditionally suppressing the sections containing the sub-reports based on the parameter value chosen by the user.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.