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!

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

Search results for query: *

  1. GaryRogers

    Schedule Export to PDF

    There is a utility that CrystalDesk has that does exactly what you are looking for. You just specify a source folder that contains all of the .rpt files and destination folder where you would like the pdf files exported to. You can also specify the frequency that you would like the source...
  2. GaryRogers

    Export 1 report for each group

    I think the most cost effective way would be to use a 3rd party utility. We offer a Report Scheduler that will perform this task automatically. It will output to many formats including a word doc. I think a better export format is pdf if that will work with your agents. You can download a...
  3. GaryRogers

    Hoe to Automate A Seagate Crystal report?

    We have some products that may help you. Report Scheduler will automatically output and email Reports to many formats. Report Viewer will allow your reports run from a batch file or view print and email them from an interface Gary Rogers CrystalDesk (Report Scheduler) Crystal Reports...
  4. GaryRogers

    Alias Tables and SQL

    The description of the query is not very clear to me. But it sounds like you may need to add a copy of the other 2 tables as alias as well. You also may want to consider using a View from the SQL database. I have had no problems with using multiple copies of tables using SQL Views. I hope...
  5. GaryRogers

    schedule report/save to different files

    Hi Crystal Reports does not have a way to schedule reports. You can download this utility from CrystalDesk that will allow you to schedule reports to be exported and saved or printed. The download is a 30 day trial if you want to purchase it the price is $199...
  6. GaryRogers

    display a comment field (filtering on the date field)

    Yes there are a couple of ways to do this. The most efficient way is to modify the SQL Query to get the most recent data by adding a Sub Query something like this "Where NoteDate = (Select Max(NoteDate) From NoteTable). This should retrieve only the latest records. You can also...
  7. GaryRogers

    SQL PROCESSING ORDER

    There are a couple of choices here. You could use a sub report, although for every sub report a separate query is run which effects report performance. From what I can see from your report description you may be able to use Cross Tabs. Cross tabs are very easy to use and you can place as many...

Part and Inventory Search

Back
Top