...subreports. Combine these totals queries with into your report's record source joining on the field(s) you would have used to Link Master/Child.
* He's telling you to sum from a query, not from the subreport itself, this way the result will be zero in case there´s no data in your subreport...
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...
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...
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.
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.
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...
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...
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.
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.
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...
...name must be the same as the name of the printer the report was designed on. Be aware that anyone printing the report must use that same printer or they could encounter problems.
---------------------------------------------
* If you´re using a network printer you should check for avalability.
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.
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...
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.
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.