Change in MHTML rendering in SP1?

Greetings.
I recently installed SP1, and am having some trouble with my Custom Delivery
Extension.
My extension renders to MHTML, converts the resulting stream to a
CDO.Message, then manipulates the resulting object. After installing SP1, I
get an exception during this process.
I also noticed that after installing SP1, my report snapshots have gone from
about 55K to 15K.
Has the MHTML rendering changed between RTM and SP1? Is there any
documentation for how it's changed?
Regards, Jonathan
http://kerblog.com/earlyedition/archive/2004/12/09/258.aspxHi Jonathan,
What's the exactly exception you encounter? Have you installed Reporting
Services Services Pack 1 successfully? Even the size the snapshot seems go
down, does the snapshot looks exactly as you expected?
Based on my knowledge, there is only one issue about rendering mhtml fixed
in SP1, see the following knowledge base articles below and no other
changes in rendering were made.
FIX: Bookmark links in a report that is rendered to the Web archive file
format (.mhtml) may not work correctly
http://support.microsoft.com/kb/842534
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Thanks for your quick reply.
"Michael Cheng [MSFT]" wrote:
> What's the exactly exception you encounter?
After I Render the report, I convert it to a CDO.Message and then try to
open the body using CDO.IBodyPart.GetDecodedContentStream(). The exception
is basically a COMException.
> Have you installed Reporting
> Services Services Pack 1 successfully?
Yes.
> Even the size the snapshot seems go
> down, does the snapshot looks exactly as you expected?
Yes, it looks fine.
Reporting Services RTM used to render MHTML into a "text/html" type message
if there were no graphics in the report. It looks to me like SP1 now always
renders as "multipart/related." I'm able to traverse the "multipart/related"
message to find the "text/html" part.
No problem, but it would have been nice to document. I only found out after
the change broke my delivery extension.
Regards,
Jonathan
http://kerblog.com/earlyedition/archive/2004/12/09/260.aspx|||Hi Jonathan,
I will try to find somebody from development team to see whether he knows
the answer and there is any documents about this available. I will keep you
updated.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||HI Jonathan,
It seems the snapshot size (in the report server catalog) has decreased,
because they are compressed in SP1 (unless snapshot compression is turned
off). However, I am not sure why SP1 always renders as "multipart/related"
as you said and no relative documents.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Change image properties at runtime

Hi,
I'm using Reporting Services for SQL2K. My report will need to dynamically
call a custom assembly for each row in a dataset, and then show the image
file that the custom assembly creates. I was thinking of using an Image
control in the report and then changing the path to the image file at
runtime. But I can not figure out how to access the image1.Value property.
Any tips on this or perhaps an alternative solution?
TIA
JonasI found the answer, and it was very easy ;-)
When the control is selected in the Report Designer, it it possible to edit
the properties as usual. The property for Value can also use an Expression,
and voila, this can point to a variable which contains a dynamically created
path.
Brgds
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23z53z3cHGHA.240@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm using Reporting Services for SQL2K. My report will need to dynamically
> call a custom assembly for each row in a dataset, and then show the image
> file that the custom assembly creates. I was thinking of using an Image
> control in the report and then changing the path to the image file at
> runtime. But I can not figure out how to access the image1.Value property.
> Any tips on this or perhaps an alternative solution?
> TIA
> Jonas
>
>

Change date format

Hello.
How can I change (global) date format from yyyy-MM-dd to my custom format?
Thank you.
For input or output?
I suggest you read below article. You find your answers in it:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I change (global) date format from yyyy-MM-dd to my custom format?
> Thank you.
>
|||I want change it globally for whole SQL Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
> For input or output?
> I suggest you read below article. You find your answers in it:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David Dvali" <david_dvali@.hotmail.com> wrote in message
> news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
>
|||That didn't answer my question. There no such thing as a global setting for SQL Server datetime
format. You have to handle input in one way and output in another way. See my article, the first few
sections. It has all the answers and options.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23v4GnkBcFHA.3400@.tk2msftngp13.phx.gbl...
>I want change it globally for whole SQL Server?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
>

Change date format

Hello.
How can I change (global) date format from yyyy-MM-dd to my custom format?
Thank you.For input or output?
I suggest you read below article. You find your answers in it:
http://www.karaszi.com/SQLServer/info_datetime.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I change (global) date format from yyyy-MM-dd to my custom format?
> Thank you.
>|||I want change it globally for whole SQL Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
> For input or output?
> I suggest you read below article. You find your answers in it:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David Dvali" <david_dvali@.hotmail.com> wrote in message
> news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> Hello.
>> How can I change (global) date format from yyyy-MM-dd to my custom
>> format?
>> Thank you.
>|||That didn't answer my question. There no such thing as a global setting for SQL Server datetime
format. You have to handle input in one way and output in another way. See my article, the first few
sections. It has all the answers and options.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23v4GnkBcFHA.3400@.tk2msftngp13.phx.gbl...
>I want change it globally for whole SQL Server?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> For input or output?
>> I suggest you read below article. You find your answers in it:
>> http://www.karaszi.com/SQLServer/info_datetime.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "David Dvali" <david_dvali@.hotmail.com> wrote in message
>> news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> Hello.
>> How can I change (global) date format from yyyy-MM-dd to my custom format?
>> Thank you.
>>
>

Change date format

Hello.
How can I change (global) date format from yyyy-MM-dd to my custom format?
Thank you.For input or output?
I suggest you read below article. You find your answers in it:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I change (global) date format from yyyy-MM-dd to my custom format?
> Thank you.
>|||I want change it globally for whole SQL Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
> For input or output?
> I suggest you read below article. You find your answers in it:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David Dvali" <david_dvali@.hotmail.com> wrote in message
> news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
>|||That didn't answer my question. There no such thing as a global setting for
SQL Server datetime
format. You have to handle input in one way and output in another way. See m
y article, the first few
sections. It has all the answers and options.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23v4GnkBcFHA.3400@.tk2msftngp13.phx.gbl...
>I want change it globally for whole SQL Server?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
>

Catching report exceptions

Instead of using the Report Manager that comes with Reporting Services, I
have built a custom ASP.NET report interface that launches reports using URL
access. When there is a problem displaying a report, I get the usual
reporting services error, but I would like to redirect to a custom report
page. How do I do that ?
Thanks, Craig"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:A040A3CA-2A55-4D2A-8410-75E2B353566D@.microsoft.com...
> Instead of using the Report Manager that comes with Reporting Services, I
> have built a custom ASP.NET report interface that launches reports using
> URL
> access. When there is a problem displaying a report, I get the usual
> reporting services error, but I would like to redirect to a custom report
> page. How do I do that ?
> Thanks, Craig
You can use web service Render method to catch an error, but if you want to
use URL approach, than
grab your's url output by using System.Net.HttpWebRequest ( or WebRequest)
class.
If the output is text based (HTML, CSV) - just convert returned by
WebResponse byte array to - char - string and check it for specific error
messages. If the output has to be binary (PDF, EXCEL, etc.) -just check
ContentType of your System.Net.WebResponse class and if it is "text/html" -
the error has occured ( you can always parse byte array to be sure as I
proposed above).

Casting

Hello,
I created a custom assembly with some business logic and attachted it to a
report.
A class in the assemby has an indexer defined which should return a string.
When I call the indexer from the code block I alway get an "Specified cast is
not valid" error back.
I created a test program in VS to test the classes and the indexer there
everything works fine.
What am I missing?
QSolved it.
I called a method on my class like the following:
wga.Attributes.Add("BG_CODE", Report.Parameters("Conc_BG").Value)
The definition for the Add method is:
public void Add(string databaseColumnName, string value)
But I have also another Add method which is:
public void Add(object key, object value)
I have to implement this method because my class inherits from IDictionary
I was under the impression that when I am adding strings the method with the
strings signature would be taken. But this was not the case. Instead the Add
method with the object signature was taken. Therefore my collection was
filled with objects and the indexer expected strings.
To solve this I had to rewrite it like the following:
wga.Attributes.Add("BG_CODE".ToString,
Report.Parameters("Conc_BG").Value.ToString)
Now the Add method with the strings signature is called.
Long live VS debugging!
Q
"Qbee" wrote:
> Hello,
> I created a custom assembly with some business logic and attachted it to a
> report.
> A class in the assemby has an indexer defined which should return a string.
> When I call the indexer from the code block I alway get an "Specified cast is
> not valid" error back.
> I created a test program in VS to test the classes and the indexer there
> everything works fine.
> What am I missing?
> Q