End User Report Designer

Hi,
I am looking into a suitable report tool I can use in an application.
I want to be able to give the end user the ability to create there own
reports, and then have the application access them just like any other
report I ship with the application.
Does SQL Reporting 2005 have a report design tool that can be used by end
users ? If not are there any third party ones ?
ThanksYou can use the Report Builder, which comes with SQL Reporting Services
2005.
You can create new reports from a set of templates. If you make the
templates general enough, your users should be able to report on everything
they need to report on.
More about the Report Builder at
http://msdn2.microsoft.com/en-us/library/ms155933.aspx
Kaisa M. Lindahl Lervik
"Aussie Rules" <AussieRules@.nospam.nospam> wrote in message
news:%23wGa6WP8GHA.608@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I am looking into a suitable report tool I can use in an application.
> I want to be able to give the end user the ability to create there own
> reports, and then have the application access them just like any other
> report I ship with the application.
> Does SQL Reporting 2005 have a report design tool that can be used by end
> users ? If not are there any third party ones ?
> Thanks
>|||Hi,
Thanks for the reply.
Is the license on this report builder only available to be run on the
server.
Ideally it would be good if any number of end users could create a report at
there own workstations, and save them centrally...
THanks
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> wrote in message
news:e4jLJqP8GHA.4996@.TK2MSFTNGP03.phx.gbl...
> You can use the Report Builder, which comes with SQL Reporting Services
> 2005.
> You can create new reports from a set of templates. If you make the
> templates general enough, your users should be able to report on
> everything they need to report on.
> More about the Report Builder at
> http://msdn2.microsoft.com/en-us/library/ms155933.aspx
> Kaisa M. Lindahl Lervik
>
> "Aussie Rules" <AussieRules@.nospam.nospam> wrote in message
> news:%23wGa6WP8GHA.608@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I am looking into a suitable report tool I can use in an application.
>> I want to be able to give the end user the ability to create there own
>> reports, and then have the application access them just like any other
>> report I ship with the application.
>> Does SQL Reporting 2005 have a report design tool that can be used by end
>> users ? If not are there any third party ones ?
>> Thanks
>|||Hello Aussie,
You do not need to purchase any additional license for the report builder.
For more information about license issue, You can call 1-800-426-9400,
Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific time) to speak
directly to a Microsoft licensing specialist, and you can get more detailed
information from there. Worldwide customers can use the Guide to Worldwide
Microsoft Licensing Sites to find contact information in their locations.
For detailed information on contacting Microsoft Customer Service, please
reference the following Microsoft Knowledge Base article.
Q295539 How and When to Contact Microsoft Customer Service
http://support.microsoft.com/?id=295539
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei,
Thanks for you reply.
Is there a standalone installation for the report builder tool, or must the
SQL tools be installed and this option selected?
Thanks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:YbcGiPQ8GHA.1860@.TK2MSFTNGXA01.phx.gbl...
> Hello Aussie,
> You do not need to purchase any additional license for the report builder.
> For more information about license issue, You can call 1-800-426-9400,
> Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific time) to speak
> directly to a Microsoft licensing specialist, and you can get more
> detailed
> information from there. Worldwide customers can use the Guide to Worldwide
> Microsoft Licensing Sites to find contact information in their locations.
> For detailed information on contacting Microsoft Customer Service, please
> reference the following Microsoft Knowledge Base article.
> Q295539 How and When to Contact Microsoft Customer Service
> http://support.microsoft.com/?id=295539
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Aussie,
If you installed the SQL Reporting Services 2005, this tool will installed
in the server side and end user could access it from the Report Manager web
site.
The report builder is a ClickOnce application that end user could download
from the web site and then installed on the client.
Once you installed the SQL Reporting Services 2005, you could use the
Report Builder.
For more information about Report Builder, please refer the following
article:
Report Builder
http://msdn2.microsoft.com/en-us/library/ms155933.aspx
How to: Start Report Builder
http://msdn2.microsoft.com/en-us/library/ms159221.aspx
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
From what i have read this is a web based tool, is there a desktop tool. My
application is a VB.net desktop client accessing a sqlserver server
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:9UvHYro8GHA.1860@.TK2MSFTNGXA01.phx.gbl...
> Hello Aussie,
> If you installed the SQL Reporting Services 2005, this tool will installed
> in the server side and end user could access it from the Report Manager
> web
> site.
> The report builder is a ClickOnce application that end user could download
> from the web site and then installed on the client.
> Once you installed the SQL Reporting Services 2005, you could use the
> Report Builder.
> For more information about Report Builder, please refer the following
> article:
> Report Builder
> http://msdn2.microsoft.com/en-us/library/ms155933.aspx
> How to: Start Report Builder
> http://msdn2.microsoft.com/en-us/library/ms159221.aspx
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Aussie,
In the VB.NET winform application, you could use the Report Viewer control
and creat a Client Report Definition (.rdlc) File to retrieve the data.
You could convert the rdl file to rdlc file. The rdlc file will render in
your winform application and does not need the report server.
For more information, please refer the following article:
Creating Client Report Definition (.rdlc) Files
http://msdn2.microsoft.com/en-us/library/ms252067.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Note: Report Builder is a winforms application. It is accessible via URL but
is downloaded to the user's desktop and store in the Click Once cache for
use.
--
Regards,
Carolyn Chau
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wei Lu [MSFT]" wrote:
> Hello Aussie,
> In the VB.NET winform application, you could use the Report Viewer control
> and creat a Client Report Definition (.rdlc) File to retrieve the data.
> You could convert the rdl file to rdlc file. The rdlc file will render in
> your winform application and does not need the report server.
> For more information, please refer the following article:
> Creating Client Report Definition (.rdlc) Files
> http://msdn2.microsoft.com/en-us/library/ms252067.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||you need to look at 90 Degree Software - they do just that
"Aussie Rules" wrote:
> Hi,
> I am looking into a suitable report tool I can use in an application.
> I want to be able to give the end user the ability to create there own
> reports, and then have the application access them just like any other
> report I ship with the application.
> Does SQL Reporting 2005 have a report design tool that can be used by end
> users ? If not are there any third party ones ?
> Thanks
>
>