Telerik Forums
Reporting Forum
2 answers
227 views
I am a pure beginner in csharp.

In my report, I have to group the results of an sql query data and calculate the average min., max. and median (I have three grouping categories: category I, II and III). For the average, min and max I can use the AVE-, MIN- and MAX-functions.
To calculate the median, I found the following c#-script:

public static double Median(this IEnumerable<double> list)
        {

            List<double> orderedList = list
                .OrderBy(numbers => numbers)
                .ToList();

            int listSize = orderedList.Count;
            double result;

            if (listSize % 2 == 0) // even
            {
                int midIndex = listSize / 2;
                result = ((orderedList.ElementAt(midIndex - 1) +
                           orderedList.ElementAt(midIndex)) / 2);
            }
            else // odd
            {
                double element = (double)listSize / 2;
                element = Math.Round(element, MidpointRounding.AwayFromZero);

                result = orderedList.ElementAt((int)(element - 1));
            }

            return result;
        }  


As I am an absolute c#-beginner, I don't know how to pass the sql-result of each group to the median-function... :-( I would be very thankful, if someone could provide me any hint.


IvanY
Telerik team
 answered on 27 Feb 2014
7 answers
239 views
I need help getting started with Telerik Reporting. I‘ve read the documentation and I understand
almost everything except how to get started in Visual Studio. I would like to use the VS designer, and
integrate the report into my WPF application, using VS 2013. I understand I should be able to create
classes inside a reporting project, but how do I start this project? I tried creating a Telerik Reporting
application, but it creates a WinForms application that doesn’t seem to do what
I need.

There is documentation on the Integrated Reports designer in
VS, but the very first line of the documentation says “Double click on the
Report.cs file” – where is this file, and how is it created??? It also mentions to click on the Telerik Menu
-> Reporting, but all I ever see is Upgrade Wizard. The documentation says other options will
appear when the designer has focus, but How do I find the Designer??? This is very frustrating when you can’t get
past square one.

I am using Telerik UI for WPF version 2013.2.724.40, and Reports version 7.1.13.802. I’ve successfully added
references to my project, and binding redirects to allow the libs to load. I’ve also added a report viewer control to my
WPF UI. What I need help with is starting the designer in Visual studio, and how to create the report classes.

Thanks,

Randy

Randy
Top achievements
Rank 1
 answered on 26 Feb 2014
2 answers
253 views
Hi Folks - I'm having problems with missing toolbox items.  Ive read over this article: Telerik Reporting Toolbox items are missing and done all the stuff but I still dont get any tools when im in report designer.  I'm using both Q1 2011 and Q3 2013 versions. (not all apps have been converted yet).  is that a problem?  when i R-Click the toolbox and do Show-All then I can see the sections but the items are all greyed out?  Im running Win64.  what does it mean when i can only see items greyed out in Show-All mode?
kellyroberts
Top achievements
Rank 1
 answered on 26 Feb 2014
1 answer
394 views
I have a vb.net application with an asp page that has a report viewer control on it. The problem is that when publishing the application, the icons does not show up as in the attached image.

The webserver is running Windows 2008 R2 with IIS7

web.config
    <compilation debug="true" explicit="true" strict="false" targetFramework="4.0">
     <assemblies>
       <add assembly="Telerik.Web.Design, Version=2013.3.1015.40, Culture=neutral, PublicKeyToken=121FAE78165BA3D4" />
       <add assembly="Telerik.Reporting.Service, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
       <add assembly="Telerik.Reporting, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
       <add assembly="Telerik.ReportViewer.WebForms, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
       <add assembly="Telerik.ReportViewer.WinForms, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
       <add assembly="Telerik.ReportViewer.Wpf, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
     </assemblies>
   </compilation>
  
   <httpHandlers>
     <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" />
     <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false" />
     <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false" />
     <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false" />
     <add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false" />
     <add type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*" validate="true" />
   </httpHandlers>
  
<system.webServer>
   <caching enabled="true" enableKernelCache="true">
     <profiles>
       <add extension=".png" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" location="Any" />
       <add extension=".jpg" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" location="Any" />
       <add extension=".gif" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" location="Any" />
       <add extension=".axd" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" location="Any" />
       <add extension=".css" policy="CacheUntilChange" kernelCachePolicy="CacheUntilChange" location="Any" />
     </profiles>
   </caching>
   <validation validateIntegratedModeConfiguration="false" />
   <handlers>
     <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=x.x.x.x, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode"   />
   </handlers>
 </system.webServer>

report.asp
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="Navigation" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="RightPane" Runat="Server">
     <div style="text-align:left; vertical-align:Top; padding-left:10px; padding-right:10px; padding-top:10px; height:650px;">
        <table style="width: 100%; border-style: none; border-spacing: 0; padding: 0;" class="ContentTable">
            <tr>
                <td style="text-align: center;" class="ContentTable">           
                    <telerik:ReportViewer ID="ReportViewer1" runat="server" Width="100%" Height="600px">
                        <typereportsource typename="CirusReports.Report1, CirusReports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>
                    </telerik:ReportViewer>
                </td>
            </tr>
        </table>
    </div>
</asp:Content>



juststarting
Top achievements
Rank 2
 answered on 26 Feb 2014
1 answer
170 views
Hi

I am creating the Telerik report we need to create a report dynamically ,so i create one button ,
on button click the call come in aspx page and i also using .ascx(user control).on ascx page i put the telerik Report viewer
so report generating on .ascx(user control) that .ascx page display dynamically on " div "  on aspx page. but the problem
report design is display but data is not display .

so please help me.

Regard,
Hitesh
KS
Top achievements
Rank 1
 answered on 25 Feb 2014
2 answers
125 views
I am trying to design a report contains a start date and end date, which needs the start and end day of current month, I implemented the logic in a C# assembly and used it in standalone designer, it's works well in designer, but when I embed it in a asp.net web application, I got this error :
Object reference not set to an instance of an object.
at Telerik.Reporting.Expressions.FunctionNode.Eval(Object row, Object context)
at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateValue(P parameter, Object definitionValue, IDictionary`2 newValues, Object data)
at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameterProperties(P parameter, IReportParameter parameterDef, IDictionary`2 parameterValues)
at Telerik.Reporting.Processing.ReportParametersManager`1.Calculate(P parameter, IDictionary`2 parameterValues)
at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameters(IDictionary`2 parameterValues)
at Telerik.Reporting.Processing.ReportParametersManager`1.get_Parameters()
at Telerik.Reporting.Processing.DocumentParametersManager`1.InitializeMergeMap()
at Telerik.Reporting.Processing.DocumentParametersManager`1..ctor(IReportDocument definition)
at Telerik.Reporting.Processing.DocumentParametersManager..ctor(IReportDocument definition)
at Telerik.ReportViewer.WebForms.ParametersPage.CreateParametersManager(IReportDocument reportDocument)
at Telerik.ReportViewer.WebForms.ParametersPage.get_ParamsManager()
at Telerik.ReportViewer.WebForms.ParametersPage.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at Telerik.ReportViewer.WebForms.ParametersPage.OnPreLoad(EventArgs e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

If I replace the values of 2 parameters to static values like "2013-01-01", it works.
 How can I achieve this goal ?
KS
Top achievements
Rank 1
 answered on 25 Feb 2014
1 answer
90 views
We have designed our report with a chart as in the attached image.
We pass the data to the report manually.

Dim rpt As New ReportLibrary.Shipping.ShippingByShipperHourly
rpt.DataSource = ds

 
The report has a chart on the detail section. We want to filter the charge data based on the UserID in the dataset.
Basically, dataset contains data for several users. Each user is displayed and then its shipping activity chart is displayed along with it. Then the row for other user and its chart. 

I need some code, I can put behind the NeedDataSource of the Chart component where I can filter the required data based on the current user data being rendered.

Is it possible? If so, how can we do it?

thanks
Sameers
KS
Top achievements
Rank 1
 answered on 25 Feb 2014
6 answers
2.8K+ views
When I try to use the html 5 report viewer, it attempts to hit the following URL.

http://localhost:58924/api/TelerikReports/clients/[object%20Object]/parameters

it returns 404 (Not Found)

If I open the link in the browser I get the following error.

<Error><Message>The requested resource does not support http method 'GET'.</Message></Error>
Stef
Telerik team
 answered on 25 Feb 2014
1 answer
68 views
Hi telerik,

Using wpf reportviewer and telerik Q1 2013 SP1
I'm currently having an issue with localization in my solution. My report is in English by default and the additional language is French. When I debug the solution I don't have any problem but in release none of the fields will be globalized. Only culture related fields like dates are correctly globalized, the rest is all in english.


Please note that I have other reports in the solution whom will localize correctly while using the same pattern.
Stef
Telerik team
 answered on 25 Feb 2014
0 answers
95 views
please is it possible to pass sessions as parameters for a telerik report on page load.
If yes how can i please go about it. Thanks
Edd
Top achievements
Rank 1
 asked on 25 Feb 2014
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?