My SP returns 9 rows. Some of them are dublicates and some ar on of a kind. And it seeems that RS just displays one of each kind. No mater how many there are i the resultset.
Ive read that RS cant handle more than one resultset, but i think that the result returned is just one resultset.
If a run the SP in the Data tab it works just fine, it displays all rows. But when im using it in previewmode its not.
The SP is built around a cursor. It makes a temporary table with info. Then just JOINs it with a real table. Would not that create a SINGLE resultset witch RS should read?
Thanks in advanceIf it is working in preview, you are doing something in the layout of your report. Maybe you are grouping by some repeating value which will cause for the number of rows to be reduced. Try to start with a blank slate and drop the fields in the detail row of a table.|||
Thanks, it workt. I started of with a blank report. You where right, it was somehing in the layout section that flawed.
