Books, articles on printing reports

I am a developer. I current have the Developer Edition of SQL Server 2000 on
my desktop and I am installing VB.Net 2003 and Reporting Services so that a
report, that uses data from a SQL Server 2000 database, can be printed.
I seek the minimal education available that will enable me to design this
report that my customers, who using the database, will print. Are there
suggestions for books or articles that meet this need?
Thanks.
JimMicrosoft SQL Server 2000 Reporting Services is pretty straight forward if
you avoid the filler about how the engine works (actually to be fair all the
books I've seen spend a lot of time on this), there is a better book but its
quite a bit more techy - hitch hikers guide to reporting services.
Phil
"James_101" <James101@.discussions.microsoft.com> wrote in message
news:F730DE37-5437-4E9C-BB8B-BA7776BDEBC9@.microsoft.com...
>I am a developer. I current have the Developer Edition of SQL Server 2000
>on
> my desktop and I am installing VB.Net 2003 and Reporting Services so that
> a
> report, that uses data from a SQL Server 2000 database, can be printed.
> I seek the minimal education available that will enable me to design this
> report that my customers, who using the database, will print. Are there
> suggestions for books or articles that meet this need?
> Thanks.
> Jim|||'Hitchhiker's Guide to SQL Server 2000 Reporting Services' is a very good
book on the subject ...
http://www.sqlreportingservices.net/
There are lot's of on-line resources here ...
http://msdn.microsoft.com/sql/2000/learn/bi/reporting/default.aspx
--
Brendan Reynolds
"James_101" <James101@.discussions.microsoft.com> wrote in message
news:F730DE37-5437-4E9C-BB8B-BA7776BDEBC9@.microsoft.com...
>I am a developer. I current have the Developer Edition of SQL Server 2000
>on
> my desktop and I am installing VB.Net 2003 and Reporting Services so that
> a
> report, that uses data from a SQL Server 2000 database, can be printed.
> I seek the minimal education available that will enable me to design this
> report that my customers, who using the database, will print. Are there
> suggestions for books or articles that meet this need?
> Thanks.
> Jim|||Best book I've read on RS is "CodeFez Guide to Reporting Services". They
released a PDF version a few weeks ago, PDF version is about $20. I found
it a lot easier to read than the others.
http://www.falafel.com/Products/tabid/58/CatalogItemID/19/CatalogID/1/psnavcmd/CatalogItemDetails/Default.aspx
--
Floyd
"James_101" <James101@.discussions.microsoft.com> wrote in message
news:F730DE37-5437-4E9C-BB8B-BA7776BDEBC9@.microsoft.com...
>I am a developer. I current have the Developer Edition of SQL Server 2000
>on
> my desktop and I am installing VB.Net 2003 and Reporting Services so that
> a
> report, that uses data from a SQL Server 2000 database, can be printed.
> I seek the minimal education available that will enable me to design this
> report that my customers, who using the database, will print. Are there
> suggestions for books or articles that meet this need?
> Thanks.
> Jim

Books on SSRS

Any recommendations on best book(s) to get a quick start with SQL Reorting
Services ? and hopefully with some depth ?
Thanks ....Liz,
did you try to query Amazon ' I found some... unfortunatly I haven't found
the time to order and read one.... maybe this helps a bit...
Regards
/Martin
"Liz" <liz@.tiredofspam.com> schrieb im Newsbeitrag
news:BIMVc.22183033$Of.3703104@.news.easynews.com...
> Any recommendations on best book(s) to get a quick start with SQL Reorting
> Services ? and hopefully with some depth ?
> Thanks ....
>|||Also take a look at
http://www.microsoft.com/sql/reporting/techinfo/books.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Martin Schlenker" <Martinschlenker@.web.de> wrote in message
news:Oah0Ol7hEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Liz,
> did you try to query Amazon ' I found some... unfortunatly I haven't
found
> the time to order and read one.... maybe this helps a bit...
> Regards
> /Martin
> "Liz" <liz@.tiredofspam.com> schrieb im Newsbeitrag
> news:BIMVc.22183033$Of.3703104@.news.easynews.com...
> >
> > Any recommendations on best book(s) to get a quick start with SQL
Reorting
> > Services ? and hopefully with some depth ?
> >
> > Thanks ....
> >
> >
>

Books on SSAS 2005....

Hi,

I will be very happy if anyone can suggest me a very good book (preferably microsoft press book) on SQL Server Analysis Services 2005 (SSAS 2005). I mean hard copy. I want to know the in and out of SSAS 2005......so i will be thankful if im suggested some good book on it.

Expecting your reply soon!!!!!

TIA,

Shaun Michael

Hi Shaun,

I'm currently reading the following books and I think they are pretty good.

- Applied Microsoft Analysis Services 2005

- Delivering Business Intelligence with Microsoft SQL Server 2005

Those books cover the whole Microsoft BI Platform (SQL,SSAS,SSIS and RS) and not only SSAS.

HTH,

Eric

|||

Hi Shaun,

Chris Webb has compiled a list of AS 2005-related books on his blog - some of which may not yet be available:

http://spaces.msn.com/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!322.entry

|||

I think these books sound good.

Thanks a lot Eric & Deepak.

sql

Books for Reporting Services

I am looking to purchase a book or books on Reporting Services. Any
opinions on the best book or books to buy?
--
DarrellPro SQL Reporting Services by Rodney Landrum and Walter Voytek from APRESS is
a good read and quite detailed in its presentation. Take a look at it at
Amazon.com or Barnesandnoble.com
"Darrell" wrote:
> I am looking to purchase a book or books on Reporting Services. Any
> opinions on the best book or books to buy?
> --
> Darrell
>|||I haven't read it yet, but Peter Blackburn and William Vaughn's
"Hitchhiker's Guide to SQL Server 2000 Reporting Services" from Addison
Wesley is available now, http://www.sqlreportingservices.net/. Anthony Mann
has also published his "The Rational Guide to SQL Server Reporting
Services", http://www.mannpublishing.com/mannpub/.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Darrell" <Darrell.Wright.nospam@.okc.gov> wrote in message
news:opsgngmfs0yvcklr@.msnews.microsoft.com...
>I am looking to purchase a book or books on Reporting Services. Any
>opinions on the best book or books to buy?
> --
> Darrell|||Ah, how could I forget Teo Lachev's "Microsoft Reporting Services in Action"
book?
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:umB8PjGwEHA.3084@.TK2MSFTNGP10.phx.gbl...
>I haven't read it yet, but Peter Blackburn and William Vaughn's
>"Hitchhiker's Guide to SQL Server 2000 Reporting Services" from Addison
>Wesley is available now, http://www.sqlreportingservices.net/. Anthony Mann
>has also published his "The Rational Guide to SQL Server Reporting
>Services", http://www.mannpublishing.com/mannpub/.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Darrell" <Darrell.Wright.nospam@.okc.gov> wrote in message
> news:opsgngmfs0yvcklr@.msnews.microsoft.com...
>>I am looking to purchase a book or books on Reporting Services. Any
>>opinions on the best book or books to buy?
>> --
>> Darrell
>|||Shame :-)
Seriously, I haven't read the other books but I do believe that each book
has its own strengths (and weaknesses). Mine emphasizes on integrating RS
with custom applications with a primary focus on .NET developers.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O2HhXrGwEHA.728@.TK2MSFTNGP11.phx.gbl...
> Ah, how could I forget Teo Lachev's "Microsoft Reporting Services in
Action"
> book?
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:umB8PjGwEHA.3084@.TK2MSFTNGP10.phx.gbl...
> >I haven't read it yet, but Peter Blackburn and William Vaughn's
> >"Hitchhiker's Guide to SQL Server 2000 Reporting Services" from Addison
> >Wesley is available now, http://www.sqlreportingservices.net/. Anthony
Mann
> >has also published his "The Rational Guide to SQL Server Reporting
> >Services", http://www.mannpublishing.com/mannpub/.
> >
> > --
> > Sincerely,
> > Stephen Dybing
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Darrell" <Darrell.Wright.nospam@.okc.gov> wrote in message
> > news:opsgngmfs0yvcklr@.msnews.microsoft.com...
> >>I am looking to purchase a book or books on Reporting Services. Any
> >>opinions on the best book or books to buy?
> >>
> >> --
> >> Darrell
> >
> >
>|||I have bought and would fully recommend "The Hitchhikers Guide to SQL Server 2000 Reporting Services" by Peter Blackburn and William Vaughn. Not a day has gone by since I bought it that I haven't referred to it, it is a truly excellent technical book.
Also has accompanying website www.sqlreportingservices.net, where you can see (I think!) the first two chapters of the book, to get a flavour for it.
Check it out!
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4661
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=22805e94d2bc46da86e37d07558fe1d4
*****************************************

Books

Looking for suggestions on some good books for Reporting Services that will
get me up to speed on its functionality. A book with a good index, good for
beginners, good reference book; that will hopefully get me up to speed pretty
quickly on utilizing Reporting Services.
Thanks in advance for your help.
wnfisbawnfisba,
I bought Wrox's Prof SQL Server 2005 Reporting Services book a month ago,
and I was disappointed.
I was very disappointed when I tried to learn about the ReportViewer
control. There were only a few pages that dealt with it, and it really didn't
get into the good, stuff.
I wanted to use the control on remote servers, and it didn't explain the
issues on setting the credentials.
I would have re-titled this book - - Beginner SQL Server Report Server, for
it really only touches high level topics regarding the SSRS 2005. However, if
you want a lesson in developing WinForm application, this is your book.
-rwiethorn
"wnfisba" wrote:
> Looking for suggestions on some good books for Reporting Services that will
> get me up to speed on its functionality. A book with a good index, good for
> beginners, good reference book; that will hopefully get me up to speed pretty
> quickly on utilizing Reporting Services.
> Thanks in advance for your help.
> wnfisba|||Don't overlook the usefulness of the "Dummies" books. I've found the "SSRS
for Dummies" book very helpful, especially for context and concept (how the
pieces fit together and why).
elinde

Bookmark in Code not working.

I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement:

"An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code

Additional information: Some parameters or credentials have not been specified"

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim strReport1 As String = "/ReportDirectory/CurrentWeekSales"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri(CStr(Session.Item("ReportServer")))
ReportViewer1.ServerReport.ReportPath = strReport1
ReportViewer1.ServerReport.Timeout = 500000

Do While ReportViewer1.ServerReport.IsDrillthroughReport
ReportViewer1.PerformBack()
Loop

Dim RptParameters1 As ReportParameter() = New ReportParameter(0) {}
RptParameters1(0) = New ReportParameter("EBO_EmpKey", CStr(Session.Item("UserKey")))
ReportViewer1.ServerReport.SetParameters(RptParameters1)

ReportViewer1.ServerReport.Refresh()

ReportViewer1.JumpToBookmark("6")

End If
End Sub

What am I missing?

ThanksI too am having a similar problem. I find that JumpToBookmark() simply does not work no matter what I try. Interestingly, setting the 'action' property of a TextBox within the report to jump to the target bookmark seems to work. Unfortunately, I need to be able to do this in code without having to force the user to click on the report.

Is this a known problem, or is there something else on the viewer and/or report that needs to be set?

Thanks,

Ian.

Book Suggestions

I would like to know if anyone has a suggestion of a book for biginners.
Reporting Services seems to be a very difficult thing to get informaion on.
The only thing that has been remotly helpful has been information from people
more expreianced. I would like book for reference. I ordered the book
"Hitchhiker's Guide to SQL Server 2000 Reporting Services". Is this one
going to be helpful or should I find another one too?The "Hitchhiker's Guide to SQL Server 200 Reporting Services" is an
excellent book.
You may also want to buy "SQL Server Reporting Services" by Wrox. Another
excellent book.
These 2 books would make a excellent edition to your book reference library.
Yosh
"Rick via SQLMonster.com" <u15024@.uwe> wrote in message
news:5615b21a3c656@.uwe...
>I would like to know if anyone has a suggestion of a book for biginners.
> Reporting Services seems to be a very difficult thing to get informaion
> on.
> The only thing that has been remotly helpful has been information from
> people
> more expreianced. I would like book for reference. I ordered the book
> "Hitchhiker's Guide to SQL Server 2000 Reporting Services". Is this one
> going to be helpful or should I find another one too?|||I appreciate it. I am Green as can be and need some reference material.
Yosh wrote:
>The "Hitchhiker's Guide to SQL Server 200 Reporting Services" is an
>excellent book.
>You may also want to buy "SQL Server Reporting Services" by Wrox. Another
>excellent book.
>These 2 books would make a excellent edition to your book reference library.
>Yosh
>>I would like to know if anyone has a suggestion of a book for biginners.
>> Reporting Services seems to be a very difficult thing to get informaion
>[quoted text clipped - 4 lines]
>> "Hitchhiker's Guide to SQL Server 2000 Reporting Services". Is this one
>> going to be helpful or should I find another one too?|||Rick,
I would also recommend the Hitchhiker's Guide.
If, as you say, you are green then the Microsoft Step by Step book
might be the easiest first book.
Hitchhiker's Guide will give you depth. Another good RS2000 book is
Teo Lachev's book from Manning.
The Wrox RS2000 book is good too.
Andrew Watt
MVP - InfoPath
On Wed, 19 Oct 2005 19:11:38 GMT, "Rick via SQLMonster.com"
<u15024@.uwe> wrote:
>I would like to know if anyone has a suggestion of a book for biginners.
>Reporting Services seems to be a very difficult thing to get informaion on.
>The only thing that has been remotly helpful has been information from people
>more expreianced. I would like book for reference. I ordered the book
>"Hitchhiker's Guide to SQL Server 2000 Reporting Services". Is this one
>going to be helpful or should I find another one too?|||Rick,
Go and search for webcasts on MS site, there are a whole series for
beginners with visual exapmles. The examples Im refering to starts on 07
March 2005.
Very very good.
--
http://dotnet.org.za/stanley
"Rick via SQLMonster.com" wrote:
> I would like to know if anyone has a suggestion of a book for biginners.
> Reporting Services seems to be a very difficult thing to get informaion on.
> The only thing that has been remotly helpful has been information from people
> more expreianced. I would like book for reference. I ordered the book
> "Hitchhiker's Guide to SQL Server 2000 Reporting Services". Is this one
> going to be helpful or should I find another one too?
>|||There is also a more recent series of Reporting Services webcasts.
Sometime during the last month.
I can't now recall if they are RS2000 or RS2005 webcasts.
Go to http://www.microsoft.com/events and then search the on-demand
webcasts.
Andrew Watt
MVP - InfoPath
On Thu, 20 Oct 2005 06:58:22 -0700, "Stan"
<Stan@.discussions.microsoft.com> wrote:
>Rick,
>Go and search for webcasts on MS site, there are a whole series for
>beginners with visual exapmles. The examples Im refering to starts on 07
>March 2005.
>Very very good.

Book Suggestion?

Can anyone recommend good books for learning Reporting Services? Assume the reader is familiar with Crystal Reports and other reporting environments, but has no experience with SQL Server 2005 and very little with Visual Studio 2005.

Try

Microsoft SQL Server 2005 Reporting Services step by step

Misner, Stacia. 2006

book samples

Hi

Does someone have the booksamples for the book: analysis services 2005 step by step

Thank

Avecinna

All the samples should be on the disk that comes with the book.

Bryan

book samples

Hi

Does someone have the booksamples for the book: analysis services 2005 step by step

Thank

Avecinna

All the samples should be on the disk that comes with the book.

Bryan

Book recommendations for an all encompassing SQL Server 2005 Reporting Services

Out of all the books for SQL 2000 Reporting Services, I found Peter
Blackburns book most helpful. Since he is not writing a Sql 2005 Reporting
Services equivalent, can any make any recommendations for an RS 2005 book?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1yes. i have the same question.
What books are recommended for SQL 2005 Reporting Services? (Last time
I checked most of the books seem to be in print)
Paul M via SQLMonster.com wrote:
> Out of all the books for SQL 2000 Reporting Services, I found Peter
> Blackburns book most helpful. Since he is not writing a Sql 2005 Reporting
> Services equivalent, can any make any recommendations for an RS 2005 book?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1

Book recommendation

Hi,
I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
Reporting Services
or
Professional SQL Server Reporting Services -- by Paul Turley
I need a book that will also show me for example how to pass parameters from
asp.net to rss. I want the user to select parameters from asp.net and pass
those parameters to the stored procedure in the report.
ThanksI use the Wrox book (as you mentioned) and also SQL Reporting Services Step
by Step - by Microsoft. Both deal, in depth, with design, deployment and
server administration.
Depending on how you want the report to open from your aspx page, you can
simply use the URL for the RS report, and pass the parameters in that (that's
how RS does it), to open the report only, without any fuss. I also use
buttons on my ASP pages to render the report in PDF/Excel etc immediately
without having the user required to 'export' it themselves.
Tony
"collie" wrote:
> Hi,
> I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
> Reporting Services
> or
> Professional SQL Server Reporting Services -- by Paul Turley
> I need a book that will also show me for example how to pass parameters from
> asp.net to rss. I want the user to select parameters from asp.net and pass
> those parameters to the stored procedure in the report.
> Thanks

Book question: Professional SQL Server Reporting Services

I am fairly new to SQL Server and very new to Reporting Services. I am
working my way through the WROX book: Professional SQL Server Reporting
Services by Turley et. al. Is this the best forum to ask questions about the
book in general and issues with walk-through examples? If it is, I am having
problems with the example that concludes on page 112. This involves
cascading parameters.
Everything works on the dataset definitions. If I run the Stores_BY_City
dataset and select AZ/Phoenix I do indeed see the 3 stores in Phoenix (437,
473, and 475). When I preview the report the parameter drop down lists work
as expected. However, the reporting fields in the preview are blank. The
labels show fine. Any suggestion on how to debug? Thank you, BobBob
Please send me you RDL file so I can see what's going on.
(nospam@.scout-master..com (fix the addess))
Paul Turley
"Robert Schuldenfrei" <RobertSchuldenfrei@.discussions.microsoft.com> wrote in message news:<1D76AEFA-7FA7-431B-9433-8D334D438FB8@.microsoft.com>...
> I am fairly new to SQL Server and very new to Reporting Services. I am
> working my way through the WROX book: Professional SQL Server Reporting
> Services by Turley et. al. Is this the best forum to ask questions about the
> book in general and issues with walk-through examples? If it is, I am having
> problems with the example that concludes on page 112. This involves
> cascading parameters.
> Everything works on the dataset definitions. If I run the Stores_BY_City
> dataset and select AZ/Phoenix I do indeed see the 3 stores in Phoenix (437,
> 473, and 475). When I preview the report the parameter drop down lists work
> as expected. However, the reporting fields in the preview are blank. The
> labels show fine. Any suggestion on how to debug? Thank you, Bob

BOOK FOR SALE: SQL Server 2005 Reporting Services for Dummies

Bought the book brand new and found out the company I started working for
already had it. It is 99.9999% mint. The only glitch is 1 or 2 folded
corners on a page...very good condition.
Paid $24.95 US for it and will take $10.00 for it. Plus shipping (media
mail).
Plus, I will give you 5 days to see if you like it! If not, I will give a
full refund if you send the book back in same condition.
USA only please.
If this is the wrong place to post this then I apologize.
Contact me at: cbmeeks@.gmail.com
PAYPAL only."cbmeeks" wrote:
> Bought the book brand new and found out the company I started working for
> already had it. It is 99.9999% mint. The only glitch is 1 or 2 folded
> corners on a page...very good condition.
> Paid $24.95 US for it and will take $10.00 for it. Plus shipping (media
> mail).
> Plus, I will give you 5 days to see if you like it! If not, I will give a
> full refund if you send the book back in same condition.
> USA only please.
> If this is the wrong place to post this then I apologize.
> Contact me at: cbmeeks@.gmail.com
> PAYPAL only.
>
Forgot to mention the ISBN: 0-7645-8913-X

book

Can you recommend a book on Integration services in sql server 2005?
ThanksProfessional SQL Server 2005 Integration Services (Wrox) Of course I'm biased, I'm a co-author.

Microsoft SQL Server 2005 Integration Services (Sams) It's not out yet but be sure to pick it up when it does come out. Kirk is on the SSIS team at Microsoft.
|||

Jason Gerard wrote:

Microsoft SQL Server 2005 Integration Services (Sams) It's not out yet but be sure to pick it up when it does come out. Kirk is on the SSIS team at Microsoft.

Sorry for digressing slightly. Kirk is no longer on the SSIS team (unfortunately). He's moved to OBA.

-Jamie

|||It seems the wrox version is the only one available at present ?|||

Correct. As Jason said, its not out yet.

-Jamie

|||The updated version of Donald's book The Rational Guide to Scripting SQL Server 2005 Integration Services would be available in a few weeks. The previous version was a Beta Preview.|||

Anjan,

Any idea what the differences are?

-Jamie

|||

>Any idea what the differences are?

Yeh, the code works against RTM. :-)

BTW, when discussing books, don't forget "The Microsoft Data Warehouse Toolkit" by Joy Mundy, Warren Thornthwaite, Ralph Kimball." It covers SSIS very effectively in the context of solving business and data warehouse problems.

Donald

bmp BLOP fields

Hi,
Does Sql reporting services support Bmp BLOB files?
SapnilSapnil, I believe the answer is yes.
You'll need an image control and choose 'Database' as the 'Source' and
the appropriate column name as the 'Value'. Also select the appropriate
MIME type.
Chris
Sapnil wrote:
> Hi,
> Does Sql reporting services support Bmp BLOB files?
> Sapnil|||Having re-read your post, I should clarify that I assume you mean
bitmaps stored in the database as BLOB fields?
If you mean external files then again yes it can, either using a field
containing the url/unc path or some other direct path are expression to
the path.
Chris
Chris McGuigan wrote:
> Sapnil, I believe the answer is yes.
> You'll need an image control and choose 'Database' as the 'Source' and
> the appropriate column name as the 'Value'. Also select the
> appropriate MIME type.
> Chris
> Sapnil wrote:
> > Hi,
> >
> > Does Sql reporting services support Bmp BLOB files?
> >
> > Sapnil|||I tried as you said. But the BMP imgaes are not displayed in the report.
I tried the same with crystal reports and it worked.
"Chris McGuigan" wrote:
> Having re-read your post, I should clarify that I assume you mean
> bitmaps stored in the database as BLOB fields?
> If you mean external files then again yes it can, either using a field
> containing the url/unc path or some other direct path are expression to
> the path.
> Chris
>
> Chris McGuigan wrote:
> > Sapnil, I believe the answer is yes.
> > You'll need an image control and choose 'Database' as the 'Source' and
> > the appropriate column name as the 'Value'. Also select the
> > appropriate MIME type.
> >
> > Chris
> >
> > Sapnil wrote:
> >
> > > Hi,
> > >
> > > Does Sql reporting services support Bmp BLOB files?
> > >
> > > Sapnil
>|||Sapnil,
I've just checked the Sample Report, Product Catalogue. This uses this
feature and works. It shows an image for each stock item and the image
is taken directly from the database. I suspect you've a setting wrong.
I suggest you load and take a look at this sample report. Look up
sample reports in BOL for details.
In the sample the image is inside a rectangle, which may confuse you
when trying to select it. In the properties pane, in the drop-down list
of property names select ProdPhoto.
Chris
Sapnil wrote:
> I tried as you said. But the BMP imgaes are not displayed in the
> report. I tried the same with crystal reports and it worked.
> "Chris McGuigan" wrote:
> > Having re-read your post, I should clarify that I assume you mean
> > bitmaps stored in the database as BLOB fields?
> > If you mean external files then again yes it can, either using a
> > field containing the url/unc path or some other direct path are
> > expression to the path.
> >
> > Chris
> >
> >
> > Chris McGuigan wrote:
> >
> > > Sapnil, I believe the answer is yes.
> > > You'll need an image control and choose 'Database' as the
> > > 'Source' and the appropriate column name as the 'Value'. Also
> > > select the appropriate MIME type.
> > >
> > > Chris
> > >
> > > Sapnil wrote:
> > >
> > > > Hi,
> > > >
> > > > Does Sql reporting services support Bmp BLOB files?
> > > >
> > > > Sapnil
> >
> >|||Chirs,
I have tried the sample product catalog sample report and it works for me too.
But If I am not wrong the images stored in the BLOB fieds are of type GIF
I tried the same thing with the Northwind database, trying to display the
employees on the report, but there seems to be some problem.
Sapnil
"Chris McGuigan" wrote:
> Sapnil,
> I've just checked the Sample Report, Product Catalogue. This uses this
> feature and works. It shows an image for each stock item and the image
> is taken directly from the database. I suspect you've a setting wrong.
> I suggest you load and take a look at this sample report. Look up
> sample reports in BOL for details.
> In the sample the image is inside a rectangle, which may confuse you
> when trying to select it. In the properties pane, in the drop-down list
> of property names select ProdPhoto.
> Chris
>
> Sapnil wrote:
> > I tried as you said. But the BMP imgaes are not displayed in the
> > report. I tried the same with crystal reports and it worked.
> >
> > "Chris McGuigan" wrote:
> >
> > > Having re-read your post, I should clarify that I assume you mean
> > > bitmaps stored in the database as BLOB fields?
> > > If you mean external files then again yes it can, either using a
> > > field containing the url/unc path or some other direct path are
> > > expression to the path.
> > >
> > > Chris
> > >
> > >
> > > Chris McGuigan wrote:
> > >
> > > > Sapnil, I believe the answer is yes.
> > > > You'll need an image control and choose 'Database' as the
> > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > select the appropriate MIME type.
> > > >
> > > > Chris
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Does Sql reporting services support Bmp BLOB files?
> > > > >
> > > > > Sapnil
> > >
> > >
>|||It's MIME type is set to image/bmp, so I assume it's bmp!
I've never actually used Blob fields. So I'm going by the book rather
than experience! Have you tried all the different MIME types against
your data? Are you 100% sure your fields contain bitmaps and not gifs
or jpegs? I guess you are because you've had it working in Crystal, but
it's worth a check!
Regards
Chris
Sapnil wrote:
> Chirs,
> I have tried the sample product catalog sample report and it works
> for me too. But If I am not wrong the images stored in the BLOB
> fieds are of type GIF I tried the same thing with the Northwind
> database, trying to display the employees on the report, but there
> seems to be some problem.
> Sapnil
> "Chris McGuigan" wrote:
> > Sapnil,
> > I've just checked the Sample Report, Product Catalogue. This uses
> > this feature and works. It shows an image for each stock item and
> > the image is taken directly from the database. I suspect you've a
> > setting wrong.
> >
> > I suggest you load and take a look at this sample report. Look up
> > sample reports in BOL for details.
> >
> > In the sample the image is inside a rectangle, which may confuse you
> > when trying to select it. In the properties pane, in the drop-down
> > list of property names select ProdPhoto.
> >
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > I tried as you said. But the BMP imgaes are not displayed in the
> > > report. I tried the same with crystal reports and it worked.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Having re-read your post, I should clarify that I assume you
> > > > mean bitmaps stored in the database as BLOB fields?
> > > > If you mean external files then again yes it can, either using a
> > > > field containing the url/unc path or some other direct path are
> > > > expression to the path.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Chris McGuigan wrote:
> > > >
> > > > > Sapnil, I believe the answer is yes.
> > > > > You'll need an image control and choose 'Database' as the
> > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > select the appropriate MIME type.
> > > > >
> > > > > Chris
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > >
> > > > > > Sapnil
> > > >
> > > >
> >
> >|||I have tried all MIME types.
And you are right, its working with crystal reports.
Actually I am in the process of evaluating repoting tools.
"Chris McGuigan" wrote:
> It's MIME type is set to image/bmp, so I assume it's bmp!
> I've never actually used Blob fields. So I'm going by the book rather
> than experience! Have you tried all the different MIME types against
> your data? Are you 100% sure your fields contain bitmaps and not gifs
> or jpegs? I guess you are because you've had it working in Crystal, but
> it's worth a check!
> Regards
> Chris
>
> Sapnil wrote:
> > Chirs,
> > I have tried the sample product catalog sample report and it works
> > for me too. But If I am not wrong the images stored in the BLOB
> > fieds are of type GIF I tried the same thing with the Northwind
> > database, trying to display the employees on the report, but there
> > seems to be some problem.
> >
> > Sapnil
> >
> > "Chris McGuigan" wrote:
> >
> > > Sapnil,
> > > I've just checked the Sample Report, Product Catalogue. This uses
> > > this feature and works. It shows an image for each stock item and
> > > the image is taken directly from the database. I suspect you've a
> > > setting wrong.
> > >
> > > I suggest you load and take a look at this sample report. Look up
> > > sample reports in BOL for details.
> > >
> > > In the sample the image is inside a rectangle, which may confuse you
> > > when trying to select it. In the properties pane, in the drop-down
> > > list of property names select ProdPhoto.
> > >
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I tried as you said. But the BMP imgaes are not displayed in the
> > > > report. I tried the same with crystal reports and it worked.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Having re-read your post, I should clarify that I assume you
> > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > If you mean external files then again yes it can, either using a
> > > > > field containing the url/unc path or some other direct path are
> > > > > expression to the path.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Chris McGuigan wrote:
> > > > >
> > > > > > Sapnil, I believe the answer is yes.
> > > > > > You'll need an image control and choose 'Database' as the
> > > > > > 'Source' and the appropriate column name as the 'Value'. Also
> > > > > > select the appropriate MIME type.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > >
> > > > > > > Sapnil
> > > > >
> > > > >
> > >
> > >
>|||Hi Sapnil,
I'm a bit stumped I'm afraid. What exactly are you getting?
In terms of evaluation, I'm an ex-Crystal user who switched to RS last
February and have had little need to revert back since.
That's not to say that there are things Crystal doesn't do better than
RS, but for my environment, RS has many more advantages. I'm playing
with RS2005 now (due to be "launched" early November) and it's looking
good with ReportBuilder filling many of the RS's shortcomings against
Crystal. This is a bit off topic now but if you trawl this newsgroup
you'll see plenty of worthwhile exchanges on the pro's and con's of
various reporting tools.
Obviously this image issue is a problem for you! Are you using SP1 or
SP2?
Chris
Sapnil wrote:
> I have tried all MIME types.
> And you are right, its working with crystal reports.
> Actually I am in the process of evaluating repoting tools.
> "Chris McGuigan" wrote:
> > It's MIME type is set to image/bmp, so I assume it's bmp!
> > I've never actually used Blob fields. So I'm going by the book
> > rather than experience! Have you tried all the different MIME types
> > against your data? Are you 100% sure your fields contain bitmaps
> > and not gifs or jpegs? I guess you are because you've had it
> > working in Crystal, but it's worth a check!
> >
> > Regards
> > Chris
> >
> >
> > Sapnil wrote:
> >
> > > Chirs,
> > > I have tried the sample product catalog sample report and it works
> > > for me too. But If I am not wrong the images stored in the BLOB
> > > fieds are of type GIF I tried the same thing with the Northwind
> > > database, trying to display the employees on the report, but there
> > > seems to be some problem.
> > >
> > > Sapnil
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Sapnil,
> > > > I've just checked the Sample Report, Product Catalogue. This
> > > > uses this feature and works. It shows an image for each stock
> > > > item and the image is taken directly from the database. I
> > > > suspect you've a setting wrong.
> > > >
> > > > I suggest you load and take a look at this sample report. Look
> > > > up sample reports in BOL for details.
> > > >
> > > > In the sample the image is inside a rectangle, which may
> > > > confuse you when trying to select it. In the properties pane,
> > > > in the drop-down list of property names select ProdPhoto.
> > > >
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > the report. I tried the same with crystal reports and it
> > > > > worked.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > If you mean external files then again yes it can, either
> > > > > > using a field containing the url/unc path or some other
> > > > > > direct path are expression to the path.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Chris McGuigan wrote:
> > > > > >
> > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > Also select the appropriate MIME type.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > >
> > > > > > > > Sapnil
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||I am using SP2
"Chris McGuigan" wrote:
> Hi Sapnil,
> I'm a bit stumped I'm afraid. What exactly are you getting?
> In terms of evaluation, I'm an ex-Crystal user who switched to RS last
> February and have had little need to revert back since.
> That's not to say that there are things Crystal doesn't do better than
> RS, but for my environment, RS has many more advantages. I'm playing
> with RS2005 now (due to be "launched" early November) and it's looking
> good with ReportBuilder filling many of the RS's shortcomings against
> Crystal. This is a bit off topic now but if you trawl this newsgroup
> you'll see plenty of worthwhile exchanges on the pro's and con's of
> various reporting tools.
> Obviously this image issue is a problem for you! Are you using SP1 or
> SP2?
> Chris
>
> Sapnil wrote:
> > I have tried all MIME types.
> > And you are right, its working with crystal reports.
> > Actually I am in the process of evaluating repoting tools.
> >
> > "Chris McGuigan" wrote:
> >
> > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > I've never actually used Blob fields. So I'm going by the book
> > > rather than experience! Have you tried all the different MIME types
> > > against your data? Are you 100% sure your fields contain bitmaps
> > > and not gifs or jpegs? I guess you are because you've had it
> > > working in Crystal, but it's worth a check!
> > >
> > > Regards
> > > Chris
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > Chirs,
> > > > I have tried the sample product catalog sample report and it works
> > > > for me too. But If I am not wrong the images stored in the BLOB
> > > > fieds are of type GIF I tried the same thing with the Northwind
> > > > database, trying to display the employees on the report, but there
> > > > seems to be some problem.
> > > >
> > > > Sapnil
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Sapnil,
> > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > uses this feature and works. It shows an image for each stock
> > > > > item and the image is taken directly from the database. I
> > > > > suspect you've a setting wrong.
> > > > >
> > > > > I suggest you load and take a look at this sample report. Look
> > > > > up sample reports in BOL for details.
> > > > >
> > > > > In the sample the image is inside a rectangle, which may
> > > > > confuse you when trying to select it. In the properties pane,
> > > > > in the drop-down list of property names select ProdPhoto.
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I tried as you said. But the BMP imgaes are not displayed in
> > > > > > the report. I tried the same with crystal reports and it
> > > > > > worked.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Having re-read your post, I should clarify that I assume you
> > > > > > > mean bitmaps stored in the database as BLOB fields?
> > > > > > > If you mean external files then again yes it can, either
> > > > > > > using a field containing the url/unc path or some other
> > > > > > > direct path are expression to the path.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Chris McGuigan wrote:
> > > > > > >
> > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > You'll need an image control and choose 'Database' as the
> > > > > > > > 'Source' and the appropriate column name as the 'Value'.
> > > > > > > > Also select the appropriate MIME type.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > >
> > > > > > > > > Sapnil
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||What exactly do you get in your image control, have you tried deploying
it? The VS Preview renderer is not the same as the RM renderer.
Maybe you could look at the code around the image control in the sample
report and that on your report for some clues.
Regards
Chris
Sapnil wrote:
> I am using SP2
>
> "Chris McGuigan" wrote:
> > Hi Sapnil,
> > I'm a bit stumped I'm afraid. What exactly are you getting?
> >
> > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > last February and have had little need to revert back since.
> > That's not to say that there are things Crystal doesn't do better
> > than RS, but for my environment, RS has many more advantages. I'm
> > playing with RS2005 now (due to be "launched" early November) and
> > it's looking good with ReportBuilder filling many of the RS's
> > shortcomings against Crystal. This is a bit off topic now but if
> > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > on the pro's and con's of various reporting tools.
> >
> > Obviously this image issue is a problem for you! Are you using SP1
> > or SP2?
> >
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I have tried all MIME types.
> > > And you are right, its working with crystal reports.
> > > Actually I am in the process of evaluating repoting tools.
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > I've never actually used Blob fields. So I'm going by the book
> > > > rather than experience! Have you tried all the different MIME
> > > > types against your data? Are you 100% sure your fields contain
> > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > had it working in Crystal, but it's worth a check!
> > > >
> > > > Regards
> > > > Chris
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > Chirs,
> > > > > I have tried the sample product catalog sample report and it
> > > > > works for me too. But If I am not wrong the images stored in
> > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > the Northwind database, trying to display the employees on
> > > > > the report, but there seems to be some problem.
> > > > >
> > > > > Sapnil
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > Sapnil,
> > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > uses this feature and works. It shows an image for each
> > > > > > stock item and the image is taken directly from the
> > > > > > database. I suspect you've a setting wrong.
> > > > > >
> > > > > > I suggest you load and take a look at this sample report.
> > > > > > Look up sample reports in BOL for details.
> > > > > >
> > > > > > In the sample the image is inside a rectangle, which may
> > > > > > confuse you when trying to select it. In the properties
> > > > > > pane, in the drop-down list of property names select
> > > > > > ProdPhoto.
> > > > > >
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > it worked.
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > or some other direct path are expression to the path.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Chris McGuigan wrote:
> > > > > > > >
> > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > Hi,
> > > > > > > > > >
> > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > >
> > > > > > > > > > Sapnil
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||The images are not displayed on the report, instead I get X marks on the
report.
I checked the RDL for the reports and there is no difference
Pretty strange
"Chris McGuigan" wrote:
> What exactly do you get in your image control, have you tried deploying
> it? The VS Preview renderer is not the same as the RM renderer.
> Maybe you could look at the code around the image control in the sample
> report and that on your report for some clues.
> Regards
> Chris
>
> Sapnil wrote:
> > I am using SP2
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > Hi Sapnil,
> > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > >
> > > In terms of evaluation, I'm an ex-Crystal user who switched to RS
> > > last February and have had little need to revert back since.
> > > That's not to say that there are things Crystal doesn't do better
> > > than RS, but for my environment, RS has many more advantages. I'm
> > > playing with RS2005 now (due to be "launched" early November) and
> > > it's looking good with ReportBuilder filling many of the RS's
> > > shortcomings against Crystal. This is a bit off topic now but if
> > > you trawl this newsgroup you'll see plenty of worthwhile exchanges
> > > on the pro's and con's of various reporting tools.
> > >
> > > Obviously this image issue is a problem for you! Are you using SP1
> > > or SP2?
> > >
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I have tried all MIME types.
> > > > And you are right, its working with crystal reports.
> > > > Actually I am in the process of evaluating repoting tools.
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > I've never actually used Blob fields. So I'm going by the book
> > > > > rather than experience! Have you tried all the different MIME
> > > > > types against your data? Are you 100% sure your fields contain
> > > > > bitmaps and not gifs or jpegs? I guess you are because you've
> > > > > had it working in Crystal, but it's worth a check!
> > > > >
> > > > > Regards
> > > > > Chris
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > Chirs,
> > > > > > I have tried the sample product catalog sample report and it
> > > > > > works for me too. But If I am not wrong the images stored in
> > > > > > the BLOB fieds are of type GIF I tried the same thing with
> > > > > > the Northwind database, trying to display the employees on
> > > > > > the report, but there seems to be some problem.
> > > > > >
> > > > > > Sapnil
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > Sapnil,
> > > > > > > I've just checked the Sample Report, Product Catalogue. This
> > > > > > > uses this feature and works. It shows an image for each
> > > > > > > stock item and the image is taken directly from the
> > > > > > > database. I suspect you've a setting wrong.
> > > > > > >
> > > > > > > I suggest you load and take a look at this sample report.
> > > > > > > Look up sample reports in BOL for details.
> > > > > > >
> > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > confuse you when trying to select it. In the properties
> > > > > > > pane, in the drop-down list of property names select
> > > > > > > ProdPhoto.
> > > > > > >
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > I tried as you said. But the BMP imgaes are not displayed
> > > > > > > > in the report. I tried the same with crystal reports and
> > > > > > > > it worked.
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > assume you mean bitmaps stored in the database as BLOB
> > > > > > > > > fields? If you mean external files then again yes it
> > > > > > > > > can, either using a field containing the url/unc path
> > > > > > > > > or some other direct path are expression to the path.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Chris McGuigan wrote:
> > > > > > > > >
> > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > You'll need an image control and choose 'Database' as
> > > > > > > > > > the 'Source' and the appropriate column name as the
> > > > > > > > > > 'Value'. Also select the appropriate MIME type.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > > Sapnil wrote:
> > > > > > > > > >
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > Does Sql reporting services support Bmp BLOB files?
> > > > > > > > > > >
> > > > > > > > > > > Sapnil
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>|||The only thing that comes to mind is some minor difference in the way
the bitmap is stored in the DB compared to what Microsoft expects.
It may be worth raising a support incident with Microsoft if you have
an MSDN subscription. It would be a shame for you to decide not to use
RS because of this one glitch. In an enterpirise environment RS is far
better than Crystal, in my view, not to mention a whole lot cheaper if
you already use MS SQL Server.
Chris
Sapnil wrote:
> The images are not displayed on the report, instead I get X marks on
> the report.
> I checked the RDL for the reports and there is no difference
> Pretty strange
> "Chris McGuigan" wrote:
> > What exactly do you get in your image control, have you tried
> > deploying it? The VS Preview renderer is not the same as the RM
> > renderer.
> >
> > Maybe you could look at the code around the image control in the
> > sample report and that on your report for some clues.
> >
> > Regards
> > Chris
> >
> >
> >
> > Sapnil wrote:
> >
> > > I am using SP2
> > >
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > Hi Sapnil,
> > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > >
> > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > RS last February and have had little need to revert back since.
> > > > That's not to say that there are things Crystal doesn't do
> > > > better than RS, but for my environment, RS has many more
> > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > early November) and it's looking good with ReportBuilder
> > > > filling many of the RS's shortcomings against Crystal. This is
> > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > various reporting tools.
> > > >
> > > > Obviously this image issue is a problem for you! Are you using
> > > > SP1 or SP2?
> > > >
> > > > Chris
> > > >
> > > >
> > > >
> > > > Sapnil wrote:
> > > >
> > > > > I have tried all MIME types.
> > > > > And you are right, its working with crystal reports.
> > > > > Actually I am in the process of evaluating repoting tools.
> > > > >
> > > > > "Chris McGuigan" wrote:
> > > > >
> > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > book rather than experience! Have you tried all the
> > > > > > different MIME types against your data? Are you 100% sure
> > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > you are because you've had it working in Crystal, but it's
> > > > > > worth a check!
> > > > > >
> > > > > > Regards
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > > Sapnil wrote:
> > > > > >
> > > > > > > Chirs,
> > > > > > > I have tried the sample product catalog sample report and
> > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > thing with the Northwind database, trying to display the
> > > > > > > employees on the report, but there seems to be some
> > > > > > > problem.
> > > > > > >
> > > > > > > Sapnil
> > > > > > >
> > > > > > > "Chris McGuigan" wrote:
> > > > > > >
> > > > > > > > Sapnil,
> > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > >
> > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > >
> > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > ProdPhoto.
> > > > > > > >
> > > > > > > > Chris
> > > > > > > >
> > > > > > > >
> > > > > > > > Sapnil wrote:
> > > > > > > >
> > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > crystal reports and it worked.
> > > > > > > > >
> > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > >
> > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > expression to the path.
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > >
> > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Hi,
> > > > > > > > > > > >
> > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > files?
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi Chris,
Thankyou very much for you comments
Sapnil
"Chris McGuigan" wrote:
> The only thing that comes to mind is some minor difference in the way
> the bitmap is stored in the DB compared to what Microsoft expects.
> It may be worth raising a support incident with Microsoft if you have
> an MSDN subscription. It would be a shame for you to decide not to use
> RS because of this one glitch. In an enterpirise environment RS is far
> better than Crystal, in my view, not to mention a whole lot cheaper if
> you already use MS SQL Server.
> Chris
>
> Sapnil wrote:
> > The images are not displayed on the report, instead I get X marks on
> > the report.
> > I checked the RDL for the reports and there is no difference
> > Pretty strange
> >
> > "Chris McGuigan" wrote:
> >
> > > What exactly do you get in your image control, have you tried
> > > deploying it? The VS Preview renderer is not the same as the RM
> > > renderer.
> > >
> > > Maybe you could look at the code around the image control in the
> > > sample report and that on your report for some clues.
> > >
> > > Regards
> > > Chris
> > >
> > >
> > >
> > > Sapnil wrote:
> > >
> > > > I am using SP2
> > > >
> > > >
> > > > "Chris McGuigan" wrote:
> > > >
> > > > > Hi Sapnil,
> > > > > I'm a bit stumped I'm afraid. What exactly are you getting?
> > > > >
> > > > > In terms of evaluation, I'm an ex-Crystal user who switched to
> > > > > RS last February and have had little need to revert back since.
> > > > > That's not to say that there are things Crystal doesn't do
> > > > > better than RS, but for my environment, RS has many more
> > > > > advantages. I'm playing with RS2005 now (due to be "launched"
> > > > > early November) and it's looking good with ReportBuilder
> > > > > filling many of the RS's shortcomings against Crystal. This is
> > > > > a bit off topic now but if you trawl this newsgroup you'll see
> > > > > plenty of worthwhile exchanges on the pro's and con's of
> > > > > various reporting tools.
> > > > >
> > > > > Obviously this image issue is a problem for you! Are you using
> > > > > SP1 or SP2?
> > > > >
> > > > > Chris
> > > > >
> > > > >
> > > > >
> > > > > Sapnil wrote:
> > > > >
> > > > > > I have tried all MIME types.
> > > > > > And you are right, its working with crystal reports.
> > > > > > Actually I am in the process of evaluating repoting tools.
> > > > > >
> > > > > > "Chris McGuigan" wrote:
> > > > > >
> > > > > > > It's MIME type is set to image/bmp, so I assume it's bmp!
> > > > > > > I've never actually used Blob fields. So I'm going by the
> > > > > > > book rather than experience! Have you tried all the
> > > > > > > different MIME types against your data? Are you 100% sure
> > > > > > > your fields contain bitmaps and not gifs or jpegs? I guess
> > > > > > > you are because you've had it working in Crystal, but it's
> > > > > > > worth a check!
> > > > > > >
> > > > > > > Regards
> > > > > > > Chris
> > > > > > >
> > > > > > >
> > > > > > > Sapnil wrote:
> > > > > > >
> > > > > > > > Chirs,
> > > > > > > > I have tried the sample product catalog sample report and
> > > > > > > > it works for me too. But If I am not wrong the images
> > > > > > > > stored in the BLOB fieds are of type GIF I tried the same
> > > > > > > > thing with the Northwind database, trying to display the
> > > > > > > > employees on the report, but there seems to be some
> > > > > > > > problem.
> > > > > > > >
> > > > > > > > Sapnil
> > > > > > > >
> > > > > > > > "Chris McGuigan" wrote:
> > > > > > > >
> > > > > > > > > Sapnil,
> > > > > > > > > I've just checked the Sample Report, Product Catalogue.
> > > > > > > > > This uses this feature and works. It shows an image for
> > > > > > > > > each stock item and the image is taken directly from the
> > > > > > > > > database. I suspect you've a setting wrong.
> > > > > > > > >
> > > > > > > > > I suggest you load and take a look at this sample
> > > > > > > > > report. Look up sample reports in BOL for details.
> > > > > > > > >
> > > > > > > > > In the sample the image is inside a rectangle, which may
> > > > > > > > > confuse you when trying to select it. In the properties
> > > > > > > > > pane, in the drop-down list of property names select
> > > > > > > > > ProdPhoto.
> > > > > > > > >
> > > > > > > > > Chris
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Sapnil wrote:
> > > > > > > > >
> > > > > > > > > > I tried as you said. But the BMP imgaes are not
> > > > > > > > > > displayed in the report. I tried the same with
> > > > > > > > > > crystal reports and it worked.
> > > > > > > > > >
> > > > > > > > > > "Chris McGuigan" wrote:
> > > > > > > > > >
> > > > > > > > > > > Having re-read your post, I should clarify that I
> > > > > > > > > > > assume you mean bitmaps stored in the database as
> > > > > > > > > > > BLOB fields? If you mean external files then again
> > > > > > > > > > > yes it can, either using a field containing the
> > > > > > > > > > > url/unc path or some other direct path are
> > > > > > > > > > > expression to the path.
> > > > > > > > > > >
> > > > > > > > > > > Chris
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Chris McGuigan wrote:
> > > > > > > > > > >
> > > > > > > > > > > > Sapnil, I believe the answer is yes.
> > > > > > > > > > > > You'll need an image control and choose
> > > > > > > > > > > > 'Database' as the 'Source' and the appropriate
> > > > > > > > > > > > column name as the 'Value'. Also select the
> > > > > > > > > > > > appropriate MIME type.
> > > > > > > > > > > >
> > > > > > > > > > > > Chris
> > > > > > > > > > > >
> > > > > > > > > > > > Sapnil wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > > Hi,
> > > > > > > > > > > > >
> > > > > > > > > > > > > Does Sql reporting services support Bmp BLOB
> > > > > > > > > > > > > files?
> > > > > > > > > > > > >
> > > > > > > > > > > > > Sapnil
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>

Blue Screen of Death (BSOD) when printing

We have been using SQL 2005 reporting services for a while but recently when
some one tries to print a report they will get a BSOD and the machine reboots.
Any Ideas'?We are also having the same problem when printing, blue screen with error
message 0X80070709.
"Eric Wainz" wrote:
> We have been using SQL 2005 reporting services for a while but recently when
> some one tries to print a report they will get a BSOD and the machine reboots.
> Any Ideas'?
>|||On Apr 10, 1:00 pm, rcruz03 <bobby.c...@.Early-Warning.com> wrote:
> We are also having the same problem when printing, blue screen with error
> message 0X80070709.
> "Eric Wainz" wrote:
> > We have been using SQL 2005 reporting services for a while but recently when
> > some one tries to print a report they will get a BSOD and the machine reboots.
> > Any Ideas'?
It sounds kind of like a printer driver issue. Does this occur when
exporting to any SSRS supported format (Excel, PDF, CSV, Web Archive,
etc) and then printing?
Enrique Martinez
Sr. Software Consultant|||No, It does not happen when you export the report.
But, We have been able to narrow it down to PCL6 print drivers.
"EMartinez" wrote:
> On Apr 10, 1:00 pm, rcruz03 <bobby.c...@.Early-Warning.com> wrote:
> > We are also having the same problem when printing, blue screen with error
> > message 0X80070709.
> >
> > "Eric Wainz" wrote:
> > > We have been using SQL 2005 reporting services for a while but recently when
> > > some one tries to print a report they will get a BSOD and the machine reboots.
> >
> > > Any Ideas'?
>
> It sounds kind of like a printer driver issue. Does this occur when
> exporting to any SSRS supported format (Excel, PDF, CSV, Web Archive,
> etc) and then printing?
> Enrique Martinez
> Sr. Software Consultant
>|||It isn't a printer driver issue, it is the ActiveX control RSClientPrint
Class that is causing the problem. It seems to be happening after a recent
Windows Update, but I have not attributed it to any particular one. Go to
C:\windows\downloaded program files and delete the RSClientPrint Class and
run your report again. It should prompt you to download the control again
and printing should resume after that.
Wish I could flag this so MS could figure out why it is happening. It has
happened to two of my users and I am sure there will be more to follow.
"Eric Wainz" <EricWainz@.discussions.microsoft.com> wrote in message
news:29A2AC00-2BDF-4052-AB0E-83D9C576EFC0@.microsoft.com...
> No, It does not happen when you export the report.
> But, We have been able to narrow it down to PCL6 print drivers.
> "EMartinez" wrote:
>> On Apr 10, 1:00 pm, rcruz03 <bobby.c...@.Early-Warning.com> wrote:
>> > We are also having the same problem when printing, blue screen with
>> > error
>> > message 0X80070709.
>> >
>> > "Eric Wainz" wrote:
>> > > We have been using SQL 2005 reporting services for a while but
>> > > recently when
>> > > some one tries to print a report they will get a BSOD and the machine
>> > > reboots.
>> >
>> > > Any Ideas'?
>>
>> It sounds kind of like a printer driver issue. Does this occur when
>> exporting to any SSRS supported format (Excel, PDF, CSV, Web Archive,
>> etc) and then printing?
>> Enrique Martinez
>> Sr. Software Consultant
>>|||I did that and still is rebooting.
"Rockn" wrote:
> It isn't a printer driver issue, it is the ActiveX control RSClientPrint
> Class that is causing the problem. It seems to be happening after a recent
> Windows Update, but I have not attributed it to any particular one. Go to
> C:\windows\downloaded program files and delete the RSClientPrint Class and
> run your report again. It should prompt you to download the control again
> and printing should resume after that.
> Wish I could flag this so MS could figure out why it is happening. It has
> happened to two of my users and I am sure there will be more to follow.
>
> "Eric Wainz" <EricWainz@.discussions.microsoft.com> wrote in message
> news:29A2AC00-2BDF-4052-AB0E-83D9C576EFC0@.microsoft.com...
> > No, It does not happen when you export the report.
> >
> > But, We have been able to narrow it down to PCL6 print drivers.
> >
> > "EMartinez" wrote:
> >
> >> On Apr 10, 1:00 pm, rcruz03 <bobby.c...@.Early-Warning.com> wrote:
> >> > We are also having the same problem when printing, blue screen with
> >> > error
> >> > message 0X80070709.
> >> >
> >> > "Eric Wainz" wrote:
> >> > > We have been using SQL 2005 reporting services for a while but
> >> > > recently when
> >> > > some one tries to print a report they will get a BSOD and the machine
> >> > > reboots.
> >> >
> >> > > Any Ideas'?
> >>
> >>
> >> It sounds kind of like a printer driver issue. Does this occur when
> >> exporting to any SSRS supported format (Excel, PDF, CSV, Web Archive,
> >> etc) and then printing?
> >>
> >> Enrique Martinez
> >> Sr. Software Consultant
> >>
> >>
>
>|||I am almost positive it is not a printer problem and I can almost bet the
problem started after a recent Windows Update. I tried my solution on one
person in the office and it seemed to fix it. I tried it on another
computer, but I wasn't logged on under his user account and it BSOD'd and
restarted.
"Eric Wainz" <EricWainz@.discussions.microsoft.com> wrote in message
news:3CEBEA69-C6F9-4B28-BE47-C8CF01A76118@.microsoft.com...
> I did that and still is rebooting.
> "Rockn" wrote:
> > It isn't a printer driver issue, it is the ActiveX control RSClientPrint
> > Class that is causing the problem. It seems to be happening after a
recent
> > Windows Update, but I have not attributed it to any particular one. Go
to
> > C:\windows\downloaded program files and delete the RSClientPrint Class
and
> > run your report again. It should prompt you to download the control
again
> > and printing should resume after that.
> >
> > Wish I could flag this so MS could figure out why it is happening. It
has
> > happened to two of my users and I am sure there will be more to follow.
> >
> >
> > "Eric Wainz" <EricWainz@.discussions.microsoft.com> wrote in message
> > news:29A2AC00-2BDF-4052-AB0E-83D9C576EFC0@.microsoft.com...
> > > No, It does not happen when you export the report.
> > >
> > > But, We have been able to narrow it down to PCL6 print drivers.
> > >
> > > "EMartinez" wrote:
> > >
> > >> On Apr 10, 1:00 pm, rcruz03 <bobby.c...@.Early-Warning.com> wrote:
> > >> > We are also having the same problem when printing, blue screen with
> > >> > error
> > >> > message 0X80070709.
> > >> >
> > >> > "Eric Wainz" wrote:
> > >> > > We have been using SQL 2005 reporting services for a while but
> > >> > > recently when
> > >> > > some one tries to print a report they will get a BSOD and the
machine
> > >> > > reboots.
> > >> >
> > >> > > Any Ideas'?
> > >>
> > >>
> > >> It sounds kind of like a printer driver issue. Does this occur when
> > >> exporting to any SSRS supported format (Excel, PDF, CSV, Web Archive,
> > >> etc) and then printing?
> > >>
> > >> Enrique Martinez
> > >> Sr. Software Consultant
> > >>
> > >>
> >
> >
> >|||What programs are installed on the computer getting the BSOD? Acrobat Pro,
IM? Others?
"Rockn" <Rockn@.newsgroups.nospam> wrote in message
news:eAXDzH8eHHA.4188@.TK2MSFTNGP02.phx.gbl...
>I am almost positive it is not a printer problem and I can almost bet the
> problem started after a recent Windows Update. I tried my solution on one
> person in the office and it seemed to fix it. I tried it on another
> computer, but I wasn't logged on under his user account and it BSOD'd and
> restarted.
>
> "Eric Wainz" <EricWainz@.discussions.microsoft.com> wrote in message
> news:3CEBEA69-C6F9-4B28-BE47-C8CF01A76118@.microsoft.com...
>> I did that and still is rebooting.
>> "Rockn" wrote:
>> > It isn't a printer driver issue, it is the ActiveX control
>> > RSClientPrint
>> > Class that is causing the problem. It seems to be happening after a
> recent
>> > Windows Update, but I have not attributed it to any particular one. Go
> to
>> > C:\windows\downloaded program files and delete the RSClientPrint Class
> and
>> > run your report again. It should prompt you to download the control
> again
>> > and printing should resume after that.
>> >
>> > Wish I could flag this so MS could figure out why it is happening. It
> has
>> > happened to two of my users and I am sure there will be more to follow.
>> >
>> >
>> > "Eric Wainz" <EricWainz@.discussions.microsoft.com> wrote in message
>> > news:29A2AC00-2BDF-4052-AB0E-83D9C576EFC0@.microsoft.com...
>> > > No, It does not happen when you export the report.
>> > >
>> > > But, We have been able to narrow it down to PCL6 print drivers.
>> > >
>> > > "EMartinez" wrote:
>> > >
>> > >> On Apr 10, 1:00 pm, rcruz03 <bobby.c...@.Early-Warning.com> wrote:
>> > >> > We are also having the same problem when printing, blue screen
>> > >> > with
>> > >> > error
>> > >> > message 0X80070709.
>> > >> >
>> > >> > "Eric Wainz" wrote:
>> > >> > > We have been using SQL 2005 reporting services for a while but
>> > >> > > recently when
>> > >> > > some one tries to print a report they will get a BSOD and the
> machine
>> > >> > > reboots.
>> > >> >
>> > >> > > Any Ideas'?
>> > >>
>> > >>
>> > >> It sounds kind of like a printer driver issue. Does this occur when
>> > >> exporting to any SSRS supported format (Excel, PDF, CSV, Web
>> > >> Archive,
>> > >> etc) and then printing?
>> > >>
>> > >> Enrique Martinez
>> > >> Sr. Software Consultant
>> > >>
>> > >>
>> >
>> >
>> >
>|||We are getting the same problem!
Just started happening a few days ago.
"Eric Wainz" wrote:
> We have been using SQL 2005 reporting services for a while but recently when
> some one tries to print a report they will get a BSOD and the machine reboots.
> Any Ideas'?
>|||I'm having the same issue with RS 2000. Microsoft, we need a hotfix...
"Eric Wainz" wrote:
> We have been using SQL 2005 reporting services for a while but recently when
> some one tries to print a report they will get a BSOD and the machine reboots.
> Any Ideas'?
>|||I fixed one of the computers using System Restore to a date before the
errors and it took care of his. I haven't narrowed it down yet, but I have
also tried removing all Windows updates for today and it still didn't fix
another users issue. I'll keep plugging away at it.
"ana9" <ana9@.discussions.microsoft.com> wrote in message
news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
> I'm having the same issue with RS 2000. Microsoft, we need a hotfix...
> "Eric Wainz" wrote:
>> We have been using SQL 2005 reporting services for a while but recently
>> when
>> some one tries to print a report they will get a BSOD and the machine
>> reboots.
>> Any Ideas'?|||I rolled back the security updates and re-installed the active x driver to no
avail. All the printers use the PCL6 driver but crashes only occur when
trying to print to an HP4250...
"Rockn" wrote:
> I fixed one of the computers using System Restore to a date before the
> errors and it took care of his. I haven't narrowed it down yet, but I have
> also tried removing all Windows updates for today and it still didn't fix
> another users issue. I'll keep plugging away at it.
> "ana9" <ana9@.discussions.microsoft.com> wrote in message
> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
> > I'm having the same issue with RS 2000. Microsoft, we need a hotfix...
> >
> > "Eric Wainz" wrote:
> >
> >> We have been using SQL 2005 reporting services for a while but recently
> >> when
> >> some one tries to print a report they will get a BSOD and the machine
> >> reboots.
> >>
> >> Any Ideas'?
> >>
>
>|||Is that a PLC 5e driver or something else?
"ana9" <ana9@.discussions.microsoft.com> wrote in message
news:27CF0AFF-AC34-4E24-81B8-34C5D446BA1F@.microsoft.com...
>I rolled back the security updates and re-installed the active x driver to
>no
> avail. All the printers use the PCL6 driver but crashes only occur when
> trying to print to an HP4250...
>
> "Rockn" wrote:
>> I fixed one of the computers using System Restore to a date before the
>> errors and it took care of his. I haven't narrowed it down yet, but I
>> have
>> also tried removing all Windows updates for today and it still didn't fix
>> another users issue. I'll keep plugging away at it.
>> "ana9" <ana9@.discussions.microsoft.com> wrote in message
>> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
>> > I'm having the same issue with RS 2000. Microsoft, we need a hotfix...
>> >
>> > "Eric Wainz" wrote:
>> >
>> >> We have been using SQL 2005 reporting services for a while but
>> >> recently
>> >> when
>> >> some one tries to print a report they will get a BSOD and the machine
>> >> reboots.
>> >>
>> >> Any Ideas'?
>> >>
>>|||It appears to be a print driver issue due to some recent update. If you
change your print drivers to PCL 5e it won't crash any longer.
ana9 had the answer, but the reason is still not figured out.
"Rockn" <Rockn@.newsgroups.nospam> wrote in message
news:%23rNh2sQfHHA.284@.TK2MSFTNGP05.phx.gbl...
> Is that a PLC 5e driver or something else?
>
> "ana9" <ana9@.discussions.microsoft.com> wrote in message
> news:27CF0AFF-AC34-4E24-81B8-34C5D446BA1F@.microsoft.com...
>>I rolled back the security updates and re-installed the active x driver to
>>no
>> avail. All the printers use the PCL6 driver but crashes only occur when
>> trying to print to an HP4250...
>>
>> "Rockn" wrote:
>> I fixed one of the computers using System Restore to a date before the
>> errors and it took care of his. I haven't narrowed it down yet, but I
>> have
>> also tried removing all Windows updates for today and it still didn't
>> fix
>> another users issue. I'll keep plugging away at it.
>> "ana9" <ana9@.discussions.microsoft.com> wrote in message
>> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
>> > I'm having the same issue with RS 2000. Microsoft, we need a
>> > hotfix...
>> >
>> > "Eric Wainz" wrote:
>> >
>> >> We have been using SQL 2005 reporting services for a while but
>> >> recently
>> >> when
>> >> some one tries to print a report they will get a BSOD and the machine
>> >> reboots.
>> >>
>> >> Any Ideas'?
>> >>
>>
>|||It doesn't appear to be a general print driver issue. As I said, only the HP
4250's have this problem. Do you see this as well, or does it effect all
your printers regardless of manufacturer?
"Rockn" wrote:
> It appears to be a print driver issue due to some recent update. If you
> change your print drivers to PCL 5e it won't crash any longer.
> ana9 had the answer, but the reason is still not figured out.
> "Rockn" <Rockn@.newsgroups.nospam> wrote in message
> news:%23rNh2sQfHHA.284@.TK2MSFTNGP05.phx.gbl...
> > Is that a PLC 5e driver or something else?
> >
> >
> > "ana9" <ana9@.discussions.microsoft.com> wrote in message
> > news:27CF0AFF-AC34-4E24-81B8-34C5D446BA1F@.microsoft.com...
> >>I rolled back the security updates and re-installed the active x driver to
> >>no
> >> avail. All the printers use the PCL6 driver but crashes only occur when
> >> trying to print to an HP4250...
> >>
> >>
> >> "Rockn" wrote:
> >>
> >> I fixed one of the computers using System Restore to a date before the
> >> errors and it took care of his. I haven't narrowed it down yet, but I
> >> have
> >> also tried removing all Windows updates for today and it still didn't
> >> fix
> >> another users issue. I'll keep plugging away at it.
> >>
> >> "ana9" <ana9@.discussions.microsoft.com> wrote in message
> >> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
> >> > I'm having the same issue with RS 2000. Microsoft, we need a
> >> > hotfix...
> >> >
> >> > "Eric Wainz" wrote:
> >> >
> >> >> We have been using SQL 2005 reporting services for a while but
> >> >> recently
> >> >> when
> >> >> some one tries to print a report they will get a BSOD and the machine
> >> >> reboots.
> >> >>
> >> >> Any Ideas'?
> >> >>
> >>
> >>
> >>
> >
> >
>
>|||It only affects printers using the PCL 6 driver. If I print to any of the
others using a PCL 5e driver it works. All of our printers are HP.
"ana9" <ana9@.discussions.microsoft.com> wrote in message
news:7FEEEDFD-FBC1-45D8-915D-087F066D3108@.microsoft.com...
> It doesn't appear to be a general print driver issue. As I said, only the
HP
> 4250's have this problem. Do you see this as well, or does it effect all
> your printers regardless of manufacturer?
> "Rockn" wrote:
> > It appears to be a print driver issue due to some recent update. If you
> > change your print drivers to PCL 5e it won't crash any longer.
> > ana9 had the answer, but the reason is still not figured out.
> >
> > "Rockn" <Rockn@.newsgroups.nospam> wrote in message
> > news:%23rNh2sQfHHA.284@.TK2MSFTNGP05.phx.gbl...
> > > Is that a PLC 5e driver or something else?
> > >
> > >
> > > "ana9" <ana9@.discussions.microsoft.com> wrote in message
> > > news:27CF0AFF-AC34-4E24-81B8-34C5D446BA1F@.microsoft.com...
> > >>I rolled back the security updates and re-installed the active x
driver to
> > >>no
> > >> avail. All the printers use the PCL6 driver but crashes only occur
when
> > >> trying to print to an HP4250...
> > >>
> > >>
> > >> "Rockn" wrote:
> > >>
> > >> I fixed one of the computers using System Restore to a date before
the
> > >> errors and it took care of his. I haven't narrowed it down yet, but
I
> > >> have
> > >> also tried removing all Windows updates for today and it still
didn't
> > >> fix
> > >> another users issue. I'll keep plugging away at it.
> > >>
> > >> "ana9" <ana9@.discussions.microsoft.com> wrote in message
> > >> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
> > >> > I'm having the same issue with RS 2000. Microsoft, we need a
> > >> > hotfix...
> > >> >
> > >> > "Eric Wainz" wrote:
> > >> >
> > >> >> We have been using SQL 2005 reporting services for a while but
> > >> >> recently
> > >> >> when
> > >> >> some one tries to print a report they will get a BSOD and the
machine
> > >> >> reboots.
> > >> >>
> > >> >> Any Ideas'?
> > >> >>
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >|||Remove security patch KB925902 or MS07-017 related to GDI+. This was just
realeased. I understand a hot patch may be available as early as Monday.
As a pre-caution read why this security update was published before
removing. Might be more of a risk to remove that to have the end users export
to pdf then print which has been my work around.
John
"Rockn" wrote:
> It only affects printers using the PCL 6 driver. If I print to any of the
> others using a PCL 5e driver it works. All of our printers are HP.
> "ana9" <ana9@.discussions.microsoft.com> wrote in message
> news:7FEEEDFD-FBC1-45D8-915D-087F066D3108@.microsoft.com...
> > It doesn't appear to be a general print driver issue. As I said, only the
> HP
> > 4250's have this problem. Do you see this as well, or does it effect all
> > your printers regardless of manufacturer?
> >
> > "Rockn" wrote:
> >
> > > It appears to be a print driver issue due to some recent update. If you
> > > change your print drivers to PCL 5e it won't crash any longer.
> > > ana9 had the answer, but the reason is still not figured out.
> > >
> > > "Rockn" <Rockn@.newsgroups.nospam> wrote in message
> > > news:%23rNh2sQfHHA.284@.TK2MSFTNGP05.phx.gbl...
> > > > Is that a PLC 5e driver or something else?
> > > >
> > > >
> > > > "ana9" <ana9@.discussions.microsoft.com> wrote in message
> > > > news:27CF0AFF-AC34-4E24-81B8-34C5D446BA1F@.microsoft.com...
> > > >>I rolled back the security updates and re-installed the active x
> driver to
> > > >>no
> > > >> avail. All the printers use the PCL6 driver but crashes only occur
> when
> > > >> trying to print to an HP4250...
> > > >>
> > > >>
> > > >> "Rockn" wrote:
> > > >>
> > > >> I fixed one of the computers using System Restore to a date before
> the
> > > >> errors and it took care of his. I haven't narrowed it down yet, but
> I
> > > >> have
> > > >> also tried removing all Windows updates for today and it still
> didn't
> > > >> fix
> > > >> another users issue. I'll keep plugging away at it.
> > > >>
> > > >> "ana9" <ana9@.discussions.microsoft.com> wrote in message
> > > >> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
> > > >> > I'm having the same issue with RS 2000. Microsoft, we need a
> > > >> > hotfix...
> > > >> >
> > > >> > "Eric Wainz" wrote:
> > > >> >
> > > >> >> We have been using SQL 2005 reporting services for a while but
> > > >> >> recently
> > > >> >> when
> > > >> >> some one tries to print a report they will get a BSOD and the
> machine
> > > >> >> reboots.
> > > >> >>
> > > >> >> Any Ideas'?
> > > >> >>
> > > >>
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> > >
>
>|||That did the trick, you are the man!!
"John" <John@.discussions.microsoft.com> wrote in message
news:3B16020C-2B19-40F9-BF4D-811DC1995D95@.microsoft.com...
> Remove security patch KB925902 or MS07-017 related to GDI+. This was just
> realeased. I understand a hot patch may be available as early as Monday.
> As a pre-caution read why this security update was published before
> removing. Might be more of a risk to remove that to have the end users
> export
> to pdf then print which has been my work around.
> John
> "Rockn" wrote:
>> It only affects printers using the PCL 6 driver. If I print to any of the
>> others using a PCL 5e driver it works. All of our printers are HP.
>> "ana9" <ana9@.discussions.microsoft.com> wrote in message
>> news:7FEEEDFD-FBC1-45D8-915D-087F066D3108@.microsoft.com...
>> > It doesn't appear to be a general print driver issue. As I said, only
>> > the
>> HP
>> > 4250's have this problem. Do you see this as well, or does it effect
>> > all
>> > your printers regardless of manufacturer?
>> >
>> > "Rockn" wrote:
>> >
>> > > It appears to be a print driver issue due to some recent update. If
>> > > you
>> > > change your print drivers to PCL 5e it won't crash any longer.
>> > > ana9 had the answer, but the reason is still not figured out.
>> > >
>> > > "Rockn" <Rockn@.newsgroups.nospam> wrote in message
>> > > news:%23rNh2sQfHHA.284@.TK2MSFTNGP05.phx.gbl...
>> > > > Is that a PLC 5e driver or something else?
>> > > >
>> > > >
>> > > > "ana9" <ana9@.discussions.microsoft.com> wrote in message
>> > > > news:27CF0AFF-AC34-4E24-81B8-34C5D446BA1F@.microsoft.com...
>> > > >>I rolled back the security updates and re-installed the active x
>> driver to
>> > > >>no
>> > > >> avail. All the printers use the PCL6 driver but crashes only
>> > > >> occur
>> when
>> > > >> trying to print to an HP4250...
>> > > >>
>> > > >>
>> > > >> "Rockn" wrote:
>> > > >>
>> > > >> I fixed one of the computers using System Restore to a date
>> > > >> before
>> the
>> > > >> errors and it took care of his. I haven't narrowed it down yet,
>> > > >> but
>> I
>> > > >> have
>> > > >> also tried removing all Windows updates for today and it still
>> didn't
>> > > >> fix
>> > > >> another users issue. I'll keep plugging away at it.
>> > > >>
>> > > >> "ana9" <ana9@.discussions.microsoft.com> wrote in message
>> > > >> news:093ABBB0-B29D-47FD-82A5-3AD3FC109510@.microsoft.com...
>> > > >> > I'm having the same issue with RS 2000. Microsoft, we need a
>> > > >> > hotfix...
>> > > >> >
>> > > >> > "Eric Wainz" wrote:
>> > > >> >
>> > > >> >> We have been using SQL 2005 reporting services for a while but
>> > > >> >> recently
>> > > >> >> when
>> > > >> >> some one tries to print a report they will get a BSOD and the
>> machine
>> > > >> >> reboots.
>> > > >> >>
>> > > >> >> Any Ideas'?
>> > > >> >>
>> > > >>
>> > > >>
>> > > >>
>> > > >
>> > > >
>> > >
>> > >
>> > >
>>|||Please review this article http://support.microsoft.com/kb/935843/. It has two patches, one for Windows 2000 and another one for Windows XP. The crashing will stop after you apply this patch
From http://www.developmentnow.com/g/115_2007_4_0_0_955642/Blue-Screen-of-Death-BSOD-when-printing.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com