Using 1 table w/o a join

[rokosz]

I am a new user.____if you saw my earlier emails re the "help" option -- a reinstall with careful attention to "help" & "samples" selection did the trick.____Now as to the subject.____All the reports in the app will make use of relatively "static" data stored in "detached" files. (e.g. in the Header of all reports will be the client^s facilty/Place of business name -- this is stored in a table that rarely if ever is part of a join. ____I can^t find any way of making files available _without_ a coding a join. None of the samples appear to do this.____Is there a way to make multiple files available without requiring a join?____thanks, BP

[freitas]

read about the rrwunin.dbf file. In there is a field called ri_master. You can create a small program that ask the user for the file name or have a list of files to report from as in a listbox. Once you know the file, however way, copy that name into the rrwrunin.dbf ri_master field.____I assume you are using R&R 8.1 or greater for xbase. The command to run the report would then be rrwrun.exe rrwrunin 1____rrwrun.exe is the free runtime engine __rrwrunin.dbf is the report file__1 is the record number in the rrwrunin.dbf file.____If you are running this through a database program, it would appear as run(.t.,"rrwrun.exe rrwrunin 1")

[rokosz]

I was about to go searching for rrwunin.dbf -- then realized I^m not using r&R Xbase -- but R&R 10+ SQL__You don^t by chance know the equivalent control file for the SQL version?

[freitas]

Sorry, I do not use the sql part of R&R. Put another query on this page asking Kathleen directly, see will be able to advice you.

[kfleming]

You could store this info in a text file and then in the report designer use Insert->Text file to add this file to the report. You can then place it on the layout from the Insert Field list.____Kathleen__R&R Support

[rokosz]

I^ve taken a quick look at your insert->text suggestion. That will work fine for the "company name" appearing in the header/summary. (I^m trying not to clone each report for each client and then maintain all those, essentially, duplicate copies) ____But there are more application-specific reasons for wanting to work outside the "join-set" of each report.____I^d thought I^d pass each report some parameters (eg. User Initials) for display in the header.__As I recall from analysis prior to purchase, parameters can be passed to reports on the call line...Yes?____There are going to be more one-off/esoteric things happening in some reports. These happenings may appear in any band -- but are not part of the join set. ____Calcuations-User Functions doesn^t seem "meaty" enough for these one-offs:(except as a venue for CDLL)__It seems what I^m looking for is CDLL(). (just found it) I need to wait a week for one of my folks to be back, however:____Do you believe, that that is the ultimate for exposing information to the report?____The help mentions, obliquely, a speed concern when using DLLs. What is the factor? Is there a benchmark? Something like a User Function that adds 10 days to Date() versus a CDLL call returning the same info from a DLL?____If you find time to answer all this, I^ll be most grateful.__Thanks, Bryan____

[kfleming]

If you are passing things for display only then you can still use a text file since it supports the use of multiple fields within the text file. See the documentation for more information.__A CDLL() call will always have more overhead than a user defined function. If you are going to use CDLL() you may also want to pre-load that file on the command line. The switches are again contained with the documentation/help.____Kathleen__R&R Support