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

    executing sql query in crystal

    Hi, I think you should try to optimize your query outside crystal and then use it. In the other hand maybe you already know there more ways to get a report done, like using ODBC, that way crystal makes its own SQL.
  17. glauco

    Oracle Datatype of Long and Crystal Formulas

    Hi, If you can't beat them, join them. How about this idea? Why don't we put another supressed in details a, so this will move a cell in export to ? Try it, i haven't.
  18. glauco

    Select Expert and Formula

    Hi, This is something I've tested: You can hide data by formatting a section and in the "Supress Formula" you put the formula wich returns false or true, depending on what you want to do. Remember your formula gets is value in the footer so take care if you want to suppress a section...
  19. glauco

    Custom Paper Size Problem...

    Hi guys, I hope someone out there can throw light to me in this situation: I have a report (version 7) that use a custom paper size in a dot mattrix (Epson) and it was working just right until they migrate to Windows 2000. Now Windows doesn't allow me to make a custom paper size thru my...
  20. glauco

    Custom Paper Size and Win2000

    Hi guys. I want you to give me a hand in this subject please: I have a report with a custom paper size configured in a Epson FX-1170, this printer enables the use of this size in Windows 98, the problem is that now we have win 2000 and the report cannot be configured with that custom size...

Part and Inventory Search

Back
Top