Report Builder Reports Filtering or Grouping at runtime possible?

I have a problem and i wonder whether it is possible select filter and sort
options at execution time not design time for report builder reportsGo to
http://www.msbicentral.com/Downloads/ReportingServices/RDLFiles/tabid/34/Default.aspx.
You'll have to register for a free login. There is an example of sorting at
run time, there may be one for filtering also.
"Yuksel" wrote:
> I have a problem and i wonder whether it is possible select filter and sort
> options at execution time not design time for report builder reports|||but i am not be able to download sample rdl files
"daw" wrote:
> Go to
> http://www.msbicentral.com/Downloads/ReportingServices/RDLFiles/tabid/34/Default.aspx.
> You'll have to register for a free login. There is an example of sorting at
> run time, there may be one for filtering also.
>
> "Yuksel" wrote:
> > I have a problem and i wonder whether it is possible select filter and sort
> > options at execution time not design time for report builder reports

Report builder and report models

Hi,

the database my app is using contains information from multiple user organisations, a sort of multi organisation database. I intend using the reprot builder to provide access to a user ine ach organisation. However the issue of who sees what info has popped up and i'm trying to think of a way to restict the user of report builder to only be able to see their own organisations information. This is a social services type application which is used by mutlitple service providers so organisations get twitchy about other organisations being able to see detailed client info. on the application the security stops this but at am a t a loss as to how to best restirct access to an organisation won client data.

any thoughts? is this somehting that can be configured through the reprt model and the report builder user account?

few ideas or advise would eb v helpful,

trhanks

Are you using SQL Server as the back end?

R

|||test. sorry to intrude.|||

Repot Models can have security rights assigned to different piece within the model. You can set up Perspectives and assigned users or roles to those perspectives. Or you can assign rights to individual folders. This can be done not through the report model (or the report server), but by opening the Report Model's Properties in SQL Server Management Studio.

Hope this helps.

|||

hi,

prev q answer - yes this is sql server 2005.

havn't come across perspectives but sounds v interesting. is that in SSRS or is it in SSAS?

i will check it out

many thanks

Report Builder / sorting

It is not possible to sort by value which is not selected as report
field.
In my scenario, I've selected monthname as field and I can not sort it
chronologically :(
KamelI don't know if this will help, but in the UDM for each attribute you can
specify the data that will be displayed and you can specify differnt data to
sort on.
So you could display the month name, and sort it on the year, month values
of the date.
Look for the sort attributes of the attributes properties.
hth, Mike
"kamel" <kwiciak@.gmail.com> wrote in message
news:1146557598.692677.326160@.u72g2000cwu.googlegroups.com...
> It is not possible to sort by value which is not selected as report
> field.
> In my scenario, I've selected monthname as field and I can not sort it
> chronologically :(
> Kamel
>