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

    Record Selection & Subreports

    Thanks again for your help. You wrote: "If your subreport is in the Details section, the correct data will be shown." This is definitely a useful suggestion. Maybe a stupid question, but how can I prevent my subreports to be printed a zilion times? You wrote: "I created a...
  2. Stroeve

    Record Selection & Subreports

    Which records are being displayed? All of them? ANSWER: No just the records where PROBLEMS.ORGANIZATION_ID="20000081". In which section is your sub report? Details? ANSWER: In a Report Footer.
  3. Stroeve

    Record Selection & Subreports

    Thanks for you reaction. I tried this, but it didn't work.
  4. Stroeve

    Record Selection & Subreports

    I have created a CR6 report with several subreports. In the main report I use the following record selection: {PROBLEMS.ORGANIZATION_ID} in ["20000082", "20000081", "10000011"] All the subreports are linked with this field called PROBLEMS.ORGANIZATION_ID to the...
  5. Stroeve

    Need help Exporting Crystal to PDF and Word for Windows

    Another way to export to a pdf-file (work with any application): 1) Install a postscript(!) printer driver (eg. HP Laserjet 5P/5MP PostScript) 2) Go to the properties of this printer driver and change the Port to "FILE" (Creates a file on disk) on the 'Details' tab. 3)...
  6. Stroeve

    Count duplicates

    My database administrator does not allow me to change anything in the database itself. My question is this: can I enter the "Count(*) AS [counter]" part somewhere in CR? SELECT DISTINCT System, Component, Item, Module, Count(*) AS [counter] FROM Table1 GROUP BY System...
  7. Stroeve

    Count duplicates

    Thanks!
  8. Stroeve

    Count duplicates

    I'm using CR (6) for about a week now and I'm still having difficulties in achieving the following: CURRENT REPORT: Database Fields are SYSTEM, COMPONENT, ITEM, MODULE. Grouping is set on SYSTEM. SYSTEM COMPONENT ITEM MODULE Applications Cognos Powerplay One Applications...

Part and Inventory Search

Back
Top