Search results for query: *

We use Crystal 11 Our dates are stored as Date/Time values. I have created a date range parameter, selected Date for the Type and Allow Range Values for Options. When I run the report, I get no data and an error like "Field requires a date/time value". I tried converting the date/time to a...

CRYSTAL 11 We have Products broken down by Model/Version. Some of our NCID Product Model/Versions are blank. I am attempting to print all records that have the Product Name of "NCID" where the Product Model/Version does not include "NG". In other words, I want all NCID Product Names where the...

Thank you, Mr. Bass! You really ARE a genius. This solution works perfectly. [bigsmile]

Crystal XI = Version I have a datetime field (SubmitDate)and need to select records in the last 6 months with a SubmitDateTime after hours, that is from 5:00 p.m. until 7:00 a.m. How do I select that 5:00 p.m. until 7:00 a.m. timeframe? Thank you!

Hi, Brian: Thank you for your formula. I changed it to: Left({SIT_Site.Site},15) I am getting the 1st. 15 characters of all site records, but I only want the site records where the 1st. 15 characters are duplicates. It seems I need an IF in there somewhere, and perhaps a DO While Printing...

I am using Crystal 11. I have a table called SIT_Site that contains the field called Site. I need to create a report that compares the 1st. 15 characters in the SIT_Site.Site field and only prints duplicates (the records where the 1st. 15 characters match). How would I accomplish this please...

THANK YOU, -LB!!! This works! Do you know of any white papers that explain in laymans terms about parenthesis use rules in Crystal? I just don't understand how to use parentheses.

I tried the suggested formula but get an error: "The remaining text does not appear to be part of the formula." This is the selection criteria I pasted that is giving the error: ) //The above gets only NULL or Blank records then // then,the section below adds further criteria for these...

I use Crystal v11. I want to see all records where either the product name or the closure product name are blank and the records also meet the other criteria. When I use the selection criteria below, I get all records, even those whose products are not null. IsNull ({HPD_Help_Desk.Product...

I found this suggestion on another post: IF isNull({HPD_Help_Desk.Last Resolved Date}) THEN DateDiff ("d",{HPD_Help_Desk.Reported Date} ,date(1900, 01, 01)) ELSE DateDiff ("d",{HPD_Help_Desk.Reported Date} ,{HPD_Help_Desk.Last Resolved Date} ) // date(1900, 01, 01) I tried that, but I am...

Thank you, FISHEROMACSE. When I use the "", however (see below formula), I get an error: "A date-time is required here." I really appreciate your work on this, and will continue to check back for updates. OGM

Thank you, FISHEROMACSE. Logically, this should work and produce the actual days open for unresolved tickets. However, after making these changes to the report formula, I still get zero (0) for days open. I did make one minor change to your formula as indicated below, since this is a...

Using v. 11 I have a report that shows days open for tickets based on the formula below. Some of the tickets are active, however, not having a Last Resolved Date. Those are currently showing zero (0) for days open (report line below -- see 0 after the date/time on first report line). I want...

THANK YOU, LB! I do like your way better.

In my continuing search for the answer to my problem, I got it solved, so please disregard my request unless you have a better or easier method than this: I created another Page Header section and conditionally suppressed it this way: IsNull ({HPD_Help_Desk.Incident Number}) = False

I am using Crystal 11. I want to print "No records for the current month." if a report for a month has no records that match criteria. What I tried (below) is not working: Formula 1 (@RecordCount) If Count({HPD_Help_Desk.Incident Number})= 0 Then {@NoRecordsText} Formula 2...

In Access 2000, I have a table that contains multi-page OLE objects in either Excel or Adobe format. This is our "Stock Reports Book." From the table, when I click the OLE field, the report opens in its native application and all pages are visible. When I create a report from the table...

We use Crystal 11 and a Remedy database, which does not allow table linking. Therefore, we must use subreports to print data from different tables. I have a main report that uses the Vendor table to print Vendor Ticket#, Date Reported, and Date Resolved. I have a subreport that is linked to...

Thank you for your feedback, LBASS. I did not understand your question above about "adding a table to a container report." I'm new & learning.

Hi, LB: We figured out the problem with getting 1000+ copies of pages 1-2 on the report! We left all the subreports in the details section BUT deleted agency selection criteria from the main report. So, the main report contains the Agency parameter field but no selection criteria, while the...