Displaying specific rows

[zenith]

hi i have a query

I have a table with 10 rows i need to display only 1st 5 when a user A logs in and remaining 5 when user B logs in how do i go about it

Cheers 

[rjcressw]

I do not believe this is possible from a reporting standpoint (if I understand what you are trying to do correctly) as it would require you to write information BACK to the database.  SQL is non-procedural, and will return the same results every time you run a query (if the data has not changed).

[bdybldr]

zenith,
Are you trying to accomplish this in ReportStudio?  Is there some logic to the sort sequence in the table?  In other words will the rows always be returned in the same order.

It seems that you should be able to add a column to the table, "rownum".  Then, in you report create a case statement for user_id and filter the data based on user.

Sorry to be so vague.  We need more information about your requirements.