Hello everyone,

I have SQL sp wrritten where i put the data from 8 table to the
#table depending on the user id.

Now, have created a report where it uses this SP. the report is
much complex with level of grouping lots of formula fields, data
fields in all places (Sections. so on...

I am getting the report as needed and also exporting the report to
different formats like PDF, EXCEL, and HTML4.0

Till here No problem at all.

What I want to know is, this report is based of the USER ID, it shows
the data (a lot data) with respect to the user. Now consider, lots
of user are logged in at the same time say 1000, for now. And every
one will open this report to see the data (because this report is the
heart of the application) and export to there desire formats (as said above). In such scanerio, is this feasible to use #table in SP and get the data from tables and show it on report? Here SP plays a main role
the lines of code written there is huge.

So tell me, if you a complex report where you are getting the data from 8 to 9 tables and put them in the #table while in run-time, how
the Crystal Reports and SQL SP tech can be used to the best of its way
for optimization and faster process and the one USER ID's report data
should not be shown to the other USER ID while seeing the report.



With Regards,
Raghavendra Mudugal

__________________
With Regards,
Raghavendra Mudugal