Search results for query: *

Thanks to both of you. I resorted to using lbass's method to create a subreport (in the report footer) to show the few lines that my main report did not pick up. Works fine except for the part number sequence.... Dirk S dirk@dol.dot.ie

I sincerely hope this is just a systax thing...here goes: I have 2 tables: parts ===== partnum descr type ------- ----- ----- A0001 Part1 STxxx A0002 Part2 FGxxx A0003 Part3 FGxxx etc... pricelist ========= partnum listname price ------- -------- ----- A0001 A0001a 5.10 A0001...

Wolfgang<br><br>You do not say what method you use to call the reports. If you use the Crystal OCX to call the report, then look at the &quot;connect&quot; property - it allows you to change the database &quot;DSN&quot; , &quot;UserID&quot; and &quot;Password&quot; dynamically.<br><br>I hope...

The principle is that the ODBC source MUST exist. <br><br>Once you have set this source up and connected to it successfully, you can use the OCX &quot;connect&quot; property at runtime to connect to the correct ODBC source.<br><br>Now lets look at your error: If you have the ODBC source working...

Is there a way to print a group footer at the end of each page? That would solve my problem (and make my day :)

I have a Report that where almost all the sections can vary in length. It has a Page-Total printed in the Page-footer. <br><br>However this often results in a huge gap between the other sections and the Page-footer.<br><br>Is it possible to set the Page-footer to print directly after the last...

Hija<br><br>I know this is an old post, but anyway ....<br><br>Are you sure that the correct ODBC sources with the SAME name exists on the other machine? As the DSN is the ODBC name, it must be exactly the same!<br><br>I hope this helps :)

I have 2 (Progress) databases: Live and Test. I set different DSN's at runtime depending on the database the report is called from. This works perfectly for Main Reports.<br><br>I have tried to find a way to set the DSN for my Subreports at runtime, without success. Is it possible??<br><br>Thanx

Eureka !

I tried it, but it only prints on the last page and I need it to print on every page BUT the last :(<br><br>Let me re-phrase my problem:<br><br>My Report Prints a BIG (6 @ page max) detail section. It prints a page footer with running-totals for some of the fields in the Detail Section. At the...

The function you used will return the 3 zero's to the right.<br><br>I would use:<br>Left({table.Field},(length({Table.Field} - 3)))<br><br>That would take care of variable length values in the field as well.

I have a report where I calculate a 2 Running Page Totals. At the end of the report I print 6 different possible Report Totals in the Report Footer (Any number of which can print). These Group Totals are suppressed if they are 0, and they are grouped to print on one page (using &quot;Keep...

Is it possible to create a Report to be used as a Sub-Report in a number of other reports, and at the same time be dynamic i.e. if I change anything in this Sub-Report it will be changed in all reports that it is used in? <br><br>I have found that my Sub-Reports are static, necessitating changes...

Thank you Malcolm. I can see the one Subreport in design view, but as the report prints other information not included in the main report or this subreport, I believe that there must be yet another Subreport. I have made all sections visible, looked in all, and still cannot find it. Anyone have...

I have a problem with not being able to see the SubReports in Design view. The Reports was not created by me but by a predecessor in the company. I KNOW it is there - am I going <i>blind</u> ;-) Please help<br><br>(I am using version 6)