Search found 20 matches
- Mon Apr 28, 2003 1:36 pm
- Forum: R&R ReportWorks Users
- Topic: Drop-down list
- Replies: 6
- Views: 3005
======> Follow up
I thank Kathleen for solving this. Here^s what we found:____She used this calulated field:____LTRIM(TRIM(ID))$param1____I^d used R&R for almost 9 years and never noticed the $ operator. __ __When I played with it some more here^s what I found:__ __The LTRIM didn^t matter, although I realize it^s...
- Sun Apr 27, 2003 12:57 pm
- Forum: R&R ReportWorks Users
- Topic: Drop-down list
- Replies: 6
- Views: 3005
==> Using Parameter file for queries
I^ve been playing with this. If you use R&R icon builder or the Rapid Runner, the conrol file is unavailable. ____If you use a parameter file, you can query for a single item, (i.e. ID=Param1), but I have not figured out a method to Query for an "In the List" using a parameter.____My t...
- Fri Dec 27, 2002 10:34 am
- Forum: R&R ReportWorks Users
- Topic: Code for running a report
- Replies: 8
- Views: 3965
======> RE: Front End
In the runtime documentation there is a runtime status file. The implication is that you can check this file to see when your report is done. I haven^t actually done that myself, but it seems like a good idea to check that out.
- Tue Dec 17, 2002 1:18 pm
- Forum: R&R ReportWorks Users
- Topic: Code for running a report
- Replies: 8
- Views: 3965
====> Front End
R&R keeps coming out with major changes I could care less about (Librarian, etc), while ignoring the fact that they need a really slick front end to run reports from.____They give us icons, and Rapid Runner (which is a good start). ____But nothing they give us allows us to define pull down lists...
- Mon Dec 02, 2002 11:55 am
- Forum: R&R ReportWorks Users
- Topic: Anyone have a Front End for R&R?
- Replies: 5
- Views: 2773
==> RE: Front End for R&R?
The ? mark prompt only allows for text entry. A sophisticated reporting system would allow users to choose their choices (when appropriate) from a drop down list of choices.____Yes, I do think a VB front end is what^s required. I may e-mail you.____Thanks.
- Sun Dec 01, 2002 6:44 pm
- Forum: R&R ReportWorks Users
- Topic: Anyone have a Front End for R&R?
- Replies: 5
- Views: 2773
Anyone have a Front End for R&R?
R&R desperately needs a runtime front end that allows the report writer to prompt the user for input (for example to filter the report) and that allows the user to select from a list of choices.____For example if you have a report of auto parts, the user should see a list of Cars, and then he se...
- Fri Nov 01, 2002 4:48 pm
- Forum: R&R ReportWorks Users
- Topic: SQL Multiple Left Outer Join
- Replies: 2
- Views: 1724
=> RE: SQL Multiple Left Outer Join
I^m aboout 99% sure you can^t do more than one left outer join.
- Sat Aug 31, 2002 9:12 pm
- Forum: Enhancements / Suggestions / General Comments
- Topic: Text Property - Label
- Replies: 1
- Views: 1977
Text Property - Label
I have a series of scans on record lines. I^m going to create a label that I want to print once on the first record of each scan group.____So I^ll need to set up a counter that tells me when I^m on record 1, and then set up a either a conditional print line or a calculated field that prints out when...
- Sat Oct 27, 2001 9:39 pm
- Forum: R&R ReportWorks Users
- Topic: Left Joins in SQL 9.0 versus Xbase
- Replies: 1
- Views: 1238
Left Joins in SQL 9.0 versus Xbase
I^m a long time xbase user, currently on 9.0. I use Access a lot also, so I just ordered a copy of 9.0 SQL.____I hit a wall almost immediately. One that^s so basic I can^t believe it^s not me doing something wrong.____Let^s say I have a master datafile full of ID numbers. I want to report on 3 relat...
- Wed May 09, 2001 6:27 pm
- Forum: R&R ReportWorks Users
- Topic: Take The Flex Link Challenge
- Replies: 2
- Views: 1966
Take The Flex Link Challenge
In my report writing I try to minimize scans whenever possible. In prior versions, I will even do 3 lookups to check for 3 possible values in a field rather than do a scan and handle the results.____I was hoping Flexlink would solve this problem by allowing us the use of Case or IIF functions. But t...