SubReport pages out of sequence More Info.

rbuser

I eliminated the sort and the report works even with large volume. Here are
the details:



5 SQL views V1, V2, V3, V4, V5 all stored in MS SQL Server 2000



Linked in RBuilder as follows:



V1 Linked directly to V2, V3, V5

V3 Linked to V4



V1 and V2 are actually the same view



If V1 or V1 and V2 contain a sort the report pages are jumbled.



Each report is for an individual person and of course the customer wants it
in alphabetical order by name. SQL Server views will not allow sorts. From
the SQL Server perspective I could create a procedure that returns a sorted
table or creates a sorted work or temporary table. Can I execute an SQL
procedure directly from RAP or would I need to use a "pass through"
function? I could also change the clustered index on the main underlying
table of the view but this has system wide implications. Another possibility
is an indexed view using the name as a cluster key. However, I am not sure
that SQL Server guarantees that results will always be returned in clustered
order. Does anyone see a simpler way?

digitalmetaphors

See previous thread. Please continue in that thread for future responses:)


Cheers,

Jim Bennett
Digital Metaphors