Recent content by qcman

In the main report its grouped by Mileage_Reading_Date (monthly) and in the Sub report its grouped by Failures_Date (monthly). The location of the sub-report is in the Report Header of the Main Report.

I am using Crystal 8.5, I have subreport with a shared numbervar Monthly_Charges := that distinctcounts total failures, "monthly" and a main report that sums total mileage, "monthly". I can't get the shared numbervar to reset monthly. The last month total is 110 and in the main report the total...

I am creating a crosstab that has 4 years of data (i.e 2009 to 2012). I only want to show the results for January of each year. A B C 2009 (Jan) (Jan) (Jan) 2010 (Jan) (Jan) (Jan) 2011 (Jan) (Jan) (Jan) 2012 (Jan) (Jan) (Jan)

I use that formula for two different months in a year but cannot use it for the same month(name) in different years. My totals are in the footer, that was a typo.

I have two groups (Date, "annually" and System type). I'm using running totals for counts on system by month in a year. For example: GH#1 2010 JAN FEB MAR GH#2 AB 5 8 3 CB 4 2 3 DB 6 2 3 GH#1 2011 JAN FEB MAR GH#2 AB 8 3 5 CB 2 3 4 DB 2 3 6 I want to show the variance per year, per month...

Sorry, didnt realize I posted thread earlier.

I want to count how many occurences happened from monday to friday and how many occurences on the weekend.

I need to create a crosstab that counts occurences that happened during the week versus weekends.

Thanks lbass. "You The Man"!

Does this work in Crystal 10

I'm using Crystal X and I am trying to create the option ALL in my parameter. My parameter is 1,2,3,4,5 How do I select all of them without clicking on each one?

I am grouping a report with specified headings. If a group does not have any data it does not display. How do I display the group with no data?

I have a month of data for three times a day (2am 8am and 10am). I want to display the 8am data only. What can I do?

I have a parameter that allows for multiple values. I want to add this to my title. For example my parameter is either A or B or Both. If a user selects A then A should be in the title. How do I create a title that shows a user as entered in Both (A&B)?

I want my report to show the first day of the week in the title. My query is for the lastfullweek and my formula in my title is minimum({datefield.field}). If I don't have any data for Sunday the title displays the minimum date. How can I show the first day of the week (Sunday)in my title?