Telerik Forums
Reporting Forum
22 answers
1.3K+ views
Is there any way to intercept the parameters passed to the default ReportsController, using the ReportFileResolver()?

I have some configurable parameters to my report (start date, end date) but I am also passing the UserId, which I would like to not expose to the client and insert the parameter value on the server using the cookie. 

Is this possible?

Thank you.
Stef
Telerik team
 answered on 21 Nov 2016
3 answers
1.1K+ views

Hello, i just started using Telerik and im creating a project using MVC 5, I use the HTML5 viewer using the add item to the project and when i go ahead and do that i select a report i have previously made on the standalone designer but when i try to run it i get the

"Warning: Connection string with name 'Server=127.0.0.1;Database=identity;Uid=root;Pwd=qwerty123;' is missing in the application configuration file."

On the web.config of the MVC project itself i do have that exact connection string, like this:

<connectionStrings>    <add name="DefaultConnection" connectionString="Server=127.0.0.1;Database=identity;Uid=root;Pwd=qwerty123;" providerName="MySql.Data.MySqlClient" />  </connectionStrings>

Can someone help me please? Is there a way i can set up the connection string from where the report will connect to manually somewhere in the mvc project?Been stuck some time with this. Thanks in advance.

Stef
Telerik team
 answered on 21 Nov 2016
2 answers
427 views

I had problems trying to print when I updated the Telerik dlls from 2008.  There was an issue discussed in some threads regarding the orientation in 

http://www.telerik.com/forums/printing-report-on-label-printer-wrong-orientation in which Stephan states

"Please download and test the latest available Telerik Reporting Q2 2014 SP1 version 8.1.14.804, where we included modifications in the print mechanism for WPF and WinForms ReportViewer controls."

 

I am struggling with he latest version of the software to make this work. Please help

Here is a snippet of vb which worked up to 2013 

 

 

Dim rpt As New CLCertReports.Assetlabel1(mID, mPartnerID, mIdent, mSerial)
Dim mInstanceReportSource As New Telerik.Reporting.InstanceReportSource()
mInstanceReportSource.ReportDocument = rpt
Dim printerSettings As New System.Drawing.Printing.PrinterSettings()
printerSettings.PrinterName = System.Configuration.ConfigurationManager.AppSettings("LabelPrinter1") '"TECB-452"
Dim printController As System.Drawing.Printing.PrintController = New System.Drawing.Printing.StandardPrintController()
Dim reportProcessor As Telerik.Reporting.Processing.ReportProcessor = New Telerik.Reporting.Processing.ReportProcessor()
reportProcessor.PrintController = printController
Me.ReportViewer1.ReportSource = mInstanceReportSource
reportProcessor.PrintReport(mInstanceReportSource, printerSettings)

 

The label renders on the ReportViewer fine and if printed with the dialogue prints fine.  However, it still tries to print portrait over two labels in code behind and if i change the .ReportDocument.PageSettings.Landscape settings then it clips the label and does not print properly from the ReportViewer.

What am I doing wrong and how do change the above code to make this work

 

Many thanks

 

 

 

Katia
Telerik team
 answered on 21 Nov 2016
4 answers
2.0K+ views

Hi Everyone

I recently registered for the free trail, wanting to use the product for report automation. After creating the template in the standalone report designer, I want to export grammatically. However i get following error on the unpack method:

Cannot read a document with the specified schema: http://schemas.telerik.com/reporting/2012/4.1.
You might be using an older version of the product.

Not sure where to go from here.

using (var sourceStream = System.IO.File.OpenRead(Server.MapPath(Url.Content("~/Forms/DebitForm.trdp"))))
{
 var report = reportPackager.Unpackage(sourceStream);
}
Paul
Top achievements
Rank 1
 answered on 18 Nov 2016
3 answers
1.2K+ views

Is there a way to include the Selected Values from a Multi-Value parameter in the report, when just using the stand-alone designer?

I have seen posts that discuss creating user functions in Visual Studio, but no solution for those of us who need to create reports using the stand-alone designer.

Is this possible? I am using Version 10.2.16.1025

Thanks,

Cecilia Daniels

Katia
Telerik team
 answered on 18 Nov 2016
2 answers
2.2K+ views

I keep getting "missing or invalid parameter value" "please input valid data for all parameters" when previewing my report. I've set up a SqlDataSource with the "Configure.." wizard. I have two parameters, both of type int/integer/Int32. When I run the "Excecute query" in the Configure-wizard I get the expected result in the results list. But, when I preview the report I get "missing or invalid parameter value" "please input valid data for all parameters"...

 

I've checked every parameter mapping in the report and everything looks ok.

I've attached the report causing this.

What could cause this?

 

//Thomas

Stef
Telerik team
 answered on 17 Nov 2016
1 answer
335 views

I have a table called Components that is hierarchical; each item has a ParentId that is either NULL if it's a top-level item, or populated with the Id of its parent Component.  I also have a table called Requirements with an OwningComponentId field, which connects each one to a Component. 

Unfortunately, there is no limit to how deep the tree can go, nor is there a limit to how many siblings an item can have. 

My report needs to be able to select a Component (ideally any component, not just top-level) as a parameter, and display aggregates for it as well as each of its children, on down to the leaves.  One thing I do know is that only the leaves (Component with no children) will actually have Requirements associated with them.  For the rows of the report showing the leaves, it should show the aggregates for that leaf.  For each parent row, it should show the aggregates for all that parent's children. 

I've seen some other threads, such as http://www.telerik.com/forums/cross-tab-report-with-a-self-referencing-hierarchy .  I was able to get that example to work.  However, that one does not show any aggregates or detail rows for each item, and I can't seem to figure out how to add those in in the way I need. 

At one point I had a query that returned all the rows with aggregate data for the leaves (still didn't have aggregates for parents) computed directly on the database, but for some reason the report would repeat the entire set of data once for each of my Components.  If there were say 125 components in the hierarchy, then the entire table was repeated 125 times.  I also realized from monitoring the db that for some reason the report was calling the same stored proc on the db 126 times (once and then once again for each component).  I have a feeling I had something wrong with my grouping but couldn't figure it out.  Is there some logic in there that says to call the stored proc once to get the Group items, and then call it again for each group?  I saw no such logic in my DataSource definition (which by the way is a SqlDataSource calling a Stored Proc that I wrote). 

I would greatly appreciate any help you can give on how to do this.  I've been working on this for a few weeks now with little progress, and am at the end of my rope! 

Chris

Stef
Telerik team
 answered on 17 Nov 2016
2 answers
211 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
438 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.5K+ 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
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?