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

Take a look at Visual Cut from Milletsoftware Peter

Thanks

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

Thanks Mark. That worked

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

dglitz Which text driver did you use Peter

Thanks With a bit of moving around the suggestion worked

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

Its is quicker if you use an ODBC connection rather than the xbase driver Peter

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

Thanks all I think that I will wait before venturing into 2008

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

Thanks I also found another example of this which Ido had a solution for and this worked. Should have checked before I posted Many thanks

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

Setting no printer does not work The custom form is larger than normal size so if I set no printer then i only get a4 size. Peter

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

Dave Dynamic parameter. Not sure what you mean by not building a value list Peter