Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Controlling what refreshes

Status
Not open for further replies.

Sarpal1

MIS
Aug 26, 2005
13
GB
Hi,

I am using v8.5 to report on Baan V. I have a simple report that produces a list of products due to complete this month, what I want to be able to do is run this report during the month and capture the latest forecast completion date so that I can compare this latest date against the initial date. At the moment I export to Excel and do the comparison there. Is there any way I can do this in Crystal 8.5?

Thanks.
 
Yes, that's the sort of thing Crystal is. You don't say what the data structure is. If there are several records per product, then group by product, suppress the details and show the group footer. Use a summary total to get the latest, or order by date and show the value from the last detail record in the group footer.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Thanks Madawc,

The report retrieves all products (single line, single record) that have a forecast completion date between the two dates that the User can select by paramter. ie show me everything due this month. The trouble is that during the month the products are rescheduled and the dates change, meaning that some products fall out of the date range andsome come in (!). Every time I refresh the report the date field (naturally) returns the current value; I would like to be able to control which field is updated on refresh though I can't see that this is possible in the same report. Sorry this is so long winded but I can't see a simpler way of explaining it.

Hope this clarifies my problem!
 
So you need to use the same data in two different ways? First to find if it was ever in the date range, and then to find the latest date?

Try using an alias, the same table added for a second time and using the same data. The first occurance would be limited to the date range, the second would have all records for those products. Better, link from produce details to the two aliases, because Crystal works by 'rows', with one row per possible link. I've not done such a thing, but it should work.

An alternative - hugely inefficient in machine time, but easier to write - would be a subreport that checked all records for products in the main report. Subreport links are found under [Edit] and data can be passed back using a shared variable. Or just displayed from the subreport.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
If your data is like this

ItemCode CompletionDate
1 15/08/05
2 17/08/05
3 01/09/05

and you filter for items completing in August then items 1 and 2 will be reported. If you then reschedule item 2 to 01/09/05 then only Item 1 will appear.

If you only have the 1 field and rescheduling an item changes this value then there is absolutely no way to know what the value used to be.

You would need to have a record of all historical completion dates for the items to be able to report on this.

If your db has this info then please supply a sample of your data layout and expected outcome.

HTH



Gary Parker
MIS Data Analyst
Manchester, England
 
Thanks both for trying to help (and you did!), I suspected that there wasn't a solution to my problem but thought that it was worth asking.

Thanks agian for taking the time to reply.

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top