Run time Prompt for report in BO

[Niri]

I am a novice user of BO.
I have a requirement to generate a report through the Web using WebI-BO. I need to use/pass the run time parameter or Prompt query however it is called.
My database contains several records, however i can select few records from this in my application and would want to generate the report for only those records. The records selected are identified by a Session Id and populated temporarily into a temporary table. At this point, i need to pass these session id to BO and generate report only for those cases with this session Id. Each user selecting cases will have a separate Session Id hence only the respective cases related to that session id should be populated.

Can anybody please suggest how this can be achieved ?

 

[skrandel]

You need to have this information stored in a table that is joined to the database.

The table will have 2 columns

BOUSER_ID Session

Then you have a join on the table defined as BOUSER_ID=@variable('BOUSER'). THe @variable('BOUSER') will pass in the login of the user.

Take a look at the tech support site and search for MIAMI. You want to find a presentation I did from the user conference titled 'Using Designer to Implement Row-Level Security. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com