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


simple web based reporting


simple web based reporting

Author
Message
biforumnewby
biforumnewby
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
Scott Murray-240410
Scott Murray-240410
SSC-Addicted
SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)SSC-Addicted (485 reputation)

Group: General Forum Members
Points: 485 Visits: 3130
Why not use SSRS or Report Builder, both part of the SQL BI stack?
Pankaj067
Pankaj067
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 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......:-)
biforumnewby
biforumnewby
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
Pankaj067
Pankaj067
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 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....:-)
Omarali9
Omarali9
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 56
.
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