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 SkipVought 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: *

  1. starsky39

    Compare values in Subreport. Alternative?

    That does exactly what I need. Thank you so much, I really appreciate you taking the time to help me. [smile] N.
  2. starsky39

    Compare values in Subreport. Alternative?

    Hi, thanks for the reply. I'm using subreports as it was the only way I knew how to do this. I'll try to explain what I'm doing and am happy to do it a different way if that is a better way of doing it. I have 20 technical support people using a call logging system (HEAT) which has an SQL...
  3. starsky39

    Compare values in Subreport. Alternative?

    Lbass - sorry back already :-) On the main report I want to create a crosstab with engineer names down the side, then hours from all in one column, hours from MS in the next and then the percentage difference in a third column for each individual. Like this...
  4. starsky39

    Compare values in Subreport. Alternative?

    LBass - that works perfectly! Thank you so much. [2thumbsup] I have to get this working on an individual engineer basis and incorporate it into graphs and crosstabs. I might come back to you if I have more questions, if you don't mind... Thanks again. Nicky.
  5. starsky39

    Compare values in Subreport. Alternative?

    Hi, I currently have two subreports and want to compare the values in each sub report within the main report, but I don't think this is possible. Subreport 1 - shows number of hours logged by engineers for All Customers. Subreport 2 - shows number of hours logged by engineers for Managed...
  6. starsky39

    Compare currentfield values in Crosstab or alternative solutions?

    Thanks lbass. However, there can be up to 300 clients listed. Does that mean I would have to manually type in 300 entries under the 'whileprintingrecords' section? The report will not always run for a set number of weeks, it could be any number of week from 4 up to the last year.
  7. starsky39

    Compare currentfield values in Crosstab or alternative solutions?

    Hi, Thanks for the reply. I am using Crystal Reports XI. I created the crosstab like above, but I don't know how to write the formula that calculates the percentage increase or decrease and then change the font colour. Sorry to sound dim, but I also don't know how to create embedded summaries...
  8. starsky39

    Compare currentfield values in Crosstab or alternative solutions?

    Hi, Does anyone have any ideas on the below? I have a Crosstab with a Date range as the column headings. The date is filtered to show Fridays only within a date range (@backuptime). The rows are the names of servers being backed up {emm_image.clientname} The field values are summarised data...

Part and Inventory Search

Back
Top