Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports
Message
General information
Forum:
Visual Basic
Category:
Third party products
Title:
Miscellaneous
Thread ID:
00407807
Message ID:
00407821
Views:
33
Problems with that are:
1) The table says it can't be linked when the report is run.  
    My fix for this was a formula as follows:
      if  {viewRequests.DeliveryDate} >= {viewRates.StartDate} and 
          {viewRequests.DeliveryDate} <  {viewRates.StopDate} and 
          {viewRates.CourseID}={viewCourses.ID} 
      then
          {viewRates.Price}

2) It now shows the right prices for the correct course but it shows the first rate for that course in the first request (regardless of whether it should) and the second rate for that course in the second request and so on, and so forth until it runs out where it just displays a blank.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform