Search results for query: *

Thanks for your rapid response k, I've decided to go with a stored procedure. Mr. K

Dear experts, I need to link two tables in crystal XI R1. The fields I need to link from the two tables contain data as follows: Table 1: London Manchester Edinburgh Chester etc Table 2: London London City Centre London Belgravia London Eye etc The first field contains cities while the...

Thanks for the quick reply Madawc, i'll give it a go later on and let you know if i have any luck. Mr. K

Dear Experts, I have a crosstab with rows and summarised fields (no columns). I would like to be able to sort the crosstab by any field based on a parameter. I have a command parameter {?Sort} that passes a dynamic string to sort the query and I know that the recordset is ordered according to...

Thanks for your immediate reply k. I'm using crystal XI with sp2 against a postgres database. Since crystal won't let me use dynamic parameters in command objects I decided to generate these in a main report and pass them on to a subreport to see if it works. Amazingly it does. On my main...

Dear Experts, Is it possible to use a string formula from the main report as a command object parameter in the subreport? I'm trying to construct dynamic sql in my subreport using CRXI. Many Thanks, Mr. K

Thanks Aatif, you're a star!

Thanks LB, much appreciated.

Dear experts, I have a standard crosstab like this: Col1 Col2 Col3 Col4 Total Row1 . Row2 . Row3 . Total . . . . . . . . Total I am trying to get all summarized fields to show...

Thanks for you help LB, i just wanted to confirm that this is a default behaviour in crystal and not just me. I am now following your suggestion of periodically populating lov for static params. Mr. K

Thanks for your reply LB, I'm using Crystal XI R1 with SP2. I use two command objects in my report: one for the report fields and another for the list of values to be used in a dynamic parameter. I've got two date parameters and one number parameter in the first command object. I have created...

Dear experts, I'm using Crystal XI with command objects and today I tried changing one of my static parameters to a dynamic one with no success. Using command objects i can create only static parameters within the command window. I can create dynamic ones from the field explorer but then the...

Dear Experts, I've created a small c# application in vs2003 that lists all .rpt files within a folder on the main page and displays the reports on the report page. I'm using version XI and the crystalreportviewer control is placed at the top left hand corner of the report page. The application...

Thanks for the suggestion, I managed to get the desired effect by creating a group based on the CustomerID and using Running Totals with evaluation formulas. Then placed the totals in the report footer and drew some borders to create a feel for a crosstab. I think crystal is a powerful reporting...

Thanks for your quick reply Madawc, stored procs are not an option in this case but i'll keep trying with a combination of group selection formulas and running total formulas. As usual any help appreciated. Mr.K

Dear Experts, I've only been using crystal for few days and am already facing the creation of a complex dashboard for our top management. The situation is as follows: CR XI I'm using a command to pull the required data from a postgres database. The resultset looks like that: SaleRef...