Questions on Reporting Forum

4 answers

76 views

Hello Support,

Like many users here, I am new to reporting. I have been going through the documentation and examples. I just can't seem to wrap my mind around the Totaling part of reports.

My question is, how do I add a Total Field (for example Price), if I went through the Report Wizard? I used a table layout.

I know you can do it as follows:
The way I can do it is, create a blank report, bind my SQL data source to the Report. Drag in the fields, then and a group section for totaling.

I like the table layout and the snap to grid... so I want to try getting it working without binding it to the report.

Hope this makes sense, apologies if it has been asked before, I looked around for a while and could not find the exact question

Thank you
Brenden

General Discussions

answered on 06 Feb 2015

1 answer

51 views

Design view looks good, but when I run it in my Visual Studio solution, the filters are all messed up?

Hello Support,

I am starting to get into the full swing of Telerik Reports. A problem I am currently having is the filtering "toolbar".

When I am in Visual Studio (13) and I compile and run my solution the filter toolbar with my input parameters is all messed up. I have filter and parameters for a Date Range, Company ID and Transaction type ID. Basically two Date Time pickers and two drop down lists the user can chose from. Like I said before all works well in the Designer when previewing the Reports.

The issues are:

- The DateTime picker style is bulky.
- When I click on the Date To (second date time picker) it triggers the first date time picker. So I cant set an end date (unless I type it in)
- In the company list the first item disappears?
- In the transaction type drop down list instead of seeing the default text <select a value> it reads <select&160;a value>

Separate from the filters but another issue is the pagination:
- The paging navigation controls do not work (I can not step through or jump to a page)

I have tried to solve the issue so far but no luck:

- I have made sure the httpHandlers in the web config file are the correct version ( I have 8.2.14.1204)

<add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=8.2.14.1204, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" />

Is my current setting..

I am not sure what it could be or why it is happening when checking the console in the browser there dont seem to be any errors?

Appreciate the feedback and any ideas?

Thank you
Brenden

General Discussions

answered on 06 Feb 2015

1 answer

480 views

Get Username of logged in user

I want to limit/secure report data based on the user that is logged in. I've set up a Report Parameter to do this, but want the value for this parameter to be populated automatically and hidden.

In SSRS there is a built-in field for this (User!UserID). Does something similar exist in Telerik Reporting?

General Discussions

answered on 05 Feb 2015

1 answer

214 views

Error Found: How To Create a Custom Parameter Editor

Good afternoon,

While working with a report viewer I found an error in the example: How To: Create a Custom Parameter Editor. In the code example the createEditor method makes a call to a jQuery function that sets the html for the element that you pass to the placeholder parameter. The call in the example is misspelled.

Please find the code example below for a working version.

//misspelled

$(placeholder).htmll('<div></div>');

//should be

$(placeholder).html('<div></div>');



//Code example fixed

<script type="text/javascript">

  $("#reportViewer1")

  .telerik_ReportViewer({           

   parameterEditors: [

    {

     match: function (parameter) {

      return Boolean(parameter.availableValues) && !parameter.multivalue;

     },     createEditor: function (placeholder, options)  {

      var dropDownElement = $(placeholder).html('<div></div>'),

          parameter,

          valueChangedCallback = options.parameterChanged,

          dropDownList;          function onChange() {

         var val = dropDownList.value();

        valueChangedCallback(parameter, val);

         }      return {

       beginEdit: function (param) {        parameter = param;        $(dropDownElement).kendoDropDownList({

         dataTextField: "name",

         dataValueField: "value",

         dataSource: parameter.availableValues,

         change: onChange

        });        dropDownList = $(dropDownElement).data("kendoDropDownList");

       }

      };

     }

     }]

  });        

</script>

General Discussions

answered on 05 Feb 2015

2 answers

137 views

Q3 2014 WinForms Report Viewer report size different than in Designer

I have recently upgraded to Q3 2014 Telerik Reporting. Now I have an issue with the WinForms ReportViewer that I didn't have before. In the visual studio report designer, I have setup my reports to be 8.5x11 Letter in Landscape mode. Report renders correctly and prints correctly in the designer. However, when I render the report in the WinForms ReportViewer, it appears that it is shrinking the report by about 60%. I have checked all the report settings at runtime and everything appears to be correct.

Any ideas on why this is happening?

Thanks,

Terry

General Discussions

answered on 05 Feb 2015

1 answer

102 views

Maps: Output Shapes as individual images

I am using the map capabilities along with WellKnownText format to plot countries and build color coded maps. My customer has the need to export the output to image or PPTX. He would like each country to be a unique object so that he can manipulate the output. For example, he may need to remove a country or offset one to highlight it. Other scenarios include adding custom labels and pointers to call out a country or identify it better.

Is there a way to create the reports so that each country is a unique image when exported instead of all countries exporting as a single image?

General Discussions

answered on 03 Feb 2015

2 answers

376 views

ObjectDataSource Generic List properties

I've searched through the forums and I've found some threads that come close to my question, but none seem to touch on it specifically. With that, I apologize if my searching skills lack and this ends up being a re-post.

I'm creating a report whose object data source is a List<Person> which has multiple properties, some of which are generic lists...

i.e.

public class Person {

public Person() { }

public string FirstName { get; set; }

public string LastName { get; set; }

public List<Address> Addresses { get; set; }

public List<Phone> Phones { get; set; }

}

On the report itself, I'd like to bind to the List<Person> via the ObjectDataSource
As far as the display goes, I'd like to have the person's name, Id, etc show up on one line (which works fine), and have the addresses / phones show up under their respective person's record (whether that's by a table or some other control).

In my searches I've found other people doing sub-reports to accomplish this. This method seems overly complicated to me, especially when there's a reporting table control that can have its own data source. It would seem I should be able to bind to the Addresses or Phones property of the Person class currently being bound.

Therefore, my question:
Are sub-reports the only way this layout can be accomplished?
Am I on the right track with the table control (or some other control) that can used as I mentioned? If so, any links or examples would be handy.

Thanks in advance

General Discussions

answered on 02 Feb 2015

2 answers

166 views

Lose focus on active control when calling RefreshReport() method for ReportViewer

Hello everyone

In my application I have a Telerik.Reporting.ReportViewer to load a preview of a report. I also have many controls like RadTextBox or RadDropDownList etc. What I'm trying to do is when the user changes the text of a RadTextBox it should reload the ReportViewer. To do this I'm using RefreshReport() method. But when I call this method it loses the focus on the textbox. I already tried refocus the control after calling the RefreshReport() method but this didn't work neither. I found this thread of October 2009:

http://www.telerik.com/forums/winforms-report-viewer-quot-refreshreport-quot-sets-focus

I'm wondering now, 5 years later, if there is a way to prevent losing focus on the control when calling RefreshReport() method?

Ah, if you want to have a look at my code, here it is:

InstanceReportSource report = new InstanceReportSource();
reportSpedi.ReportSource = new Spediauftrag(this);
reportSpedi.RefreshReport();

// active textbox
txtSpediGewicht.Select();

Regards,
Danilo

General Discussions

answered on 02 Feb 2015

2 answers

382 views

HTML5 Telerik Reporting DropDown

The default formatting for HTML5 using Kendo is a select list instead of a drop down. There is an article here (http://www.telerik.com/help/reporting/html5-report-viewer-howto-custom-parameter-editor.html) that shows how to turn them into dropdowns. The only problem is when you have cascading parameters (http://www.telerik.com/help/reporting/designing-reports-parameters-cascading-report-parameters.html) When you change the first dropdown the values of the second dropdown update but the first dropdown's display does not change. I'm trying to figure out how to resolve this issue. I've attached my report to show the cascading parameters.

Thank you

General Discussions

answered on 30 Jan 2015

1 answer

156 views

Should PaperSize change?

You can see in the attachment that I changed the PageSettings to Landscape.

The PaperSize remained 210 X297. Should this change to 297 X 210?

I do not seem to be able to view anything to the right of 210.

Thanks,
John

General Discussions

answered on 30 Jan 2015