Search results for query: *

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

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

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

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

Hello, I have been given a task to write a report which calculates cost based upon the time elapsed between two datetime values. I would do this by writing my sql then importing to Crystal V11 to format accordingly. This may seem fine as you would expect a typical datetime(minutes,[x...

Hi, I am producing a report in Crystal XI and have two similar cross tabs next to each other. Both tabs have the same row headings therefore I would like to hid the row headings on one to make it look as if they are just one cross tab. Before you say I can't put the info out of one into the...

Hi guys, I am currently writing a report in which I will need to find the working hours between two date time values. One value will be 20080101 09:00 and another 20080201 17:00 Idealy a function something like WORKINGHOURS('20080101 09:00','20080201'). WORKINGHOURS('FIELD1','FIELD2') I...

Hello, I am having problems with a field in our data base called tpot.u_months_unemployed. This field is a string lengh 4 however only contains numeric characters. Due to the field being a string I cannot ranges in Crystal Reports XI due to the field data type. For example the command...

I created a report which uses a couple of Dynamic parameters. The first time I wrote the report the Dynamic Parameters worked absolutely fine and picked up all database values when I was prompted for my parameters. I then made minor change to the report totally insignificant to the parameters...

When creating a CASE when command in a select statement it is cutting what was originally '079' to an output of '79'. I have tried to CAST the CASE as an INT(3) to avoid the problem but is still removing the zero's before numbers. Do you know why this would do this? I have also tried CAST to a...