Search results for query: *

lbass, When changing null's to default values, what does Crystal use as a default value 0? Thanks Rory

Hello, I have a report which has a number of running total fields which reset after a specific group 'Output'. They are Period_01 Period_02 Period_03 etc up to 12. In another few reports these have been counts on a specific string field, however now need to be sums of a specific field...

I see your point and thank you very much. I haven't used vars before but get what these are doing. I'm sure this won't give me what I need though.

I should have really known that given I worked with Crsytal for nearly 3 years, albeit self tought! That prompts me with a huge problem though... I need the report to give me the average of a specific formula field and then plot it per quarter on my graph. Some background.... The formula...

Hi, I am fully aware that Crystal won't get a calculation wrong, that wasn't the point of the question. I have done what you suggested however in order to this I will have to create a running total for this, because I am getting the average when the @quarter variable equals specific quarters...

Hi all, I have a Crystal V11 Report which has 3 Groups as per below Grp 1Service Area Grp 2Local Authority Grp 3Quarter In Grp 3 footer I have 7 formula fields which I am using to create a 7 series line graph in the report footer for Grp1. For the graph I am using data > layout...

Much appreciated Rory (",) I LEARN SOMETHING NEW EVERY DAY

Hello, I have a report in Crystal V11 which contains a Graph containing 8 different series, therefore I have renamed these using right click edit axis labels then saving the report After saving > closing and re opening the report then running again the axis labels don't return and are...

Hello, I have a simple parameter titled date range that has values such as: Last Week Last Month This Week This Month Today and the @startdate and @enddate are formula fields which automatically calculate the date required based upon the option selected from the list of examples above...

Hello, The dates I am planning to use to create these weeks are the @startdate and @enddate. They are simply date values selected by the user. "Are you saying that you ONLY have start and leave dates and that you want to create week periods even though the actual dates might not exist in the...

Sorry to have complicated things. My report already returns data using the @startdate and @enddate fields, the parameters selected when running the report. This then returns x rows of data using the (({Command.Client Start Date} in {@StartDate} to {@EndDate}) or ({Command.Client Start Date}...

Thanks lbass, The groups are not related to the data as such because the report uses a semi complex select expert formula when selecting records. I have put the select expert statement below: (({Command.Client Start Date} in {@StartDate} to {@EndDate}) or ({Command.Client Start Date} <...

Hello, I am using Crystal V11 on a report which has a start and end date. Using these dates I want the report to automatically generate groups based up on these dates, one for every week elapsed between the dates. For example: 20080101 to 20080131 would create Grp 1 Week1 (20080101 to...

Hi people, I have written a report using Crystal v11 and have included a Hyperlink to a file location of V:\ClientTracking\MAYTAS\Reports\ExceptionReports\MLive Exception Report.xls, however when exporting data only and also exporting the object formatting the hyperlink doesn't work once in...

Hi people, I have written a report using Crystal v11 and have included a Hyperlink to a file location of V:\ClientTracking\MAYTAS\Reports\ExceptionReports\MLive Exception Report.xls, however when exporting data only and also exporting the object formatting the hyperlink doesn't work once in...

I didn't even know there was a Crystal forum....lol Sorry

Hi people, I have written a report using Crystal v11 and have included a Hyperlink to a file location of V:\ClientTracking\MAYTAS\Reports\ExceptionReports\MLive Exception Report.xls, however when exporting data only and also exporting the object formatting the hyperlink doesn't work once in...

Hi people, I have written a report using Crystal v11 and have included a Hyperlink to a file location of V:\ClientTracking\MAYTAS\Reports\ExceptionReports\MLive Exception Report.xls, however when exporting data only and also exporting the object formatting the hyperlink doesn't work once in...

Hi guys, I managed to get what I wanted. Just though I would add the code so you can see what I did. SELECT trainee.traineeid as 'TraineeID', traineepot.pot as 'POT', trainee.firstname as 'First Name(s)', trainee.lastname as 'Last Name', trainee.firstname + ' ' + trainee.lastname as...

Thanks I really appreciate your help guys. I think I will create a columns in my select which shows... Hours 07:00 - 18:00 Mon - Fri ¦ Hours outside 07:00 - 18:00 ¦ Base Cost ¦ Other Cost ¦ etc. Therefore covering auditing purposes and hopefully achieving the desired goal. I'll get there. Rory