Feed Icon  

Contact

  • Bryant Likes
  • Send mail to the author(s) E-mail
  • twitter
  • View Bryant Likes's profile on LinkedIn
  • del.icio.us
Get Microsoft Silverlight
by clicking "Install Microsoft Silverlight" you accept the
Silverlight license agreement

Hosting By

Hot Topics

Tags

Open Source Projects

Archives

Ads

Trying things out in Reporting Services

Posted in Reporting Services at Tuesday, 24 February 2004 03:55 Pacific Standard Time

Tom Rizzo has asked for people to try some things out in Reporting Services.

1) Try customizing Reporting Services via its URL customization.  You can easily drop RS into an IFrame, SharePoint, etc. by using an URL.

I've done a lot of this recently. It seems to work pretty well for most things. However, there are a few things that I think could be improved:

  • The toolbar. It would be nice if you could specify to get only certain parts of the toolbar and if you could load the toolbar by itself in another frame.
  • It seems there is something strange with the report width and height. It seems like you always get an extra wide report even if you set it up to be narrow in the report designer.

2) Try programming the Web Services of Reporting Services.

This is pretty straightforward, however, it doesn't work very well if you're trying to hit the web service from a another server by passing the Credentials. You end up not being able to authenticate since it is a “double-hop”.

3) Exporting to XML. 

Haven't tried this yet. What would be a good reason to export this to XML?

4) Subscriptions and rendering formats.

These are also pretty easy to use. The email subscription doesn't seem to be compatible with Lotus Notes which is a real problem for us. Links do work, but they aren't as impressive as getting the full report in the email itself.

Some things I would like Reporting Services to do better:

1) Get some decent charting functionality. The way it currently works you can't even change the color of the chart items (you can only switch between pallettes).

2) Allow me to pass in the RDL to the Render function. There must be some way to do this since the report preview works in Visual Studio, but I haven't figured it out yet.

3) Provide some best practices for accessing the service via ASP.Net apps. I've heard that there are some Reporting Services Web Parts coming soon (which will solve a lot of problems for me), but how about some general guidelines on how to integrate Reporting Services into a web application.

Overall Reporting Services is a great product that we have been very happy with.

 

Tuesday, 16 March 2004 16:11:00 (Pacific Standard Time, UTC-08:00)
First, thanks for taking the time to post your learnings around RS and your feedback. It's appreciated by both myself and the rest of the SQL Server group. Second, thanks for being an RS customer. Keep sending feedback my way so we can keep building the product you really want and need.
<br>
<br>
<br>Answers to your questions/comments below:
<br>
<br>The toolbar. It would be nice if you could specify to get only certain parts of the toolbar and if you could load the toolbar by itself in another frame.
<br>--> Great feedback. Something we can definitely look at doing in the future. Today, we can turn off the toolbar using URL commands.
<br>
<br>It seems there is something strange with the report width and height. It seems like you always get an extra wide report even if you set it up to be narrow in the report designer.
<br>--> We've never seen this before so you may want to raise an issue with product support.
<br>
<br>
<br>Web Services - This is pretty straightforward, however, it doesn't work very well if you're trying to hit the web service from a another server by passing the Credentials. You end up not being able to authenticate since it is a double-hop.
<br>--> You can use Basic Authentication to get to another machine. You can also use constrained delegation in Windows Server 2003 to allow the web server to logon as you on the other server. That's something you can try since I haven't tried it myself yet with RS.
<br>
<br>3) Exporting to XML.
<br>
<br>Haven't tried this yet. What would be a good reason to export this to XML?
<br>
<br>4) Subscriptions and rendering formats.
<br>
<br>These are also pretty easy to use. The email subscription doesn't seem to be compatible with Lotus Notes which is a real problem for us. Links do work, but they aren't as impressive as getting the full report in the email itself.
<br>
<br>Some things I would like Reporting Services to do better:
<br>
<br>1) Get some decent charting functionality. The way it currently works you can't even change the color of the chart items (you can only switch between pallettes).
<br>
<br>2) Allow me to pass in the RDL to the Render function. There must be some way to do this since the report preview works in Visual Studio, but I haven't figured it out yet.
<br>
<br>3) Provide some best practices for accessing the service via ASP.Net apps. I've heard that there are some Reporting Services Web Parts coming soon (which will solve a lot of problems for me), but how about some general guidelines on how to integrate Reporting Services into a web application.
<br>
<br>Overall Reporting Services is a great product that we have been very happy with.
<br>
<br>
<br>
<br>posted on Tuesday, February 24, 2004 11:55 AM
<br>
<br>Comments
<br># Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
<br>Enjoy Every Sandwich
<br>Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
<br>Posted @ 2/24/2004 6:16 PM
<br>
<br>Post a comment
<br>Title
<br> Please enter a title
<br>Name
<br> Please enter your name
<br>Url
<br>
<br>
<br>
<br>Comments
<br>Answers to your questions/comments below:
<br>
<br>The toolbar. It would be nice if you could specify to get only certain parts of the toolbar and if you could load the toolbar by itself in another frame.
<br>--> Great feedback. Something we can definitely look at doing in the future. Today, we can turn off the toolbar using URL commands.
<br>
<br>It seems there is something strange with the report width and height. It seems like you always get an extra wide report even if you set it up to be narrow in the report designer.
<br>--> We've never seen this before so you may want to raise an issue with product support.
<br>
<br>
<br>Web Services - This is pretty straightforward, however, it doesn't work very well if you're trying to hit the web service from a another server by passing the Credentials. You end up not being able to authenticate since it is a double-hop.
<br>--> You can use Basic Authentication to get to another machine. You can also use constrained delegation in Windows Server 2003 to allow the web server to logon as you on the other server. That's something you can try since I haven't tried it myself yet with RS.
<br>
<br>Exporting to XML
<br>--> A couple of good reasons to do it. Perhaps you want to control formatting of the report and use XSLT to transform it to HTML. Maybe you want to batch feed the report into another system that only supports XML. There are a bunch more.
<br>
<br>Subscriptions - These are also pretty easy to use. The email subscription doesn't seem to be compatible with Lotus Notes which is a real problem for us. Links do work, but they aren't as impressive as getting the full report in the email itself.
<br>--> We send MHTML and use SMTP. If Lotus mangles it, there's probably something that Lotus is not doing right. I've got a copy of Exchange Server I could send to you to help solve this problem :)
<br>
<br>The do better part:
<br>1) Something we're definitely looking at.
<br>2) Create a temp copy of the report and then render it. Something we are also looking at for the future.
<br>3) The Web Services API is the way to go here. The Web Parts are great for SharePoint but if you're using pure ASP .NET, the web services are your best friend.
<br>
<br>Keep the feedback coming!
<br>
<br>Tom
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Wednesday, 20 October 2004 18:05:00 (Pacific Daylight Time, UTC-07:00)
I would like to ask how to remove an extension file in export function:
<br>for example i only want to view the pdf format when i click the select format dropdown in export function pls help... tnx in advance
<br>i think its something in RSReportDesigner.config file but i dont know how to do it...
Ban Mido
Sunday, 06 February 2005 21:47:00 (Pacific Standard Time, UTC-08:00)
As you state in your blog, "The email subscription doesn't seem to be compatible with Lotus Notes which is a real problem for us."
<br>
<br>Our new product, Proposion Report Adapter for Microsoft Reporting Services and Lotus Notes/Domino fixes this problem and a lot more. (It also allows you to use Notes/Domino as data sources for reports and/or allows you to automatically deposit scheduled reports into Notes databases. See <a target="_new" href="http://www.proposion.com/ReportAdapter">http://www.proposion.com/ReportAdapter</a>.
Thursday, 20 April 2006 16:42:22 (Pacific Daylight Time, UTC-07:00)
Hi

I am new to Reporting Service .I would require soem help on "Jump To Report " Option in Reporting service.

Currently We have set up a Link to a TextBox whichopens up another Report using "Jump to Report" option.
But the problem is that the new report opens in the Same Window.
Is there any option in Reporting Service So that i can open the new Report in a seperate Window.


Regards
Vinesh
vinesh
Comments are closed.