Hi,
Finally discovered why some of my stored procedures are not returning the right list of columns on the Report Designer...
It's because the engine is sending "SET FMTONLY ON" to the SQL Server to get the list of columns... the big problem is this don't work when we use Temporary Tables inside of the store procedures (SPs).
I start to add SET FMTONLY OFF on the SPs that are being used on the Reports.
I would like to know if the use of this workaround have any other implications on the reports engine and I can continue to using it?
Thank You
Hi,
Attached is a picture where we can notice like a random position of the bars along the series.
How to center the bars on the middle of the series? and if possible define a width for them?
Thank you
Hi there,
I'm currently in the process of creating an invoice document and seem to have hit a bit of a stumbling block.
My report (a sales invoice) is based on a view which is looking at data derived from 2 tables:
InvoiceHead - a single record per job listed on the invoice.
InvoiceLines - a record per line on the invoice (each job COULD have multiple lines)
The issue I've run into is that carriage is only recorded at the Head level... which means I can't simply sum it up.
To get around this in Crystal (which I've been using for pushing 20 years now), I'd either:
create a running total which would add the carriage value in when the InvoiceHeadID changes
or
create a numberVar and manually add the value when required.
... but I can't see any way to do either of these in the designer and Google doesn't seem to have any apparent examples.
Any help will be gratefully appreciated.
Cheers in advance,
Mat
Question for the forum.
When creating 1D barcodes, which Module value works best?
I am experimenting around and found the following but am looking for others to reply as to what they are having success with (using Code128).
Stretch = Not liking this as it fills the entire container and is resulting in difficult to read barcodes as the bars become to wide.
1pt = Seems to look correct, but I am finding it troublesome to scan with inexpensive readers.
1px = Seems to look correct, seems to scan ok...but can be troublesome sometimes.
So what are the recommend settings to use to ensure a good consistent read?
I am developing labels to go on products and they need to be able to scan properly the first time everytime.
Using the HTML5 ReportViewer in MVC
Aiming at finding a way to force the whole report to display in just one long scrolling page without interfering with how it may show up when printed.
The report being displayed is in a reportbook which switches between landscape and portrait orientation and it made up of ~ 19 report/subreports.
What is happening is that certain page breaks are showing up that push the contents onto additional pages even though the viewer is in ViewMode.Interactive .
Is there a listing anywhere of what reporting elements/settings/etc may be causing these breaks even in Interactive mode?
Is there any way to truly force the reportviewer to have everything on only a single page?
Here's the viewer code being used:
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Telerik MVC HTML5 Report Viewer</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<link href="http://kendo.cdn.telerik.com/2015.3.930/styles/kendo.common.min.css" rel="stylesheet" />
<link href="http://kendo.cdn.telerik.com/2015.3.930/styles/kendo.blueopal.min.css" rel="stylesheet" />
<script src="@Url.Content("~/ReportViewer/js/telerikReportViewer.kendo-11.0.17.118.min.js")"></script>
<style>
#reportViewer1 {
position: relative;
width: 1300px;
height: 900px;
font-family: Verdana, Arial;
}
</style>
<script src="@Url.Content("~/ReportViewer/js/telerikReportViewer-11.0.17.118.min.js")"></script>
</head>
<body>
@(Html.TelerikReporting().ReportViewer()
.Id("reportViewer1")
.ServiceUrl(Url.Content("/api/reports"))
.ReportSource(new TypeReportSource() { TypeName = "ReportLibrary1.ReportBook_Oriented, ReportLibrary1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" })
.ViewMode(ViewMode.Interactive)
.ScaleMode(ScaleMode.Specific)
.Scale(1.0)
.PersistSession(true)//NOTE: If this is False it clears the site sessions so it may no longer be used
.PrintMode(PrintMode.AutoSelect)
)
</body>
</html>
Hi,
I want to print pageHeaderSection on clicking of print button which is visibility is set to false on design time in telrik using mvc or web application VS 2010.
Hi everyone,
I want export report to PDF and Save file windows appear when i click the button in my page. That mean i hide report viewer or don't load data on this viewer.
Because my report really lagre data with 4-5000 pages so when i load report, my report viewer show error Memmory Error and i can resolve it.
Please help me!