Telerik Forums
Reporting Forum
2 answers
167 views

Hi there,

I have a report showing a publisher/supplier relationship. The master is a simple table report grouped by publisher. There is a drill down on the table, which then shows a breakdown grouped by supplier. Both master and detail report tables have the same columns.

Want I want to do is have a toggle on the master report that can hide particular columns. I have achieved this on the master report by having a textbox with a toggle visibility action - if it is , certain columns disappear, but of course, if the user drills down to the supplier details, the columns are still displayed in the sub-report.

Is there any way of setting up a toggle visibility option that will affect both the master and detail reports?

Kind Regards,
Martin.

Katia
Telerik team
 answered on 17 Nov 2016
2 answers
393 views

Hey guys,

I'm trying to create a single report, which shows multiple reports. The idea is, I have an InvoiceReport at the moment, and I built a Scheduler, that needs to generate all the reports of the month. So in this Scheduler I render all the reports and attach them to a bookReport, then I create the file. 

We have to render around 3000-5000 reports into a file, but when using bookReport, you have to render each report individually first and then attach to the bookReport, and it takes 1-2 seconds to render each report individually. The data sources inside that report are really fast, so the problem becomes the render.

That's why I need to create a single report to render all the InvoiceReport without using bookReport. I found the SubReport control, but it doesn't render the Header/Footer.

 

Does anyone know how to solve this problem? To render many reports inside a "master report" without using bookReport.

 

Thanks

 

Gustavo
Top achievements
Rank 1
 answered on 16 Nov 2016
6 answers
1.4K+ views
I have my own DAL and BLL I want to use with Telerik Reporting but the documentation is vague on using ObjectDataSource and binding it to a report, etc.  Do you have a sample of using a BLL that returns say a DataSet for the report?
JOSE
Top achievements
Rank 1
 answered on 16 Nov 2016
5 answers
315 views

I've created a Telerik report and my datasource is pointing to a stored procedure in sql server.  However, when executing the report I get the following error:

Procedure or function '​ABC123' expects parameter '@CustomerLocationID', which was not supplied.​

When going through the "Configure" option for the datasource, the correct report parameters are mapped to the stored procedure parameters.

When testing the stored procedure call through the "Configure" option, the resultset is returned, as expected, but when running the report through the application, I get the above error.  See the attached images for parameter mapping.

 Thanks.

Doug
Top achievements
Rank 1
Veteran
 answered on 16 Nov 2016
5 answers
307 views

TLDR - Is there a way to set the minimum number of pages for a report to print on, just so that the page header and footer will print a known number of times?

More detail:  I've got an issue in that I have two distinct sets of data to integrate into one report.  One is a list of invoice lines, and one is a list of shipping labels, both to be printed on the same page(s).

The simplest solution I have that is almost workable is to put a picture box in the page footer.  I have set the image URL to: = ReportItem.Report.ItemDefinition.Transaction.OrderNumber + "-" + PageNumber + ".png".  If there is only one shipping label and one page worth of transaction lines, then it will work fine.  If by some stroke of luck there are two shipping labels and two pages of transaction lines, then it will also work.  In most other cases, the user will get one shipping label and will have to open up the shipping software to "reprint" the other labels.  This isn't the worst thing in the world, because the vast majority of the orders they ship have exactly one shipping label, and just combining the shipping label and invoice/packing slip onto one page is a huge improvement in their workflow.  Is there, by chance, a way to specify a minimum number of pages for the report?  If so, I could programmatically set the number of pages equal to the number of shipping labels.  There will be some pages with no invoice lines printed, but the report would happily reprint the page header and footer and it would work perfectly for my purposes.

Alternately, if someone would like to enlighten me on the actual proper way to do this (a report with two sets of data with different page count requirements), I'd be happy to hear it.  However, it would be much easier if I could just set the minimum number of pages...

Stef
Telerik team
 answered on 16 Nov 2016
3 answers
642 views

I am trying to use telerik report viewer version 7.1.13.612.

I am encoutering the followig issue at run time.

Please help

Invalid report type
Value cannot be null.
Parameter name: type
at Telerik.Reporting.Processing.TypeReportDocumentResolver.Resolve(IReportDocumentResolverContext context, TypeReportSource rs)
at Telerik.Reporting.Processing.ReportDocumentResolver`1.Telerik.Reporting.Processing.IReportDocumentResolver.Resolve(IReportDocumentResolverContext context, ReportSource rs, Boolean loadParameters)
at Telerik.Reporting.Processing.ReportDocumentResolver.<>c__DisplayClass1.<Resolve>b__0(IReportDocumentResolver r)
at Telerik.Reporting.Processing.ReportDocumentResolver.Bind[T](ReportSource source, Func`2 func)
at Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IReportDocumentResolverContext context, ReportSource source, Boolean loadParameters)
at Telerik.ReportViewer.WebForms.ParametersPage.ResolveReportDocument(ReportSource reportSource)
at Telerik.ReportViewer.WebForms.ParametersPage.get_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)

Animesh
Top achievements
Rank 1
 answered on 16 Nov 2016
1 answer
50 views

Hi Team,

I am new to telerik controls usage. I want to create a report and need your help here, if you can provide me any solution which has simple reports created .

Suppose my table has column EmpId,Name,Age,Salary and

in Report also we need to show this in table.

I have a button , when i will click on button , this report should be opened.

Can you please provide me any demo of these kind of telerik report design/devopment ?

Katia
Telerik team
 answered on 16 Nov 2016
6 answers
178 views

Hi,

Say I have two reports, one that is a list of companies and one that is a list of staff, from the company report I want to click one of the rows and open the staff report to show all people in that company. I have got the click action working fine ie. I can run the staff report by clicking a company name but I can't figure out how to filter the data.

I would imagine that the staff report needs a parameter "company" that would get passed to it when a company is clicked but I can't see how to do this - is it possible?

Al
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 16 Nov 2016
1 answer
93 views

Hi - We're a product company and are evaluating a new reporting platform.  There's a few questions I can't seem to clearly resolve via documentation.  I'd appreciate it if you could clarify!

1)  Our product needs to provide a runtime report designer to our customers.  So, in ref to your stand-alone report designer:
  a.  Can we extend / customize display controls and offer them as part of the stand-alone designer?  I've already seen that data providers are customizable.
  b.  Can users load / edit / save reports in the stand-alone designer via in-memory structures only, i.e. no files / file system involved at all?  We need to move report definitions in and out of our database with no file system involvement.
  c.  Is it possible to customize other parts of the stand-alone designer?  I.e. toolbars, toolbar event handlers, etc.

2)  Can your reports be exported to native DOCX?  I'm not referring to RTF that'll open in MS Office, etc.  Referring to native DOCX here.

I need to determine the basics here before dedicating some time to an eval, so thanks for any info!

Katia
Telerik team
 answered on 16 Nov 2016
1 answer
393 views

Hi Guys,

 

I have a data structure like this:

 

Headers

ID  Desc
1   Head1
2   Head 2

------------------------------------------

Lines

ID   HeadID
1    1
2    1
3    1
4    2

 

Etc. is there a possiblity to handle this inside on report so that it shows the header + the lines for this header and then breaks the page and continues with the next header?

Also is there a way to show the page no not based of the total pages but based of the "sub documents" e.g. page per Header in my case?

 

Cheers

 

Katia
Telerik team
 answered on 16 Nov 2016
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?