Parameter not filtering data.

[ezamon]

Hello All,
I have been working on an expense report using CR 8.5 working off of data from Access 2000 Crosstab Query. My report has been working when I hard code the filtered values in the Query that crosstab qry runs off of, but when I try to use Crystal Parameter Fields it returns all the data. The report will be ran by the end user who should be able to select these individual parameters. I need to filter three different pieces of data: first is [Year] which is a text field, next is the [Manager]which is a text field, and [Period] Year-to-date which is a Integer/number field.
The Access file is currently linked through ODBC.
Not sure if any more info is needed to answer this question.
Hope someone can help. Thanks!
EZ

 

[dgillz]

Silly question, but did you write a record selection formula to restrict the report to the records that match the parameter field?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[ezamon]

Thank you for getting back to me Dgillz. I did that for the [manager] and [Year] field just now, but for the [Period] it is a little more complex (for me that is).
I have two queries, the main query that gets the data from few different sources and the the Cross tab Query that my report is based on.
the Fields are:
[Cost #]
[Cost Description]
[Year]
[Period] <= the one that is troublesome
[Manager]
[Cost group]
[Values] Actual and Planned expense summed(two columns in the Crosstab)

My Issue: when I put the [period] field, which is an integer type 1 through 12 (representing months), in the crosstab and run the crystal report I only get back one period (month) of data. When I do not have the period field in the crosstab the report is correct.

What I am looking to do is have the parameter in the report where the user can, for example, get back Period one through Six Year-to-date summed up.

I thought it would be better to filter through the first query that the crosstab works off of, but I don't know if i can bring in another query since I would have to link it but there is no unique ID.
Thanks again for the help!

 

[dgillz]

Also The cross tab query that your report is based on, is this an Access cross tab query? If so does it have its own parameters?

If so this is most likely the problem. Crystal doesn't handle Access queries with parameters very well. Pass the entire recordset to crystal, and create a crystal parameter to do the record selection.

If this does not solve your problem then post your record selection formula.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com