Telerik Forums
Reporting Forum
1 answer
122 views

Can Telerik report tool for HTML5 work with ASP.NET Web Forms using a Master page?

When I try the report does not display inside of the asp:Content, it displays on top of it.  Writing over some of the other content of the page.

 

 

 

David
Top achievements
Rank 1
Iron
Veteran
Iron
 answered on 07 Aug 2017
1 answer
378 views

Hi Experts,
I need to have a report break AFTER the PathwayId changes. I have used 2 queries/reports to get the desired results:
For the Header/Footer of the report which shows the Title, Description, Date and Score of each Pathway I used:

SELECT DISTINCT r.PathwayId,  p.Title, p.Description, s.Score, CONVERT(Varchar(10), s.CreateDate, 101) AS [Date]
  FROM ucare.Responses r
  INNER JOIN ucare.RiskScores s ON s.ScheduleId = r.ScheduleId
  INNER JOIN ucare.Pathways p ON p.Id = r.PathwayId
  WHERE r.ScheduleId = @Enc AND PathwayId IN (Select DISTINCT PathwayId FROM ucare.Responses
  WHERE r.ScheduleId = @Enc )and Score = (SELECT MAX(Score) FROM ucare.RiskScores
  WHERE ScheduleId = @Enc)
  GROUP BY r.PathwayId,  p.Title, p.Description,  s.Score, s.CreateDate
  ORDER BY r.PathwayId, p.Title

For the Detail section Sub-Report that will have the Questions and Answers per each Pathway I have used:

SELECT PathwayId, d.Label AS Question,
CASE WHEN Text = 'False' THEN 'No'
     WHEN Text = 'True' THEN 'Yes'
     ELSE Text END AS Answer, CONVERT(Varchar(10), EntryDate, 101) AS Entered
FROM ( SELECT p.PathwayId, p.Text, p.EntryDate, p.DecisionInputId,
      MAX(p.EntryDate) over (PARTITION BY p.PathwayId) AS Entered
      FROM ucare.Responses p
      WHERE p.ScheduleId = @Enc) t
  INNER JOIN ucare.DecisionInputs d ON d.Id = t.DecisionInputId
  WHERE EntryDate = Entered
  ORDER BY PathwayId

I’ve placed this report in the detail section with approximately 50 other sub-reports linked with the report parameters of @CaseNum and/or @Enc.

The diagram below is showing what I need this report to output:
Pathway_1_Title                           Date_Entered
      Question_1                          Answer_1
      Question_2                          Answer_2
      Question_3                          Answer_3
Pathway_1_Description                     Score
Pathway_2_Title                           Date_Entered
      Question_1                          Answer_1
      Question_2                          Answer_2
      Question_3                          Answer_3
Pathway_2_Description                     Score
Pathway_3_Title                           Date_Entered
      Question_1                          Answer_1
      Question_2                          Answer_2
      Question_3                          Answer_3
Pathway_3_Description                     Score

Any help or guidance will be appreciated. If you need anymore info please do not hesitate to ask.

Thank you,

Jack Willhoite

Katia
Telerik team
 answered on 07 Aug 2017
3 answers
859 views

I get this after upgrading to the latest reporting DLL's from RC1. I know this is a breaking change according to the following:

http://www.telerik.com/support/kb/reporting/details/telerik-reporting-r3-2016---upgrade-issues-with-objectdatasource-component

but I do not know where to put the information. I've tried the app.config, web.config but I still get the message. My project is using an HTML5 viewer in a .Net Core view and I just can't quite get it to work properly.

Thank you for any assistance,

Scott

Anatoliy
Top achievements
Rank 1
 answered on 04 Aug 2017
6 answers
283 views
Hi,

Can the WPF report viewer be used with the WCF service?  If so is there any example code for this?

Thanks,
Rob
Katia
Telerik team
 answered on 04 Aug 2017
3 answers
196 views

 I would separate every slice of the graph with a black line. How can I do it?

 

Thanks,

Angelo

Ivan Hristov
Telerik team
 answered on 04 Aug 2017
7 answers
388 views
Hi Support,

In my main report, I've several sub reports. One of those displays in multicolumn. However, this multicolumn subreport  displays only one long column even in HTML or PDF. I've tried to make it works like hours, but no luck.

Anyway, if I display that multicolumn report directly without including it in the main report, it works.

Any advice on this?

Thanks,
Sandy
Katia
Telerik team
 answered on 04 Aug 2017
2 answers
116 views

Good Morning,

I'm trying to add XLSX format for ours reports, we have Reporting Q2 2014.

I added OpenFormatXML.dll on my project, installed OpenXML SDK 2.0 on my computer and on our server.

Now I'm trying to add Telerik.Reporting.OpenXmlRendering.dll on our project with NuGet Package, all seems to be ok with the package creation.

When I install it on my computer all is working, I can export my reports on XLSX format all is ok. But when I push these modifications on the server and try to install this package on another computer there is a crash :

Severity Code Description Project File Line Suppression State Error Could not install package 'Telerik.Reporting.OpenXmlRendering 8.1.14.804'. You are trying to install this package into a project that targets '.NETFramework,Version=v4.5', but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author

On my computer the Nuget add this line in our packages.config

<package id="Telerik.Reporting.OpenXmlRendering" version="8.1.14.804" targetFramework="net45" />

So I don't understand what's the problem .... Could you help me please? 

Here my Nuspec file :

The dependencies is a packages which contains : Telerik.Reporting.dll and Telerik.Reporting.Service.dll

<package>
  <metadata>
    <id>Telerik.Reporting.OpenXmlRendering</id>
    <version>8.1.14.804</version>
    <title>Telerik.Reporting.OpenXmlRendering</title>
    <authors>XXXX</authors>
    <owners>XXXX</owners>
    <requireLicenseAcceptance>false</requireLicenseAcceptance>
    <description>Export telerik reporting to XML </description>
    <copyright>Copyright XXXXX</copyright>
    <dependencies>
     <dependency id="Telerik.Reporting.Assembly" version="1.0.0.1" />
    </dependencies>
    <references></references>
    <tags></tags>
  </metadata>
  <files>
    <file src="*.dll" target="lib\net45" />
  </files>
</package>

 

Thanks in advance for your help

Ben

 

 

Benjamin
Top achievements
Rank 1
 answered on 04 Aug 2017
3 answers
325 views

Hi,

We develop a wpf application and now our final users need to create them custom report, starting from an empty page and decide everything about the page layout.

I was wandering if is it possible to integrate telerik report designer (exe) into our application. Is it legally possible?

I was thinking about a button from the application that open your exe.

 

Thank you

Nasko
Telerik team
 answered on 03 Aug 2017
1 answer
461 views
Hi,

I need to pass the culture by parameter to a report (TypeReportSource), in the code behind (server side).
From the report side (server side) I need to get the culture passed by report parameter to the report itself.

I tried to to do this with the following code:
Dim cultureInfo As Globalization.CultureInfo = New Globalization.CultureInfo("pt-PT")
Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo Threading.Thread.CurrentThread.CurrentCulture = cultureInfo
 This works before the 'InitializeComponent()' function as expected, but I have no way of retrieving the report parameters at this stage because they weren't initialized yet.

The main idea is to replace "pt-PT" with the report parameter sent when the report was invoked.

The following code shows how I invoke the report and pass it the required parameters:
Dim clientReportSource As New Telerik.ReportViewer.Html5.WebForms.ReportSource clientReportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource clientReportSource.Identifier = "SIC.UI." & report & ", SIC.UI, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" clientReportSource.Parameters.Add("P1", p1) clientReportSource.Parameters.Add("P2", "pt-PT") reportViewer1.ReportSource = clientReportSource reportViewer1.Page.Title = report

I'm trying to do exactly what you guys have in this demo, but so far unsuccessfully.
I've been digging through the forums and documentation for a few days now and i just can't get this to work.

Any help would be greatly appreciated.

Thanks in advance,
Nuno.
Katia
Telerik team
 answered on 03 Aug 2017
4 answers
229 views

I have a cross tab where I would like to have a sub report that spans across the row groups on the left and across all column groups on the right.  This is tough because I don't know how many columns will end up because it depends on my data.

Is there anyway to make a sub report span row and column groups that it is flush with the left and right borders regardless of the number of columns?

Phil
Top achievements
Rank 1
 answered on 02 Aug 2017
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?