Search results for query: *

Thanks for the quick response (!). I told you it was a dumb question (or should that be a dumb user?). It's Crystal v8.5 connecting to Baan V ERP - don't know what db type it is. It's always been the same data source and I've had no problem in the past - just the last few days. I thought it was...

Dumb question of the day; Expression builder no longer displays all the Functions and Operators in their trees. Selecting fields from the field tree does not put them in the {}. I've tried both creating a new report and using and existing one but neither gives me a full tree. I'm assuming that...

Just found a link to this site http://www.kenhamady.com/formula.html whilst surfing here. With some engineering of a couple of his formulae it may be possible to produce a dynamic AP range (first Monday to last Sunday) so there would be no need to hand code ranges.

not apostrophe, colon!!

I note the last apostrophe is missing from my first post

Sorry for taking so long to reply APB, the full formula should look something like this; StringVar accountingperiod; If{tppin020.sidt} < DateTime (2005,08,29,00,00,00) Then accountingperiod := "Too early"; If{tppin020.sidt} > DateTime (2005,08,29,00,00,00) and {tppin020.sidt} < DateTime...

Funny old thing but I have (had) a similar problem where I wanted the user to be able to select an Accounting Period (AP) using a simple parameter, my solution is as follows - 3 steps; 1. I created a formula along the lines of; StringVar:=ap If {date}> DateTime(yyyy,mm,dd,hh,mm,ss) And {date}<...

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

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...

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...

Hi -k, Thanks for responding. I wasn't being deliberately vague; the problem (I think) lies in Crystal not the OS, which is XP, and it is Crystal that crashes not the OS. I have several dozen reports but not all of them use Parameters, those that I use regularly that do have them are crashing...

Hi, Is there any way to control what gets refreshed? I have a report (in v8.5) that generates forecast completion dates for products in month. What I want to do is run this at the start of the month and then during and at end of month to compare the completion dates. Ie measure forecast...

Hi, Has anyone else experienced Crystal 8.5 crashing when trying to modify a Parameter? Over the last few months if I try to modify a parameter setting in v8.5 I get the standard Windows program error with the "do you want to report the error etc" message and then Crystal shuts down. My IS dept...