[rm-users] Re: error message: no output

[Greetje Coninckx]

Hi all

I've found the solution: we had to choose "Oracle" in stead of "remote" in
the in the Local Database window.  Now everything is working fine.

Greetje


 
__________________________________
Greetje Coninckx
Information Technology Analyst
V 1.33
Virco
Generaal De Wittelaan L11 B4
B-2800  Mechelen
Belgium
Phone:  +32 15 285 613
Fax:    +32 15 286 346
__________________________________


on 07-07-2000 16:34, Nathan Stratton Treadway at nathant@ontko.com wrote:

> On Fri, Jul 07, 2000 at 04:05:09PM +0200, Greetje Coninckx wrote:
>> When I want to create a new report, I use a database with data in it (seems
>> logically, isn't it?), I can connect to the database and I can select tables
>> and fields and finish the report.  Then I can see the layout and the source
>> (also saving it is no problem), but when I want to do the last step, i.e.
>> seeing the preview, there is no output returned and I get the following
>> message:
>> 
>> The report ran successfully, but generated no output.  This can happen when
>> the query does not retrieve any rows from the database.
>> 
>> When I work with BrioQuery and take the same database I can create reports.
>> Do you have any suggestion about what I forgot or did wrong?
> 
> First, this is really an SQR issue, not a Portal issue.  You probably
> should ask this on the sqr-users mailing list.  (See
> http://www.sqrug.com/sqr-users/  for more information.)
> 
> From your description, it sounds like there is something set up wrong in
> the Join screen of the query which is preventing any rows of data from
> being returned by the SELECT in your program.  Make sure that tables are
> only joining on columns that actually do relate the two tables in
> question. 
> 
> (Report Builder's Auto-Join function can sometimes be
> confused if two tables both have columns with the same name but which
> don't actually have the same data in it.  For example, suppose you had a
> DEPARTMENT table and an EMPLOYEE table, where each EMPLOYEE had a DEPTNO
> column that linked back to the key of the DEPARTMENT table.  Then
> supposed both tables had an EMAIL column,  for a department-wide e-mail
> alias and the employee's individual addresses, respectivly.  In this
> case, the Auto-Join would try to join the two tables using the EMAIL
> column as well as the DEPTNO column, but since none of the EMAIL address
> would actually match, you'd get no rows back.)
> 
> Hope this helps.
> 
> Nathan
> ----------------------------------------------------------------------------
> Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
> nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/
>