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 bkrike 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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)
  3. 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...
  4. qcman

    Separating Weekdays and Weekends

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

    Weekday versus Weekend

    I need to create a crosstab that counts occurences that happened during the week versus weekends.
  6. 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?
  7. 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?
  8. 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?
  9. 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)?
  10. 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?
  11. 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?
  12. qcman

    Summarize a Shared Numbervar

    I'm passing a variable from a subreport into a main report. How do I summarize a shared numbervar?
  13. 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.
  14. qcman

    Converting a String

    I would like to convert a string to a datetime.
  15. qcman

    Query Last 30 Days, 60 Days etc...

    I'm using Crystal 8.5,In the select expert Crystal allows a user to query in the period of "thelast7days". I want to run a query for the period of "Last 30 Days" or "Last 60 Days" etc...
  16. qcman

    Manual Crosstab

    I want to show the following Monday Tuesday Wednesday Team Car Team Car Team Car 01 7261 01 7233 01 7248 02 7264 02 7334 02 7658 03 7111 03 6555 03 6767 I can't use a crosstab because there are no calculations to be performed. I want the week days to go across the page rather...
  17. qcman

    Summarizing a formula

    I created a formula to find the difference between one record and the previous record. My problem occurs when I want to total the formula column. I can not add a summary. If i try a formula i.e. Sum (@MBI) I get the following error message "The summary/running total could not be created

Part and Inventory Search

Back
Top