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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sdzlkds

  1. sdzlkds

    Bar chart widths

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

    Chart axis settings - auto scale - values as whole numbers

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

    Adding formula results in a group

    thanks Ibass - this works
  4. sdzlkds

    Adding formula results in a group

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

    Adding formula results in a group

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

    Is it possibe to change field type

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

    Is it possibe to change field type

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

    Cross tab to show null value

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

    Chart function - making a value always be the same colour

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

    Chart function - making a value always be the same colour

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

    Chart function - making a value always be the same colour

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

    Formula displays zero when placed in report header

    This is now sorted - thanks all for you assitance
  13. sdzlkds

    Formula displays zero when placed in report header

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

    Deliver report groups to different destinations

    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.)
  15. sdzlkds

    Deliver report groups to different destinations

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

Part and Inventory Search

Back
Top