Search results for query: *

That'll work for what I'm trying to accomplish. Thanks! "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

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

Thanks for the response. I tried your suggestion and it just resulted in the bar chart still graphing the 1 values. Perhaps I am doing something wrong when creating the chart. Because I cannot create this data in a cross-tab, I am having to do the following when creating the chart: Right-click...

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 just wanted to let everyone know that I figured this issue out. The problem was I was comparing records based on the serial number to say whether or not they were duplicates. This caused an issue because some serial number fields were blank. Therefore, it was causing a blank column to show in...

The @Compliance formula referenced towards the end of the post should be @Unique. I am only using one formula. Sorry for any confusion. "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

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

Thank you once again. This worked like a charm. "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

I am referring to the axis labels. When I right-click on the labels that are on the x-axis (the ones that are being generated by the formula), there is only a "Font" tab. However, when I right-click on the labels that are on the y-axis, I see both a "Font" and "Number" tab. I'm guessing this...

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

Worked like a charm. Thanks again for your help. "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

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

I just tried both formulas today and they worked great. Thank you so much! "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

I will try these out and see how they work. Thanks for the help. "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

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

I remember when I first installed Windows 7 on a partition. After booting into Windows 7, it showed it was being on C: instead of G: where I assigned it. I completely freaked out and then breathed a sigh of relief when I booted into Windows XP (my main OS) and saw everything was correct. It's...

Unfortunately, I am trying to sort the main report by the subreport fields. I will take your advice and reverse them. Thanks for your help with this. "Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

I used to have Crystal XI Release 2 until I downgraded to Release 1 because of compatibility issues with scheduling reports on our Enterprise Server. Anyways, when I was using Release 2, I did not notice any performance degradation. However, unlike your situation, I did an upgrade rather than 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...