Search results for query: *

Hi, has anyone tried embedding a map into Crystal Reports 2008 ? I am interested in plotting postcodes (like MS Map Point). Please let me know what software you used, and any ideas / tips you have. thanks Paul

Sorry, I can not get this to work. let me try and explain better: Group 1: Product 1 50 50 50 Group 2: Product 2 100 100 100 I want to supress the details above and have: Group 1: Product 1- 50 Group 2: Product 2- 100 Total: 150 BUT... my sums add up the details even when I supress, so with...

Hi, I am using CRXI and have built a report which links to a spread sheet. the report is based on sales against targets. the sales are being taken from a table in a DB2 system, and the budgets/targets are being taken from a spreadsheet. this is what I'd like GROUPED on PRODUCT, only...

Hi, I am using Crystal Repeorts XI and have a report containing a subreport. How can I sort my report using the data from the subreport? Thanks Paul

Hi, I'm using Crystal Reports XI and need to sort my records by the group footer total. Can anyone help? as I can not selct this field in Record Sort Expert. Thanks Paul

Hi, I'm using Crystal Reports XI and have a number field which is: 20071213 YYYYMMDD how do I make this into a date field crystal will reconise? Thanks Paul

Hi, I'm using Crystal Reports XI and have a problem which I hope someone can help with. I am running a query using over 3 table (customer, product and sale). If I run a report over Sale I can find all the products a customer has bought, ie: customer001 product001 customer001...

Hi, I'm using Crystal Reports XI. The records of my report are made up of a Group Header, (Many) Details and Group Footer. Is it possible to stop a record being half on one page and half on another? I've tried 'new page before', but that does it for every record, I need it to only apply to...

Hi, I have created a report in Crystal Reports XI and have created a dynamic parameter. I then have a Crystal Viewer to run the report, but the dynamic parameter is empty- because at this point it has not asked me to log onto the data source. Any ideas how to resolve this? Thanks Paul

Hi, Wonder if someone can help. I'm currently using Crystal Reports XI and want to split a number field into a time field. The field format is 34512 (which is 3:45 and 12 seconds). The solution must also take into accound if past 12 O'clock, the field reads- 133643 (which is 13:36 and 43...

Hi can anyone help!!? Crystal is driving me mad :oP I am running a report (using Crystal Reports XI) over a OLE DB connection to an SQL data source. The report shows customers and all the orders they have made. I have created two groups: Group 1- customer Group 2- order This way the report...

Hi, I am using Crystal Reports XI and I would like to change the background colour of my 'called customer' date field yellow when the date is over a month ago. Can anyone help? Thanks Paul

Hi, I am currently using Crystal Reports XI and have created a report containing a formula which divides two formulas. The problem is, if the formula's result to '0', then I get the following error message: "Division By Zero". Is there away of geting around this? I understand you can not...

Hi, I did verify the datasource, but the owner and catalog did not update, do you think this is because the datasource (altho pointiong to different databases) is called the same? I need a way of manually changing the owner and catalog in the database location I think. Thanks Paul

Hi, I am using Crystal Reports XI, is there a more efficent way of changing a report's owner and catalog without going into the 'set database location'. This is to allow me to create one report which can then be easily edited to run over many datasources with the same table names and fields...

Hi, I'm using Crystal Reports XI and am getting the following problem, which means I do not retrieve any data: Relational Database *** is not the same as current server ***. I have looked in the database location tab, and that seems to be fine. Any ideas?

Thanks for that Ian! works a treat!

Hi, I currently connect Crystal to the AS400 using ODBC, it is slow, and have been told there are other ways to connect. Does anyone know of a more efficient way of connecting to the AS400?? Thanks Paul

Hi, i have a field in my group which contains values. Is there a way of counting the amout of "200"'s? For example: 100 200 200 50 200 the count would be- 3 Thanks Paul

Hi, Thank you, that works a treat. I will try and give more info next time :) My next challenge is to have one bar chart, where the axes are variable. IE the user selects the two data fields to show the results they require.... not even sure its possible.