SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Builder - Software as a Service model SaaS


Report Builder - Software as a Service model SaaS

Author
Message
ddesai-585412
ddesai-585412
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 54
Hi

We have a software as a service model. SaaS.
The user logons to our website and run our existing standard reports which can be static.
They cannot build their own filters or build their own reports.

I believe the end users who don't have the Microsoft Business Intelligence Studio on their computer can launch the Ad-Hoc "Report Builder" using Click Once application that will provide the front end interface for drag and drop.

Let me know if I have understood this correctly or Business Intelligence studio will be required to be installed at client end to use the Ad-Hoc Report Builder.

Or if there is a better way of implementing d-hoc reports in Software as a Service model.


Regards

Devesh.
ddesai-585412
ddesai-585412
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 54
Alright I got this one

The application that launches is the front end it does not require programming.

Here is more if anyone would like to respond

How do I use Report Builder in a Software as a Service Model (SaaS) or (SaS)

We have a common database for all users but the data that gets pulled should get seperated based on their login details and the hierarchy.

Like manager A should get data only for the employees under A or not the whole company.

Also are there any APIs for Microsoft AdHoc Report Builder?

Any help highly appreciated
Jim Russell-390299
Jim Russell-390299
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2287 Visits: 1403
Let me admit that I don't use Report Builder (and can't spell SaS). (You may want to stop reading...)

Instead, for similar requirements I publish a general use Excel workbook that imports external data from SQL Server views (or functions or stored procedures). On the server, I keep a user table where I can store, for an authorized user, their login id (Windows authentication) and report parameters like the organization code prefix which they are allowed to see. (The org codes we use include the hierarchy in the code; the more significant digits the smaller the scope. [I don't like the scheme, but it is what we inherited.])

The views typically pass the appropriate arguments from the User table to invoke a corresponding user defined table returning function.

The Excel query parameters specify refresh on open, and clear on save, so that a user without a valid user id and User table entry sees no data in the worksheet, and can refresh the Excel query only for the organization structure specified for them in the user table.
ddesai-585412
ddesai-585412
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 54
Thanks Jim

Unfortunately I will have to try and make Report Builder work with our web application

I did get an article
Launching Report Builder from a Winform or Webform Application in SQL Reporting Services 2005
http://blogs.msdn.com/bimusings/archive/2005/11/02/488141.aspx

I am currently looking to see if there are any APIs by which we can pass parameters to the Report Builder.
We only need to bring information from a particular company stored in the database.
Currently it hits the database and brings everything
Sarah Johnston
Sarah Johnston
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 20
Depending on what you are trying to accomplish, I believe you either need to look at the data source view (if you only ever need 1 particular company) or row-level security and filters (if which company you need depends on who is logged in). I am currently struggling with the later, but the MS tutorial about it is here:
http://msdn2.microsoft.com/en-us/library/ms365343.aspx
ddesai-585412
ddesai-585412
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 54
Hi Sarah

Its always nice to see response to a query.

In the report model I was able to create a filter such that it pulls only from one company.

What I was looking to do was pass the 'company name' which is stored in one of the database tables at run time to the Report Builder model such that only data from that company comes up.

Under Data Source Views, (Solution Explorer in Visual Studio) I right clicked on the table diagram and selected 'Replace Table with a new Named Query'

But I would still not be able to pass parameters to the Report Model at Run Time based on values stored in a database table.


I feel the authentication is based on the server credentials.
We cannot do authentication based on data stored in one of the tables in database.
So what I trying to do is not going to work. :-( Unsure


DD
thatsastounding
thatsastounding
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 2
Any luck on this front? I am looking into doing the same thing. Regretfully, at this time I have nothing to offer.


Dave
ddesai-585412
ddesai-585412
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 54
No man
I don't think it is possible, there is no way we can pass a parameter when we click on 'Report Builder' button.

Sigh....I hope microsoft comes up with it in their future versions
vkoripalli
vkoripalli
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 0
Are there any enhancements 2008 R2 that help with this problem. I have the exact same problem.
umashankard
umashankard
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 30
You can create views which will have the condition in it to apply the company ID. Any queries that you build over these views will retrieve data only for that particular company.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search