Search found 22 matches
- Thu Mar 24, 2005 3:39 pm
- Forum: R&R ReportWorks Users
- Topic: Memo field
- Replies: 3
- Views: 2851
===> RE: Memo field
Insert the memo field on your report and set the width to 7.5 inches (or what is appropriate) and alignment to Left with word wrap on. ____Randall
- Thu Mar 24, 2005 3:35 pm
- Forum: R&R ReportWorks Users
- Topic: Lots of calculated fields?
- Replies: 2
- Views: 2267
=> RE: Lots of calculated fields?
Could you set up groups for ZONE, PAY_FLAG, INTCODE, RES_FLAG, etc. and create a subtotal at the lowest group level that prints on the group footer band with the values of ZONE, PAY_FLAG, INTCODE, RES_FLAG, etc. being printed in the corresponding group header?____Randall____
- Fri Mar 04, 2005 2:09 pm
- Forum: R&R ReportWorks Users
- Topic: sum over a certain ID
- Replies: 6
- Views: 4298
===> RE: sum over a certain ID
It refers to the group Reset (Grand Total, group1, group2....). Put the total field in a group footer line so that all the records will be processed and create the correct total(s).__
- Fri Mar 04, 2005 11:40 am
- Forum: R&R ReportWorks Users
- Topic: sum over a certain ID
- Replies: 6
- Views: 4298
=> RE: sum over a certain ID
Define a group for ID_NO - you may also want to sort by ID_NO. Then create a Total Field (ID_NO_TOT) with a reset on the ID_NO group. Finally, place ID_NO_TOT in an ID_NO bandline.____Randall
- Tue Nov 16, 2004 5:00 pm
- Forum: R&R ReportWorks Users
- Topic: Using a string in IIF or CASE
- Replies: 4
- Views: 3231
===> RE: Using a string in IIF or CASE
Try this:____CASE(str(CONTRACT->UNITPRICE,,2),__str((P1_PRICE,P1_AMOUNT),,2),"",__str((P2_PRICE,P2_AMOUNT),,2),"",__str((P3_PRICE,P3_AMOUNT),,2),"",__str((P4_PRICE,P4_AMOUNT),,2),"",__str((P5_PRICE,P5_AMOUNT),,2),"",__str((P6_PRICE,P6_AMOUNT),,2),&qu...
- Mon Nov 15, 2004 5:08 pm
- Forum: R&R ReportWorks Users
- Topic: Using a string in IIF or CASE
- Replies: 4
- Views: 3231
=> RE: Using a string in IIF or CASE
From R&R Help:____"IIF(condition,true-value,false-value) where condition can be any data type. The values returned, true-value and false-value, must be the same data type, but need not be the same data type as condition."____One option is to change your IIF statement from____ IIF(self_...
- Wed Oct 27, 2004 1:13 pm
- Forum: R&R ReportWorks Users
- Topic: Export to Worksheet
- Replies: 4
- Views: 2974
=> RE: Export to Worksheet
In the Worksheet Export Dialog box indicate which band you wish to export (record, group header, group footer, etc.). R&R can only export from one band.
- Tue Oct 19, 2004 5:37 pm
- Forum: R&R ReportWorks Users
- Topic: Line number in report
- Replies: 1
- Views: 1876
=> RE: Line number in report
You can count the number of records printed on a page with a Total Field that resets on each page. Then, if you know the number of lines per record, and lines in headers and footers, you should be able to calculate the number of lines per page.
- Wed Oct 13, 2004 2:58 pm
- Forum: R&R ReportWorks Users
- Topic: Total counting records
- Replies: 2
- Views: 2280
=> RE: Total counting records
Use a condition in your total field where it has to be greater than zero (e.g. FIELD > 0).
- Tue Aug 31, 2004 1:56 pm
- Forum: R&R ReportWorks Users
- Topic: Printer Misdirection
- Replies: 1
- Views: 2009
=> RE: Printer Misdirection
With XP we have to set up a network printer as a "local" printer.____When adding a printer in XP, first indicate that it is a "local printer attached to this computer." Next, select the port of the desired network printer. Then proceed to install the printer driver, etc.____Randall