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!

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

Recent content by Sarpal1

  1. Sarpal1

    Expression Builder problem

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

    Expression Builder problem

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

    Parameter Selection (Need to Display Calendar)

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

    Parameter Selection (Need to Display Calendar)

    not apostrophe, colon!!
  5. Sarpal1

    Parameter Selection (Need to Display Calendar)

    I note the last apostrophe is missing from my first post
  6. Sarpal1

    Parameter Selection (Need to Display Calendar)

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

    Parameter Selection (Need to Display Calendar)

    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}<...
  8. Sarpal1

    Controlling what refreshes

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

    Controlling what refreshes

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

    Controlling what refreshes

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

    Parameter crash

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

    Controlling refresh

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

    Parameter crash

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

Part and Inventory Search

Back
Top