Crystal 8.0 "No rowset was returned error"

[Theadmans]

Hi,
I am using Crystal V8.0 connecting SQL Server Tables. I need to make a mod to an existing report which currently only uses one table. I decided to add a new table to the report and join the tables using an Equal Join using the Crystal Visual Linking Expert. I then put a new formula on the report which uses data from the table I just linked in.

Now when I run the report I get "No rowset returned for this table, query or procedure"

As far as I can see the link should return data. Can anyone tell me what the problem is likly to be - It is driving me mad!!!

 

[synapsevampire]

Use Database->Show SQL Query and go paste the query created into Query Analyzer and see if it returns data.

The join probably isn't working, but we don't know your database.

You might change it to a left outer, and make sure that youdon't have anything in the record selection formulas until you start seeing data.

-k

 

[Theadmans]

Hi,

Thanks for your quick response. I have tried a Left Outer Join and I get the same error. I don't have anything in Record Selection or Group Selection. Have you got any other ideas?

 

[synapsevampire]

Yep, your join is incorrect.

-k

 

[Theadmans]

In my main table there is currently only one record. I am joining using a ClientID field into a Clients Table that also has the ClientID. If I use Enterprise Manager to query the client table for the ID in the main table the client is found?

 

[synapsevampire]

That's why I suggested copying the query from Database->Show SQL Query and pasting it into Query Analyzer (Enterprise Manager)to see what it returns.

There's something different there.

-k

 

[Theadmans]

Yeah sorry - I have tried the Show SQL thing (not used that before). I have noticed that the resultant SQL Query makes no mention of the JOIN at all!? Despite the fact that the Visual Linker shows the JOIN.

I am wondering if the fact that there is a Record Sort on this report is stopping the Link working?

 

[lbass]

Also try browsing each client ID field to ensure that they are appearing in the same format if they are strings, i.e., make sure that the client ID doesn't appear as "01" in one table and "1" in the other.

-LB

 

[synapsevampire]

Place a field fromthe second table on the report canvas, then it should show.

-k

 

[Theadmans]

Thanks for all your help. With a bit of fiddling about with the Show SQL Query I have finally got this to work - cheers.