Recent content by sdzlkds

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

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

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

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

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