Search results for query: *

I want to sort a series of release records in our IT Service Management database by the Deployment Start Date. Unfortunately, this field is not always populated. Is there a way to sort the data by the Deployment Start Date and if the field is null, sort it by another field, such as the Release...

I am using Crystal Reports XI connected to a database using an ODBC driver. I have 8 formulas that result in either a 0 or 1. Each formula is as follows: If isNull({fieldname}) Then 0 Else 1 I want to create a bar chart that results in something that looks like the bar chart that I created...

I am using Crystal Reports XI and am trying to create a cross-tab that shows the number of duplicate records, the number of records that do not have duplicates (unique), and the total number. The end result should look like this: Duplicate Unique Total 197 9927 10124 I...

I am using Crystal Reports XI connecting to an Oracle database that houses help desk information. I am using DateDiff to calculate the difference in days between when a help desk ticket is opened and closed. Here is the formula I am using: DateDiff( "d",{HPD_Help_Desk.Reported...

I have a report that is pulling data using LastFullMonth. In the title of the report, I would like to display the month and year the report is for. For example, if I run the report in February, I would like the title to display "January 2009." Likewise, if I run the report in January, I would...

I am trying to do something with a line graph in Crystal Reports XI. I have a cross-tab that looks like this: 1/3/09 1/10/09 1/17/09 Total Incidents 10 20 30 60 Requests 40 50 60 150 Total 50 70...

My goal is to run a report that will show information for a certain date depending on the date the report runs. There are two date fields I need the query to run against: ScheduledStartDate and ActualStartDate If the report runs on a Wednesday, I need it to pull records with either a...

This is my first post in this forum and I apologize if this is not the correct place for this type of question. I am using Crystal Reports XI Release 1. I have a main report which has a linked subreport within it. I want to sort the subreport by two of the fields. However, when I set this up on...