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...

thanks Ibass - this works

Thanks for responding. Unfortunately the Running Total won't let me select a formula under field to summarise...

...$255 $127.50 1b 2.5 $500 $1250.00 Cost of project = $1377.50 Formula 1 is if Cost = 0 then 0 else Sum (FTE Equivalent}, Rate)* Maximum (Cost, Rate) The end result I am after is Project 1A = $1377.50 Project 1B = $222.50 Project 2A = $2500.00 etc Thanks

Thanks. the issue I'm having is I'm reporting off an Excel data source, where the field may have more or less than 255 characters. If the field is more than 255 Crystal makes it memo, then if the data changes to less than 255 Crystal makes it string. The data changes back to more that 255 and...

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...

Thanks fishymetrics and Ibass Likewise I had not noticed the Colour Highlight function in 11 - excellent that does exactly what I need

Thanks fishymetrics, this doesn't work due to the way the report is set up - see attachedhttp://www.mediafire.com/?hgt7egc0ph342h3

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...

This is now sorted - thanks all for you assitance

...works in the report footer, but not in the report header, where the chart is placed. The formula I an using is if {dsplit.row_date} = currentdate -1 then 100*(Sum({dsplit.acceptable},{dsplit.row_date}))/sum({dsplit.callsoffered},{dsplit.row_date}) else 0 is there any way round this? Thanks

Thanks kray4660 - yes I think that would work, although I was kinda hoping not to have to do something 150 times! (Although this would be less work than uploading the report 150 times.)

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...

...1234 Billing Service Delay 1235 Payment made Billing 1236 Service Delay [no data entered*] (*{CAT1_Extra} is not a mandatory field so may be null value) We want to count these two tables combined, so the result we want to see is...

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...

Thanks for the feed back. I don't think I've explained the problem very well. The report is returning data as below 1-60NX5 John TekTips 2 TeckTip Rd A1 1AA 1-VG-25 John TekTips 2 TeckTip Rd A1 1AA 1-55R-1 Fred TekTips 5 TeckTip Rd A2 1AA 1-55R-1 Fred TekTips 5 TeckTip Rd...

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...