Telerik Forums
Reporting Forum
2 answers
246 views
Greetings,

I am trying to get a working sample through an asp.net webforms project.  I have worked through the quickstart tutorials and have a working sample report (Report1.cs) that shows data in the Preview and Html Preview window as expected.  However when I attempt to load the report through an asp.net webform web page I can't seem to get any results to appear.  So far I've added the ReportViewer control to the page:

<telerik:ReportViewer id="ReportViewer1" runat="server" ></telerik:ReportViewer>

I've added the web.config settings:

<system.web>
 ...
  <httpHandlers>
    <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=7.1.13.802, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
  </httpHandlers>
</system.web>
<system.webServer>
  <handlers>
    <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=7.1.13.802, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode"/>
  </handlers>
  <validation validateIntegratedModeConfiguration="false"/>
</system.webServer>

I've added the code to the page load method:

protected void Page_Load(object sender, EventArgs e)
        {
 
            if (!IsPostBack)
            {
                InstanceReportSource reportSource = new InstanceReportSource();
                reportSource.ReportDocument = new Report1();
 
                 
                reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@batchType", "Open"));
                reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@fromDate", DateTime.Parse("9/1/2013")));
                reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@toDate", DateTime.Parse("9/10/2013")));
                reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@entityId", 0));
                reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@entityType", ""));
                reportSource.Parameters.Add(new Telerik.Reporting.Parameter("@userId", 1));
 
                ReportViewer1.ReportSource = reportSource;
                //ReportViewer1.RefreshReport();
            }
        }

The site compiles and runs, however when the page executes, I'm getting what appears to be a blank or empty ReportViewer control.  I see no difference If I comment out the parameter list in the codebehind, or if I delete all code from the codebehind.  I've tried calling DataBind() and RefreshReport() but no changes.  What am I missing?

Thanks,
Rick
Stef
Telerik team
 answered on 12 Sep 2013
1 answer
62 views
Hi,

I want to allow the End user to be able to customize the look and feel of the report .
That is , the user will be able to only
1. add custom logos
2. change the type of the chart (bar, pie etc)
3. change text and layout etc.

The user will not be changing the query, i.e I don't have to expose all the individual fields from the data source, the user will only be customizing the look and feel of the report.

Can you please help me achieve this in a ASP .NET application using telerik reporting.

Thanks
-Harsha
Nasko
Telerik team
 answered on 12 Sep 2013
2 answers
155 views
I have a report parameter named "Trained" with the following values:
- All
- Trained
- Not trained

The problem is that I can not have a parameter value that does not filter ("All").

At the moment, the filter applied on my tab is as follows:
Expression: =Fields.ResourceTypeTraining (that is a boolean, true if trained)
Operator: =
Value: =(Parameters.Trained.Value Like "Trained" )

If the user selects "All" value, obviously only the "not trained" data will be displayed.

I have tried many solutions, with "Allow null" for example, but I still do not obtain what I want. Is there a property or something else that could fix that?
Christophe
Top achievements
Rank 1
 answered on 12 Sep 2013
3 answers
194 views
Basically I have the following columns on the table feeding this graph (DeviceID=151, 152, 153, 154, 155, 156, 157, 158 total of Eight Line Series, one per device)

[TimeStamp] [DeviceId] [Volume]

Graph works nicely when lots of data is in the graph, even when one single data point is in the graph I see no problem, the graph breaks when I have TWO data points as shown in two_dp.jpg. So why is that? it works for one (one_dp.jpg), it works for three (three_dp.jpg), four (four_dp.jpg), five (five_dp.jpg), and so on, BUT NOT FOR TWO data points(8 per device, 16 total). what's going on?.

The Sample Data is given by:
TimeStamp DeviceId Volume
9/9/2013 9:30 151 19
9/9/2013 9:30 152 20
9/9/2013 9:30 153 20
9/9/2013 9:30 154 19
9/9/2013 9:30 155 0
9/9/2013 9:30 156 0
9/9/2013 9:30 157 0
9/9/2013 9:30 158 0
9/9/2013 9:31 151 22
9/9/2013 9:31 152 24
9/9/2013 9:31 153 24
9/9/2013 9:31 154 18
9/9/2013 9:31 155 0
9/9/2013 9:31 156 0
9/9/2013 9:31 157 0
9/9/2013 9:31 158 0
9/9/2013 9:32 151 21
9/9/2013 9:32 152 22
9/9/2013 9:32 153 21
9/9/2013 9:32 154 24
9/9/2013 9:32 155 0
9/9/2013 9:32 156 0
9/9/2013 9:32 157 0
9/9/2013 9:32 158 0
9/9/2013 9:33 151 25
9/9/2013 9:33 152 22
9/9/2013 9:33 153 21
9/9/2013 9:33 154 23
9/9/2013 9:33 155 0
9/9/2013 9:33 156 0
9/9/2013 9:33 157 0
9/9/2013 9:33 158 0
9/9/2013 9:34 151 22
9/9/2013 9:34 152 20
9/9/2013 9:34 153 21
9/9/2013 9:34 154 20
9/9/2013 9:34 155 0
9/9/2013 9:34 156 0
9/9/2013 9:34 157 0
9/9/2013 9:34 158 0

Data shown in one_dp.jpg includes records whose timestamps are in [9:30am ... 9:31am> (doesn't include 9:31am)
Data shown in two_dp.jpg includes records whose timestamps are in [9:30am ... 9:32am>  (doesn't include 9:32am)
Data shown in three_dp.jpg includes records whose timestamps are in [9:30am ... 9:33am>  (doesn't include 9:33am)
Data shown in four_dp.jpg includes records whose timestamps are in [9:30am ... 9:34am>  (doesn't include 9:34am)
Data shown in five_dp.jpg includes records whose timestamps are in [9:30am ... 9:35am>  (doesn't include 9:35am)

The full graph (with lots of data point) is shown in lots-dp.jpg

This is how I built the graph: created data source with the fields mentioned above, dragged Graph wizard onto the detail
Section, dragged DeviceId on Series, 
Dragged Volume on Values, Dragged TimeStamp on Categories. Clicked on Series, and set X = (Fields.TimeStamp)
Clicked on the horizontal Axis and change Scale from "Category Scale" to "DateTimeScale".

Hope you can help. I have been dealing with this issue for the last week. without any success.



Stef
Telerik team
 answered on 11 Sep 2013
3 answers
114 views
Hi there, I am getting this error when my report gets rendered:
======================================================================
Failed to create a 'X1' from the text 'INF'.' Line number '1' and line position '670'.

'INF' string cannot be converted to Length.
======================================================================
I need to know what settings on the report is causing this i.e. what function call/property setting is doing this so I can address the problem accordingly. This is happening probably because I don't have enough data points for my graph (with DateTime scale on x axis). But I need some help as to what could be causing it. Because after all, a graph with no data points should not be throwing an error anyways.

Stef
Telerik team
 answered on 11 Sep 2013
3 answers
520 views

I use the NeedDataSource Event to bind a table from the resultset of a stored procedure. In the table I have a text box(textBox7) in which sometimes there is a visible value, other times there is not. I want to test to see if there is a value in this textbox. I
I
f there is, I want to set the value of textBox6 to "Yes". If textBox7 does not have a value, make the value of TextBox6 equal to "No". I am using the ItemDataBound event of TextBox6 to try to achieve this. Right now the value of textBox6 always ends up being "Yes" . However, this is not correct. I need to know how to write a valid test for the value of TextBox7, or if I am doing something else wrong. Code is below. Any help would be greatly appreciated.

jason

        private void textBox6_ItemDataBound(object sender, System.EventArgs e)  
        {  
 
            if (textBox7.Value != null || textBox7.Value=="")  
            {  
                textBox6.Value = "Yes";  
            }  
 
            else  
            {  
 
                textBox6.Value = "No";  
            }  
        }  
    } 

 

Squall
Top achievements
Rank 1
 answered on 11 Sep 2013
1 answer
115 views
I'm looking for the scale breaks functionality in the latest telerik reporting ( http://www.telerik.com/help/reporting/featuresscalebreaks.html ) but can't seem to find it? 

Since the chart is obsolete I suppose we need to use Graph or is not all functionality present yet?



Peter
Telerik team
 answered on 11 Sep 2013
2 answers
112 views
Please see the attached image for detailed description - what I need is my report (table) and the graph to be placed next to each other.  If I place my graph in the details section the graph repeats.  I've tried using sub report but still no success.  Can you please tell me if its possible or not to have such format for the report.
Neepa
Top achievements
Rank 1
 answered on 11 Sep 2013
1 answer
283 views
I have used attached files way for displayed the dynamically column in telerik reproting but all r not working..please suggest me how can displayed dynamcially column using telerik reporting


Thanks
Randhir
Stef
Telerik team
 answered on 11 Sep 2013
1 answer
94 views
Hello Guys,
  Is it possible to create a Pie of Pie chart (like the one attached) using telerik reporting graph control?? 
  
  Any thoughts will be appreciated.

Thanks!
Stef
Telerik team
 answered on 11 Sep 2013
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?