Search found 154 matches

by cstrasser
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...
by cstrasser
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...
by cstrasser
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...
by cstrasser
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.
by cstrasser
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...
by cstrasser
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_...
by cstrasser
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_...
by cstrasser
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...
by cstrasser
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))")
by cstrasser
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...