Search found 154 matches
- Wed Mar 21, 2018 10:43 pm
- Forum: R&R ReportWorks Users
- Topic: Select number of report lines
- Replies: 2
- Views: 15431
Re: Select number of report lines
The easiest way I can think of doing this is to create three fields: 1. A ParameteRR field which holds the number of records you want to create the limit for 2. A running total field of the value you want to restrict (count) 3. A boolean / logical calculated field comparing the ParameteRR with the t...
- Thu Feb 15, 2018 6:47 pm
- Forum: R&R ReportWorks Users
- Topic: Problems with SCANNING lines in report
- Replies: 3
- Views: 16847
Re: Problems with SCANNING lines in report
I understand what you're saying. Unfortunately, the graphic I posted in my previous comment got messed up (leading spaces were deleted). Multi-scans similar to what I think you're trying to do are R&R's answer to sub-reports. If you'd like some assistance, we can help. Something like what you're try...
- Tue Feb 06, 2018 7:49 pm
- Forum: R&R ReportWorks Users
- Topic: Problems with SCANNING lines in report
- Replies: 3
- Views: 16847
Re: Problems with SCANNING lines in report
HI Bruce, If you're scanning from the master into both child DBs, you need to take into account that you're essentially creating a checkerboard resultset: MMMM CCCCCCCCCCCCCCCCCC MMMM CCCCCCCCCCCCCCCCCC MMMM CCCCCCCCCCCCCCCCCC MMMM DDDDDDDDDDDDD MMMM DDDDDDDDDDDDD So that any query you impose on the...
- Mon Jun 05, 2017 1:26 pm
- Forum: R&R ReportWorks Users
- Topic: Export/Excel Issues
- Replies: 2
- Views: 8996
==> RE: Export/Excel Issues
I agree, this is very odd.____This is something we^ll try and test to see what^s going on.
- Mon Jun 05, 2017 1:24 pm
- Forum: R&R ReportWorks Users
- Topic: Lookup for memo files
- Replies: 1
- Views: 8301
=> RE: Lookup for memo files
A lookup on a memo would be a good idea. Unfortunately, these types of fields are treated very differently by Xbase, being kept in a separate memo file with only a pointer to the specific location for a record.____We^re looking into making memos more accessible within R&R in general, including t...
- Mon Jun 05, 2017 12:19 pm
- Forum: R&R ReportWorks Users
- Topic: FollowMe drivers not working with R&R
- Replies: 4
- Views: 12027
=> RE: FollowMe drivers not working with R&R
Sorry for the delay in replying. We appreciate your support.____You don^t specify how the reports are being executed. Typically, the message you^re getting is thrown by a runtime shortcut trying to us a printer that^s no longer available.____A typical shortcut / runtime input file looks like:____RI_...
- Mon Jun 05, 2017 11:58 am
- Forum: R&R ReportWorks Users
- Topic: Visual FoxPro Message
- Replies: 10
- Views: 149726
=> RE: Visual FoxPro Message
Sorry for the delay. Thanks for supporting R&R.____If you haven^t installed R&R on your system using the actual Windows MSI, then it^s possible that the libraries aren^t present.____The files R&R is looking for (for the Librarian in this case), are:____VFP9R.DLL__VFP9RENU.DLL__VFP9T.DLL_...
- Mon Jun 05, 2017 11:52 am
- Forum: R&R ReportWorks Users
- Topic: Putting text/image on lines with multi-line memo fields
- Replies: 3
- Views: 11592
=> RE: Putting text/image on lines with multi-line memo fields
If I understand your question, properly, I think the answer is that you create the lines with your images and the memo fields as "freeform" height and just expand them enough to hold the image file comfortably.____I just did a quick report where I had two such lines (using the same memo fi...
- Mon Sep 14, 2015 6:09 pm
- Forum: R&R ReportWorks Users
- Topic: Connecting to SQL 2008 database
- Replies: 2
- Views: 4914
=> RE: Connecting to SQL 2008 database
You can also create an R&R calculated field using the SQLEXP() function (which forces the SQL database to evaluate the contents of the parentheses).____Example: SQLEXP("CAST(allbuses.pickup as char(20))")
- Wed Apr 29, 2015 2:18 pm
- Forum: R&R ReportWorks Users
- Topic: RTF Export Title Band - Header section
- Replies: 1
- Views: 4038
=> RE: RTF Export Title Band - Header section
I think the best solution would be for you to create a large group header band for the first page that takes up all the space and then insert a "page break" into the report following it. Also, create a conditional field on the record number that controls showing the header band.____OnFirst...