Telerik Forums
Reporting Forum
2 answers
129 views
Hi

I'm using item.DataObject to get at the data in a report:
the data comes from SQL Server
and the column is named OptiClear

Code as follows:
==============
Private Sub detail_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles detail.ItemDataBound
Dim item As Processing.ReportItemBase = DirectCast(sender, Processing.ReportItemBase)
Me.Total_OptiClear += DirectCast(item.DataObject("OptiClear"), Decimal)
===============

If the case of OptiClear is changed to Opticlear
ie A small c

The report previews fine in my windows project
but falls over in the Web Report Viewer

NOT A MAJOR PROBLEM
but it means that you have to make absolutely sure that the case of your item
is the same as the source column....

Any comments appreciated....

Regards

Martin Hoey






Martin
Top achievements
Rank 1
 answered on 01 Mar 2010
1 answer
343 views
Hi

I have created my own WCF service which uses the ReportProcessor to render an Xps to be used in the WPF DocumentViewer control. It worked fine when using the ReportProcessor directly from the App. But at soon as I move it to a service it fails.

I have created unit test that proves that the ReportProcessor works fine.

I get the following exception:
Test method Dako.ReportingService.UnitTest.DakoReportServiceTest.TestRenderXpsWithServiceHost threw exception:  System.ServiceModel.FaultException: FixedDocument must contain at least one FixedPage..

And when I look at the Debug trace I see another error:
----------------------------------------------------------------------------------------------------------------------------------
...

*** Measure Report (Vertical) STARTED ***
*** Measure Report (Vertical) DONE in 00:00:00.0008545 ***

*** Measure Report (Vertical) STARTED ***
*** Measure Report (Vertical) DONE in 00:00:00.0010941 ***

*** Measure Report (Vertical) DONE in 00:00:00.0055121 ***

*** ProcessReport #0 DONE in 00:00:00.3215597 ***

*** RenderReport #0 STARTED ***

*** RENDER PAGES STARTED ***
*** RENDER PAGES DONE in 00:00:00.0028726 ***

An error has occured while rendering the report: System.InvalidOperationException: The calling thread must be STA, because many UI components require this.
   at System.Windows.Input.InputManager..ctor()
   at System.Windows.Input.InputManager.GetCurrentInputManagerImpl()
   at System.Windows.Input.InputManager.get_Current()
   at System.Windows.Input.KeyboardNavigation..ctor()
   at System.Windows.FrameworkElement.FrameworkServices..ctor()
   at System.Windows.FrameworkElement.EnsureFrameworkServices()
   at System.Windows.FrameworkElement..ctor()
   at System.Windows.Controls.Panel..ctor()
   at System.Windows.Controls.Canvas..ctor()
   at Telerik.Reporting.XamlRendering.CompositionXamlBase.NewPhysicalPage()
   at Telerik.Reporting.XamlRendering.CompositionXps.NewPhysicalPage()
   at Telerik.Reporting.ImageRendering.CompositionBase.NextUsableArea()
   at Telerik.Reporting.ImageRendering.CompositionBase.NextHorizontalPage()
   at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(CompositionBase composition, RenderingElement renderingReport, Int32 startPage, Int32 endPage, Boolean render)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(Report report, CompositionBase composition, Int32 startPage, Int32 endPage, Boolean render)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.RenderReport(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
*** RenderReport #0 DONE in 00:00:00.0068132 ***

*** ReportProcessor.Render DONE in 00:00:00.3291403 ***

---------------------------------------------------------------------------------------------------------------------------------

I have another test that also calls the service which passes.

What am I doint wrong?

Best regards,
Michael
Michael Bendtsen
Top achievements
Rank 1
 answered on 01 Mar 2010
1 answer
282 views
When I export my report to Excel, how can I get the columns to 'Autofit'?
Peter
Telerik team
 answered on 26 Feb 2010
2 answers
399 views
In my report, I want to change the value of a textbox based on the value of the row data. I can't really use an expression because I may need to do a additional data lookup (depending on the data). Instead, I use the detail_ItemDataBound method to process the row data and change the text. At the same time (using the same method) I also change the visibility of another text box.

When I run the report, the visibility works fine, but the text is only changed on the row after the one being processed (the text for row n is displayed on row n+1). 

Is detail_ItemdataBound the right place to do this processing? Would detail_ItemDataBinding be better?

When do I use each one?

TIA.
Dave Hayward
Top achievements
Rank 1
 answered on 26 Feb 2010
4 answers
280 views
I have a master report that uses a single group. Within each group, I display a subreport with data for the group. When the report is displayed using the ReportViewer control on my web page, the first sub-report is empty, and the second sub-report contains the data for first group etc.

I step through the code in the debugger to be sure the correct data is being supplied for the group data, and it appears to be correct.

Are there any known problems with using grouping and sub-reports? Are there any other mistakes on my part that could cause this behaviour?

It's happeneing on two separate master/sub-report pairs, and it's very repeatable.

TIA.
Dave Hayward
Top achievements
Rank 1
 answered on 26 Feb 2010
0 answers
62 views
It is our pleasure to announce the immediate availability of the Q1 2010 BETA of Telerik Reporting. The downloads are now available in your account (or free trials) - look for the "Q1 2010 Beta Available" link under the Telerik Reporting section.

What's new:
  • Declarative data source engine with full design time support through wizards
  • Optimized and improved data manipulation performance (up to 300%)
  • Data source parameters
  • Calculated fields through expressions
  • Support for stored procedures and methods as report data sources
  • User defined aggregate functions
  • Visual Studio 2010 RC Support

Check the release notes.

We will expect your feedback through the the Beta Forum.
Telerik Admin
Top achievements
Rank 1
Iron
 asked on 26 Feb 2010
3 answers
120 views
Hi,

I have a created a simple report in Silverlight but when I run the application I get this error:

AG_E_UNKNOWN_ERROR:

System.Windows.Markup.XamlParseException occurred
  Message="AG_E_UNKNOWN_ERROR [Line: 26 Position: 36]"
  LineNumber=26
  LinePosition=36
  StackTrace:
       at System.Windows.Application.LoadComponent(Object component, Uri resourceLocator)
       at Silverlight_Reporting.MainPage.InitializeComponent()
       at Silverlight_Reporting.MainPage..ctor()
  InnerException:


Here is my code from the MainPage.xaml

<

 

reportViewer:ReportViewer x:Name="xReportViewer"

 

 

    ReportServerUri="../ReportService.svc"

 

 

    Width="1000"

 

 

    Report="ReportLibrary.BasicReport, ReportLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">

 

 

 

 

</reportViewer:ReportViewer>

 

Pascal Rieder
Top achievements
Rank 1
 answered on 26 Feb 2010
3 answers
244 views
Hello,

I don't see the the ZoomMode and ZoomPercent properties for the Silverlight ReportViewer? Do they exist? Do they have different names? Are there equivalent properties I should be looking at?

Thanks,

-Gary
Svetoslav
Telerik team
 answered on 26 Feb 2010
1 answer
149 views
Hi,

I created a class library project to create my reports and use that in an existing web application. I created a table adpater which uses an existing stored procedure(with parameters). I am using these reports in my application using the reportviewer. The parameters for the stored procedures are controls on the page containing the reportviewer. I am unable to figure out a way to pass the parameters from this page to the stored procedure and display the correct report. What am I missing?

Thanks
Steve
Telerik team
 answered on 26 Feb 2010
0 answers
124 views
I have a report that binds to a collection of objects. One of the properties on the object is an enumeration. When the report is ran, the field with the enumeration shows up as an integer. How can I convert an enumeration field to use the actual value of the enumeration instead of the integer value?
kelly moore
Top achievements
Rank 1
 asked on 25 Feb 2010
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?