Showing posts with label html. Show all posts
Showing posts with label html. Show all posts

Friday, March 30, 2012

ReportViewer Control Internal Secrets

Hi,
unfortuntely, MS has changed the logic of their generated Report HTML
between RS 2000 and SSRS 2005 using the WEB RepotViewer control.
In RS 2005 the generated HTML
a) the values of parameter list are no longer the REAL report values -
now it's only the collection id
b) the name of the parameter control can't be identified anymore
because it shows someting like:
"ReportViewerControl_ctl01_ctl01_ctl01_ctl00" that was in RS 2000
always the name of the control - especially of the parameter values.
Now a few question regarding the RS 2005 Web ReportView internals,
perhaps somebody could answer:
1) Is there a possibilty during the runtime to lookup the parameter
controls ReportViewerControl_ctl01_ctl01_ctl01_ctl00 via webservices or
ReportingServices DB to find out what is the original name of the
control?
2) Is there a possibility during the runtime to lookup the collection
id values to find out the corresponding parameter values via
webservices or ReportingServices DB to find out what is the original
name of the control?
3) Is there the plan of MS to allow customizable parameterwith your own
ASP implementation with the next SP'
4) Has somebody experience/ idea how to extract the underlying SQL for
the report parameter or already an inplemenation of a dynamicly
generated Parameter screen only based on the RDL definition &
dependencies?
Thanks a lot
best regards
BBBruce, curious to know if you made any headway on your #2 problem?
As I understand, your trying to get the values that the dropdown list is
populated with.
The best I've come up with so far is to run your own dataset (ADO.NET) and
load the dataset into a combo box. Then pass the ddlist.selectedvalue to the
report parameter collection and send that along to the webservice when
rendering the report.
Let me know if you have more, I'm really trying to find way to build dynamic
webpages, based off the parameters of a particular report. Hence the user
selects a report from a dropdown, and the page (an aspx page) shows the
appropriate controls to satisfy the parameter requirements.
When a different with different set of parameters is selected the screen is
changed accordingly.
Thanks,
rwiethorn
"BB_Reporting" wrote:
> Hi,
> unfortuntely, MS has changed the logic of their generated Report HTML
> between RS 2000 and SSRS 2005 using the WEB RepotViewer control.
> In RS 2005 the generated HTML
> a) the values of parameter list are no longer the REAL report values -
> now it's only the collection id
> b) the name of the parameter control can't be identified anymore
> because it shows someting like:
> "ReportViewerControl_ctl01_ctl01_ctl01_ctl00" that was in RS 2000
> always the name of the control - especially of the parameter values.
> Now a few question regarding the RS 2005 Web ReportView internals,
> perhaps somebody could answer:
> 1) Is there a possibilty during the runtime to lookup the parameter
> controls ReportViewerControl_ctl01_ctl01_ctl01_ctl00 via webservices or
> ReportingServices DB to find out what is the original name of the
> control?
> 2) Is there a possibility during the runtime to lookup the collection
> id values to find out the corresponding parameter values via
> webservices or ReportingServices DB to find out what is the original
> name of the control?
> 3) Is there the plan of MS to allow customizable parameterwith your own
> ASP implementation with the next SP'
> 4) Has somebody experience/ idea how to extract the underlying SQL for
> the report parameter or already an inplemenation of a dynamicly
> generated Parameter screen only based on the RDL definition &
> dependencies?
> Thanks a lot
> best regards
> BB
>

Tuesday, March 20, 2012

Reports rendered bad in Firefox...

Because of some peculiar way of using CSS, the reports aren't rendered correctly in Firefox. I've tryed specifying different rendering options (html 4 for instance) but it didn't help. What are my options on this? I could use Webservices (SOAP) and wrap SSRS in a proxy, but I'd have to parse reports and extract the data and build my own presentation layer. This way I'd be missing half of the SSRS functionality. Any ideas?You also loose features in Firefox and besides the numerous display bugs, their is also a Session TimeOut bug. Essentially SQL reports is IE only.

http://msdn2.microsoft.com/en-us/library/ms156511.aspx

The following features are not supported in third-party browsers:

Document map
|||
Indeed. We have now ditched Ms Server completely and looking for alternatives. Too hard to integrate with anything.

Friday, March 9, 2012

ReportRenderingException when exporting to excel

Hi all
I have a report that works fine for html and pdf rendering. But when I
export it to excel RS throws a ReportRenderingException. The error is "Stack
empty". Anything else like PDF, TIFF... is rendering without errors. Does
anyone has similar problems or knows whats wrong? Can this be a bug?
Here's an extraction of the log file:
w3wp!library!ed8!12/07/2004-17:03:20:: i INFO: Call to RenderNext(
'/Astrada/Ferienuebersicht' )
w3wp!chunks!ed8!12/07/2004-17:03:20:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=cdb86ab2-85ce-41b8-9edc-3faffec8410b
w3wp!reportrendering!ed8!12/07/2004-17:03:24:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.InvalidOperationException: Stack empty.
at System.Collections.Stack.Pop()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.GetPostFixNotation(String[] tokens, ArrayList finalExpr)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.ProcessFormula(String formula, ArrayList& postFixList, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateExcelFormula(IReportItemInfo
reportItemInfo, String outputTypeCode, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(ReportItemInfo
reportItemInfo, PageCell pageCell, PageTableGrid pageTableGrid, Hashtable&
duplicateItemsTable, Int32 row, Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!ed8!12/07/2004-17:03:30:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.InvalidOperationException: Stack empty.
Thanks for any help!
M. PeyerThis problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve|||This problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve

Saturday, February 25, 2012

Reporting using HTML??

Hi,
I am developing a data management system using ASP.net 2.0 and Sql server 2000.
Now I am dveloping some reports for the INVOICE, PACKING LIST etc.
Is there any tools for achieve thie purpose in ASP.net 2.0??
I was using crystal reports in legacy system, but crystal reports is too heavy and lots of problem, dont want to
use it this time.
I guess HTML is light. but dont know how?
All I came up with is using abosolute positioning is a aspx file. Is there any advanced skill???
Your help is appreciated!
Joseph
Hi,
In my applications I observed that reports especially in Excel or PDF reports are decreased in size after the SP2 for RS.
I guess this is also true for RS2005
Also internet printing may be a good feature for printing your reports from HTML
Eralper
http://www.kodyaz.com
|||Hi
If you are still looking for a report application to handle your reports via SQL Server and you dont want to use Crystal Reports - then use SQL Server Reporting Services. This application is still new but it is directly compatible with SQL Server.