Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pmgatwork

  1. pmgatwork

    crytsl link tables based on nearest date

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

    How to prevent excel converting imported data to dates

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

    Automating Report Creation

    Take a look at Visual Cut from Milletsoftware Peter
  4. pmgatwork

    list all char columns

    Thanks
  5. pmgatwork

    list all char columns

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

    find last position in char string

    Thanks Mark. That worked
  7. pmgatwork

    find last position in char string

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

    reading data from ini file

    dglitz Which text driver did you use Peter
  9. pmgatwork

    sub report and page breaks

    Thanks With a bit of moving around the suggestion worked
  10. pmgatwork

    sub report and page breaks

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

    Crystal Reports XI with dbf files

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

    reading data from ini file

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

    Sub reports on different size of paper

    Thanks all I think that I will wait before venturing into 2008
  14. pmgatwork

    Sub reports on different size of paper

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

    printing multiple copies

    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
See more

Part and Inventory Search

Back
Top