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

simple web based reporting Expand / Collapse
Author
Message
Posted Sunday, April 14, 2013 11:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 7:11 AM
Points: 2, Visits: 1
I’m looking for a simple web based tool that can be used to generate tabular reports. Our application has a SQL Server database for each customer with different views that would be exposed to this tool. Customers would need to be able to:
choose from predetermined parameters we will build for the different views
select fields to display
filter and sort each column (Excel style)
save these options as custom named reports

So we’re not looking for a full BI tool with charts and graphs and such. It just needs to be web based running on Windows and Mac so we can integrate it with our existing web app. The tools I’ve seen so far seem to be more expensive full BI suites. We would need something with a flat fee we can use for as many customers as we like.

Can anyone point me in a direction for something like that?

If you know of a simple SSAS cube web based client that would be helpful as well. The requirements would be similar except that we would want drag and drop to columns and rows, but again no charts and graphs required.

Thanks
Post #1442119
Posted Monday, April 15, 2013 4:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 16, 2014 5:11 AM
Points: 243, Visits: 2,717
Why not use SSRS or Report Builder, both part of the SQL BI stack?
Post #1442244
Posted Monday, April 15, 2013 11:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 18, 2013 12:37 AM
Points: 33, Visits: 68
Hello biforumnewby,

There are several BI tools available but I suggest you should use Report Builder because of certain reasons:

1. This is a Microsoft BI tool which can easily integrated with SQL Server, also very small in size so do not required much space on your disc.
2. It also provides a simple and tabular representation of data
3. You can easily Filter, Sort, Select...etc from this tool
4. The report build up by this tool can easily be deployed on the report Server. So you can make it live by configuring the virtual directory setting in Report Server Configuration Manager and your report can be accessible from any where on internet.

NOTE: Remember If you use this tool while deploying the reprot please check the version of your SQL Server and Report Builder.

For SQL Server 2008 or below go for Report Builder 2.0
For SQL Server 2008 R2 or above go for Report Builder 3.0 (Latest Version)

In case you want more information regarding this tool you can contact me

Thanks......
Post #1442577
Posted Wednesday, April 17, 2013 7:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 7:11 AM
Points: 2, Visits: 1
Thank you for the response but I need a mac compatible, web based tool (as opposed to a click once app like Report Builder) that I can integrate into our existing web based app as opposed to having it launch on its own.

Any other ideas?

Thanks
Post #1443246
Posted Wednesday, April 17, 2013 7:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 18, 2013 12:37 AM
Points: 33, Visits: 68
Hello,

Ok, since you mentioned SQL Server Database so i think that you might be need to work on windows.

But as per your question, yes there are web based BI reporting tool which can be worked on MAC OS

"YELLOWFIN" is the desired one for your requirements. More Information can be seen on the link below:

http://www.yellowfinbi.com/YFForum-Installing-Yellowfin-on-Mac-OS-X-?thread=89781

If you need extra information for the download of tools and documents, you can visit the yellowfin site or can contact me.

Thanks....
Post #1443263
Posted Friday, November 8, 2013 5:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 17, 2014 9:31 AM
Points: 1, Visits: 36
.
Post #1512617
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse