Telerik Forums
Reporting Forum
1 answer
119 views
Hi,

I'm new to Telerik Reporting (Q2 2013 SP1) in ASP.NET. I have only been playing with it for a week or so and I have read the documentation but i can't find the answers to some basic questions.

1. The biggest question is: When building a Report Item, Visual Studio shows a Report.cs and a Report.Designer.cs. The wizard puts everything in the Designer.cs (I would have thought some of it if not all to be in the Report.cs) so what goes in Report.cs? What type of things can I put there or does that Report.cs file stay as is? (sorry if stupid question).

2. I'm interested in creating my own UI (date pickers, checkboxes etc..) and then hitting a button to trigger a report in the ReportViewer. I saw this link that i can bind a datatable to the report which I would like to do. My stumbling block is, in order to build a report, I already have to have the ObjectDatSource predefined in order to design the report so what happens to that ObjectDataSource when I bind another datatable to the report when the existing ObjectDatSource in the report is pointing to a different function? Do i remove it from the Designer after the report is created?

Thanks!
Shane
David
Top achievements
Rank 1
Iron
Veteran
Iron
 answered on 17 Sep 2013
1 answer
38 views
Hello, I want to cotinuidade to this Topic.

http://www.telerik.com/community/forums/reporting/telerik-reporting/running-report-created-in-report-designer.aspx

graciously
André
Peter
Telerik team
 answered on 17 Sep 2013
1 answer
195 views

 Hello,

 I'm formatting a chart from telerik reporting to make it look as one telerik chart we have in our silverlight application.

 To do so, I have applied a Skin, and then, programatically, I'm applying new color after the chart constructor initialize component has finished and the skin is applied.

  This is what i'm formatting:
 
            Color deepBlue = Color.FromArgb(255,34,85,146); // DeepBlue RGB 34; 85; 146 ARGB 255; 34; 85; 146
            // chart border
            chart.Appearance.Border.Color = deepBlue;

            Color metalOrange = Color.FromArgb(249, 158, 13); // MetalOrange 249; 158; 13
            // title letters
            chart.ChartTitle.TextBlock.Appearance.TextProperties.Color = metalOrange;

            Color lightBlue = Color.FromArgb(235, 255, 255); // LightBlue 235; 255; 255
            // chart background; original 226; 247; 255
            chart.Appearance.FillStyle.MainColor = lightBlue;

  The Telerik.Reporting.Chart chart var is the one I'm getting from the report after is constructed. The problem is that when rendering the report in PDF, none of this color changes are done.

  As a note, in a test i do, when debugging i check the colors of the chart getting the ones in the skin, the after a clear skin line, i see back the original ones and then, when set mines, i correctly saw debugging my color values set
if I clear the skin, then i see debugging the original values for the colors of the chart. 

Thanks,
Squall
Top achievements
Rank 1
 answered on 17 Sep 2013
1 answer
145 views
Hello Guys,
   Take a look at the screenshot. In the top picture, I applied a filter Top N=5, which returns the result set you see in screen.
   When I remove this filter, the Top N=5 is different.

   I found that if I remove the sorting, the Top N=5 matches the one that is displayed in the top image.  This means that the Filtering is applied over an unorder collection of results.

   Is this a known issue? or do you know what I might be doing wrong?

Thanks!!
Stef
Telerik team
 answered on 16 Sep 2013
1 answer
144 views
Hi. I placed an image using Picturebox in Report. I want to set Tooltip for the Image. By default, tooltip showing as "Image" but i want to set my own tooltip. Please help me out, how to set it. I am using Telerik version 2011. 
Thanks in advance.
KS
Top achievements
Rank 1
 answered on 13 Sep 2013
1 answer
140 views
Hi,
Included is example file. column width is smaller then the recommended size, as shown with borderlines. In preview showing one column, also in print showing 1 only, whereas setting are columncount =4 on normal A4 paper, with margins of 254 mm has a face remaining of 15 cm. interested in hearing how I can resolve things.

Regards,
Nasko
Telerik team
 answered on 13 Sep 2013
2 answers
263 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
73 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
170 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
208 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
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?