After Books Online, the Microsoft Knowledgebase should always be your next
stop for information:
"Description of the waittype and lastwaittype columns in the
master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005"
http://support.microsoft.com/?kbid=822101
HTH
Kalen Delaney, SQL Server MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OyW0FqPlGHA.3304@.TK2MSFTNGP03.phx.gbl...
> Where can I find more info about these waittypes such as 0x0081,etc. ? I
> want to know what they stand for
>Where can I find more info about these waittypes such as 0x0081,etc. ? I
want to know what they stand for|||After Books Online, the Microsoft Knowledgebase should always be your next
stop for information:
"Description of the waittype and lastwaittype columns in the
master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005"
http://support.microsoft.com/?kbid=822101
HTH
Kalen Delaney, SQL Server MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OyW0FqPlGHA.3304@.TK2MSFTNGP03.phx.gbl...
> Where can I find more info about these waittypes such as 0x0081,etc. ? I
> want to know what they stand for
>|||http://support.microsoft.com/kb/244455
-oj
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OyW0FqPlGHA.3304@.TK2MSFTNGP03.phx.gbl...
> Where can I find more info about these waittypes such as 0x0081,etc. ? I
> want to know what they stand for
>|||Here are the links from my favourites on the subject.
http://support.microsoft.com/kb/822101/
http://www.sqldev.net/articles/wait_types.htm
http://sqldev.net/misc/waittypes.htm
http://blogs.technet.com/mat_stephe.../25/359848.aspx
http://www.sqldev.net/misc/sp_waitstats.htm
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OyW0FqPlGHA.3304@.TK2MSFTNGP03.phx.gbl...
> Where can I find more info about these waittypes such as 0x0081,etc. ? I
> want to know what they stand for
>|||http://support.microsoft.com/kb/244455
-oj
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OyW0FqPlGHA.3304@.TK2MSFTNGP03.phx.gbl...
> Where can I find more info about these waittypes such as 0x0081,etc. ? I
> want to know what they stand for
>|||Here are the links from my favourites on the subject.
http://support.microsoft.com/kb/822101/
http://www.sqldev.net/articles/wait_types.htm
http://sqldev.net/misc/waittypes.htm
http://blogs.technet.com/mat_stephe.../25/359848.aspx
http://www.sqldev.net/misc/sp_waitstats.htm
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OyW0FqPlGHA.3304@.TK2MSFTNGP03.phx.gbl...
> Where can I find more info about these waittypes such as 0x0081,etc. ? I
> want to know what they stand for
>
Showing posts with label online. Show all posts
Showing posts with label online. Show all posts
Friday, March 9, 2012
Friday, February 24, 2012
different image source for online and PDF reports?
In my current job, I've inherited a website and some ReportViewer
reports, and I've figured out how to poke around and make some changes
requested by my employer, but there's still a lot that I don't
understand. Any input would be appreciated.
Here's the current problem: the reports that we make available on our
website are mostly made up of images. Up until now, we've been saving
the images at the size that they need to be when the reports are
viewed online at 100%. Of course, this means that when exporting the
report to PDF, or printing it, the quality is unacceptable. I've tried
saving larger images and scaling them proportionately in the reports,
which results in beautiful PDFs and illegible online reports due to
resampling. Naturally, and reasonably, my employer wants our reports
to look good online AND when they're printed. I've looked around
online and found that other people have wrestled with this problem,
with no clear solutions.
The one idea that I've come up with is to use different images for the
online and printed versions (so the online report would use /preview/
image01.png and the PDF would use /print/image01.png or something). Do
you think this is possible? Any idea where I would start?
Thanks in advance for any advice.
SarahOn Jun 4, 2:37 pm, "s. o." <sarah.oh.li...@.gmail.com> wrote:
> In my current job, I've inherited a website and some ReportViewer
> reports, and I've figured out how to poke around and make some changes
> requested by my employer, but there's still a lot that I don't
> understand. Any input would be appreciated.
> Here's the current problem: the reports that we make available on our
> website are mostly made up of images. Up until now, we've been saving
> the images at the size that they need to be when the reports are
> viewed online at 100%. Of course, this means that when exporting the
> report to PDF, or printing it, the quality is unacceptable. I've tried
> saving larger images and scaling them proportionately in the reports,
> which results in beautiful PDFs and illegible online reports due to
> resampling. Naturally, and reasonably, my employer wants our reports
> to look good online AND when they're printed. I've looked around
> online and found that other people have wrestled with this problem,
> with no clear solutions.
> The one idea that I've come up with is to use different images for the
> online and printed versions (so the online report would use /preview/
> image01.png and the PDF would use /print/image01.png or something). Do
> you think this is possible? Any idea where I would start?
> Thanks in advance for any advice.
> Sarah
That sounds like the best option. You should have one report that can
be viewed and then when the user goes to export it, change the report
behind the scenes in the application to point to the smaller imaged
report. This should be fairly straight forward in terms of pointing to
one report in a report viewer and then pointing to another report once
the user selects something like a print preview aspx page or
something. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
reports, and I've figured out how to poke around and make some changes
requested by my employer, but there's still a lot that I don't
understand. Any input would be appreciated.
Here's the current problem: the reports that we make available on our
website are mostly made up of images. Up until now, we've been saving
the images at the size that they need to be when the reports are
viewed online at 100%. Of course, this means that when exporting the
report to PDF, or printing it, the quality is unacceptable. I've tried
saving larger images and scaling them proportionately in the reports,
which results in beautiful PDFs and illegible online reports due to
resampling. Naturally, and reasonably, my employer wants our reports
to look good online AND when they're printed. I've looked around
online and found that other people have wrestled with this problem,
with no clear solutions.
The one idea that I've come up with is to use different images for the
online and printed versions (so the online report would use /preview/
image01.png and the PDF would use /print/image01.png or something). Do
you think this is possible? Any idea where I would start?
Thanks in advance for any advice.
SarahOn Jun 4, 2:37 pm, "s. o." <sarah.oh.li...@.gmail.com> wrote:
> In my current job, I've inherited a website and some ReportViewer
> reports, and I've figured out how to poke around and make some changes
> requested by my employer, but there's still a lot that I don't
> understand. Any input would be appreciated.
> Here's the current problem: the reports that we make available on our
> website are mostly made up of images. Up until now, we've been saving
> the images at the size that they need to be when the reports are
> viewed online at 100%. Of course, this means that when exporting the
> report to PDF, or printing it, the quality is unacceptable. I've tried
> saving larger images and scaling them proportionately in the reports,
> which results in beautiful PDFs and illegible online reports due to
> resampling. Naturally, and reasonably, my employer wants our reports
> to look good online AND when they're printed. I've looked around
> online and found that other people have wrestled with this problem,
> with no clear solutions.
> The one idea that I've come up with is to use different images for the
> online and printed versions (so the online report would use /preview/
> image01.png and the PDF would use /print/image01.png or something). Do
> you think this is possible? Any idea where I would start?
> Thanks in advance for any advice.
> Sarah
That sounds like the best option. You should have one report that can
be viewed and then when the user goes to export it, change the report
behind the scenes in the application to point to the smaller imaged
report. This should be fairly straight forward in terms of pointing to
one report in a report viewer and then pointing to another report once
the user selects something like a print preview aspx page or
something. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Tuesday, February 14, 2012
Differences between subscription types - help needed
I'm attempting to learn about Data Driven Subscriptions via Books
Online, particularly this tutorial:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx, with no luck
thus far.
I have created essentially the same subscription as a non-data driven
one, and this successfully creates the file (rather than the email
mentioned in the tutorial). What could cause a data-driven subscription
not to work when an almost identical regular subscription does work? I
have tried both methods multiple times, with the same results.
Thanks in advance.This problem has been resolved. The local copy of that tutorial is
outdated, with the new version online. It makes values for a few fields
more explicit, and explores writing to a fileshare rather than to
email.
Online, particularly this tutorial:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx, with no luck
thus far.
I have created essentially the same subscription as a non-data driven
one, and this successfully creates the file (rather than the email
mentioned in the tutorial). What could cause a data-driven subscription
not to work when an almost identical regular subscription does work? I
have tried both methods multiple times, with the same results.
Thanks in advance.This problem has been resolved. The local copy of that tutorial is
outdated, with the new version online. It makes values for a few fields
more explicit, and explores writing to a fileshare rather than to
email.
Subscribe to:
Posts (Atom)