Questions on Reporting Forum

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?

General Discussions

answered on 04 Apr 2018

9 answers

929 views

Hyperlink not working when Exported to Excel

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.

General Discussions

answered on 04 Apr 2018

2 answers

649 views

Show percentage as datapoint

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?

General Discussions

answered on 03 Apr 2018

1 answer

111 views

Missing Telerik Menu on new Install (vs2017)

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

General Discussions

answered on 03 Apr 2018

3 answers

154 views

SubReport truncated if export (by code) to RTF

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. }

General Discussions

answered on 03 Apr 2018

1 answer

69 views

X axis label from different field to value - CategoryGroup.Label?

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

General Discussions

answered on 02 Apr 2018

0 answers

192 views

Telerik Report not Showing in browser

Hi All,

I have telerik report 2018 r1 but after configuration it still doesnt show in browser.

below is the code

var reportSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();

reportSource.IdentifierType = IdentifierType.UriReportSource;

reportSource.Identifier = "test.trdp";

// reportSource.Parameters.Add("Date", DateTime.Today.AddDays(25));

ReportViewer1.ReportSource = reportSource;

General Discussions

asked on 01 Apr 2018

3 answers

250 views

Export to MS Word without grid

Hi to all,

I export to MS Word from a Report. This report is a quote document. Users show me a problem to manipulate simply the exported document in MS Word.

This problem is caused by rendering all TextBox (of report) into a grid layout of word. But where there is not a value, it not generates a cell.

User can't write into "ghost cell".

Can I void to generate MS Word using grid?

General Discussions

answered on 30 Mar 2018

1 answer

139 views

Issue with Parameters after upgrading version

I was using Telerik 2014 Q2 SP1 and upgraded my report to 2018 R1 and one of my reports does not show a parameter I am passing down.

Report A has a subreport (Report B) and Report A creates a parameter for Report B

instanceReportSource1.Parameters.Add(new Parameter("SampleParameter", "=Fields.SampleParameter"));

In my code for Report B I want to pull the parameter value that is being passed in order to filter some data, so I have:

var param = Convert.ToInt32(this.ReportParameters["SampleParameter"].Value);

This worked just fine before and instead of this.ReportParameters["SampleParameter"].Value having a value it just says the value is "=Fields.SampleParameter".

Was there a change in how parameters were retrieved or accessed in this way?

General Discussions

answered on 29 Mar 2018

2 answers

300 views

Custom Toolbar for the WinForms ReportViewer?

Is it possible to make a custom toolbar, with different icon images, etc. and drop downs similar to the one outlined in the article for the Web ReportViewer (custom-toolbar-for-the-web-)?

thanks.

General Discussions

answered on 29 Mar 2018