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...
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...
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.
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.