Search results for query: *

Hi all I have a table which contains the fuel rates and dates when entered. e.g. 01/01/15 = 120 and 01/07/15 = 114. This denotes that the rate at 01/01/15 was 120p per litre and on 01/07/15 was 114p per litre (uk dates) I have another table which has transactions processed on most days. What I...

Hello I have a csv file that has one column with an account number in it. This is for example MARC03. When this is imported excel converts this to Mar-03. Is there any way to stop this. The file is required to be a csv file and it needs to iimport straight into excel as the user will not be...

Hi all Is there a way to output all table columns which are type CHAR Thanks Peter

Hi all I have a column in a table which contains a string of Y or N values e.g.NNNNNYYYYYNNNNNYYYYYNNNNNY and i want to be able to return the last position of Y from the string eg the last Y is position 26 Is this posible Thanks Peter

Hi all I have a report which has a sub report on other tables. I want the sub report to only print 5 records on each page and then throw a page and print the groups from the main report before starting the sub report for the remaining records Is this possible Crystal XI Thanks Peter

Hi all Is it possible to read information from an ini file into a crystal report Crystal Report XI

Hi all Is it possible to have a report which prints in portrait but includes a sub report at the end which prints in landscape Crystal XI Peter

Hi all Crystal reports XI, windows XP SP2 What I want to do is print a report but print three copies of the report with a different page header for each copy. Is this possible Peter

Hi all I want to be able to alter a column name from null to not null which i can do using the designer but if i try with the following script i cannot do this until i drop an index trhat uses that column. Is this possible from a script ALTER TABLE brokered alter column site_id numeric(2,0)not...

Crystal XI on XP If I create a form on one PC for a non standard size and then use this in a crystal report. I can preview and print correctly. If I then create the same form on another machine,use the same printer and run this, it defaults to the standard size on this pc. If I change the...

Hi all Crystal XI When I create a dynamic parameter on a colum in a report and then run the report I only get the first 1000 entries in the table. Is there a limit of the first 1000 entries for dynamic parameters Thanks Peter

Hi If I create a report in crystal XI that uses a custom form defined in server properties the report runs fine on the pc that I defined the custom form. If i create the same custom form on another pc and then try to run the report on this pc it does not use the custom form until I save the...

Hi all I need to produce a report which has upto 5 lines of detail printed followed by anoth 5 lines of detail with info for the same first lines. eg Report header Page header detail lines Product code 1 Code 1 description Product code 2 Code 2 description Product code 3...

Hi If I use the multiple columns how can I set the detail height using section expert layout tab as this is always greyed out Thanks Crystal 9 or 11

Hi all Is there any way to change the date parameter to ask for the date in format DD-MM-YYYY instead of the default of YYYY-MM-DD Thanks Peter

Hi all If i run a crystal report (version 9 to 11) on a sage database table I get the error The database table cannot be found. Proceed to remove this table from the report If I click no then the report continues to run, but if I click yes then the table is reomved from the report. Has anyone...

Hi all If I use the foxpro odbc version 6 I can only see character fields upto a maximum of 244 characters. Is there any way of extending this so that if a field is 600 characters long then this displays in full Thanks Peter

Hi I need to report a dbase table which has a 600 character field. I can do this if I use version XI using the xBase driver for the data source and aqll I need to do is set the field to Can Grow. However if I use the dbase or visual foxpro odbc driver I can only report on 244 characters of this...

Hi all Crystal 9 using ODBC Is there any way of reporting the location of the tables that are used in a report Thanks Peter

Hi all I am trying to print a base64 encoded signature which is in an xml file. Is there any way of printing this in crystal so that it is decoded and printed as a bitmap Many thanks Peter