Bryant Likes's Blog

It's all about WebData

Recent Posts

Tags

News


  • Windows Live Alerts
    View Bryant Likes's profile on LinkedIn

    Me

    Get Microsoft Silverlight
    by clicking "Install Microsoft Silverlight" you accept the
    Silverlight license agreement


    The posts on this weblog are provided "as is" with no warranties and confer no rights. The opinions expressed herin are the personal opinions of the individual authors and do not represent the views of Avanade in any way.

Community

Email Notifications

Archives

Posted: by

Comments

bryantlikes said:

A very good point made for all the software professionals ... A break once in a while can keep you healthy ...
# September 29, 2003 9:44 PM

TrackBack said:

SqlXml.org Home Page
# October 3, 2003 8:11 AM

TrackBack said:

Sam Gentile's Blog
# October 3, 2003 8:13 AM

bryantlikes said:

Welcome anytime ... :) ...

Your blog makes it even more interesting ...
# October 6, 2003 9:11 PM

bryantlikes said:

Hi Bryant,

I read your comments on my blog regarding meeting up tomorrow sometime. Do you mean Thursday?? If so, where do you think we can touch base??

Home Page URL:
http://www32.brinkster.com/srisamp
# October 29, 2003 2:20 PM

bryantlikes said:

I am curiouse if the "SqlXml in ADO.Net" will still need a seperate XSD schema, or will it integrate the SQL Mapping for fields, tables, and annotated relationships into the typed datasets schema.
# November 10, 2003 6:14 AM

bryantlikes said:

Good work wrt PDC notes ... Was hoping to get more from you when I read the thread subject ... :) ...
# November 17, 2003 6:51 PM

bryantlikes said:

Personally I dislike putting images into the database itself for the following reasons:

1. Small rows that could have been put on one page ( 4k ) would be now split over several pages because of the size of the image. This adversely affects performance.

2. Large images would be more appropriately stored on a single server. Having scaled out a database, it makes much more sense to just refer to a URI for the image such as:
//ImageServer/NorthwindDB/Products/ChaiZoom.jpg

3. For the most part, no processing is done on images beyond saving them to disk, retrieving them, and deleting them. The most common operation begin, of course, retrieval. Consider your average webpage, wouldn't it be easier to just put in a tag like:
<img src="//ImageServer/NorthwindDB/Products/ChaiZoom.jpg" />
than to actually read byte by byte from the db the image, and then write it out byte by byte to the webpage ?

Of course, if you do need to perform image processing, it <u>may</u> be appropriate to store it in the db. This is rare, from my experience.
# November 18, 2003 12:11 AM

bryantlikes said:

Thanks for the feedback!

I do agree, you take a performance hit by storing images in the database. However, I think it is a fair price to pay for the managability you get from storing images in this way. For instance, things like website portals or intranet sites where you have users managing images, it seems more robust to use a database.

I generally try to have a separate images table which helps (I assume) avoid some of the performance issues associated with page splits. Maybe for my next blog article I write up some performance stats to see what kind of price I'm paying.
# November 18, 2003 9:33 AM

TrackBack said:

# November 18, 2003 1:50 PM

TrackBack said:

# November 20, 2003 7:54 AM

bryantlikes said:

This ALWAYS happens to me.

I start writing a comment, it gets too long, and I write an entry on my blog instead.

You can find it here: http://udidahan.weblogs.us/archives/011400.html

I try to cover all the issues on the disk/db debate for images.

My bottom line: Disk is better.
# December 27, 2003 5:00 AM

bryantlikes said:

Hello Bryant,

I use SqlXml in a way that I've described in two posts on my blog.

http://www.alexthissen.nl/Weblog/PermaLink.aspx?guid=de819ad9-a666-4a96-9ede-e8651538cfbe
http://www.alexthissen.nl/Weblog/PermaLink.aspx?guid=83c8f964-f47d-48bd-b73c-1583e5f2fa6a

Let me know what you think of this. And, reading your Fun with deserialization, I figured I would have the same problem with binary columns. One of the shortcomings of this data layer I hadn't realized just yet.
# January 8, 2004 11:30 PM

bryantlikes said:

Hi,
I am using Bulkload to upload multiple relational tables, one table with Autoincrement PK. It worked fine. Now I need to Add a child table to it which has the Same PK field and has to be loaded from the parent.

Here I have scores table, whose Score_ID feild is autogenrated. I need to populate another TblScoreHistory table with scoreID and omr_scores fields. I tried with the relationship specifiled but didn't work. How do I define my Schema.

Thanks


MY datafile
<Score editflag="0">
<omr_score>*</omr_score>
<ScoreHistory>
<OrigScore>*</OrigScore>
</ScoreHistory>
</Score>



-------------------------

My Schema
<sql:relationship name="ScoresScoreHistory" parent="scores" parent-key="score_id" child="tblScoreHistory" child-key="ScoreID"/>

<xsd:element name="Scores" minOccurs="0" sql:is-constant="true">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Score" minOccurs="0" maxOccurs="unbounded" sql:relation="scores" sql:relationship="BookletPageScores" sql:key-fields="score_id">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="score_id" type="xsd:integer" minOccurs="0"/>
<xsd:element name="omr_score" type="xsd:string" sql:field="omr_scores"/>
<xsd:element name="ScoreHistory" minOccurs="0" sql:relation="tblScoreHistory" sql:relationship="ScoresScoreHistory" sql:key-fields="score_id">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="scoreid" type="xsd:integer" minOccurs="0" sql:field="scoreID" sql:mapped="true"/>
<xsd:element name="OrigScore" minOccurs="0" sql:field="vcscanvalue" sql:mapped="true"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
# January 16, 2004 1:19 PM

bryantlikes said:

Been a looong looong time Bryant. Nice to see you back here and at the XML newsgroups. Was wondering where you had vanished. :) And belated New year wishes and congrats on the new job.

Vinod
# February 4, 2004 6:56 PM

TrackBack said:

The daily list of stuff I found interesting while blogreading.
# February 9, 2004 7:49 PM

bryantlikes said:

Good luck with new job. I look forward to your comments on Sharepoint.
# February 12, 2004 9:17 AM

TrackBack said:

Moving FOR XML EXPLICIT to the new PATH mode (part II)
# February 19, 2004 11:36 PM

TrackBack said:

# February 20, 2004 9:27 AM

TrackBack said:

# February 21, 2004 8:20 PM

TrackBack said:

# February 21, 2004 8:20 PM

TrackBack said:

# February 24, 2004 11:32 AM

TrackBack said:

Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
# February 24, 2004 6:16 PM

TrackBack said:

# February 26, 2004 10:14 AM

bryantlikes said:

I ran into the same issue. JetBrains folks are looking at it.
# February 26, 2004 10:45 AM

TrackBack said:

Take Outs: The Digital Doggy Bag of Blog Bits for 26 February 2004
# February 26, 2004 11:38 PM

bryantlikes said:

ReSharper 69 addresses this issue.
# February 27, 2004 9:52 AM

bryantlikes said:

Cool. I will take another look at ReSharper...
# February 27, 2004 12:36 PM

bryantlikes said:

Hi Bryant,

Can you check help me on this specific feedback I recieved recently on the RSS.

http://blogs.sqlxml.org/VinodKumar/archive/2004/02/26/386.aspx
# February 27, 2004 11:35 PM

bryantlikes said:

Thanks for this, If you want it let me know.
# February 29, 2004 2:22 PM

bryantlikes said:

Perhaps our Snowflake.net component fits this need. It provides tons of wrapped up functionality for OLAP, however you, the developer, can choose how much of that functionality is exposed to the end-user. On the other hand the fact that the source is available with our Intellimerce source license means that there is also no dead-end in terms of implementing functionality that we might not already have. The list of functionality is too long for a post but most of OLAP front end actions are implemented and all within an MVC in asp.net with grid and charts synchronized. I hope you like it.
# March 1, 2004 4:17 PM

bryantlikes said:

I should have mentioned the company is Intellimerce Inc, http://www.intellimerce.com and the product is Snowflake.net.
# March 2, 2004 6:32 AM

bryantlikes said:

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.


Answers to your questions/comments below:

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.
--> Great feedback. Something we can definitely look at doing in the future. Today, we can turn off the toolbar using URL commands.

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.
--> We've never seen this before so you may want to raise an issue with product support.


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.
--> 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.

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.



posted on Tuesday, February 24, 2004 11:55 AM

Comments
# Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
Enjoy Every Sandwich
Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
Posted @ 2/24/2004 6:16 PM

Post a comment
Title
Please enter a title
Name
Please enter your name
Url



Comments
Answers to your questions/comments below:

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.
--> Great feedback. Something we can definitely look at doing in the future. Today, we can turn off the toolbar using URL commands.

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.
--> We've never seen this before so you may want to raise an issue with product support.


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.
--> 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.

Exporting to XML
--> 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.

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.
--> 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 :)

The do better part:
1) Something we're definitely looking at.
2) Create a temp copy of the report and then render it. Something we are also looking at for the future.
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.

Keep the feedback coming!

Tom








# March 17, 2004 12:11 AM

bryantlikes said:

Any luck yet? I have a similar problem (maybe exact) with one machine, but not another, so I have been developing on the good one and then moving the .rdl file and publishing with an .rss script...not ideal, but it works!

I get an reporting services install error that indicates:
Package 'VsReportDesigner Package' has failed to load properly ( GUID = {...

I've checked the registry and it seems to be pointing to the correct locations for the dll, but I cannot get reporting services to open in visual studio.
# March 19, 2004 8:54 AM

bryantlikes said:

Your "Double-hop"-problem is not about supported or not, this limitation is by design. If you use Kerberos delegation you can do multiple hops also with Reporting Services.

HTH,
Oliver
# March 19, 2004 10:05 AM

bryantlikes said:

This should fix your problem:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;837119

I had the same problem and installing this fix resolved it for me. Good luck.
# March 23, 2004 11:37 AM

bryantlikes said:

Thanks for the suggestion. The reinstall seemed to fix the problem.
# March 23, 2004 11:57 AM

TrackBack said:

# March 23, 2004 7:05 PM

TrackBack said:

# March 23, 2004 7:10 PM

bryantlikes said:

Difference made by .Net in Yukon? Unfortunately, very little.
# March 24, 2004 8:01 AM

bryantlikes said:

I had some of the same problems.

http://www.lazycoder.com/weblog/index.php?p=45
# March 24, 2004 9:55 AM

bryantlikes said:

Thanks for the article! It really helped alot me in my project...
# March 29, 2004 2:29 AM

bryantlikes said:

I was wondering if you would like to share this webpart?
# March 31, 2004 10:27 AM

TrackBack said:

# March 31, 2004 5:06 PM

bryantlikes said:

I don't think I can really share the webpart since I built it at work, but perhaps I can write an article that details how to make client side webservice calls in a webpart.
# April 1, 2004 7:25 AM

TrackBack said:

# April 2, 2004 1:43 AM

TrackBack said:

# April 2, 2004 1:45 AM

TrackBack said:

# April 2, 2004 11:34 AM

TrackBack said:

Take Outs for 2 April 2004
# April 2, 2004 9:47 PM

bryantlikes said:

I must point out that this was a beta version of Confluence, and proper handling of licensing problems was added in a subsequent beta. Dumping a stack-trace isn't really the best way to deal with things like this. :)

As for the stack-trace, it's just a big dynamically constructed chain of responsibility. .NET hackers should definitely look at things like Spring and PicoContainer from the Java world: there's nothing stopping these containers from existing in .NET except for the fact that nobody's written them yet.
# April 5, 2004 5:20 PM

bryantlikes said:

Bryan,

I've pretty much consider it a given that anything Don Box talks about is based on "future bits".

Unfortunately all the Whidbey/Longhorn talk doesn't help me get work done today.

CassiniEx will allow you to host multiple web sites (with different hostheader/port bindings) similar to IIS. In fact the new Management Console I'm finishing up looks suspiciously like the IIS 6 MMC.

However, since NTLM authentication wasn't a big priority for me (most of my web apps use Forms Authentication) I haven't implemented it yet. I did come across some other implementations of NTLM authentications, so I'll have to see how easy it will be to integrate it.

Anyway, thanks for taking the time to evaluate CassiniEx. At least for me, it meets my needs, which is the ability to develop multiple web sites on Windows XP.

Kiliman
# April 13, 2004 1:47 PM

bryantlikes said:

BTW: Sorry for misspelling your name.
# April 14, 2004 5:06 AM

bryantlikes said:

No problem. Lots of people call me Bryan :)

CassiniEx looks great. Have you thought about putting it up on GotDotNet? The Web Protocol guys liked your project. I should probably post some of the results of conversation I had with them.
# April 14, 2004 9:28 AM

bryantlikes said:

Bryant, once I get it to a "feature complete" stage, then I'll probably put it on a more public server.

I like to hear what other people are saying. I've gotten a lot of favorable comments about CassiniEx.

I think this will at least hold us over until Whidbey is officially released.

# April 14, 2004 9:40 AM

bryantlikes said:

that would be great
# April 14, 2004 8:45 PM

TrackBack said:

# April 16, 2004 10:12 AM

TrackBack said:

# April 16, 2004 10:12 AM

TrackBack said:

# April 20, 2004 10:20 AM

TrackBack said:

# April 20, 2004 10:23 AM

TrackBack said:

# April 26, 2004 9:54 AM

bryantlikes said:

my first biztalk experience. thanks a bunch!
# April 27, 2004 12:35 PM

bryantlikes said:

Thanks for this - very interesting ... and i look forward to the next installment as this is a very useful topic you are addressing. Mark
# April 27, 2004 3:28 PM

bryantlikes said:

Thanks for this - very interesting ... and i look forward to the next installment as this is a very useful topic you are addressing. Mark
# April 27, 2004 3:29 PM

TrackBack said:

SharePoint has simple 'out of the box' workflow capabilities, but there suddenly seems to be an abundance ...

# April 27, 2004 3:36 PM

TrackBack said:

Take Outs for 27 April 2004
# April 27, 2004 6:41 PM

bryantlikes said:

Bryant, just wanted to drop a note to let you know that another developer sent me a patch to add NT Authentication to CassiniEx.

I'm making some other changes and hope to get that out in the next day or two.

Hope this will make CassiniEx even more compelling for you to use.

Kiliman
# April 28, 2004 5:17 AM

bryantlikes said:

I'm still digesting it, but it looks like a great writeup on getting started with this.
# April 28, 2004 11:33 AM

bryantlikes said:

Where the heck were you about 5 hours of frustration ago!!!!

THANKS A BUNCH MAN.
# May 3, 2004 11:26 AM

TrackBack said:

Take Outs for 9 May 2004
# May 9, 2004 8:02 PM

bryantlikes said:

Is it possible to do it by creating a Orchestation
# May 12, 2004 8:07 AM

TrackBack said:

# May 12, 2004 10:19 AM

bryantlikes said:

I know it is possible to do this with XML files via Orchestration, but it is a little more complex to do it with plain text files.
# May 12, 2004 10:34 AM

bryantlikes said:

Try looking at www.dsppanel.com
# May 13, 2004 11:46 AM

TrackBack said:

# May 13, 2004 2:28 PM

TrackBack said:

# May 13, 2004 2:31 PM

bryantlikes said:

i'm place youre cod to my Global.asax file, create the table and procedure, but i have the Server Error in '/' Application. Runtime Error
# May 13, 2004 11:10 PM

bryantlikes said:

Make sure that your connection string is correct. You cannot use integrated security so you will need to set a username/password. When you do this make sure that SQL Server is setup to use mixed authentication.
# May 14, 2004 7:25 AM

bryantlikes said:

>>This is something I plan on looking at real soon

Bryant,

Will you be posting your results back to your blog? I'd love to see your findings (always looking for a faster way to bulk load data)
# May 14, 2004 9:50 AM

bryantlikes said:

Hello Bryant,

You can add my blog to the list, as well as the WSS FAQ at http://wss.collutions.com

-Jim
# May 16, 2004 9:58 PM

bryantlikes said:

can you show me example of the connection string ?
# May 23, 2004 8:56 PM

bryantlikes said:

Thanks for the help on the first error about setting it to Activate. That had me stumped!
# May 26, 2004 12:14 PM

bryantlikes said:

Sure will! Sorry I missed your blog!
# May 26, 2004 5:22 PM

TrackBack said:

# May 27, 2004 4:46 PM

TrackBack said:

# May 27, 2004 4:48 PM

bryantlikes said:

# May 27, 2004 4:56 PM

TrackBack said:

# May 27, 2004 4:58 PM

TrackBack said:

RsWebParts Workspace
# May 27, 2004 5:12 PM

TrackBack said:

# May 27, 2004 5:41 PM

TrackBack said:

# May 27, 2004 6:26 PM

TrackBack said:

# May 27, 2004 10:22 PM

TrackBack said:

Reporting Services Web ???(SharePoint)
# May 27, 2004 10:50 PM

TrackBack said:

# May 28, 2004 5:45 AM

bryantlikes said:

Hi

I was wondering if you managed to come up with a solution to your problem?
I'm sitting in the same situation as you.

People have recommended Snowflake.net however my superiors are not too keen to on purchasing the licence for a product that can be developed by a member of our team.

Please could you offer some advice on a good route to follow.

Regards
# May 31, 2004 4:09 AM

bryantlikes said:

PLease, May I have a copy of ActiveViews code? I'm a MS Regional Director. I work closely with SQL andReporting services for big companies. I aldo deal with multilingual issues.

Any help will be most appreciated.

Regards
# June 2, 2004 8:19 AM

bryantlikes said:

You will need to email Tom Rizzo (see email address above) as I don't have access to the code.
# June 2, 2004 8:59 AM

bryantlikes said:

GOOD

HELP ME IN CREATING THE MENUS IN WEBPARTS AND PASSING WEBPARTS QUIRES TO ANOTHER PAGE.

PLS SEND POST THE SAMPLES
REGARDS
# June 3, 2004 4:41 AM

TrackBack said:

# June 3, 2004 6:59 PM

bryantlikes said:

I did everything the way you described but none of the events in my global.asax get triggered. Is there anything else I should do to make SharePoint use this global.asax?
# June 4, 2004 8:44 AM

TrackBack said:

Linked
# June 4, 2004 4:57 PM

TrackBack said:

Linked
# June 4, 2004 4:59 PM

TrackBack said:

Linked
# June 4, 2004 4:59 PM

bryantlikes said:

I got this baby to work! Many thanks for putting it together.
# June 8, 2004 11:22 AM

bryantlikes said:

Mario: What kind of security do you have on the site? Also, I would try commenting out the try/catch section so that you can see if you're missing the SQL error.

Denis: Here is the format I'm using:
DATABASE=[DB Name];SERVER=[Server];UID=[User Name];Password=[Password];
# June 8, 2004 6:14 PM

bryantlikes said:

Grate! We are looking forward to use this solutions sone.
# June 9, 2004 7:54 AM

TrackBack said:

# June 10, 2004 6:24 AM

TrackBack said:

# June 10, 2004 6:26 AM

TrackBack said:

# June 10, 2004 6:26 AM

TrackBack said:

Ok, es tut sich mal wieder viel im SharePoint-Universum.
# June 11, 2004 3:35 AM

TrackBack said:

Ok, es tut sich mal wieder viel im SharePoint-Universum.
# June 11, 2004 3:38 AM

bryantlikes said:

Great Job Bryant. Can't wait to check it out!
# June 11, 2004 9:08 AM

bryantlikes said:

I'm also working on some Reporting Services web parts. I've posted some screen shots to my blog, but the code isn't quite available yet, but I'll be releasing it with an artilce soon. Check it out at <a href="http://jaynathan.blogspot.com/2004/06/reporting-services-web-parts-screen.html">http://jaynathan.blogspot.com/2004/06/reporting-services-web-parts-screen.html#comments</a> and let me know what you think.
# June 11, 2004 9:20 PM

bryantlikes said:

# June 11, 2004 9:21 PM

TrackBack said:

# June 13, 2004 11:14 AM

bryantlikes said:

I have reports that Use Date Parameters. I am getting a sType Undefined Error When I try to uyse the Report Parameters
# June 15, 2004 12:54 PM

bryantlikes said:

I will have to look into that error. I thought it was working with Date parameters but I could be wrong.
# June 16, 2004 8:54 AM

bryantlikes said:

Hi ... whats the difference between your web parts and Jays?
# June 16, 2004 11:49 AM

bryantlikes said:

Well it looks to me like Jay's web parts have a lot more features than mine do. It also sounds like he has implemented a "My Reports" feature which is something I haven't done yet (but would love to have).
# June 16, 2004 5:45 PM

bryantlikes said:

I'm getting the error on 1 server.
microsoft vbscript runtime error
object required: creationdate()
line=6,col3
line is offset from the start of the script block.

and on the second server i'm getting this error
Server did not recognize the value of HTTPheader SOAP action http:\\schemas.microsoft.com\sqlserver\2003\12\reporting\reportingservices\listchildren.

Any help is appreciated.
# June 19, 2004 11:18 PM

bryantlikes said:

Report Viewer works but export when consumming a report and using one sharepoint server which is pointing at a report on reporting services on a different server does not work it opens up the url incorrectly.

Any help is appreciate.
# June 19, 2004 11:34 PM

bryantlikes said:

Valter,

Can you send me an email with more information or post a bug report to the workspace?

Thanks!
# June 23, 2004 6:34 AM

bryantlikes said:

Hi,

I downloaded the cab file and saved it to c:\Temp folder on the server. Ran through your instructions and hit an error when I tried to run stsadm.

Error:
Unknown arguement: c:\temp\bml.rswebparts.setup.cab

Not sure what I am doing wrong. Any help would be appreciated!

thank you in advance.
# June 23, 2004 1:29 PM

bryantlikes said:

Sounds like you forgot the -filename argument. Can you post what you're typing at the command line?
# June 23, 2004 1:49 PM

bryantlikes said:

I got the same error as Valter Borges

Please Help!

microsoft vbscript runtime error
object required: creationdate()
line=6,col3
line is offset from the start of the script block.
# June 23, 2004 5:47 PM

bryantlikes said:

Fantastic work. All functionality appears to be working well.
However two issues I've come across.
1. Using the explorer web part - pops up a message whenever it is rendered about security (yes/no to continue)

2. I really just need the report view, however the report does not update once it has been assigned, I have changed data as well as report layout and neither are reflected when I reload the web part page. The report is set not to cache and the updates are shown when viewed directly via the url
# June 24, 2004 5:26 PM

bryantlikes said:

Glad you like it. The security error is something you can't really get around unless you put the reporting service in the intranet zone and turn off prompting for that zone.

The updating issue is interesting. I haven't seen this issue. Since the viewer is really an iframe it shouldn't be caching things any more than the regular browser. I will look into adding a refresh button but for now you can probably right click the report and select refresh to refresh the report.
# June 25, 2004 7:11 AM

TrackBack said:

# June 26, 2004 7:52 AM

bryantlikes said:

I have had a play with the refresh issue. I embedded the report in a standard 'Page View' web part and the same effect is seen. The report does refresh when the Reporting Services refresh button is pressed, but not when a IE refresh is done (right click, etc). So I think that where there is a report with dynamic data the Reporting Services refresh mechanism will be essential. A button would be good, but even better would be a property that would allow enabling an 'auto refresh on load' - which would refresh the report whenever the report is rendered - a nice feature for highly dynamic reports.
# June 27, 2004 5:23 PM

bryantlikes said:

That did it! Thank you!!!
# June 28, 2004 5:19 AM

TrackBack said:

# June 28, 2004 4:04 PM

TrackBack said:

# June 28, 2004 4:08 PM

bryantlikes said:

i tried reporting web part but is not give me any listing of reports
# June 29, 2004 12:57 AM

bryantlikes said:

Make sure you set the report server URL correctly and that you have reports on your server.
# June 29, 2004 6:04 AM

TrackBack said:

# June 29, 2004 2:45 PM

TrackBack said:

# June 30, 2004 6:08 AM

bryantlikes said:

Hi there - got the webpart installed ok but I cant get the report path to work - I have the reports server on a seperate machine and I am getting a problem when i try to setup the server url and reports path.

I have http://(servername)/reportserver/
and folder path is /Teched/

Can anyone give me advice if this looks wrong?

Cheers
Gregor
# June 30, 2004 8:29 AM

TrackBack said:

# July 1, 2004 6:52 AM

bryantlikes said:

It is wider on the home page because of your post at http://blogs.sqlxml.org/bryantlikes/archive/2004/06/18/711.aspx

The image there is wider than the "allowable" width, but because it is below the fixed right side area it pushes stuff over. If you go to the post with the wide image you'll see it gets pushed down below the right side area.

I think that gosatango posted some stuff you could add to the CSS to make the page more fluid and allow for maximum width, but I haven't played with it yet.
# July 1, 2004 9:58 AM

bryantlikes said:

Thanks! I made the image smaller and it fixed the problem.

BTW - I like the skin you're using on your blog. Very nice!
# July 1, 2004 11:33 AM

bryantlikes said:

to Bryant lides:
So how to do it using Orchestration in .NET,please demonstrat setp-by-setp,I`m just touch this technology!thanks!
# July 4, 2004 12:03 AM

bryantlikes said:

The MSN search is same as the Google search, I do not find much difference in the approach or algorithm. Check amazon's www.a9.com instead
# July 6, 2004 3:18 AM

TrackBack said:

# July 6, 2004 12:03 PM

TrackBack said:

# July 6, 2004 12:14 PM

TrackBack said:

# July 7, 2004 3:01 AM

TrackBack said:

# July 7, 2004 3:01 AM

TrackBack said:

# July 7, 2004 3:03 AM

TrackBack said:

# July 7, 2004 3:03 AM

bryantlikes said:

Hi,
Very nice job !!!
After changed the rs.js ('type' insted of 'sType') due to rs parameter problem all work fine.
congratulations.
# July 7, 2004 3:53 AM

TrackBack said:

# July 7, 2004 6:15 AM

TrackBack said:

# July 7, 2004 6:15 AM

bryantlikes said:

Awesome, wonderful stuff. Is it possible to hide the "Reporting Services Error" message that apears before a report and parameters are selected?

Take care,
Eli.
# July 7, 2004 11:57 AM

bryantlikes said:

Thank you, in advance, and I know this is not necessarily the appropriate place for this question, but can you point me to a chat room that would tell me how to set up Visual Basic 6.0 so it sees objects on my SharePoint server?

Thanks,

Ken
kstephan@csc.com
# July 7, 2004 12:31 PM

TrackBack said:

# July 7, 2004 2:19 PM

TrackBack said:

# July 8, 2004 7:41 PM

TrackBack said:

# July 8, 2004 7:41 PM

bryantlikes said:

receive shape's activate=true fixed my issue.... thanks
# July 9, 2004 4:22 AM

TrackBack said:

# July 12, 2004 12:57 AM

TrackBack said:

# July 12, 2004 2:58 PM

bryantlikes said:

No doubt. GDN is long overdue for a major overhaul. Too bad, because the idea behind it is great, just poorly implemented (maybe because it was built when .NET was still so new and the developers we learning as they go?? by now they surely could do it all over again much better)

It is funny that you mentioned this, I've been reading a lot of comments about GDN lately (I think I just saw a similar complaint on Frans Bouma's blog).
# July 13, 2004 3:13 PM

bryantlikes said:

My system is Windows 2003, I can not find the root "[c]:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN", My root is "[c]:\Program Files\Common Files\Microsoft Shared\web server extensions\40\BIN and [c]:\Program Files\Common Files\Microsoft Shared\web server extensions\50\BIN ", at the same time ,can not find "stsadm"
# July 14, 2004 12:47 AM

TrackBack said:

# July 15, 2004 1:57 AM

TrackBack said:

# July 16, 2004 12:38 PM

bryantlikes said:

Nice... thanks for taking the time to blog this...
# July 16, 2004 1:03 PM

bryantlikes said:

Bryant is a Genius! Thanx B
# July 19, 2004 10:18 AM

bryantlikes said:

Thanks Bryant - just what I needed to get start.
Microsoft if you're watching - this is what we want in documentation, step by step examples.
# July 20, 2004 2:23 AM

bryantlikes said:

Could you elaborate on instance based classes and the procedures required to make this work.

I ran across this "bad example"
:
Public shared Function AddToCount (ByVal Value As Integer) As String
Count = Count + value
End Function
Shared Count As Integer=0

It was considered a "bad example" because multiple users would be changing the same Count field.

What would be a working "good example" of this using instance based functions and using the Reference Tab and the Class/Instance section in RS?

I have seen many examples using static functions and step by step instructions. I have not found a single example yet of a working instance based custom assembly walk through anywhere. :(

Would appreciate it if you could take a look at this and extend your blog to cover this case step by step.

Thanks for the guidance. I just think the community needs more input on instance based data manipulation with custom assemblies. Instead of static functions.

Once we actually know how to implement a instance based solution we can discuss when and where to use it but I'm still stuck on implementation. :(
# July 20, 2004 1:31 PM

bryantlikes said:

Sidney,

What are you trying to accomplish that requires a stateful object? There are ways you could do this but they would probably have some high overhead.

# July 20, 2004 6:38 PM

bryantlikes said:

Well the question was fairly generic-I simply don't know how to implement an instance based function into RS. I don't know what elements have to line up on the code in the VB to fit with what you select/enter on the RS side.
I've not seen 1 step by step example on connecting the dots between the name of the assemblie/namespace/class name/function name to what you enter in the RS property reference tab.

One specific question i have in mind:
Assume data in Groups
Within a group you have a column of string values-Say states for example
on a group summary line you want a concatenation of the string state values for all rows in the group.
so you might have
ID State
1 AZ
1 AL
1 MO

Summary group footer:
1 AZ, AL, MO

This is a little similar to the "running total" idea but instead of adding values I want to concatenate strings togather.

Any suggestions.

But beyond resolving this need, I need to understand generally how to use instance based functions in RS. So please don't try to answer the need behind the need when I really need to nail down how to design ANY instance based custom assembly and line it up with RS.

Thanks.
# July 21, 2004 8:45 AM

bryantlikes said:

Ok. I've played with this a little and it seems to work fine. I'll post an update.
# July 21, 2004 10:32 AM

bryantlikes said:

When I do this, I get the following error message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

Any idea?
# July 21, 2004 10:38 AM

TrackBack said:

# July 21, 2004 11:08 AM

TrackBack said:

# July 21, 2004 11:14 AM

bryantlikes said:

You can't use a trusted connection to connect to the database. So you need to change your connection string to something like this:

http://blogs.sqlxml.org/bryantlikes/articles/583.aspx#675
# July 21, 2004 11:24 AM

bryantlikes said:

I am trying to access a database through a custom assembly and I already have the following in the rssrvpolicy.config file , but I still get the #Error.
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="MySecurityExtensionCodeGroup"
Description="Code Group for Don's test security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\MyAssembly.dll"
/>
</CodeGroup>
Do I need an associated permission set? And what would that be if I do, I dont know?

And do I need to do step 3 and 4 of your article for my custom assembly if I am only accessing a database from my function.
And If I do, what would step 3 and 4 be?

# July 21, 2004 12:04 PM

TrackBack said:

# July 21, 2004 2:10 PM

bryantlikes said:

To person trying to acccess database:
you need to add a different permission set class than the file/IO one in Bryant's blog or the UrlMembershipCondition in yours.
Try this one:
class =SqlClientPermission

You also need to see books online: Asserting Permissions in Custom Assemblies

From MSFT post on forum:
You need
to assert security permissions inside the custom assembly. Every call that
requires certain permissions (e.g. opening a database connection) will fail
unless the required security permissions for that call (documented in MSDN)
have been asserted.

Example for opening a connection to a SQL Server:

...
SqlClientPermission permission = new
SqlClientPermission(PermissionState.Unrestricted);
try
{
permission.Assert(); // Assert security permission!
SqlConnection con = new SqlConnection("...");
con.Open();
...
}


You might also want to check out these links:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_0so6.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconAssert.asp
http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_rdl_8wyq.asp

--
This posting is provided "AS IS" with no warranties, and confers no rights.
# July 21, 2004 3:52 PM

bryantlikes said:

Oops Sorry I didn't notice this was answered already. Bryant's responsiveness is out of this world. :)
# July 21, 2004 3:58 PM

bryantlikes said:

Oops Sorry I didn't notice this was answered already. Bryant's responsiveness is out of this world. :)
# July 21, 2004 3:58 PM

TrackBack said:

# July 21, 2004 6:13 PM

bryantlikes said:

it is very nice webpart
but i have no idea to first step

my server name is
so i put
http://swdevsrv0/reportserver

then in folder path what information i put
please tell to me ) i didn understand what the line say

'The Folder Path is just the root path where the explorer will start at. The RsFolderView and RsStaticReportView have similar properties (FolderPath and ReportPath) which do the same thing.


# July 22, 2004 3:40 AM

bryantlikes said:

Has anyone managed to use the RS Static Report View?
All other web parts run ok but this.
In the parameters I have:
Server URL: http://bagr-ath-fs17/reportserver
Report Path: /1- Ex Warehouse Sales/1-1 PH ExWarehouse Sales/1-1-4 Ex Warehouse Monthly Sales Product

Any ideas?
Thanks
MP
# July 22, 2004 4:20 AM

bryantlikes said:

Bryant is too good. Your the man!
Thanks,
Don
# July 22, 2004 5:08 AM

bryantlikes said:

Are you getting an error? The static view doesn't have any visible results. It only allows you to connect multiple webparts to the same report.
# July 22, 2004 8:04 AM

bryantlikes said:

Felix: Just put a "/" without the quotes for the root folder. Other folders would be /[folder name]. If you need to map to a specific report you would use /[folder name]/[report name].
# July 22, 2004 8:16 AM

bryantlikes said:

I've tried changing my connect string. I have searched far and wide through the net for the answer to this.

My connectstring is this:
strConn = "Server=MySERVER;Database=MYDEV;integrated security=SSPI";

SqlConnection cn = new SqlConnection(strConn);

cn.Open();

I have also tried:
strConn = "server=MYSERVER;Trusted_Connection=True;Database=MYDEV;uid=me;password=********"

Neither of them work. they both work from a standard winform.
# July 22, 2004 12:04 PM

bryantlikes said:

I'm a recent college grad doing some asp.net. I'm writing a webpart which I want to access a SQLServer, but I get this error:

"Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed."

I read the Lamont post and added this:

<SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

and this:

<IPermission class="SqlClientPermission"
version="1"
Unrestricted="true"
/>


to my wss_mediumtrust.config, and minimaltrust files.

However this did not work. I got an error saying:

A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe.

Before I ever made the config file changes, I also made a strongname for my NewWebPart.dll file, and I thought I took care of the "not registered as safe" problem.

Could it be that I should use my own key instead of the b77a5c5....? I tried using the one I have for the .dll file, but that didn't seem to work either.

Does anyone have a solution? I'm a new programmer and I don't understand what I'm doing.
# July 23, 2004 10:40 AM

bryantlikes said:

I am getting the same error Jesse,

The value expression for the textbox ‘xxxxx' contains an error: Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.

Still looking into it.

Don
# July 23, 2004 12:21 PM

bryantlikes said:

This is a very good idea to use a HV sax.net control, especially if it's free. But you can meet a problem. The problem is this control doesn't work properly with MS IE 5.00. It works good with IE 6. The problem is that IE 5.00 puts the page that generates an "obfuscated" HV code into the cache right away you open a page in your browser and never shows your another code. It gives you as a result that you can't enter a valid code, because you just don't know it and you can't see it. So, if somebody met this problem and know how to fight IE 5.00, give a tip please.
aturlov@cogeco.ca
# July 23, 2004 12:39 PM

bryantlikes said:

This is a very good idea to use a HV sax.net control, especially if it's free. But you can meet a problem. The problem is this control doesn't work properly with MS IE 5.00. It works good with IE 6. The problem is that IE 5.00 puts the page that generates an "obfuscated" HV code into the cache right away you open a page in your browser and never shows your another code. It gives you as a result that you can't enter a valid code, because you just don't know it and you can't see it. So, if somebody met this problem and know how to fight IE 5.00, give a tip please.
aturlov@cogeco.ca
# July 23, 2004 12:39 PM

bryantlikes said:

First of all - great job with the webparts.

I am able to connect to SRS directly from RS Explorer. However, I am trying to create a simple webpart view by just using the RSreportViewer and RS Report Paramaters. Each of them is connected to the ReportServer however when I try to connetc them both, I get "..... Error: 'sType' is undefined"

Any idea on what could be wrong?

Thanks
# July 23, 2004 1:14 PM

bryantlikes said:

I see that you mentioned that it is possible to do this in an Orchestration with plain text files. How is this done? I have tried this however I get an error when building the Orchestrarion - 'System.IO.File' must be XML serializable to be a message part type. Note that both my Inbound and Outbount message types are type 'System.IO.File' as are both my Inbound and Outbound Port Operation Request Message types. It almost seems as if Biztalk needs me to use a pipiline to translate the text file to xml, transform the xml to the exact same xml and then use a pipline to translate the xml back to the text file!!! It is as if anything that enters a Biztalk Orchestration must be xml or it must enter the Orchestration via a Port pipeline to make it xml. Any suggestions?

# July 26, 2004 7:14 AM

bryantlikes said:

You can't use "Trusted_Connection=true". See the example connection string that I posted here:

http://blogs.sqlxml.org/bryantlikes/articles/583.aspx#675
# July 26, 2004 7:24 AM

bryantlikes said:

The sType error is a bug that can be fixed by replacing sType with type in the rs.js file as mentioned here:

http://blogs.sqlxml.org/bryantlikes/articles/628.aspx#781

# July 26, 2004 11:17 AM

bryantlikes said:

Once I added this code group below along with code group and permission set and assert commands Bryant mentioned I no longer got the System.Permissions.SecurtiyPermission message. Everything seems to work although everything is a little fuzzy as to why?

<CodeGroup
class="UnionCodeGroup"
version"1"
PermissionSetName="FullTrust"
Name="The name of your DLL. This shouldn't be necessary, but it worked for me."
Description="">
<Imembershipcondition
class="ZoneMembershipCondition"
version="1"
Zone="MyComputer"/>
</CodeGroup>
# July 27, 2004 4:31 AM

TrackBack said:

# July 27, 2004 11:13 AM

bryantlikes said:

This is just great Bryant! I was struggling with how to get started with this custom code. Good Job.
# July 31, 2004 5:24 PM

bryantlikes said:

Hi
how am'i doing deploy with the dll that used in develop environment ?
how can i use external connection string to data source?

thanks

doron
# August 1, 2004 4:44 AM

bryantlikes said:

Why can't you use Trusted Connection?
# August 3, 2004 8:17 AM

bryantlikes said:

Yes!? Why can't we use Trusted Connection? My company's administrator is allways boring me with this issue...
# August 3, 2004 9:41 AM

bryantlikes said:

I was wondering if it's possible to connect 2 webparts which are both RS Report Viewer webparts. The idea is to click on a link in webpart1 and pass a parameter to webpart2 which uses the parameter in a query and shows the results.

Thanks!
# August 4, 2004 2:31 AM

bryantlikes said:

Oh, I forgot to say that when I put 2 RS Report View webparts on 1 page a get a javascript error saying: 'style' is null or not an object.

Is this a known error or am I just making some mistake?
# August 4, 2004 2:34 AM

bryantlikes said:

Is it possible to get the reports from a different server from the server sps is on?

Thanks
# August 6, 2004 6:51 AM

bryantlikes said:

Veyr nice, however I still could not get the rsparameters web part to work. I already changed the rs.js file.
# August 9, 2004 7:58 AM

bryantlikes said:

You can't use it here unless the user id that executes the global.asax has access to the database.
# August 9, 2004 12:36 PM

bryantlikes said:

Good Job! Will you please help me regarding the use of custom control in parameter in reporting services, tnx
# August 10, 2004 1:43 AM

bryantlikes said:

hi,

this is fine, i am trying to do file transfer from remote system to the local system. how to do that?. can you explain in the same way as you did before..

thanks
mani
# August 11, 2004 6:32 AM

bryantlikes said:

Excellent walk through. Thanks Bryant.
Is it possible to pass a parameter to the report, and have the Assembly code adjust a column width based on the parameter value?

Thanks
# August 11, 2004 11:14 AM

bryantlikes said:

Can we combine two tables each other?
# August 16, 2004 3:32 AM

TrackBack said:

# August 16, 2004 2:42 PM

TrackBack said:

Bryant Likes points out that he has a SharePoint Resource Page added to his wiki. Very cool....
# August 16, 2004 6:00 PM

bryantlikes said:

I don't believe your dad felt the baby moving until each was pretty big. That is so exciting that you could feel your precious little one. I love you!
# August 17, 2004 10:12 PM

bryantlikes said:

how to use Dll's in reporting services
# August 18, 2004 6:26 AM

bryantlikes said:

Everything ok, adds all in the DB.
Also cab (signed and ok) with stsadm installed. All successfully.
BUT
When in SharePoint dragging the webpart to the page (after dragging and auto refresh of the page) nothing is there :-(

Can you help me out?
# August 18, 2004 1:03 PM

bryantlikes said:

Congrats Bryant. That is always such an awesome feeling to start to understand and almost interact with this new life that is a part of you. I have 4 kids, is this your first?
# August 19, 2004 11:24 AM

bryantlikes said:

Thanks! Yes this is my first one.
# August 19, 2004 12:52 PM

bryantlikes said:

Bryant,

My entry in the registry is WSSEL ... which does not contain a '.' in it. I still have the same problems of not being able to read the password. I gave all osrt of permissions to ASP.NET worker process and I still get the same error.

... any ideas?

Thanks

-Enrique
# August 20, 2004 10:01 AM

bryantlikes said:

I have been working on this for a few days and have hit every message board, called ms support and re-written the darn thing at least 20 times. I am still getting the #error in my report manager and have even added strong name. Is there a problem that's not being spoken of?


JamesH.
# August 21, 2004 7:34 PM

bryantlikes said:

If I do not use static for methods I get the following error.
Even after adding a reference to the dll and class section.

This is the error.
>> Reference to a non-shared member requires an object reference.

Thanks
-walter
# August 23, 2004 12:20 PM

bryantlikes said:

Hi,

I'd appriciate if someone could point me to right direction.
I've got my custom assembly working on development computer,
but when I deploy it to production server I'm getting this error:

Error while loading code module: ‘xxxxxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ab6b2957da4e38d6’. Details: ?

I copied the assembly to Reporting Services /bin and copied permission set and code group settings to the config file.

What am I missing?

Thanks,
Alex
# August 23, 2004 6:48 PM

bryantlikes said:

Alex,

If you haven't checked yet, you should take a look at:

http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs

There are really a lot of good links from MS on there albeit they're redundant. Good luck.

JamesH
# August 23, 2004 7:03 PM

bryantlikes said:

hi, thanks a lot for this example, now, is it possible to add acquittment whitin an orchestration when the file are received ?
you can contact me : olivier@sekence.net

have a nice day.
# August 24, 2004 2:58 AM

bryantlikes said:

Thanks for great web parts.
Only issue I am having is with rsparameters web part.
Even after replacing the "sType" with "type" in rs.js, still it is giving sType error.
# August 24, 2004 12:48 PM

bryantlikes said:

Interestingly enough, it started working after I rebooted production server.

Thanks,
Alex
# August 24, 2004 1:44 PM

bryantlikes said:

sType Problem gone. Try this:
1. Change the sType to type in rs.js.
2. Clear the temp files.
3. Open the reports.

Great job Bryant!
# August 24, 2004 2:06 PM

bryantlikes said:

Nice web parts really helpful.

One thing in the RS Explorer I get all the web parts I can run not all the web parts I can view. So I have sub reports that are run by other reports that can't be run on thier own. So when I browse from sharepoint I get many more reports.

Hope that made sense.

Thanks again and comments appreciated.

Peter
# August 26, 2004 3:34 AM

bryantlikes said:

Can sb. tell me where is this rs.js file located?

# August 27, 2004 2:33 AM

bryantlikes said:

I have found it and fixed the problem. It works now. But there is a new issue popped up. In some of the reports, I have used dynamic parameters (with pull down menu), which now in the RS Report Parameters Web Part are with no more pull down menus. Could you please look into this problem and fix this bug? Thanks a lot in advance.

Anyway, they are really fantastic web parts.
# August 27, 2004 2:48 AM

bryantlikes said:

There might be a bit of overlap when it comes to Articles (but the WSS FAQ site doesn't have a list of bloggers (even though my RSS reader has most of the same ones) and has a quite outdated list of sites so those two sections would be a very useful addition if ever you did want to move it there.
[Jim Duncan at Collutions would be the guy to contact for how to integrate it if you got that far]
# August 27, 2004 4:29 AM

ANDRES said:

Hey guys, i am with this problem, I have developed a dashboard using silverlight but there are some problems with the version. As you may know, silverlight forces you to update the version to the latest one, unfortunatly iam not with the last one.

Pleas help me finding a solution for this.

# August 27, 2004 6:26 AM

bryantlikes said:

Hi,
verify in the application pool if the Network Service account is configured (default). Then give read permission in the registry to Network Service account. My problem finished when I did that.

Vinícius
# August 27, 2004 12:23 PM

bryantlikes said:

thanks for these - are very useful.
One thing though - can't seem to get the Static Report viewer to work.
Maybe, I'm being dumb, but not sure exactly what setting to put for server URL, and report path.
For example, the report I'm trying to use has the following hyperlink:
http://MYSERVER/Reports/Pages/Report.aspx?ItemPath=%2fSamples%2fCompany+Sales

Also, I get a "security risk" warning from IE each time I use a page with one of the web parts - something about the page not being under the control of the site.

Regards
Chris
# August 29, 2004 3:24 AM

bryantlikes said:

Ensure you have Authz.dll in system folder
# August 29, 2004 6:41 PM

bryantlikes said:

Congrats, Bryant!
# September 4, 2004 9:33 AM

bryantlikes said:

Congrats Bryant !!!
# September 5, 2004 9:44 PM

bryantlikes said:

hi.. I am getting this error after entering the date parameters for a report:
"The value provided for the report parameter 'Report_Parameter_0' is not valid for its type. (rsReportParameterTypeMismatch)".
The date parameters are of type datetime.
Is it because it is expecting a string input instead?
Thanks!

# September 6, 2004 8:48 PM

bryantlikes said:

Yep, pretty cool.

I was scared to have kids, and real turn around for me was the same experience. Just wait till the baby starts to RESPOND to touch, sounds, etc. Thats really cool too. And for that matter, there will be a great many more moments such as first tooth, first word...

I have no second thoughts now; being a father is one of the best experiences in my life.

Congrats
# September 7, 2004 11:14 AM

bryantlikes said:

Bryant,
Thanks for all the info you posted. I'm working my way through, and I'm now working on the part were you are having us complete steps 3 & 4.

I found something that I'm not sure about, syntactly.

You code is as follows:
<FileIOPermissionAttribute(SecurityAction.Assert, Read="c:\temp\hello.txt")> _
Public Shared Function HelloFromFile() as String

I got an error stating READ is not defined. I did some reading on MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconAssert.asp)
and saw the equals (=) sign is preceded with a colon, as such Read:="c...."

Does this make a difference?

rwiethorn
# September 8, 2004 8:49 AM

bryantlikes said:

Would it be easy to convert a Crystal Report RPT extracted XML file to RDL?
# September 10, 2004 8:12 AM

bryantlikes said:

HOw can I reference a report's run time attributes (not parameters!) within a custom assembly. I want to determine if the render format type is pdf, then set a custom global value and make navigation textbox's visible/non-visible based on that global value. Is it possible?

thnks
jim
# September 10, 2004 11:31 AM

bryantlikes said:

Even when they start to poop and spit-up and cry, all of those things are worth it for the first glance and smile they give you.
Good luck!
# September 10, 2004 1:39 PM

bryantlikes said:

I added RS Explorer, RS Parameters and RS Report View webparts. Everything works for reports without parameters.

For a report with parameters, I get "Page not found" in the report view when I select a parameter. All the connections (provide row to/consumes row from) appear fine. What am I missing?

Thanks.
Dave
# September 11, 2004 11:53 AM

bryantlikes said:

Hi Bryant,

Thanks for this wonderful article. Atleast the basic are clear now.

I have a question here. With so many changes that are needed to be made to the config files, is there any way I can do it programatically ( just I can deploy reports using the rs.exe tool and scripts)?
Because we cant expect the end user to make all these changes and (since xml is case sensitive), his whole application will go for a toss even if a small change is left out.

Regards,

Ravindra
# September 13, 2004 3:54 AM

bryantlikes said:

Fantastic Job Bryant!

This is an exellent and extremly useful tool that you made.

At this point I'm getting troubles when I'm displaying a multi-page report.
The whole report is rendered inside of the Report View, without the paging functionality that provides MS Reporting Services.
Is it possible that I have a configuration issue?

Thank you!
# September 13, 2004 8:40 AM

bryantlikes said:

The reason you need initiate permission object in your code is that you did not assert unrestricted permission on your permissio attributes for the protected method.

using this one should eliminate the usage of instance of sqlclientpermission in your code:

[Visual Basic]
<SqlClientPermission(Permissions.SecurityAction.Assert, Unrestricted:=True)>

[C#]
[SqlClientPermission(Permissions.SecurityAction.Assert, Unrestricted=True)]

Regards,

Henry Wang
Expired MCT,MCSE+I,MCSD,MCDBA
# September 13, 2004 9:45 PM

TrackBack said:

# September 14, 2004 7:56 PM

bryantlikes said:

I was just wondering where you were :) ... Its been a silent month of Aug and Sep so far ...

Nice to hear from you ...

Vinod Kumar
# September 14, 2004 8:34 PM

bryantlikes said:

Great Job!
# September 15, 2004 12:18 PM

bryantlikes said:

Hi Bryant

How can I configure a report using the webparts, that has two parameters, one by URL and the other by selection?

Thanks
Priya

Hey, BTW your web parts have added pizzaz to our intranet site!
# September 16, 2004 1:59 PM

bryantlikes said:

I see no solution to the "CreationDate" error mentioned a couple of times above. Does anyone have a resolution to this issue?
# September 17, 2004 12:09 AM

bryantlikes said:

Thanks for the great web parts. They seem to work well.
# September 21, 2004 7:32 PM

bryantlikes said:

I keep getting stype undefined on my reports. The report view part simply says the this report requires a parameter but the report parameters part does not give me any options for parameters??
# September 22, 2004 8:25 AM

bryantlikes said:

Changed the only "stype" to "type" in rs.js but what does above user mena when saying "clear the temp files"?
# September 22, 2004 8:31 AM

bryantlikes said:

Now getting the same 'creationDate(...)' error some are getting above. Did anyone ever get this fixed?
# September 22, 2004 9:09 AM

bryantlikes said:

Excellent Job, Bryant
Go Ahead
# September 23, 2004 4:30 AM

TrackBack said:

# September 24, 2004 5:21 AM

TrackBack said:

# September 24, 2004 5:21 AM

bryantlikes said:

This is a perfect example of how NOT to implement a Sharepoint Statistics tracking piece. Why not use some OOP techniques and implement the IHttpModule interface to accomplish this task. The resulting module would leave the original SPS global file intact, while delivering a truly elegant solution.

P.S.
You are an IDIOT!!

# September 27, 2004 10:20 AM

bryantlikes said:

Thanks Bryant,
Good work in clearing this up
# September 27, 2004 1:10 PM

bryantlikes said:

I fail to see what advantages you would gain from using an OOP technique. Leaving the global file intact was not one of my prime concerns, nor was an elegant solution. I simply wanted to enable some logging into a database (which I accomplished in about ten minutes).

If this means I'm an idiot, oh well.
# September 27, 2004 1:44 PM

bryantlikes said:

I was wondering if it is possible to access authentication cookie values directly from cutom code. I am using custom authentication. I tried accessing it with HttpCookie class after referencing system.web. It didn't give an error at compile time but gives one at runtime. Do you know if it's possible.

Do I need an associated permission set? Do you know what the IPermission section should in this case

Any sample code would be helpful.

PR
# September 28, 2004 7:29 AM

bryantlikes said:

Boy,
They give the MVP status away to anybody.
# September 28, 2004 8:10 AM

bryantlikes said:

i am able to send the text files, it is picking up properly but i am not able to get the text file in the receive location.
# September 29, 2004 6:43 AM

bryantlikes said:

When I add the web part for RS Explorer or RS Folder View, it is fine until I try to configure it with a URL & folder path. After I put in the URL & folder, then hit apply, I get a permission denied error. I am logged onto the box (RDP) with the administrator account.

I can load RS Report View and configure it with the same URL & path without any errors.

Any ideas?

Thanx,
Jay
# September 29, 2004 10:28 AM

bryantlikes said:

I downloaded and went through your Walkthrough with the webparts. So far everything seems to be fine until I try to connect the RSParameters web part to the explorer view. Every time I do this I get an error message saying "The "RsParameters" Web Part appears to be causing a problem" I have to delete the web part just to be able to access the page again.

Also why when I access the Manage Web Part Page do these webparts only say "Error" for the web part title. And "ErrorWebPart" for the Type? Should they say something else?

I would appreciate any help as being able to use these would be a big benefit.

Thanks

Tom
# September 29, 2004 1:22 PM

bryantlikes said:


Hi Bryant
I have some problems with reporting service web parts
If the parameters contain some special value such as #, & [] , I have received following error Message

The path of the item '/R/Product Division,P]' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath) Get Online



Regards & Thanks
Vijay Vijayaratnam
# October 4, 2004 9:25 PM

bryantlikes said:

If the Account that your App Pool is configured to run under (in W2k3) can access the SQL Server then you can use Trusted_Connection=true.. otherwise, you will have to specify the userid and password in the connection string without the trusted_connection part.
# October 5, 2004 9:19 AM

bryantlikes said:




Hi Bryant
I have some problems with reporting service web parts
If the parameters contain some special value such as #, & [] , I have received the following error Message

The path of the item '/R/Product Division,P]' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath) Get Online



Regards & Thanks
Vijay Vijayaratnam
# October 5, 2004 3:56 PM

bryantlikes said:

Inspite of changing stype to type : it gives me type undefined

Can any one help ?

Amarnath
# October 6, 2004 10:07 PM

bryantlikes said:

I seeing something really odd.. Just tried to deploy my custom assembly and I get this error message: Exception of type Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown.

Any ideas?
# October 9, 2004 11:21 AM

bryantlikes said:

Just to let you know, this problem still hasn't been resolved in the release versions of the VS 2005 and XP SP2. I figured out what was wrong and then searched to see if there was a known solution posted, this was the only real reference i found.
# October 9, 2004 11:50 AM

bryantlikes said:

Can you explain what are these web parts doing exactly?
I installed them without any problems but what am I going to do with them???
Could you be more explicit what info should we put in the "Server URL" and "Folder Path" text boxes?
Let's say my server name is: SERVER

No disrespect, and I am sure you spent a lot of time for this web part, but what's the purpose?

We need some documentation!!!

Thank you!
# October 12, 2004 3:14 PM

bryantlikes said:

Hi

Thanks for your site .

Do u have "SPS Document Library Treeview" bcoz it's author removed that from his page .!!!!

Thanks.

# October 13, 2004 12:50 AM

bryantlikes said:

If you like that, then take a look at the http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/Logging.asp

And if you prefer something arguably better than EIF/MLAB then take a look at log4net at: http://sourceforge.net/projects/log4net/

Personally I think log4net is best, but that is my background and it comes preloaded with loads of event sinks and is very simple to use. Either way they are both essential to an enterprise solution.
# October 13, 2004 4:18 AM

bryantlikes said:

Hi,Bryant, Can you help me to figure out how to reference other instance(like in other businee lay) which in the different project in Custom Code.

For Example, I have a
Function getString(parm1,parm2) as String

dim s as new aObjectFromBusinessLay-----((this object have database access)))
s.ID=123
s.Load()
getString=s.getString()
End Function

If I call this function in web form I can get the right result so the function its self work. But when I treat it as Custom Assemply code and reference in report as instance base custom code. I can do any instance base custom code if not use any reference to another object in my function. I try to follow your article to change the associated permission set in the policy config file. I still get the #error in my report.
# October 13, 2004 9:10 AM

bryantlikes said:

Thanks a lot, you helped me.
# October 15, 2004 4:40 AM

bryantlikes said:

Good to hear from you, Bryant! How is the baby coming along?
# October 15, 2004 10:41 AM

bryantlikes said:

Good to hear from you as well. The baby appears to be coming along pretty well as my wife is popping out quite a bit. Three months to go!

:)
# October 15, 2004 10:52 AM

bryantlikes said:

I totally agree with you Bryant. That reboot thing is just plain wrong! For some reason, it hasn't happened to me yet. So as soon as I read your post yesterday I changed the setting so it only downloads them, but the only notifies me instead of installing.

I leave VS.NET open all the time when I leave my PC. I'd hate to loose some work because of a reboot - so thanks for the heads up!

-Ryan
# October 15, 2004 2:25 PM

bryantlikes said:

At the risk of stating the obvious: if you're running Windows Server 2003 as the guest OS in your Virtual Server, you can always use Terminal Server to connect to it instead of the VMRC client...
# October 18, 2004 1:16 AM

bryantlikes said:

But you can analyze log of iis and get same info ;)
Without creating gloabal.asax, base and other.
# October 18, 2004 9:32 AM

bryantlikes said:

True, you could analyze the log to get the stats. You wouldn't be able to show who's online though, unless you analyzed the log quite often. You also run into issues if you have multiple sites and/or if you have multiple front-end sites sinc e you have to analyze multiple logs on multiple machines.
# October 18, 2004 1:09 PM

TrackBack said:

# October 19, 2004 11:14 AM

bryantlikes said:

Dylan:

In theory, wouldn't it be cheaper to buy a tool that someone else maintains and upgrades than to put the money and effort into internal development? Employees' time costs money, too, doesn't it? :)
# October 19, 2004 11:23 AM

bryantlikes said:

Very cool. I was wondering if you would be willing to share your web part development standards? We are working on our own and would be very interested in sharing those with you if you would like.

Thanks for all of your informative blogs

Mike
mike@mikelinster.com
# October 19, 2004 1:02 PM

bryantlikes said:

Thanks for all the feedback! I'm looking into every issue....
# October 19, 2004 3:13 PM

bryantlikes said:

You're welcome! Unfortunately the only requirements I have gotten is that the web part assembly be signed and that it be distributed in an MSI file.

If I come across others I'll try to post them...
# October 19, 2004 5:44 PM

TrackBack said:

# October 19, 2004 10:21 PM

bryantlikes said:

Ok, so this is all cool...
Can I use internal data from sharepoint (ie. Lists) to generate these reports, and then... can I export the generated reports back into the document repositories inside sharepoint? Even better is that I want them to get data from child-sites of the main one where the control is running and I also need to store the reports in the areas where the data came from.

I could run the control locally in the individual child sites, but I need data from the main site as well....
...I think it's time to cut losses and write this baby in PHP.
# October 20, 2004 7:29 PM

bryantlikes said:

I would like to ask how to remove an extension file in export function:
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
i think its something in RSReportDesigner.config file but i dont know how to do it...
# October 21, 2004 1:05 AM

bryantlikes said:

First of all thanks for this great example!
My question:
In order to build up the parameter list, I notice that it is done in the rs.js script file, through client side script. Is there any particular reason to do so. Can the parameter list not be populated on the server via the renderwebpart method?

Thanks for your feedback
# October 21, 2004 2:06 PM

bryantlikes said:

Thanks, glad you like the example. There is a reason it is client side (I'd much, much prefer to do everything on the server side). The problem is authentication. Even though you're logged into SharePoint, your credentials cannot be passed to the Report Server (unless you use a solution like Single Sign-On). By doing everything on the client you pass the credentials correctly.

# October 21, 2004 2:35 PM

bryantlikes said:

I'm not sure what I am missing. I still get #error - where is the error more detailed than this? How would you ever know what the error is since documentation is so bad? I am trying to access SQL Server database.

Here is my code:

<System.Data.SqlClient.SqlClientPermission(Security.Permissions.SecurityAction.Assert, Unrestricted:=True)> _
Public Shared Function GetMdx(ByVal sUserName As String) As String
GetSqlConnection = New SqlClient.SqlConnection
GetSqlConnection.ConnectionString = "Data Source=datasourcehere;User Id=userhere;Password=passwordhere"
GetSqlConnection.Open()
' do query here

End Function

Here are entries in rssrvpolicy.config:

<PermissionSet
class="NamedPermissionSet"
version="1"
Name="SqlClientPermissionSet"
Description="A special permission set that grants access to do SQL Server DB Access.">
<IPermission
class="SqlClientPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
</PermissionSet>


<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="SqlClientPermissionSet"
Name="MyCustomAssemblyCodeGroup"
Description="For my custom assembly">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\MyDll.dll"
/>
</CodeGroup>


Still get #error - not sure where to get any further detail.
# October 25, 2004 11:10 AM

bryantlikes said:

Bryant:
I'm having a hard time getting the report viewer webpart to render the reports.
nothing happens all the otehr webparts point to the proper locations and items as per your instructions, no error is thrown.

another question:
Would it be possible to get the actual C# code for these Webparts as I need to add another layer of security to them to meet the Business requirements of security for report viewing , that falls outside the scope of the security that sharepoint has built in.

Cheers!
# October 25, 2004 3:56 PM

bryantlikes said:

First off thanks... The tool works great... It will definately come in handy for me...

I am using the Beta version and had an oddity where The viewer would only work if the Reports were in a subdirectory... off the Root they didnt? So I just put everything in a sub directory and all is good. ;)

Thank you
# October 25, 2004 4:54 PM

TrackBack said:

Zum Abschlu
# October 26, 2004 2:01 AM

bryantlikes said:

"I would like to maintain the session state of a report in a sharepoint 2003 webpart. When I call a report chart image I place it in to a temp location and then call that image to the Webpart but I also need that reporting services image to maintain its state."

anyone know how to do this? or where I might find the answer?
# October 26, 2004 10:30 AM

bryantlikes said:


I have this problem curently going on. Windows 2003, IIS 6.0, encrpyted impersonate w/aspnet_reg utility and keep getting the "Error reading the password from the registry".

Any word on this bug.
# October 26, 2004 1:15 PM

bryantlikes said:

This article saved my life. I had serious deadline and knew that I had to use a custom code assembly to acheive the result. It pointed me in right direction and I was able to figure things out from there. The is honestly almost nothing else on the internet (believe me, I looked) that explains precisely how do it. Thanks Bryant!
# October 27, 2004 2:45 PM

TrackBack said:

Automatic Updates ???
# October 31, 2004 7:42 PM

bryantlikes said:

I still get the #Error (Security Exception) and I have done everything that both your articles say. Any other suggestions?

Thanks for doing this, btw.
# November 1, 2004 12:51 PM

bryantlikes said:

Your Article gave me a lot help. I write a custom code to connect to the database and get the right result in my report if I defined the connect string in my custom code directly. But I still struggle with my business objects vb files which using app.config value "Connectstring" to connect to the database which can be get by ConfigurationSettings.AppSettings("ConnectionString") in all business data access objects. I try use the ConfigurationSettings.AppSettings("ConnectionString") in my custom codes to test if I get right connect string but in report there is nothing display and no #error too. But if I use the web application or console application to test costum code in report. All get what I want. I reallize because the web application has the web.config file and console project has app.config they are all same as the business config's connection string. So I wonder if the report project in my solution should have some place to put the *.config file.
# November 1, 2004 12:57 PM

bryantlikes said:

the Report Viewer Webpart will actually connect but how do you get it to show charts and graphs?
# November 1, 2004 3:44 PM

bryantlikes said:

a noob here.

I get this error in my event viewer everything i start to view my localhost.

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {0C0A3666-30C9-11D0-8F20-00805F2CD064}"

I tried the DCOM config in the component services but could not find the entry {0C0A3666-30C9-11D0-8F20-00805F2CD064}.

Is there any ohter solution I can try?

Thanks in advance.

# November 1, 2004 6:42 PM

bryantlikes said:

I tried almost the same thing, but I keep getting the following error:

Unable to read and validate the configuration file C:\Data\Personal\Tech-Ed\EIF\EIF\EnterpriseInstrumentation.config. The following type(s) cannot be loaded:
CustomSink.FileEventSink
Please check the event & eventSink element's type attribute in the configuration file, and that these types are correctly installed on the system.

Where else do I look to see where I went wrong?
# November 2, 2004 2:52 AM

bryantlikes said:

Bryant,
first ..... a good approach !
I have donwloaded and successfully installed the webparts. After walking through your desciption how to set up the webparts I am facing a problem. I have started to add the RSExplorer and pointed to my reportserver. After refreshing the page the webpart area is still empty. No reports are isplayed (but there ARE reports in the pointed folder of the report server !).
Anything I have missconfigured ?
The reportserver is running on another server !!

Thanks for help
/Martin
# November 3, 2004 5:39 AM

bryantlikes said:

At the risk of stating another obvious: did you uninstall the tools prior to the upgrade, and then reinstall them afterwards in your vm's ?
# November 5, 2004 3:26 AM

bryantlikes said:

Can you/some one explain in detail, how double hop issue is, making you call reporting services web services, though client side script (rs.js)??

# November 5, 2004 5:28 AM

bryantlikes said:

The issue is explained pretty well here:

http://blogs.msdn.com/nunos/archive/2004/03/12/88468.aspx

There are some possible workarounds, but it was by far the easiest to use client-side scripting.
# November 5, 2004 11:04 AM

bryantlikes said:

Sounds Pretty Cool! Are you planning on sharing that source code? :)
# November 5, 2004 11:16 AM

bryantlikes said:

Hi,

OWC is hidden within Reporting Services for presentaion. Let's say you generate a Pivot table with Reporting Services, nothing is stopping from Exporting the data from the Pivot table to PDF and then let the users print the PDF. Let me know what you think of this

SathiV@hotmail.com
# November 9, 2004 9:05 AM

bryantlikes said:

Bryant,
Thanks for all the info you posted. I'm working with an assembly that read the Active Directory, in desing view all work nice!, but when i deploy my project, i recieve an error, my code is:

Public Shared Function GetUserInfo(ByVal inSAM As String, ByVal inType As String) As String
Try
Dim sPath As String = "LDAP://inet.com.sv" '' Dominio donde se buscara
Dim SamAccount As String = Right(inSAM, Len(inSAM) - InStr(inSAM, "\")) ''' Usuario que se buscara
Dim myDirectory As New DirectoryEntry(sPath, "Inet\lopez.carlos", "lc97028") 'pass the user account and password for your Enterprise admin.
Dim mySearcher As New DirectorySearcher(myDirectory)
Dim mySearchResultColl As SearchResultCollection
Dim mySearchResult As SearchResult
Dim myResultPropColl As ResultPropertyCollection
Dim myResultPropValueColl As ResultPropertyValueCollection
'Build LDAP query
mySearcher.Filter = ("(&(objectClass=user)(samaccountname=" & SamAccount & "))")
mySearchResultColl = mySearcher.FindAll()
'I expect only one user from search result
Select Case mySearchResultColl.Count
Case 0
Return "Null"
Exit Function
Case Is > 1
Return "Null"
Exit Function
End Select
'Get the search result from the collection
mySearchResult = mySearchResultColl.Item(0)
'Get the Properites, they contain the usefull info
myResultPropColl = mySearchResult.Properties
'displayname, mail
'Retrieve from the properties collection the display name and email of the user
myResultPropValueColl = myResultPropColl.Item(inType)
Return CStr(myResultPropValueColl.Item(0))
Catch ex As System.Exception
'do some error return here.
Return "Ha ocurrido el siguiente error: " + ex.Message
End Try
End Function

I copied the assembly to Reporting Services /bin and copied permission set and code group settings to the config file.

What am I missing?

Thanks,
Carlos
# November 9, 2004 9:32 AM

bryantlikes said:

Nice Idea!
# November 9, 2004 9:09 PM

TrackBack said:

# November 9, 2004 11:02 PM

TrackBack said:

# November 10, 2004 4:55 AM

bryantlikes said:

I'd like to try out the webparts, but the GotDotNet workspace is inaccessible. :( When I click on the link in your article, all I get is the main page that says announcements.
Is there another way to get your files?

Kaisa
kml[at]completo[dot]no
# November 11, 2004 3:02 AM

bryantlikes said:

It appears there is some kind of problem with the RsWebParts workspace. I've contacted the GotDotNet team to see if I can resolve it. I'll let you know when I get a response.

If they don't fix it I'll move the project over to source forge.
# November 11, 2004 7:49 AM

bryantlikes said:

Hi there, I am thinking about going for an interview at Boston, but I am unsure if I want to go there. I live in California, and with estimated yearly costs of $60,000 i think you can understand the downside. I was hoping you might have a few words from your brother in law about how he likes the school? Classes, campus, faculty...etc. I know this is quite random, but I would really appreciate any insight you can give.
Thank you!
email hollywoodomar at yahoo or you can post a comment here, and i can check back later?
# November 11, 2004 7:56 AM

bryantlikes said:

Dude, I am Palm OS. What kind of crap is that?! How embarrassing.

"You are Palm OS - Punctual, straightforward and very useful. Your mother wants you to do more with your life like your cousin Wince, but you're happy with who you are."

lol
# November 12, 2004 4:49 PM

bryantlikes said:

Simply superb article I can say for starters.

Byrant your important point "I created a folder specifically for this at c:\tests\StaticTest\Send." is really a good note to understand that two ports can not have the same configured locations , which was the issue in my project from last 3 days.

Thanks a ton Byrant. Expecting more of this types.
# November 13, 2004 2:05 AM

bryantlikes said:

I was looking for this too. I've decided to take the source from the Treeview navigation web part and rework this.
# November 14, 2004 9:34 PM

bryantlikes said:

I'm still Microsoft Windows (XP and 98SE for I enjoy playing with these guys!), but I sincerely hope being a Linux worm soon.
# November 15, 2004 6:34 AM

bryantlikes said:

Bryant,

Great tool. I've been using it for a few months and the users love it. I installed the Beta version to try to resolve the parameters issue I was having, but I'm still running into issues when I use a drop-down list of parameters.
As soon as a value is selected, the report does not generate and no error message is returned. (However, it does work fine when the parameter is not validated against a list.)

Any ideas?

Thanks again for these parts.
# November 18, 2004 11:12 AM

bryantlikes said:

Bryant,

I posted on the Walkthrough page, but this seems more appropriate.

I installed the Beta version to try to resolve the parameters issue I was having, but I'm still running into issues when I use a drop-down list of parameters.
As soon as a value is selected, the report does not generate and no error message is returned. (However, it does work fine when the parameter is not validated against a list.)

Any ideas?

Thanks again for these parts.
# November 18, 2004 11:19 AM

bryantlikes said:

I want to play with the new webparts too but i'm not a programmer and alot of the stuff up there is gobblydygook to me. :|
I am a competant windows user though and can get around server 2003, Office 2003 and XP Pro for the most part.
In Frontpage 2003 there's an "Import webpart" function when I open the site live. Can't I just do it that way without going through all the other junk?

TIA
Steven
# November 18, 2004 2:27 PM

bryantlikes said:

I have added a RS exployer part to my page and set the server url. but all I see is "Retreiving Data....."

Any help?

Shawn McFArland
shawn.Mcfarland@atk.com
# November 19, 2004 8:17 AM

bryantlikes said:

Now you can create your Reports Programmatically using the RDL Writer Component specially designed for SQL Reporting Services

Generate the XML-RDL (Report Definition Language) file on the fly, programmatically in any .NET application with 100% managed code, with out any knowlegment of the RDL/XML format.


Good Luck
Jerry
# November 22, 2004 10:22 AM

bryantlikes said:

# November 22, 2004 10:22 AM

bryantlikes said:

I have deployed the web part in my share point server. But I am getting error, when I set the url for the Server URL for Rs Explorer. I am getting Access denied error.

My sharepoint is on windows 2003 server and my reporting service server is in win2k professional.

eg: share point admin address : https://subin:8098/default.aspx
and reporting service address : http://arihantjain/Reports/Pages/Folder.aspx

Any help?

Suresh.A
# November 26, 2004 2:11 AM

bryantlikes said:

Great web parts. When can we expect the release version of version 1.1.
# November 26, 2004 4:08 AM

bryantlikes said:

could you post me the example in vb.

my email is david@elbit.co.il
# November 30, 2004 5:48 AM

TrackBack said:

# November 30, 2004 10:15 AM

TrackBack said:

# November 30, 2004 10:23 AM

bryantlikes said:

This problem also exists with Virtual Server on Win 2003.
# December 1, 2004 5:19 PM

bryantlikes said:

I have developed an ASP based application. Let me if you are interested
# December 3, 2004 1:03 PM

bryantlikes said:

I'm in.
# December 7, 2004 10:53 AM

bryantlikes said:

Cool! I was hoping you'd be interested.
# December 7, 2004 11:39 AM

bryantlikes said:

Thank you kindly for this website. I am having refreshing problems. We have available the autorefresh feature, but how could I refresh only onload. Can this be done via custom code. How?

Will appreciate anything you can do for this.


DotNetFranco@yahoo.com
# December 7, 2004 1:11 PM

bryantlikes said:

I'd be willing to help out as well, Bryant.
# December 7, 2004 6:22 PM

bryantlikes said:

Kimberly Tripp rocks!
I attended a full day (9 hours) session on indexes by her, in Norway. Indexes has never seemed so interesting before.

Kaisa
# December 7, 2004 11:36 PM

bryantlikes said:

Great!
# December 8, 2004 8:36 AM

bryantlikes said:

I'd like to see more information and maybe an example on how you got this working.

Nice job.
# December 8, 2004 12:38 PM

TrackBack said:

# December 8, 2004 12:50 PM

bryantlikes said:

I have changing "stype" to "type" in the file rs.js but it gives me:" type undefined "

Can any one help ?
# December 9, 2004 10:44 PM

bryantlikes said:

Bryant,

I am working on a report, which when opened in the browser should trap the user's window credentials and display his details alone. Impersonation is being for deploying the report on the report server. Therefore the user login info cannot be obtained from SQL server. Is there any alternative way of getting the user login credentials?
# December 12, 2004 8:54 PM

bryantlikes said:

Slick!
# December 13, 2004 9:32 AM

bryantlikes said:

Bryant,

I'm getting the same results as 11/19/2004 8:17 AM by Shawn McFarland . Have you found a solution?

I'm tried the following five [URL - Folder] combinations:
[http://dwdev.mercurycompanies.com/ReportServer - /Reports/Pages/Folder.aspx?ItemPath=%2fSalesReps&IsDetailsView=False]

[http://dwdev.mercurycompanies.com/Reports - /Pages/Folder.aspx?ItemPath=%2fSalesReps&IsDetailsView=False]
(This I thought should work since it is the FQDN to the reports)

[http://dwdev.mydomain.com/ReportServer">http://dwdev.mydomain.com/ReportServer - /Reports]

[http://dwdev.mydomain.com - /Reports]

[http://dwdev.mydomain.com/Reports - blank Folder option]
With the blank folder option WSS errors with:
The "RsExplorer" Web Part appears to be causing a problem.
Web Parts Maintenance Page: If you have permission, you can use this page to temporarily disable Web Parts or remove personal settings. For more information, contact your site administrator.


None of it works. Plus I'm always getting an Access Denied pop-up box after clicking Apply or OK.

The WSS server and SQL RS Report Manager are on the same box server.
The WSS server URL is http://intradev.mydomain.com
The SQL RS Manager URL is http://dwdev.mydomain.com/Reports and is on the Default web site.

I've used Host Headers and DNS CNAME (aliases) for reference the server name for each web site FQDN.

Server is Windows 2003 Web Ed w/ WSS 2.0 and RS SP1 Standard.
# December 13, 2004 11:53 AM

bryantlikes said:

Another thought...

I'm thinking that the people who have got it to work are using the Default web site for both WSS and RS. That way credentials are passed within the same application pool web site context. I'm going to try and setup/move the Reports and ReportServer virtual folders to the WSS web site I expanded and created separately from the Default web site. Here is the article to move the RS folders. http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk. We'll see...
# December 13, 2004 12:05 PM

bryantlikes said:

In my sample receive shape's activate=true also fixed my issue.
After that I got the binding error as you described. It has been fixed very simply - my Biztalk assembly contains spaces in the name. After deleting spaces the assembly has been deployed.
# December 13, 2004 12:45 PM

bryantlikes said:

Well... the last steps didn't work. Still getting "Retrieving data... " displayed on RS Explorer web part.

I tried a number of combiniations for the URL and Folder after getting RS and WSS side-by-side on a different web site. Followed the steps below:

Move RS to different Web Site
http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk

WSS and RS side-by-side
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp
# December 13, 2004 4:05 PM

bryantlikes said:

I got it working... With WSS and RS on same server/web site other than default web site.

URL: http://dwdev.mydomain.com/ReportServer
Folder: /SalesReps

Follow the steps in Bryant's Article after Performing the steps outlined here:
Move RS to different Web Site
http://www.sqljunkies.com/How%20To/525B575A-7F61-483A-AC8F-FEC700C34674.scuk

WSS and RS side-by-side
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp

# December 13, 2004 4:13 PM

bryantlikes said:

Bryant,

Great idea, nice job!

maxim
[www.ipattern.com do you?]
# December 15, 2004 11:59 AM

bryantlikes said:

Hi, i've gone through the tutorial word by word but the files won't transfer to Send Folder! i tried many time but couldn't get it to work. it's kinda urgent, any idea where i may be going wrong. i've restarted the BizTalk Service many time but didn't help... any help would be very much appreciated..

thank you and keep up the good work..

Kamal
# December 16, 2004 5:12 AM

bryantlikes said:

fixed it, security issue with the folders!

by the way, do you need to specify the filter? i tried to not have the filter but it won't transfer the file, it keeps saying:

The "FILE" adapter is suspending a message coming from Source URL:"C:\TestApp\BTS_Test\In\*.xml". Details:"Could not find a matching subscription for the message. ".

Any idea???

Thanks
# December 16, 2004 6:51 AM

bryantlikes said:

What sorts of problems were you seeing with Office Web Components? I only ask because we have a lot of users who believe (possibly incorrectly) that these can solve a lot of issues for them. Let me know if you mind corresponding directly on this (not looking for free consulting here, don't worry).
# December 16, 2004 11:52 AM

TrackBack said:

# December 18, 2004 4:22 PM

TrackBack said:

# December 19, 2004 3:51 PM

bryantlikes said:

Congrats, Bryant! Merry Christmas!
# December 22, 2004 10:15 AM

bryantlikes said:

Congrats to you and your wife!
# December 22, 2004 10:17 AM

bryantlikes said:

Congrats Bryant.
# December 22, 2004 10:50 AM

bryantlikes said:

Hi Bryant,

Please forgive me, but im quite new to RS. This might sound kind of simple but ive yet to find how to tile records in a report. i have a need to generated a report which produces pics and associated values in a 2 x 2 or a 2 x 3 format which spill over onto new pages depending on the quantity. all the examples ive seen are straight forward matrices of data with details falling vertically down the table. id like to populate the report left to right and kick down to the next row once the first is filled (max value being at my discretion). any ideas?

thanks ahead of time for all who help.
# December 22, 2004 11:55 AM

bryantlikes said:

Congratulations. Thanks for the awesome blog.
# December 22, 2004 1:23 PM

bryantlikes said:

Congratulations Bryant. Happy Christmas.
# December 22, 2004 9:04 PM

bryantlikes said:

What a cute family!
# December 22, 2004 9:37 PM

bryantlikes said:

Looks like sharp as a marble is.
# December 22, 2004 9:38 PM

bryantlikes said:

You mean there are people on this planet who understand what you said there?
# December 22, 2004 9:39 PM

bryantlikes said:

what kind of a name is Kaisa?
# December 22, 2004 9:42 PM

bryantlikes said:

That is a pretty impressive reduction of time needed to acess the data. Bet the bosses loved that!
# December 22, 2004 9:42 PM

bryantlikes said:

Congratulations!
# December 22, 2004 9:56 PM

bryantlikes said:

Congrats to the family. Enjoy it!
# December 23, 2004 1:05 AM

bryantlikes said:

Bryant,

Is there a way in the Custom Code can access more than one textbox that contains data. One textbox contains an account number (numeric) from a database field. Another textbox contains a string value from another database field.

Also, is there a way (in the Custom Code) to determine when the previous accounts number does not equal the current account number. When the condition is true some condition is set.
In Crystal Reports this can be done by using the following:
If account_nbr <> Previous account_nbr then (some action is taken);
Example of account numbers:
2345
3456
3456
1234
6789
4567
4567
# December 23, 2004 10:02 AM

bryantlikes said:

Congrats Bryant. Have fun !!!
# December 27, 2004 2:13 AM

bryantlikes said:

how do i set the value of a textbox through custom code? (and can it be done if the textbox is situated in the header?
# December 27, 2004 6:54 PM

bryantlikes said:

Is it possible to use 3rd party controls/assemblies written for use in ASP.NET in Reporting Services? I would like to use the ChartFX for .NET in my reports, instead of the built-in charting functionality.

TIA
# December 28, 2004 12:33 PM

bryantlikes said:

Congrats! Now the real fun begins. :-)
# December 28, 2004 5:16 PM

bryantlikes said:

Congratulations! Great Christmas Present!

Now, Will you still have time to blog now ;)?
# December 29, 2004 4:55 AM

bryantlikes said:

The Address (URI) you are specifying is from the same machine.

But I hae the BizTalks server in a seperate machine and the Data comes from another machine. How to specify BizTalk to take the data from that machine ? Is there any option for this ?


Thanks
MankayarKarasi.C
# December 30, 2004 4:42 AM

bryantlikes said:

Would you happen to know how to add ActiveX controls onto/into custom SQL Reports? There are many articles that mention this as a possibility, but nothing that I have found will allow me to do so. Even a good link would be welcome.

Thanks,
Jim
# December 30, 2004 4:11 PM

TrackBack said:

# January 3, 2005 1:35 AM

bryantlikes said:

Congratulation! So great gift!
# January 5, 2005 7:41 AM

bryantlikes said:

# January 5, 2005 4:27 PM

bryantlikes said:

It is correct, because WSS uses another ISAPI application to render the pages to the FrontPage.
# January 6, 2005 7:56 AM

bryantlikes said:

Need help on this one! It is driving me up the wall!

Message Window says:

SQL Setup failed to execute a command for server configuration. the error was:User does not have permission to alter database 'ReportServer'.
Refer to the server error logs and setup logs for detailed error information.

Appreciate it
# January 6, 2005 11:51 AM

TrackBack said:

# January 6, 2005 5:34 PM

TrackBack said:

# January 6, 2005 5:35 PM

bryantlikes said:

You can use NET USE X: \\sharepointserver\xxx\doclib1 to map a SharePoint doc lib to a local drive. (doc lib is at http://sharepointserver/xxx/doclib1 in this example)

Isn't this enough for what you need ?
# January 7, 2005 4:45 AM

bryantlikes said:

Hi Bryant,

First of all, i'd like to congratulate you for this great webpart..!!

I'm having an error with parameters. With the reports that doesn't have parameters works excelent. But with reports with parameters shows the followin error:

Cannot read reports from the server.
Please check the path to the web-service and folder. Error: Object required.

Can you help me, please.

Gerardo.
# January 11, 2005 11:01 AM

bryantlikes said:

So if Sharepoint and Rs are installed on differnt servers ,it means that I can't use RS Explorer?? Somebody please help me .I can't get it working ,RS explorer keeps on showing "Retrieving data..." and it never shows reports.
# January 11, 2005 11:43 AM

bryantlikes said:

I forgot to say that ,I got the following error when I installed the web part on my Sharepoint Portal server:

====WPPackager install log started 1/11/2005 10:31:42 AM =========
1/11/2005 10:36:12 AM: Error: Config file: 'c:\inetpub\wwwroot\web.config' for virtual server 'http://my_sharepoint_server/">http://my_sharepoint_server/' is missing or appears invalid. Could not apply required CAS settings to this server.

1/11/2005 10:36:12 AM: Error: Could not apply required CAS settings to virtual server 'http://my_sharepoint_server/">http://my_sharepoint_server/' during installation of 'RsWebParts'

1/11/2005 10:36:13 AM: Success: Installation Successfully Completed

You have successfully installed this package.
Note: After you configure the virtual server, you must restart Internet Information Services (IIS), by typing iisreset on the command line.
# January 11, 2005 11:47 AM

bryantlikes said:

Hi Bryant,

Thanks for this code. This is just what I needed!

Regards,
Q
# January 11, 2005 2:25 PM

bryantlikes said:

Here is how I got it to work. When you put in the name of the url for the server, I used Http://servername/reportserver, instead of http://servername/reports, which is the web portion of the reporting server.
If you were to type http://servername/reportserver into a browser, you should get a directory structure, which is what I beleive the webpart wants to read.
As for the stype error, if you change the rs.js file as mentioned in an above posts, and delete you temporary internet files, that should work aslo.
# January 12, 2005 10:48 AM

bryantlikes said:

Thanks Bryant.

This example helpfull me to debug my report, because I didn't found in Microsoft documentation that the compiled dll must be copied in the "report designer" folder.
# January 13, 2005 2:33 AM

TrackBack said:

# January 13, 2005 11:36 AM

TrackBack said:

# January 13, 2005 11:38 AM

bryantlikes said:

Ofcourse you must use "Http://servername/reportserver" and u can never use Report Manager to get service from RS.Do u have RS and WSS on the same server??if yes Are they on the same virtual directory???
# January 13, 2005 4:24 PM

bryantlikes said:

I got this one successfully working. Where can I get the other ones (RS Explorer, RS Report View, RS Report Parameters and RS Report Export)?
# January 14, 2005 2:16 PM

bryantlikes said:

how do i download the source
# January 16, 2005 6:25 PM

bryantlikes said:

Please email me the source code
at
shaikh_intekhab@hotmail.com
# January 16, 2005 6:27 PM

bryantlikes said:

It's a little late but congrads Bryant to you and your wife. What a beautiful little boy you have there!
# January 17, 2005 5:14 PM

bryantlikes said:

Useful tip indeed.
A little more information you may need to know about that _WPR_:
The _WPR_ is extended to the absolute path to the specified instance of the web part.
If your web part is in a sub site, or sub area, you will get:
/[path to the area]/wpresources/[AssemblyName] and not
/wpresources/[AssemblyName].
This may definitely come to a surprise to you (at least it did surprise me), as it makes it more difficult to access the web parts resources from the code behind: if you try to use the url, you will get an access denied because of the double hop/ kerberos-NTML authentication. And if you want to find the file path from the url, you'll run into trouble as Page.MapPath doesn't work!
If anybody who has a good solution (other than parsing the string), I'm listening.
# January 18, 2005 2:20 PM

bryantlikes said:

I am intersted.. Pls. could U share with me..
# January 20, 2005 11:09 PM

TrackBack said:

# January 22, 2005 12:24 AM

TrackBack said:

# January 22, 2005 12:24 AM

bryantlikes said:

I have a report with 2 parameters.. the second parameter is dependent on the first parameter.. I have noticed that when I changed the first parameter, the values of the second parameter doesn't changed.., so I got an error..

any help?
thanks!
# January 24, 2005 2:16 AM

bryantlikes said:

Microsoft offers two web parts with SQL Reporting Services SP2, but unfortunetly they are just an Iframe, what a dissappointment!
# January 24, 2005 11:11 AM

bryantlikes said:

If the comment about the Microsoft web parts in SP2 is true, I think it is a good idea to continue development! We are very happy users of (a slightly modified version of) your web parts!
# January 24, 2005 12:19 PM

TrackBack said:

# January 24, 2005 1:02 PM

TrackBack said:

# January 24, 2005 2:24 PM

TrackBack said:

# January 24, 2005 2:50 PM

bryantlikes said:

where do i download it?
# January 25, 2005 6:23 AM

bryantlikes said:

Hi Bryant,
I have been messing around with BizTalk in a VM session for 2 weeks, I created mutilple samples using The File and other adapter. When I tried to replicate what I have done on a dev server it did not work. I tried your simple demo, it also failes to pick the file.

I have sql, sharepoint, BizTalk on a dev server and I am on client machine connecting to it. I created a share with admin rights to the in/out folders. I must be missing a configuration, but no idea what it is.

Thanks.
# January 25, 2005 8:37 AM

bryantlikes said:

If anyone has done the same with database, could you please help me. I am really struggling.
# January 26, 2005 10:29 PM

bryantlikes said:

I can't seem to download the cab file. It keeps sending me to the GotDotNet workspace website. Please help.
# January 27, 2005 8:07 AM

bryantlikes said:

The trick is to access the resource via http and not directly.
http://www.schaeflein.net/blog/ClassResourcePathGotcha.aspx
# January 27, 2005 2:21 PM

bryantlikes said:

Where is this webpart?? The link is not working.
# January 28, 2005 5:31 AM

bryantlikes said:

Bryant Likes,

Keep the good work man but just bear in mind to fix the security issue that your webpart has with Reporting services while SPS and RS are in different servers.not everyone can enable Kerebros in his/her organization.I was unable to get it work even on the same box when Reporting Services and SPS are on different Virtual directories.If these issues are solved I'm pretty sure that Microsoft won't be able to create such a webpart atleast till SP5 for Reporting Services:-).
Why don't you use your weblog to share the source code then?
# January 28, 2005 3:13 PM

bryantlikes said:

I've posted my issue in the sourceForge.net
# January 28, 2005 8:51 PM

bryantlikes said:

I've posted my issue in sourceForge.net.
Hopefully we can get it fixed [I Won't leave here till I solve this hassle:-)]

Thanks
Reza Alirezaei
# January 28, 2005 8:54 PM

TrackBack said:

# January 30, 2005 3:03 PM

bryantlikes said:

Hi Bryant,

as with the others, fabulous work.

Now to yet another question :)

We are actually trying to call RS methods inside our custom assembly. For a simple example, I am just trying to list the reports. I figure if I can get this working I'll be happy. Question is what permissions do I need to set for the method and in the config file.

any ideas

Many thanks

Matt
# January 31, 2005 12:44 AM

bryantlikes said:

by the way, do you need to specify the filter? i tried to not have the filter but it won't transfer the file, it keeps saying:

The "FILE" adapter is suspending a message coming from Source URL:"C:\TestApp\BTS_Test\In\*.xml". Details:"Could not find a matching subscription for the message. ".

Any idea???

Thanks
# January 31, 2005 5:03 AM

TrackBack said:

# January 31, 2005 6:17 PM

TrackBack said:

# January 31, 2005 6:18 PM

bryantlikes said:

How would you create a ticket for a report server which has form based authentication and authorization for RS. I understand it would be a webpart which should be instantiated before all of your other RS webparts which would create the cookie. But can't figure out the implementation bit. Any ideas!!
# January 31, 2005 10:42 PM

bryantlikes said:

Hi, I wrote BIP. I also suggest you have a look at the BIP addin, it has the ability to bring Reports directly to Excel/Outlook/PPT/Word.
If you want, the source code+ updates+community suppport can be found at a GotDotNet Workspace at http://www.gotdotnet.com/workspaces/workspace.aspx?id=40063240-4d29-42d6-a163-47dcdf2efcaa
# January 31, 2005 11:57 PM

bryantlikes said:

Here is a microsoft kb that also shows how to do this:

http://support.microsoft.com/?kbid=842419
# February 1, 2005 11:14 AM

bryantlikes said:

That is the most sensible discussion I have seen around anything lately.

BTW, my recommendation is if your submission contains more than a certain number of hrefs, then show the captcha to proceed, otherwise accept the comment - this taking out the genuine comment poster's few brain cycles cost.
# February 3, 2005 11:15 AM

bryantlikes said:

It is great that you have provided this webpart. Following your steps from above everything seems to be fine until I try to generate the report. Down by the RS Report View I get this error.

"This report requires a default or user-defined value for the report parameter 'Database'. To run or subscribe to this report, you must provide a parameter value."

With just reporting services Report page I can run this parameter fine. NOt sure why there are no parameters for me to run with the Web Part. Just a side note, the Database parameter is a static one. NOt sure if that has anything to do with it.
# February 3, 2005 1:57 PM

bryantlikes said:

RSWEBPARTS work fine when the report has no dependent parameters.. But when it has a dependent parameters, I'm having an error.. when I changed the first parameter, the values of the second parameter doesn't changed...
# February 4, 2005 2:00 AM

bryantlikes said:

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."

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 http://www.proposion.com/ReportAdapter.
# February 7, 2005 5:47 AM

bryantlikes said:

I think you guys might be mistaken. There is a new managed System.Data.SqlXml namespace that is intended to be a replacement for the COM based SqlXml that ships with MDAC.

That AFAIK is correct, but hey I could be wrong instead :).

But if I'm right, i'd change the misleading title of this post from "SqlXml deprecated" to "SqlXml made more kickass".
# February 7, 2005 1:14 PM

TrackBack said:

# February 7, 2005 1:27 PM

bryantlikes said:

e-piphany happens to be my blog. :)
# February 7, 2005 3:09 PM

bryantlikes said:

Irwin's always been underappreciated. :)
# February 7, 2005 3:11 PM

bryantlikes said:

How it all happened is all a mystery !! :-P
# February 7, 2005 4:28 PM

bryantlikes said:

You should use flags to mark articles of interest then,
# February 7, 2005 5:35 PM

bryantlikes said:

hello.. about the parameter issues., the parameter dependencies, when will it be fixed? thanks 4 reply...
# February 7, 2005 11:51 PM

bryantlikes said:

hi,

I have a problem when my report has dependent parameters.. When I tried to change the selected value on the first parameter, the second parameter did not changed.. How can I fix this bug.. Please help.. thanks!
# February 8, 2005 12:31 AM

bryantlikes said:

... and Greg's Cool [Insert Clever Name] of the Day is mine ... :)

So Simi!
# February 9, 2005 8:02 AM

bryantlikes said:

Ok Arie, you're right. That works. Thanks!
# February 9, 2005 3:42 PM

bryantlikes said:

hello...

I have a report with dependent parameters.. When I select a value from the first parameter, the list of values on the second parameter doesn't changed.. Can anyone explain how can I fix this parameters issue? Is there a new version of RSWebparts that support parameter dependencies?

thanks for help...
# February 9, 2005 6:01 PM

bryantlikes said:

I would be *very* interested. I am pleased that MS have provided the original article but disappointed that they haven't gone the whole way and produced a complete tool that can be used on production systems.

I look forward to seeing your results.

--Philip
# February 11, 2005 6:52 AM

bryantlikes said:

im trying to figure out how to refresh reports on load beside of behing forced to push the refresh button every times.. anyone found a way to do it?
# February 11, 2005 10:07 AM

TrackBack said:

# February 11, 2005 7:52 PM

bryantlikes said:

Wow, this is great. I would be very interested!
# February 11, 2005 7:56 PM

bryantlikes said:

Hi
I am using Stored Procs to get my data, the SP's for instance contain 3 parameters, 2 that i want to prompt for and one I want to set dynamically, by sending the value via the url or by changing the default value of this last parameter.

Thanks
# February 14, 2005 8:53 AM

bryantlikes said:

Hi

I hope someone can help, I have one reporting portal with a set of reports, but many datasources that contains the same data. example, a database per store, so when a user logs in I now to what database he should log into, so i want to change the Datasource dynamically so the report points to the correct database.

Thanks
# February 14, 2005 8:58 AM

bryantlikes said:

Hi,

Thanks for these webparts and many of the above responses. Kudos on the webparts and the blogs have made configuring them a snap.

When I enter a numeric parameter and <tab> the page refreshes with the default parameter. The second time I enter the parameter and <tab> the page refreshes correctly. Does anyone have a clue why this is happening?

Thanks ahead!
# February 14, 2005 1:54 PM

TrackBack said:

# February 14, 2005 6:41 PM

TrackBack said:

# February 14, 2005 6:41 PM

bryantlikes said:

This does seem to be a much more elegant solution. Does this account for documents in doc libs that has versioning turned on?
# February 15, 2005 4:56 AM

bryantlikes said:

According to Michael Yeager who made a webcast on SharePoint Workflow last week, there are rumors Service Pack 2 will add a few essentials missing functionalities to SPS. Maybe they'll add something like this.
# February 15, 2005 6:41 AM

bryantlikes said:

It doesn't account for versioning, however, you could add that in if you wanted. There is a seperate table used to version the documents.
# February 15, 2005 8:33 AM

bryantlikes said:

Sharepoint IMO is hardly hardly hardly a search engine like google or it's competitors are. I don't see how this even borders with Sharepoint. Perhaps you could elaborate.
# February 15, 2005 12:18 PM

bryantlikes said:

Hmmm ... Well thought but I DONT *personally* feel Google's Mini will ever pose a threat as a competitor. Yes, may be on the searching capability alone. That too, "May be".

SP is more of a complete product. And searching is just one of the feature. The portal capability of this product is much superior when compare to just a single feature comparision.

I love to see the scripting capability, aggregation of data capability, giving a personal look and feel capability, document storing capability, easy deployment capability and many more (i am not a SP expert :) ... AFAIK, these are some of the USP for SP).

Just my random thoughts :) ... Found this topic interesting, so posted ...
# February 15, 2005 11:02 PM

bryantlikes said:

Avanade, my employer has a solution using the DB trigger method. It's very full featured although I haven't actually used it yet.

I also developed a similar solution before coming to Avanade but the problem that Maxim and I had with it was that it is a little more "high risk" when it comes to deployment, requiring a certain level of SQL skills. It also has the shortcoming of voiding Microsoft support, any modification to the database will result in Microsoft's refusal to support the SPS installation. MSDN being a Microsoft publication we didn't think they would be comfortable publishing something that voided Micrsoft Support for the product.
# February 15, 2005 11:58 PM

bryantlikes said:

Hi,
I've blogged about this a little while ago. I think this might be a competitor for Sharepoint search when indexing and searching external websites, for example MCMS sites. Martin Muldoon made an interesting point why this isn't a good alternative for indexing corporate intranet sites.

http://blogs.tamtam.nl/mart/CommentView,guid,3a9a502f-bec0-4f2d-8049-52fd61706967.aspx

It might be interesting...

Mart
# February 16, 2005 2:23 AM

bryantlikes said:

Eric,

Thanks for the comment. That makes a lot of sense and I kind of suspected that making a change like this to the database might cause issues for MS support. In light of that the article makes a lot more sense.
# February 16, 2005 9:48 AM

TrackBack said:

# February 17, 2005 11:28 AM

TrackBack said:

# February 18, 2005 7:23 AM

bryantlikes said:

hello all,

i went through this article and did everytihng that has to be done but when i try to connect to the report manager the report manager does not start up. It gives the following error Unable to communicate with the report server. Please verify the report server is operational. When i restore the rssrvpolicy.config the connection to the server is ok. Can anybody help out. This is really nerve racking.. and mdsn help is awful on this.. my rssrvpolicy.config looks like this

<Permissionset
class = "NamedPermissionset"
version="1"
Name="CustomFunctionPermission"
description="test"
<IPermission
class = "OleDbPermission"
version="1"
Flags="Execution,Assertion"
/>
</Permissionset>

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="CustomFunctionPermission"
Name="Test"
Description="Description">
<IMembershipCondition
class = "UrlMembershipcondition"
version="1"
Url="c:\Program Files\Microsoft SQL Server\80\Tools\Report Desinger0x;dll"/