Crystal Report-Need Help

[swoozie]

I inherited a crystal report that I now have to alter and change. Unfortunately I havent used Crystal in years, and what I did not was not extensive. Well here is a list of my issues that I am not sure of.

1) There is criteria hard coded somewhere and I havent been able to find it in the formulas. It displays under the "Enter Parameter values" box

2)The report is supposidly designed to only pull on a weekly basis, however the only constraints that I am locating are period start and period finish meaning I should be able to increase the time period between them, however when I dothis the report comes up null

3)I attempted just to rebuid the report, but the table names listed in the Report Expert, I am unable to locate 3 of them in the database that supposidly this is linking to.

4)I guess you could say I just dont have a clue

[ARPRINCE]

(1) If you are using version 8.5 - 9.0 (I can't say the same for other versions because this is the version I am working with), the parameter should be visible under the Field Explorer.

Also, if you are using a SQL server as a database that uses SPROC as reference for your Database Field, the parameter must be modified in the SPROC and the report updated thru "VERIFY DATABASE". You would be able to see the parameter under the field explorer but would not be able to modify (except the PROMPT TEXT part of it) or delete it.

(2) and (3) depends upon if you are using SQL + SPROC to define your report.

(4) I've been there and there would be cases in the near future that's I'll visit that path again so rest assure that you are not alone.

[swoozie]

Thanks, I had been searching for that for 2 hours now. 5 mins later and wha-la I have the report somewhat fixed. It even exports correctly now, something the old one didnt do.