crystal input parameter in select expert causes no records returned

[sue1127]

I'm using Crystal Reports 8.0 with Sybase 11.0.3. I've had a crystal report in place for more than a year. Trying to add two tables to the report has been a nightmare. I finally got it to almost work by playing around with the sql, and copying and pasting it in. For example, the report returned duplicate records, and when I tried to link one of the new tables to an older table to solve that problem, Crystal told me that the item had already been read. I placed the link earlier in the sql, and it worked.

The remaining problem is that Crystal will not recognize one input paramter. I can successfully input fiscal period and a period range. However, when I try to input a budget approver(which is in one of the two new tables), Crystal returns no records. If I type in the instruction as part of the sql (i.e. Budget_Lists.Approver="jsmith", the correct number of records is returned.

Does anyone have an idea of what the problem could be?

Thanks very much.

Sue

 

[synapsevampire]

I don't think that CR 8 allows you to replace it's SQL, if you check the Database->Show SQL Query, note that it states that you can change the From, Where and Order By.

Rather than text descriptions, please post table layout, example data and expected output.

To use parameters, reference them in the Report->Edit Selection Formula->Record, as in:

Budget_Lists.Approver = {?MyApproverParameter}

I have a FAQ in the Crystal Formulas forum which addresses optimizing SQL Pass Through using the record selection formula.

-k