Liveware Publishing Support Forum

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

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

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.

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

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.

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

I^m aboout 99% sure you can^t do more than one left outer join.

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

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

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