Telerik Forums
Reporting Forum
3 answers
530 views
Hi All,

I'm quite new to telerik reporting and wish to use an object as a datasource, a sort of reportmodel (like the viewmodel in MVVM pattern).
With that use, I will be sure to separate my reports from my datas.
But I didn't found anything that tells me i can use nested properties from my datasource.

Does Telerik Reporting tool support this ?
Thanks

BR,

Steeve
Matthias Auswöger
Top achievements
Rank 1
 answered on 24 Mar 2010
1 answer
113 views
Hi,

I'm trying to resize an element at bind based on properties of the data. I have a barcode object in a group header that is large for the first group and smaller for the subsequent groups. I want to resize the barcode and group header accordingly.

My data is in a DataTable and I have set two columns, for each height containing a Unit.Cm() with the required values. I've put these where I think they should go, in the relevant Bindings section with an expression equal to the columns.

However, at runtime I get a red box containing the error "Bindings error - an error occured while invocing the setter on property 'Height' with valuue '2.5cm'"

Please could you explain what I am doing wrong as there doesn't seem to be much documentation regarding using Bindings to change elements during the Bind events.

Thanks in advance
Joe
Top achievements
Rank 1
 answered on 24 Mar 2010
3 answers
229 views
I have a simple column to hold phone numbers. It is an nvarchar(20) to allow for standard phone numbers with extensions.

The first 14 digits will be a standard US phone number. The column allows NULL values and I want to format the data to the following:

(999) 999-9999. This is being done with an expression as follows:

="(" + Fields.PrimaryPhone.SubString(0,3) + ") " + Fields.PrimaryPhone.SubString(3,3) + "-" + Fields.PrimaryPhone.SubString(6)

The issue we are having is if a value is NULL, the expression errors out. I have tried an IIF function, but it does not fix the error condition. Here is the error we are receiving:

 

An error has occured while processing TextBox 'primaryPhoneDataTextBox':

Object reference not set to an instance of an object.

 

 

We have tried a conditional format prior to the expression, and that has not worked either...

Need some assistance as to how to do this...

Thanks...

 

Peter
Telerik team
 answered on 24 Mar 2010
1 answer
348 views

HI

i have read the other threads that are related but i can not get the viewer to run on my hosting servers, but it does run on my development servers. Fiddler reports that the http handler is not working when getting the images and style sheets see below.

i have included extracts from my web.config

 

<

 

 

system.web>

 

<

 

 

httpHandlers>

 

<

 

 

add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.0.10.310, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="false" />

 

</

 

 

httpHandlers>

 

......

 

 


 

<

 

 

system.webServer>

 

<!--

 

 

validation validateIntegratedModeConfiguration="false" /> -->

 

<

 

 

modules runAllManagedModulesForAllRequests="true">

 

<!--

 

 

preCondition="manageC:\Users\Tricky\Documents\Visual Studio 10\Projects\Silverlight_Portal_4\Silverlight_Portal_4.Web\Web.configdHandler" -->

 

<

 

 

add name="DomainServiceModule" type="System.Web.Ria.Services.DomainServiceHttpModule, System.Web.Ria, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

 

</

 

 

modules>

 

<

 

 

validation validateIntegratedModeConfiguration="false" />

 

<

 

 

handlers>

 

<

 

 

add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.0.10.310, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0" />

 

</

 

 

handlers>

 

</

 

 

system.webServer>

 

 

 

 


 

<

 

 

location path ="Telerik.ReportViewer.axd">

 

<

 

 

system.web>

 

<

 

 

authorization >

 

<

 

 

allow users ="*"/>

 

</

 

 

authorization>

 

</

 

 

system.web>

 

</

 

 

location>

 

 

 

 




# Result Protocol Host URL Body Caching Content-Type Process Comments Custom
2 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.ReportViewer.css 904 text/html iexplore:7716
3 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Resources.ParametersArea.css 904 text/html iexplore:7716
4 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Resources.ReportViewerInternal.css 904 text/html iexplore:7716
5 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Resources.ReportViewer.js 904 text/html iexplore:7716
6 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Resources.Parameters.js 904 text/html iexplore:7716
7 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.FirstPageDisabled.gif 904 text/html iexplore:7716
8 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.FirstPage.gif 904 text/html iexplore:7716
9 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.Background.gif 904 text/html iexplore:7716
10 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.PrevPage.gif 904 text/html iexplore:7716
11 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.PrevPageDisabled.gif 904 text/html iexplore:7716
12 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.NextPageDisabled.gif 904 text/html iexplore:7716
13 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.NextPage.gif 904 text/html iexplore:7716
14 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.LastPage.gif 904 text/html iexplore:7716
15 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.LastPageDisabled.gif 904 text/html iexplore:7716
16 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.Refresh.gif 904 text/html iexplore:7716
17 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.RefreshDisabled.gif 904 text/html iexplore:7716
18 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.Print.gif 904 text/html iexplore:7716
19 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.PrintDisabled.gif 904 text/html iexplore:7716
20 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.DocumentMap.gif 904 text/html iexplore:7716
21 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.Loading.gif 904 text/html iexplore:7716
22 404 HTTP i-possum.com /Demo/Telerik.ReportViewer.axd?optype=Resource&version=4.0.10.310&name=Skins.Default.Splitter.gif 904 text/html iexplore:7716

Steve
Telerik team
 answered on 24 Mar 2010
2 answers
369 views
I reviewed the article about the three possible causes for this error but none seem to apply for my situation. My function is very simple with no parameters, so #2 and #3 can't apply, plus I've rebuilt the project many times so I don't think it is #1. The error goes away when i set Visible=false for the parameters' UI. I was able to choose the function from within the ReportParameter Collection Editor under "User Functions", and the Editor then automatically set the Value of the parameter to "= GetDefaultFromDate()" (without the quotes)

GetDefaultFromDate() is defined in the same class as the report as the following:

  public static DateTime GetDefaultFromDate() 
  { 
    return DateTime.Now.AddMonths(-1); 
  } 


This is for an ASP.NET 3.5 website written in C#. I was first using Telerik Reporting Q3 2009, but upgrading to Q1 2010 did not resolve the issue.  Please let me know if you need any other information to understand my problem.

Thanks,
David

The expression contains undefined function call GetDefaultFromDate(). 
   at Telerik.Reporting.Expressions.FunctionNode.Eval(Object row, Object context) 
   at Telerik.Reporting.Processing.ParametersManager`1.CalculateValue(T parameter, Object definitionValue, IDictionary`2 newValues) 
   at Telerik.Reporting.Processing.ParametersManager`1.Calculate(T parameter, IDictionary`2 parameterValues) 
   at Telerik.Reporting.Processing.ParametersManager`1.GetParameters(IDictionary`2 parameterValues) 
   at Telerik.ReportViewer.WebForms.ParametersPage.OnPreLoad(EventArgs e) 
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 

Dave Bierbaum
Top achievements
Rank 1
 answered on 23 Mar 2010
5 answers
119 views
We have noticed in Q1 2010 of Telerik Reporting that if you apply a style to a textbox that includes changing the font, font size, forground color and positioning within the textbox, and then copy and apply that style to one or more other textbox controls that the Font does not change in the pasted textbox controls. All other changes are applied, but the Font remains Tahoma instead of your altered selection.
Chavdar
Telerik team
 answered on 23 Mar 2010
1 answer
291 views
Hi.

After reading some threads about memory management in Telerik Reporting, I noticed that it is a known issue that memory management and performance on the component have some room for improvement. At this moment, I'm facing some challenges to keep the memory usage low when reports are generated, so that I can get my application more scalable and support more concurrent users, and I've been trying some stuff to get around the issue.

We are wondering if it would be a good idea to replace the usage of the ReportViewer control in our web page by using ReportProcessor.RenderReport, using HTML as the format. That way we can just place the resulting HTML on the page and release all resources. Here is how the code would look like:

//Note: "ec" below is my Telerik report class
Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();  
Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("HTML", ec, null);  
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();  
string htmlResult = enc.GetString(result.DocumentBytes);  
reportProcessor = null;  
result = null;  
lblResult.Text = htmlResult;


We thought this approach could be good for two reasons:

1. The call to RenderReport is synchronous and runs on the same thread as the page - that way I have control of when the render finishes, so I can release the resources after everything is done. The call to ReportViewer.RefreshReport() doesn't work that way, as per our observation (seems to run on a separate thread, so we have no way of capturing the moment the report finishes rendering to clear resources).
2. We don't want/need the toolbar provided by the ReportViewer component.

I'd like an opinion from Telerik on the approach above. Does it make sense?

Another question: the code above renders only the first page of the report in HTML. Is there a way I can get the other pages? I couldn't find information about this on the documentation of the RenderReport method.
Chavdar
Telerik team
 answered on 23 Mar 2010
0 answers
121 views
Hi,

We are using Telerik Reporting and Telerik Openaccess in our project.

We plan to have a common stored procedrue that returns granular data. Teleik Openaccess is used to call the stored procedure.

This stored procedure normally returns about a million rows and upto 4 million rows in extreme cases.

On the frontend, we use crosstab control of telerik reporting to group data as per the requirement.

We will have about 20 different types of telerik reports and all will call this common stored procedure. However, each report will group data in a different way.

I would like to know the following

1. Can crosstabs of Telerik reporting can handle this data volume (1 miilion - 4 million records)

2. What is the maximum volume crosstabs can handle without degradation in performance.

3. Is the above approach the recommended approach? If not, what is Telerik's recommendation?
mennam
Top achievements
Rank 1
 asked on 23 Mar 2010
5 answers
302 views
Hi Telerik team,
I've made a report, run alright on design and html mode. When i embedded in consume page, it gived error: 
An error has occured while processing Report '':
Format of the initialization string does not conform to specification starting at index 0.

Steps:
Create a new project for reports as advise. Put the project in the same solution as my consume project. Physical path however is another place.
Create a report, feed data using store proc. ---> the result as expected until here.
Create a Web form, whose report viewer is assigned to just-made report.
I got the error above.
Am i missing something ?
Thank you

Bogice
Top achievements
Rank 1
 answered on 22 Mar 2010
0 answers
96 views
hi there,

i will build a report, that contains around 21 columns.. i my view, i think its thats too much for one row (with all the data)

one solution might be: to break the data into two rows in the detail section, so that two header rows and two data rows appear.. the problem at this solution is the readability, because of the second header row

another idea is a master-detail output... but i don't know how i could realize it...

so anyone ever had a similar problem or an better idea?

kind regards,
basti
Farouk
Top achievements
Rank 1
 asked on 22 Mar 2010
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?