Search found 22 matches

by Randall_Warden_(Guest)
Thu Mar 24, 2005 3:39 pm
Forum: R&R ReportWorks Users
Topic: Memo field
Replies: 3
Views: 2062

===> 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
by Randall_Warden_(Guest)
Thu Mar 24, 2005 3:35 pm
Forum: R&R ReportWorks Users
Topic: Lots of calculated fields?
Replies: 2
Views: 1746

=> 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____
by Randall_Warden_(Guest)
Fri Mar 04, 2005 2:09 pm
Forum: R&R ReportWorks Users
Topic: sum over a certain ID
Replies: 6
Views: 3222

===> 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).__
by Randall_Warden_(Guest)
Fri Mar 04, 2005 11:40 am
Forum: R&R ReportWorks Users
Topic: sum over a certain ID
Replies: 6
Views: 3222

=> 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
by Randall_Warden_(Guest)
Tue Nov 16, 2004 5:00 pm
Forum: R&R ReportWorks Users
Topic: Using a string in IIF or CASE
Replies: 4
Views: 2402

===> 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...
by Randall_Warden_(Guest)
Mon Nov 15, 2004 5:08 pm
Forum: R&R ReportWorks Users
Topic: Using a string in IIF or CASE
Replies: 4
Views: 2402

=> 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_...
by Randall_Warden_(Guest)
Wed Oct 27, 2004 1:13 pm
Forum: R&R ReportWorks Users
Topic: Export to Worksheet
Replies: 4
Views: 2197

=> 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.
by Randall_Warden_(Guest)
Tue Oct 19, 2004 5:37 pm
Forum: R&R ReportWorks Users
Topic: Line number in report
Replies: 1
Views: 1422

=> 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.
by Randall_Warden_(Guest)
Wed Oct 13, 2004 2:58 pm
Forum: R&R ReportWorks Users
Topic: Total counting records
Replies: 2
Views: 1734

=> RE: Total counting records

Use a condition in your total field where it has to be greater than zero (e.g. FIELD > 0).
by Randall_Warden_(Guest)
Tue Aug 31, 2004 1:56 pm
Forum: R&R ReportWorks Users
Topic: Printer Misdirection
Replies: 1
Views: 1464

=> 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