Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: qcman
  • Order by date
  1. qcman

    Resetting A Variable

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

    Resetting A Variable

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

    Show only Month in Crosstab

    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)
  4. qcman

    Monthly Variance

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

    Monthly Variance

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

    Separating Weekdays and Weekends

    Sorry, didnt realize I posted thread earlier.
  7. qcman

    Separating Weekdays and Weekends

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

    Weekday versus Weekend

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

    Select One or All in Parameter

    Thanks lbass. "You The Man"!
  10. qcman

    Select One or All in Parameter

    Does this work in Crystal 10
  11. qcman

    Select One or All in Parameter

    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?
  12. qcman

    Displaying Group Headings with No Data

    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?
  13. qcman

    Display Data For A Specific Time Of Day

    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?
  14. qcman

    Display Multiple Values from Parameter

    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)?
  15. qcman

    First Day of Week - Title

    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?
  16. qcman

    Crosstab too wide for one page

    Can this be done if the Crosstab is placed in the Report Header or the Report Footer?
  17. qcman

    Crosstab too wide for one page

    Thanks, I had a feeling there was a way. Just couldn't figure it out.
  18. qcman

    Crosstab too wide for one page

    I am using CR 8.5 and CR X, I have a crosstab that is too wide for one page. I want to have the remainder of the crosstab display below the 1st part of the crosstab on the same page. Can this be done? if so how?
  19. qcman

    Summarize a Shared Numbervar

    I'm passing a variable from a subreport into a main report. How do I summarize a shared numbervar?
  20. qcman

    Date Display

    I want to display the week ending date (i.e. Work Orders created for the week ending 9/29/07). I am using the create date field (wo_create_date). The create date can be any day in the week.

Part and Inventory Search

Back
Top