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!

Register Log in
  • Congratulations derfloh 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: Cyked
  • Content: Threads
  • Order by date
  1. Cyked

    Missing months/days/week/etc. in group sorts/crosstabs

    I want a report to show number of Priority 1 and Priority 2 tickets by month and total each P1 and P2 separately based on date opened. I want to create a report that will show number of tickets OPENED in each month, but have the report show ALL months regardless. The issue is if there is not...
  2. Cyked

    Passing parameters to sub report

    I have a report where I am using 3 sets of parameters for begin and end dates (report, current, previous). The main report uses report_begin_date and report_end_date in the select statement to grab 2 months worth of data. In the main report where I am displaying monthly data metrics I use...
  3. Cyked

    sub reports in a main report with multiple report footers

    I've built a report that mimics a "dashboard" used by upper management as a monthly board report. I have lots of report foots for each line of data formatted something like this (see attachment) What I want to do is insert a sub report using a different date range (previous month) in the blank...
  4. Cyked

    Formulas and charts.

    So, not really formula related (where should I post this?).... What does everyone use to create pretty charts with colors management love to see? Excel? I'm trying to create dash boards in crystal where you can basically run the report for a date range and dump to PDF as the final product...
  5. Cyked

    date/time conversions and select expert

    Long story short our DB stores data in GMT, and I need to report on PST. So I convert that with a formula: NumberVar i; DateTimeVar gmtDateTime; DateVar searchDate; DateVar beginDST; DateVar endDST; NumberVar timeDiff; DateTimeVar localDateTime; //Find the DST begin date (which is always the...
  6. Cyked

    Cross Tabs and Graphs

    Trying to do charts for data in a report or even from a cross tab... Assume I have a report by month, assignment team, ticket priority, and ticket duration. I can do a bar chart from this showing month, team, and duration, but I can't also show Priority. Is there a way to add more data to...
  7. Cyked

    CR Charts

    I'm trying to add charts to some reports. The data being worked with is in our change tool and I am grouping by change "type"). Right now the report is for a single team and the changes they submitted for a single month. I'm looking at changes that were a certain "type" (e.g. informational...

Part and Inventory Search

Back
Top