Failed to open a rowset

[Crider]

I am working on forms which have a lot of sub reports. Because of the amount of data, there will be times when some of my stored procedures don't return a rowset simply because no data exists for that person on that part of the form. Is there a way within Crystal to easily tell Crystal to ignore the empty rowset message and continue processing?

Thank you

 

[MVisconte]

How about adding conditional code to the SP to test for 0 records, and force a single record return is that is the case? The single record would include dummy columns for each field, and a special value in one of the fields. Test for the special value upon return.



--
Marc Visconte
CSC
Lead RMS Developer
Crystal Reports

 

[Crider]

That's what I have been doing and that works. I was just wondering if there was a way within Crystal to override the error. I will continue with the dummy row solution which has been working for me.

 

[MVisconte]

I also believe that there are some (minor) conditional formatting capabilities in CR 8 on. I have not had need to use them, but, they let you supress sections on zero records. I use something _similar_ by conditionally showing one section on recordcount = 0 or on isnull({UniqueMandatoryField})

I think I wound up using the second one as it responded correctly with more consistancy that the Record Count = 0.

Then again, I'm guessing at what you're trying to achieve.

;-)

--
Marc Visconte
CSC
Lead RMS Developer
Crystal Reports

 

[MVisconte]

Whups...

There are two or more areas where you can specify SUPRESS PRINTING IF ZERO RECORDS. What I use is the conditional supression based on ISNULL().

Sorry for the confusion.

--
Marc Visconte
CSC
Lead RMS Developer
Crystal Reports