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

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!

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

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

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

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

I am using CRXI; my main report consists of 20 subreports. I am passing a parameter from the main report to all 20 subreports. When I run the report, which consists of 2 pages, thousands of pages are generated of the same first 2 pages. It appears to be hung in some sort of loop with the first...

I have the following selection critera for a report: {HPD_Help_Desk.Reported Date} in datetime (2008, 06, 30, 00, 00, 00)to datetime (currentdate) and {HPD_Help_Desk.Assigned Group} = "TS Service Delivery Solutions Development" and {HPD_Help_Desk.Product Categorization Tier 2} = "Video" I also...