Telerik Forums
Reporting Forum
1 answer
177 views
we use Html5 report viewer in our web page, it works correct in 10.0.16.204, the toolbar show at the top of the report viewer page in that version. But the toolbar show at the bottom of the report viewer page after we update the report to latest version 10.2.16.1025, we use report viewer template to show the report, I update the template and set the toolbar html tag top of the content tag, it still doesn't work, could you help me fix this issue?
Katia
Telerik team
 answered on 22 Nov 2016
6 answers
240 views

I would like to know ,can i get sample.png style in Telerik reporting R2 2016 and R3 2016(lastest).I use Telerik reporting graph with object datasource to get this column  chart.If can't,how can i know differently this group by month.I also appologize for my english is not good. Thanks.

With Regards,

Shwe Yee

Shwe
Top achievements
Rank 1
 answered on 22 Nov 2016
2 answers
102 views

I am having a hard time getting a report to print to a Brother QL-1060N printer. The printer is using a 1 1/7" wide label roll that can print any length of label and it cuts when finished. Because it is 1 1/7" wide, everything is printed in landscape so that it is laid out properly on the label. However, since the label is longer than it is wide, it is technically Portrait orientation.

 

I have been trying every possible combination of printer settings for PaperSize = 1.14x3.54 or 3.54x1.14, Landscape property of the report = True/False, etc. When I send the report to the printer, it just kills the printer (flashing red light on printer, need to be reset). That error usually indicates an incorrect paper size sent to the printer. I am able to print a test page from Windows in both Portrait and Landscape orientation, but as yet, I have not been able to get anything to successfully print to the Brother printer from a report. Any guidance would be much appreciated!

Brian
Top achievements
Rank 1
 answered on 21 Nov 2016
22 answers
1.2K+ 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
362 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
1.9K+ 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.1K+ 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.0K+ 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
294 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
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?