Telerik Forums
Reporting Forum
4 answers
356 views

Could you tell me why when I create a new text box in the "detail_ItemDataBinding" method (for each row) ... this new text box is only created in the second row (and in the third row, and in fourth ... but never in the first) ...? I can not create any new text boxes in the first row ... It's the same code for each row

Why it happens?

Thanks

Silviya
Telerik team
 answered on 05 Apr 2018
0 answers
137 views

Hi,

I am using HTML5 Telerik Report Viewer for my MVC 5 Project and using Stored Procedures to fetch the data. Its pretty awesome.

The only issue I am facing is, I cannot use the column names exactly returned by my stored procedure. The pattern is following:
If a user select February from the options, report should show:
Sr. No         February         Name

  1                  15                  xyz

  2                  30                 abc

but if user select December, it should show the following:

Sr. No         December         Name
  1                  15                  xyz
  2                  30                 abc

 

I cannot make the columns dynamic. My stored procedure can return dynamic column name (using pivot). Can you please help me out? I am unable to find such a solution on your forums and/or stackoverflow. Please keep in mind that I am using MVC 5 HTML 5 Report Viewer with stored procedures.

 

Thanks alot

 

Shahid
Top achievements
Rank 1
 asked on 05 Apr 2018
0 answers
127 views
I had an old Silverlight Project which I am trying to upgrade.
I did upgrade the reports using the Upgrade Wizard from Telerik.
Now I am using HTML Report Viewer to display the reports. 
The report and parameters are being set from the client side using java script for which I followed  https://docs.telerik.com/reporting/html5-report-viewer-howto-custom-parameters 
I can see the parameters being passed from the console and in the report viewer but the parameters are not being received by the Stored Procedure. The stored procedure gets the parameter values as NULL. 

Unable to figure out why it is happening like this. 

Thanks
Pooja
Top achievements
Rank 1
 asked on 04 Apr 2018
0 answers
83 views

I want change or set a new sorting in telerik reporting 2016 r3 in code behind.I am using silverlight.

I cannot to update or set the new sorting. It does not work?

I tried to use below code in need_datasource (before or after datasource assignning) but does not effect.

Telerik.Reporting.Sorting sorting1 = new Telerik.Reporting.Sorting();

sorting1.Expression = "=Fields.MyField";

sorting1.Direction = Telerik.Reporting.SortDirection.Asc;

this.report.Sortings.Add(sorting1);

 or by direct assigning :

this.report.Sortings.Add(new instance with new expression and direction);

Does not work!

 

 

 

M
Top achievements
Rank 1
 asked on 04 Apr 2018
1 answer
1.3K+ views

Hello 

I am trying to follow article below:

https://docs.telerik.com/reporting/designing-reports-parameters-programmatic-control

I designed my report in Standalone Report Designer(Test.trdp), Data source is stored procedure taking one parameter(@pDest).

Now, I am trying to display report in WPF ReportViewer, how shall I pass this parameter to ReportViewer ?

       <tr:ReportViewer Grid.Row="0" x:Name="ReportViewer1" HorizontalAlignment="Stretch" EnableAccessibility="False">
                <tr:ReportViewer.ReportSource>
                    <telerikReporting:UriReportSource Uri="Reports/Test.trdp"/>
                </tr:ReportViewer.ReportSource>
            </tr:ReportViewer>

How do I assign NeedDataSource event handler? 

 

Katia
Telerik team
 answered on 04 Apr 2018
9 answers
1.0K+ views
I'm using the hyperlink on a Textbox (not a HTMLTextbox but rather a plain Textbox).   I did this via the Action property and selecting Navigate to URL with Link Selected set to NewWindow.   The target URL is set to the following expression:

= Parameters.URLPrefix.Value + CStr(Fields.SERVICEREQUESTIDNUM)

It works great in the Report Viewer and when I export it as a PDF, but not in Excel.   How do I fix this?   Is this an Excel setting that is preventing me from hyperlinking.  Thanks.
Keira
Top achievements
Rank 1
 answered on 04 Apr 2018
2 answers
731 views

In a stacked column graph (not the 100% one), is it possible to construct an expression that show the percentage of the amount of the series as expressed as a percentage of the total for the column, as per the attached?

Or do I have to do this in the SQL?

Scott Waye
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 03 Apr 2018
1 answer
139 views

I just installed a trial version and I am not getting the telerik menu when i am viewing a report in vs2017.

 

Telerik reporting: v12.0.18.227

VS2017 enterprise: v15.6.2

Momchil
Telerik team
 answered on 03 Apr 2018
3 answers
192 views

Hi to all,

something strange happens to me.

I have a report that contains a subreport. Subreport generates several records, each record is 1/4 tall of an A4 page.

If I try to render report into Visual Studio 2017 I see all correct, and if I try to save in RTF format it generates all.

But if I try to generate RTF file by code, if I open rtf file with Word content of subreport is truncated after some records.

What's happend?

01.public static Bundle SaveAsWord(string fileName, Bundle pBundle)
02.        {
03.            Bundle bundle = new Bundle();
04. 
05.            try
06.            {
07.                //Create new CultureInfo
08.                var cultureInfo = new System.Globalization.CultureInfo(pBundle.Get(2).ToString());
09. 
10.                // Set the language for static text (i.e. column headings, titles)
11.                System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
12. 
13.                // Set the language for dynamic text (i.e. date, time, money)
14.                System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
15. 
16.                Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
17. 
18.                // set any deviceInfo settings if necessary
19.                System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
20. 
21.                Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource();
22. 
23.                // reportName is the Assembly Qualified Name of the report
24.                typeReportSource.TypeName = typeof(OffertaVenditaBrema).AssemblyQualifiedName;
25.                typeReportSource.Parameters.Add("NumeroOfferta", pBundle.Get(1).ToString());
26.                typeReportSource.Parameters.Add("MostraPrezziListino", pBundle.Get(3).ToString());
27.                typeReportSource.Parameters.Add("MostraPrezziNetti", pBundle.Get(4).ToString());
28.                typeReportSource.Parameters.Add("SfondoGrigio", pBundle.Get(5).ToString());
29.                typeReportSource.Parameters.Add("TestoBianco", pBundle.Get(6).ToString());
30.                typeReportSource.Parameters.Add("MostraTabellaPrezzi", pBundle.Get(7).ToString());
31. 
32.                Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("RTF", typeReportSource, deviceInfo);
33. 
34.                //string fileName = result.DocumentName + "." + result.Extension;
35.                string path = System.IO.Path.GetTempPath();
36.                string filePath = System.IO.Path.Combine(path, fileName);
37. 
38.                using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
39.                    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
40. 
41.                bundle.Add(1, true);
42.                bundle.Add(2, filePath);
43.            }
44.            catch (Exception ex)
45.            {
46.                bundle.Add(1, false);
47.                bundle.Add(2, ex.Message);
48.                bundle.Add(3, ex.StackTrace.ToString());
49.            }
50. 
51.            return bundle;
52.        }

 

Silviya
Telerik team
 answered on 03 Apr 2018
1 answer
104 views

What is the purpose of CategoryGroup.Label as highlighted in the attached graphic?  I have a report with categories for each week of the year, but want to display the week start date not the week number.  So I thought I could set to Numeric scale using the week of the year (which comes from the SQL), but change the label to come from the week start date (also from the SQL), but this appears to have no effect.

Thanks,

 

Scott

 

Katia
Telerik team
 answered on 02 Apr 2018
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?