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 TouchToneTommy 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 glauco

  1. glauco

    Blank subreports creates errors

    This is not my idea but i think i can make it clear. Whe dhookom writes: Another option (I prefer) is to create totals queries from the record sources of your subreports. Combine these totals queries with into your report's record source joining on the field(s) you would have used to Link...
  2. glauco

    Crystal from HTML, basic sintax.

    Hi everyone, I'd be glad if you can answer this: I've been making EXE files for my reports in CR7 and CR8 but I've been trying to understand how i can see my reports from a HTML page or just from a vbscript file. I get to see the controls in a web page but not the report. What's the basic...
  3. glauco

    Skip line with NO REASON

    Hi Guys. This is the subject: I preview a report on screen and it looks ok, in the second page after printing 2 lines of detail it just jump 3 lines and then everything after is a mess. Im using CR 8.5 and Win2K and the page size is 8.5X5.5, there's no special character like chr(13) to make it...
  4. glauco

    Suspicious Blank Lines

    Thanks for answering, but there's not special character in my report, besides, i print the report in different dates with the different data and always the same: The second page skips some lines.
  5. glauco

    Suspicious Blank Lines

    Hi Guys. This is the subject: I preview a report on screen and it looks ok, in the second page after printing 2 lines of detail it just jump 3 lines and then everything after is a mess. Im using CR 8.5 and Win2K and the page size is 8.5X5.5 Thanks in advance for all the help you can give me.
  6. glauco

    Preview/Printing Difference. Skip some lines.

    Hi, I'd appreciate all help i can get from you my fellows. I have a report wich must be printed on a 8.5 x 5.5 paper, this is in win2K so I created a form 8.5x5.5, everything seems ok so far. The problem comes when the report is printed, in the second page, specifically on the detail section...
  7. glauco

    How to use .qry parameters in CR report?

    Hi, Maybe i don't understand but why dont you use crystal parameters?
  8. glauco

    Control # of columns from VB code?

    Hi, I recommend using crosstab reports in case the number of columns is varying about the data in a table. For example, i had to make a report from the payroll. The data's organized so that every record has EMPLOYEE, TYPE-OF-TRANSACTION, AMOUNT (just for example). I used i cross-tab so for...
  9. glauco

    Selection Expert bug

    Hi, These guys are quite right, i had this same problem, i got the answer creating a view with the column and using a function as described early in this page, i tell you this so you don't get confused in using a sql expression in crystal, it'd not work, you must use a function in the server.
  10. glauco

    Linking a table from with columns from two separate Tables

    Good Morning, I don't see why you couldn't do it 'cause is quite simple the way you explain, are you using a very old version of crystal or check the data type of the columns. You are so clear that i know you're almost done with that problem, just try to check again.
  11. glauco

    Grouping on Parameter fields

    Since you have a date range to filter data in the report all the records get to be in that same range, how come you want to group by that range if you only have one ? or do you mean to group in that range day by day ?. Please be more specific and clear, we'd like to figure out so we can help...
  12. glauco

    default printer problems

    Hi, I got this from help file: In general, it is a good idea not to choose a specific printer. Even though the printer may be identical to the default printer, how the printer is recognized can still vary for different operating systems. If you select a specific printer, Crystal Reports looks...
  13. glauco

    executing SQL query by crsytal rpt

    I got this from crystal help file. Preview Sample dialog box This dialog box appears when you choose the Preview Sample command from the Print menu (under the File menu). Use the Preview Sample dialog box to select how many records you want to preview.
  14. glauco

    Help doesn't function

    there are two kind of help, html help works only with Netscape, so get the compiled help file that comes in the CD as you install
  15. glauco

    Problem with Groups and "Others"

    Hi Kyle, there's a way to limit the number of groups that :"you want change", well i don´t know what you mean with "change" and i think limit is not your problem, First of all you have records with no "user name" or user name = "Others" in your data...

Part and Inventory Search

Back
Top