Showing posts with label contains. Show all posts
Showing posts with label contains. Show all posts

Friday, March 23, 2012

Report Builder: Is there a way to filter a filter?

Dear Anyone,

We have a report model that connects to a single table. Some of the columns of the table contains blank values which is regarded as a valid value in our reports.

We have a requirement that the filter selection should not contain any blank values. They do not want to include a blank value for the users to choose but if the users decide not to use a filter, those blank values should still be included in the report.

Does anyone have any suggestions on how to do this in RB? We already made this work in RS2k5 but we can't seem to find any way to do this in RB.

Thanks,
Joseph

No, there is no way to control the list of values presented to the user. It is always a list of all existing values in the underlying database.

Monday, March 12, 2012

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

Saturday, February 25, 2012

Report appearance issues

I have 2 issues wih the appearance of my report both in the preview tab and when I deploy.

1. My report contains a subreport and the subreport appears indented from the left edge of the main report. How can I stop this? I won't the subreport to be aligned with the main report.
2. The last column of my report is stretched to the edge of the page even though I have all my cells set to CanGrow = false. How can I stop this?

Any help is appreciated.
I solved this one myself. The subreport's body was wider than the main report's body and as I have the table centred on both reports the subreport appeared indented. As soon as I made both report's body width the same the subreport aligned with the main report correctly. I also set every cell in the table in both reports to CanGrow = false and that stopped the last column stretching to the edge of the page.