Passing result sets: html

Showing posts with label html. Show all posts

Friday, March 30, 2012

Peer to Peer question.

BOL link:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/23e7e8c1-002f-4e69-8c99-d63e4100de64.htm
Howdy all. I was just reading up on this topic and have a question. It says
on this page (Topology with two participating databases) that reads will be
spread out between the two servers, thereby giving better performance. But it
doesnt say how that is accomplished. Does the app have to be designed a
specific way, like it would be if updates were going to go between the two
boxes in the same scenario?
TIA, ChrisR
Hi Chris - I would guess that they are talking about a load-balancing
middle-tier solution, but I can't see the exact link here. Can you post up
the topic header and I'll check out the page on the web.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||It's scale out read and write performance. Instead of having 100 users
banging away against one box you have two boxes and 50 of the 100 users
banging away against box 1 and the other 50 banging away against box 2. You
get improved performance because of reduced io contention, lock contention,
and improved concurrency.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:8EB2FFF2-B2A5-4F1A-A0AB-58552D3C212D@.microsoft.com...
> BOL link:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/23e7e8c1-002f-4e69-8c99-d63e4100de64.htm
> Howdy all. I was just reading up on this topic and have a question. It
> says
> on this page (Topology with two participating databases) that reads will
> be
> spread out between the two servers, thereby giving better performance. But
> it
> doesnt say how that is accomplished. Does the app have to be designed a
> specific way, like it would be if updates were going to go between the two
> boxes in the same scenario?
> TIA, ChrisR
>
|||I understand why you would want it to be spread out, but I don't understand
how it gets spread put. Does the app need to be written a certain way?
"Hilary Cotter" wrote:

> It's scale out read and write performance. Instead of having 100 users
> banging away against one box you have two boxes and 50 of the 100 users
> banging away against box 1 and the other 50 banging away against box 2. You
> get improved performance because of reduced io contention, lock contention,
> and improved concurrency.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:8EB2FFF2-B2A5-4F1A-A0AB-58552D3C212D@.microsoft.com...
>
>
|||replication [SQL Server], peer-to-peer replication/ Peer to Peer
Transactional Replication.
"Paul Ibison" wrote:

> Hi Chris - I would guess that they are talking about a load-balancing
> middle-tier solution, but I can't see the exact link here. Can you post up
> the topic header and I'll check out the page on the web.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>
|||DML which occurs on one server is sent to each node in the peer-to-peer
topology. Each command has an originating server tag on it so it does not
loop back.
The recommendations for writing a client app which uses the peer-to-peer
topology is that all updates are directed at one server to prevent
conflicts, the tables are perfectly partitioned to prevent conflicts and all
systems are quiesced when you make schema changes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:37CA311D-26D6-42A9-88B7-A1396C8CB730@.microsoft.com...[vbcol=seagreen]
>I understand why you would want it to be spread out, but I don't understand
> how it gets spread put. Does the app need to be written a certain way?
>
> "Hilary Cotter" wrote:
|||Thanks guys.
"ChrisR" wrote:

> BOL link:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/23e7e8c1-002f-4e69-8c99-d63e4100de64.htm
> Howdy all. I was just reading up on this topic and have a question. It says
> on this page (Topology with two participating databases) that reads will be
> spread out between the two servers, thereby giving better performance. But it
> doesnt say how that is accomplished. Does the app have to be designed a
> specific way, like it would be if updates were going to go between the two
> boxes in the same scenario?
> TIA, ChrisR
>

Wednesday, March 28, 2012

PDF rendering bug in SP2

We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error:

An error occurred during rendering of the report. (rrRenderingError)

An error occurred during rendering of the report.

Non-negative number required. Parameter name: value

The log gives the following traceback:

at Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
at Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
at Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!6!17/04/2007-10:27:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
aspnet_wp!library!5!17/04/2007-10:28:09:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!cache!5!17/04/2007-10:28:09:: i INFO: Session live: /EFaultReports/FaultReport
aspnet_wp!library!5!17/04/2007-10:28:23:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!reportrendering!5!17/04/2007-10:28:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. > System.ArgumentOutOfRangeException: Non-negative number required.
Parameter name: value
at System.IO.MemoryStream.set_Position(Int64 value)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.MonochromeJpeg(MemoryStream memStream)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImagePDF image, Double left, Double top, Double width, Double height, Boolean scaleImage)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Image.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableCell.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableRow.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render)
at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
End of inner exception stack trace
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!library!5!17/04/2007-10:28:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. (rrRenderingError) > Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. > Microsoft.Reporting.WebForms.ReportServerException: Non-negative number required.
Parameter name: value
End of inner exception stack trace
End of inner exception stack trace

We have got same problem and I have found that it happens with reports containing *.pjpeg images. Not all *.pjpeg gives this problem.

Please reply if anyone knows the fix. it is urgent

Thanks

Satjinder

sql

PDF rendering bug in SP2

We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error:

An error occurred during rendering of the report. (rrRenderingError)

An error occurred during rendering of the report.

Non-negative number required. Parameter name: value

The log gives the following traceback:

We have got same problem and I have found that it happens with reports containing *.pjpeg images. Not all *.pjpeg gives this problem.

Please reply if anyone knows the fix. it is urgent

Thanks

Satjinder

pdf instead of html as default output format

Hi all,
I would like to output all reports in pdf format instead of html.
I dont want to allow users to choose an export format.
So, if they access an URL and fill some textboxes with appropriated
parameters I can send them a ready-to-print PDF file in Internet Explorer.
Is it possible?
(I´m assuming all clients uses IE browser and Acrobat Reader plugin).
thanks a lot!One way you can do it is in the url of the report. You can add at the end of
your report url:
&rs:Command=Render&rs:format=pdf
Since it is in the url you have to be careful how you open it. I just open
the report in a new windows and it will actually render the report in the
adobe acrobat reader progam so there is no url the user can change. You
could embed it in an iframe on a page to display to a user as well.
"Ricardo" wrote:
> Hi all,
> I would like to output all reports in pdf format instead of html.
> I dont want to allow users to choose an export format.
> So, if they access an URL and fill some textboxes with appropriated
> parameters I can send them a ready-to-print PDF file in Internet Explorer.
> Is it possible?
> (IÂ´m assuming all clients uses IE browser and Acrobat Reader plugin).
> thanks a lot!
>
>

Monday, March 26, 2012

PDF Export Very SLOW ! MS Rerporting Services TEAM Where Are you ??

Hi,
I have a matrix report that produce 79 pages on the HTML browser in 30
seconds, but
if I try to export the report in a PDF format it take more than 1 our !!!
The system configuration is:
IBM Server with 2 Pentium Xeon of 2.4 Ghz
1 Gb of RAM
Fast network HD
Windows 2003 Server SP1 (SBS)
SQL Server 2000 SP4
Rerpoting Services SP2
Do you have any idea about this problem ?
I've saw there are some old messages about this problem on this newsgroup,
but nobody of the
Microsoft Rerpoting Service Team has reply !!!
I think this is a very important issue, that can KILL the reportin services
system on a
Serious Real World company application.
Thanks.
Cesar Augusto Flavio De Min.
MCSDEven 30 seconds for HTML is very slow. PDF definitely is much much slower.
Everything is done in RAM. 1 GB of RAM is pretty minimal. Is your data on
this server as well or just RS? Can you add more RAM to it. Perhaps bring it
up to 2 Gig. Also, an 80 page report while not huge is most likely taking
time due to complexity. You could try splitting it up into multiple reports.
I don't know if RS 2005 has improved performance of PDF rendering or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cesar Augusto Flavio De Min" <cdemin_news@.yahoo.com> wrote in message
news:emEEYAO7FHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a matrix report that produce 79 pages on the HTML browser in 30
> seconds, but
> if I try to export the report in a PDF format it take more than 1 our !!!
> The system configuration is:
> IBM Server with 2 Pentium Xeon of 2.4 Ghz
> 1 Gb of RAM
> Fast network HD
> Windows 2003 Server SP1 (SBS)
> SQL Server 2000 SP4
> Rerpoting Services SP2
> Do you have any idea about this problem ?
> I've saw there are some old messages about this problem on this newsgroup,
> but nobody of the
> Microsoft Rerpoting Service Team has reply !!!
> I think this is a very important issue, that can KILL the reportin
> services system on a
> Serious Real World company application.
> Thanks.
> Cesar Augusto Flavio De Min.
> MCSD
>

PDF export error

I've created a report and it works fine in html,
but when I export to PDF, I receive next error:
Reporting Services Error
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown
Index and length must refer to a location within the string.
Parameter name: length
Any suggestions please?
Regards,
Miguel.Check what the report language property is set to. If it's not a
language-country pair, you might run into this error. For instance, if you
choose "English", this error might occur. Change it to a language-country
pair (for example en-US).
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Miguel Esteban" <mestebanpt@.yahoo.es> wrote in message
news:eUEQ258cEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I've created a report and it works fine in html,
> but when I export to PDF, I receive next error:
> Reporting Services Error
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown
> Index and length must refer to a location within the string.
> Parameter name: length
>
> Any suggestions please?
> Regards,
> Miguel.
>

PDF export and invisible columns

I have a report with some columns that are visible\invisible based on a
parameter value. The report renders fine in HTML and when exported to Excel.
But when its exported to PDF the report shows blank white space for some of
the columns that are invisible, e.g. the report is 3 pages wide when the
collumns are all visible, it is 1 page wide when some are invisible, but if
you export the 1 page wide report to PDF it still comes out as 3 pages wide,
with the last 2 pages just alll blank space.
ANything I can do?Did you find any solutions? I had teh same problem.
I am setting the visibility for the Rows through the expression. They are
not showing in HTML mode. However, If I export to PDF it shows some white
spaces.
"NH" wrote:
> I have a report with some columns that are visible\invisible based on a
> parameter value. The report renders fine in HTML and when exported to Excel.
> But when its exported to PDF the report shows blank white space for some of
> the columns that are invisible, e.g. the report is 3 pages wide when the
> collumns are all visible, it is 1 page wide when some are invisible, but if
> you export the 1 page wide report to PDF it still comes out as 3 pages wide,
> with the last 2 pages just alll blank space.
> ANything I can do?|||Hi,
No, never found a solution. I am afraid that you dont get many replies to
your queries in this forum.
"GC" wrote:
> Did you find any solutions? I had teh same problem.
> I am setting the visibility for the Rows through the expression. They are
> not showing in HTML mode. However, If I export to PDF it shows some white
> spaces.
>
> "NH" wrote:
> > I have a report with some columns that are visible\invisible based on a
> > parameter value. The report renders fine in HTML and when exported to Excel.
> > But when its exported to PDF the report shows blank white space for some of
> > the columns that are invisible, e.g. the report is 3 pages wide when the
> > collumns are all visible, it is 1 page wide when some are invisible, but if
> > you export the 1 page wide report to PDF it still comes out as 3 pages wide,
> > with the last 2 pages just alll blank space.
> >
> > ANything I can do?|||I have experienced something like this before...the problem is that in
order to shrink up the hidden columns then you will need to set the
visibility property on each column, not just the tablerow. Very
tedious but I believe that this may be what your report needs...
Matt A|||i have a similar problem. html & xls work fine, but when you export to
csv, the columns are hidden no matter what you do...
reportdude wrote:
> I have experienced something like this before...the problem is that in
> order to shrink up the hidden columns then you will need to set the
> visibility property on each column, not just the tablerow. Very
> tedious but I believe that this may be what your report needs...
> Matt A|||Thanks for the Update. I have tried the option of applying the Expression for
the Visibiliy of every cell in that Row. Still it doesn't make any difference.
This is creating space at the end of the Report. ( I have few Sub Reports).
If I set the hidden false then the white spaces are disappearing. However
this works well in HTML Viewer.
"reportdude" wrote:
> I have experienced something like this before...the problem is that in
> order to shrink up the hidden columns then you will need to set the
> visibility property on each column, not just the tablerow. Very
> tedious but I believe that this may be what your report needs...
> Matt A
>

Friday, March 23, 2012

PDF and Merge Cell Border Style Issue

Problem: I have borders that are hidden (Border Style=None) that appear ok in HTML but when Render in PDF they appear when they should not. Basically I am using a few columns like TABS in one Major Column in my report in combination with Merge Cells.

In Sql2000 -> There is no problem in the HTML or PDF rendering.

In Sql2005SP1 -> The problem occurs in two forms:

a) Problem Only Shows up in the PDF Creation call in our ASPX in IIS

b) Problem occurs in both the ASPX call and the Reporting Services Report Upload (Export to PDF)

Is there a fix to this issue or work around?

Solution

1) Reset All Border Styles and Border Colors to Vanilla (I mean every cell)

2) Redo your Border Styles etc but be careful -> It kinda like chess

This is due to that Sql2000 and Sql2005 handles the narly RDL Rendering conflicts differently.

Monday, February 20, 2012

Passing result sets

Hi All
I have to create a very generic procedure that can accept 2 data sets.
These data sets will typically be:
1) Lines of HTML code saved into a table for frequent use but having
variable fields which have to be replaced with data depending on the request
made to the database
2) Variable name, variable data records to be used to replace the variables
in the first data set
e.g.
1) table1 (HTML varchar(8000))
rows:
<HTML>
<UL>
<LI>%%Fld1</LI>
<LI>%%Fld2</LI>...
2) table 2 (VarName varchar(100), VarValue varchar(2000))
rows:
VarName VarValue
%%Fld1 MyData1
%%Fld2 MyData2
Since it has to be generic and is going to be used by different systems on
dirrent server, etc, I would like to pass the entire data sets to my
procedure.
I would not prefer to use temporary or permanent tables as this would
possibly complicate the use of the procedure by multiple users at the same
time.
I also have to consider performance. I've written the basic parser code for
inside the procedure but need advice on how would be the best way of getting
the 2 data sets into the procedure.
Any advice would be greatly appreciated.Hi
You may want to consider using XML instead of HTML.
John
"Chan" wrote:

> Hi All
> I have to create a very generic procedure that can accept 2 data sets.
> These data sets will typically be:
> 1) Lines of HTML code saved into a table for frequent use but having
> variable fields which have to be replaced with data depending on the reque
st
> made to the database
> 2) Variable name, variable data records to be used to replace the variable
s
> in the first data set
> e.g.
> 1) table1 (HTML varchar(8000))
> rows:
> <HTML>
> <UL>
> <LI>%%Fld1</LI>
> <LI>%%Fld2</LI>...
>
> 2) table 2 (VarName varchar(100), VarValue varchar(2000))
> rows:
> VarName VarValue
> %%Fld1 MyData1
> %%Fld2 MyData2
> Since it has to be generic and is going to be used by different systems on
> dirrent server, etc, I would like to pass the entire data sets to my
> procedure.
> I would not prefer to use temporary or permanent tables as this would
> possibly complicate the use of the procedure by multiple users at the same
> time.
> I also have to consider performance. I've written the basic parser code f
or
> inside the procedure but need advice on how would be the best way of getti
ng
> the 2 data sets into the procedure.
> Any advice would be greatly appreciated.
>|||No go, unfortunately. There's a strict architecture in our environment
"John Bell" wrote:
> Hi
> You may want to consider using XML instead of HTML.
> John
> "Chan" wrote:
>|||Then you will probably have to resort to string manipulation. This may help
http://www.sommarskog.se/arrays-in-sql.html
John
"Chan" wrote:
> No go, unfortunately. There's a strict architecture in our environment
> "John Bell" wrote:
>

Friday, March 30, 2012

Peer to Peer question.

Wednesday, March 28, 2012

PDF rendering bug in SP2

PDF rendering bug in SP2

pdf instead of html as default output format

Monday, March 26, 2012

PDF Export Very SLOW ! MS Rerporting Services TEAM Where Are you ??

PDF export error

PDF export and invisible columns

Friday, March 23, 2012

PDF and Merge Cell Border Style Issue

Monday, February 20, 2012

Passing result sets

Passing result sets

Blog Archive

About Me