Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Builder - Software as a Service model SaaS Expand / Collapse
Author
Message
Posted Thursday, January 10, 2008 11:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 29, 2008 12:33 AM
Points: 14, 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.
Post #441591
Posted Thursday, February 21, 2008 2:09 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 29, 2008 12:33 AM
Points: 14, 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
Post #458803
Posted Friday, February 22, 2008 8:38 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 30, 2010 11:27 AM
Points: 435, Visits: 1,403
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.
Post #459146
Posted Monday, February 25, 2008 9:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 29, 2008 12:33 AM
Points: 14, 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
Post #459798
Posted Thursday, March 6, 2008 4:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 1:40 PM
Points: 5, 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
Post #465549
Posted Friday, March 7, 2008 7:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 29, 2008 12:33 AM
Points: 14, 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. :-(


DD

Post #465833
Posted Monday, July 7, 2008 11:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 7, 2008 2:53 PM
Points: 1, 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
Post #529494
Posted Monday, July 7, 2008 11:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 29, 2008 12:33 AM
Points: 14, 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
Post #529509
Posted Tuesday, June 28, 2011 1:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 28, 2011 1:18 PM
Points: 1, Visits: 0
Are there any enhancements 2008 R2 that help with this problem. I have the exact same problem.
Post #1133185
Posted Tuesday, December 27, 2011 3:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 4:17 AM
Points: 1, 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.
Post #1226816
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse