If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Displaying specific rows

Started by zenith, 27 Apr 2006 06:24:11 AM

Previous topic - Next topic

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.