CR8.5 errors when adding new fields

[sixtoesofdean]

Firstly, apologies for this post because I guess anybody thats used Crystal has had this sort of problem in the past, however I'm loosing the will to live and havn't found anything thats helped so far:

- I have a sub report
- It has a number of shared variables (set by parent reports)
- It also has a few user defined formulae.

In so far as I can see there is nothing complicated about it, however it simply generates the error "No rowset was returned for this table, query or procedure", followed by a now very familiar "Error detected in database dll" - whenever I try to add a new db field to it.

Refreshing doesn't help (obviously, its at this point I get the error).

I'm pretty sure its connecting to the db and that I have sufficient access rights to go about my stuff (see below).

If I start removing objects in the template I still get the error until there's nothing left. So after deleting everything I can get it to preview a blank report. Not ideal

However, even with all formulae and fields deleted, and running through the report wizard again (thereby trashing whatever was left), I still get the error (regardless of what table I select).

If I start a brand new report then everything seems fine. However I'm not looking forward to copying every single object in 80 or so reports into new templates just to get them working.

I'm beginning to think that somehow the crystal report template has some sort of security issue with the db, or maybe trying to reference the db through a dodgey url \ udl name; the reports were never created on my PC. However I'm dubious about this since in the suspect templates I can browse data (i.e. Ctrl+B) when in the field explorer.

I'm sure I'm running the latest service pack for CR8.5 too.

Kicking the PC and putting rude words with "Crystal" in google hasn't helped either.

 

[synapsevampire]

Before you make a mess of the place force feeding yourself to the CPU fan, try Database->Verify Database

Just in case, open the subreport and do it in there as well.

This will check the connectivity.

It may be that someone has changed the database on you, your rights, or even the ODBC connection if one is used is no longer correct.

If this doesn't resolve, try posting details, such as the database used and the type of connectivity.

-k

 

[sixtoesofdean]

Thanks for the response... I'd forgotten to mention that I'd already tried veriffying the db (Its SS2000 btw) - and although it did highlight changes, it didn't help. Just to recap:

Some data is being passed back; in the preview pane there is a tree displayed on the left that contains (I presume) grouping information. This is being populated. I'm also able to browse the data for db fields on the report template (Ctr+ from field explorer). Its just the damn report itself in all its glorious gestalt - doesn't work!!

Again - thanks for the reply.

 

[sixtoesofdean]

An update on this, for anyone else that happens to find themselves in this soul-destroying position....

It works today. I'm not sure why. A colleague of mine managed to get the same template working, noticing that the SQL held within did not specify an alias. It seemed that this was the cause of the problem

I tried reproducing the same keystrokes on my PC (yes - down to keystrokes now)... And the damn thing worked! Nothing was ever changed so I find this a bit frustrating.

However, I'm pretty sure that when I tried adding new fields (and new tables) that crystal wasn't asking me to specify an alias for the table. I'm pretty sure this is the case since I've no memory of a dialogue popping up to ask me. However, now it does. Though this is now resolved, I'm wonderting why it never prompted in the first place, and, with no interaction on my part, now prompts for an alias.

If anyone else finds themself in this situation, this might be the reason why....