Search results for query: *

I have some reports with bar charts that run each day and result levels can vary considerably, so on one day the chart may have 5 bars and on other days the chart may have only 1 bar. When there are less bars the width of the bar increases - if there is only one bar then the chart has one big...

Hi I have some reports with charts that run each day and result levels can vary considerably, so I have to use auto scale. Is there a way I can force the chart to have a scale that is only whole numbers - if the chart result is, say, 1, the scale will show 0.2, 0.4. 0.6, 0.8, 1.0 - when I just...

I'd be grateful for some help. I am using Crystal XI I am looking to add the results of a formula at Group 2 level together so that I get a total at Group 1 level The report is set up as follows and I want to add the results of Formula 1 together to give the total $1377.50 at Group 1 level...

I'm using Crystal XI. Is it possible to change the Field Type from string to memo on a field in an existing report? Thanks

Where a field has, for example 4 values, is it possible to set up a cross tab to show all values even when some of the values do not appear? So, I would like the cross tab to always show A,B,C&D - like this A=1 B=5 C=2 D=4 But if there is no data meeting C, the cross tab returns A=1 B=5 D=4...

Hi I have a report that is using a number of guage charts. Each chart has two pointers on it relating to two values - the results for yesterday, and the average results over a 3 month period. What I would like ot be able to do is make the pointer colour always be the same for each value ie the...

I have a report where I want to show a chart that displays the KPI target met yesterday, and the average KPI target met over the last 3 months No problems with the 3 month average measure, but the formula to get yesterday's KPI works in the report footer, but not in the report header, where the...

Using BusinessObjects Enterprise 11.5 & Crystal Reports v10 We have a report that groups on Project ID - there are about 150 project IDs. We want to deliver separate monthly reports on each project ID. Is it possible to do this using one Crystal Report or will we need to create 150 reports and...

Hi When using the "Download to Excel" functionality in Siebel Analytics, the data on Excel appears with hyperlinks, which then needs reformating to delete the hyperlinks I cannot see what I need to do to format the reports in Analytics so that no hyperlinks appear Any help would be...

Hi I'm using Crystal 10 We have two fields on our database {CAT1} {CAT1_EXTRA} Data entries would be as follows Record Ref {CAT1} {CAT1_Extra} 1234 Billing Service Delay 1235 Payment made Billing 1236 Service Delay [no...

Crystal 10 user I've used the advice from Ibass below to create a report showing a random 10 records, however, the requirement has now changed to "report showing a random 10% of all records (or 10 actual records depending on what is higher)" I;d be grateful for any advice on whether this is...

I'm trying to run a report against a customer name and address database. The database has a table for the name (contact) and a separate table for address details. One contact may have more than one address linked to it. The requirement is to look for duplicate contacts where the postcode...

I'm running a report which looks at call centre stats. The report shows Answered calls, Total time waiting for a call, and average time waiting for a call. The average time waiting for a call is calculated by Total time waiting for a call/Answered calls. So an example would be 18:19:10...

I have a report with a formula that takes data from the main report and two sub reports. I'm coming up with a division by zero error, and whatever permutation I try I cannot get round it! The formula is shared numbervar ACTIVITYCOUNT; shared numbervar CASECOUNT; 100 *...

I'm using a report that has a sub report that is more than one page in length - is there a way I can put page headers onto the sub report so that when the sub report goes onto a second page headings (ie column names) are shown? I'm using Crystal 10 Thanks

I need to set up a report that summarises data from "last week" and the "week before last" which then shows the dfference between the values, so Value Week Before Last Last Week Difference Value A 50 100 50 Value B 100...

Hi I run the following report Top 4 count of cases Company ID Count of cases Acme Ltd 100 ABC Ltd 80 DEF Ltd 40 Blah Ltd 25 Other 300 What I want to do is make some of the results anonymous - so Company ID Count of cases Acme Ltd 100 Company A 80...

I'm trying to group data to show customer records with duplicate post code/surname and non-duplicate customer ID, so I have data as follows DO NOT WANT TO INCLUDE Postcode Surname Customer ID A1 1AA Smith 123 A1 1AA Smith 123 WANT TO INCLUDE Postcode...

I'm using BusinessObjects Enterprise XI Release 2 When setting the destination of a report to Email (SMTP) is there any way to attach more than one report to the same email, ie currently email recipients will receive 8 emails each with one report, but I would like to send them one email with 8...

1) I am doing some reporting on the main support number coming into the business. This number has 5 options (vectors). However, when I add up the number of inflowcalls for the 5 vectors they are less than the number of outflowcalls from the starting point vector. Can any one explain why this...