Questions on Reporting Forum

5 answers

71 views

Export Report to Excel. Excel Skipping Every Other Row Around Row 120

Hey Guys,

I'm generating a report, but I'm fairly new to it still. I followed instructions to make sure everything was lined up perfectly so when it was downloaded to Excel it wasn't making rows different sizes and what not. Nevertheless, everything is looking great except I have a weird issue where once I get to about row 120 in Excel it starts skipping every other row. Any ideas? (screenshot attached - in this case it starts at row 125)

General Discussions

answered on 02 Sep 2015

3 answers

166 views

hidden panel, spacing

Hello

I have two columns of textboxes with a panel in between.

When I turn of visibility of the panel, the textboxes to the right shifts position towards left.

Is there a way of taking the panel out of influence? (bring to front, doesent work)

Regards

Mark

General Discussions

answered on 02 Sep 2015

3 answers

502 views

Checkbox or picturebox in table

Is it possible to display a picturebox or checkbox in a table in a report? The data source has a column that contains a binary image, and there is also a bit field that is used to indicate yes/no. I believe I can do it programmatically, but is there any way to create this declaratively?

General Discussions

answered on 01 Sep 2015

14 answers

945 views

Problem with ReportViewer rendering in IE

Hi,

I am using version 6.1.12.611 of Telerik.Reporting.DLL

I have created a dll with all my reports in it that the ReportViewer uses. (see below for code)

When displaying the web page in Visual Studio's Development server, the reports render correctly.

When displaying the web page from the production server (IIS 6) in a Chrome browser, the reports render correctly.

But when displaying the web pages in IE(V10, 9, 7), the Report viewer is BLANK. The page count still says 1 of 5, and you can scroll through 5 blank pages. Also, if you export to PDF, when you open the PDF file on a computer, it looks just fine; no blank pages.

Any ideas?

Thanks for your assistance!

-Chuck Bryan

PS: This was all working correctly under Telerik Reporting v 6.0.12.215 before I updated to the latest versions of all Telerik products...

.aspx page

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="PrintPreview.aspx.vb" Inherits="MAdmin_PrintPreview" %>

<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=6.1.12.611, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

<style type="text/css">

form#form1, div#content

{

height: 100%;

}

</style>

</head>

<body>

<form id="form1" runat="server">

<div id="content">

<telerik:ReportViewer ID="ReportViewer1" runat="server" Height="100%" Width="100%" ShowDocumentMapButton="False" ShowHistoryButtons="False" ShowRefreshButton="False" ShowZoomSelect="True" ViewMode="PrintPreview" ReportBookID="ReportBookControl1">

</telerik:ReportViewer>

<telerik:ReportBookControl ID="ReportBookControl1" runat="server">

</telerik:ReportBookControl>

</div>

</form>

</body>

</html>

.aspx.vb

Private Sub RptSet01()

Dim fs As Integer

Dim x As Integer

Dim rBook As New ReportBook()

fs = S.PrintSize

SigFull = P.ANO

SigIntRec = P.CFS

x = 0

' Create the Command and the Connection.

Dim connectionString As String = WebConfigurationManager.ConnectionStrings("DBString").ConnectionString

Dim con As MySqlConnection = New MySqlConnection()

con.ConnectionString = connectionString

Dim sql As String = SelString

Dim cmd As MySqlCommand = New MySqlCommand(sql, con)

' Open the Connection and get the DataReader.

con.Open()

Dim reader As MySqlDataReader = cmd.ExecuteReader()

Do While reader.Read

Select Case fs

Case 1

Full10Bt1ns(rBook, reader("RecordID"))

Case 2

Full12Bt1ns(rBook, reader("RecordID"))

Case 3

Full11Bt1ns(rBook, reader("RecordID"))

Case Else

Full10Bt1ns(rBook, reader("RecordID"))

End Select

rBook.Reports(x).PageNumberingStyle = PageNumberingStyle.ResetNumberingAndCount

x += 1

Loop

reader.Close()

con.Close()

ReportViewer1.Report = rBook

End Sub

Private Sub Full10Bt1ns(ByVal rBook As ReportBook, ByVal TheUserID As Integer)

Dim ConnectionString As String = WebConfigurationManager.ConnectionStrings("DBString").ConnectionString

Dim theAdapter As MySqlDataAdapter

Dim sql As String = SelString2

theAdapter = New MySqlDataAdapter(sql, ConnectionString)

Dim Report1 As New Reporting.tFull10Bt1ns

Report1.ReportParameters("1").Value = Dem1

Report1.ReportParameters("2").Value = Dem2

Report1.ReportParameters("3").Value = Dem3

If P.PrintDocument = 1 Then

Report1.ReportParameters("Sig").Value = SigFull ' SET FOR SIGNATURE LINES

Else

Report1.ReportParameters("Sig").Value = SigIntRec ' SET FOR SIGNATURE LINES

End If

Report1.DataSource = theAdapter

rBook.Reports.Add(Report1)

End Sub

General Discussions

answered on 01 Sep 2015

6 answers

1.1K+ views

Telerik Reporting - Html.TelerikReporting() not found

HI

I'm trying to write a simple Telerik Reporting project but met some diffcults :

New > Project > ... > Telerik C# ASP.NET MVC Application
New > New Item > ... > Telerik MVC Report Viewer Page Q2 2015 (Sample report definition)

Build the project there have no any failed :

========== Build: 2 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

But the Error List show lots of errors after open ReportViewerView1.cshtml :

Error CS0103 The name 'ViewBag' does not exist in the current context CSharp.MvcDemo C:\Program Files\Telerik\Reporting Q2 2015\Examples\CSharp\MvcDemo\Views\Home\Index.cshtml 6
...
...
Error CS1061 'HtmlHelper' does not contain a definition for 'TelerikReporting' and no extension method 'TelerikReporting' accepting a first argument of type 'HtmlHelper' could be found (are you missing a using directive or an assembly reference?) CSharp.MvcDemo C:\Program Files\Telerik\Reporting Q2 2015\Examples\CSharp\MvcDemo\Views\Home\Index.cshtml 202

And the errors disappears after close ReportViewerView1.cshtml.

Why ? The bug of Visual Studio 2015 ??

Then move the \ReportViewerView1.cshtml into Views/Home, rename to Index.cshtml, the runtime error occurred after Start Debugging :

... CS1061: 'System.Web.Mvc.HtmlHelper<dynamic>' not contains 'TelerikReporting' ...，... 'TelerikReporting' 來接受類型 'System.Web.Mvc.HtmlHelper<dynamic>' ...

...:

Line 27: }
Line 28:
Line 29: @(Html.TelerikReporting().ReportViewer()
Line 30: // Each report viewer must have an id - it will be used by the initialization script
Line 31: // to find the element and initialize the report viewer.

*The Telerik Reporting Q2 2015 Examples have the same problem but it can run report normally :
C:\Program Files\Telerik\Reporting Q2 2015\Examples\CSharp\MvcDemo\Views\Home\Index.cshtml

Visual Studio 2015
ASP.NET MVC 5
.NET Framework 4.6

Best regards

Chris

General Discussions

answered on 01 Sep 2015

1 answer

224 views

Executing oracle stored procedures in packages

Hello, I am trying to run a stored procedure which is located within an oracle package. The report wizard does not locate these stored procedures, so I have tried to write an SQL statement which should execute it. However when I test it, no rows are returned (no error messages given).

What is the correct syntax to achieve this?

This is my current attempt:

DECLARE
P_VAR1 NUMBER;
P_VAR2 NUMBER;
p_cursor sys_refcursor;

BEGIN
P_VAR1 := 123;
P_VAR2 := 456;
p_cursor:= NULL;

NII.MYPACKAGE.MY_PROCEDURE( P_VAR1, P_VAR2, p_cursor);
COMMIT;
END;

General Discussions

answered on 01 Sep 2015

4 answers

1.0K+ views

Setting Graph Colors

Hi

I have the following problem: A Report containing graphs (a pie and a bar) which show the status of objects.
This status can be canceled, ok, delayed,…
I want to set the shown color of the graphs corresponding to the status:
Ok = green
Delayed = orange
And so on.
If I set the ColorPalette to the desired Colors everything is fine until a status is missing (no object has the status OK) then green is used for the delayed Status and so on.
Is there a way to enforce the same color for a certain attribute value, even if another attribute value is missing?

Thanks for any help

Report Designer (standalone)

answered on 31 Aug 2015

3 answers

291 views

When are parameters resolved

I'm need to progromatically change some things in a report based on external conditions. I've created a non-visible parameter and I'm setting that parameter value from outside the report. However, I'm never seeing the parameter being set to anything but the default expression string from either the report constructor or the ItemDataBinding event. When in the cycle are report parameters bound to their values, and how can I hook into that?

General Discussions

answered on 31 Aug 2015

2 answers

318 views

Break line in cell table

Hi,

I have a field biding to data and put it in to table "Example 1, Example 2, Example 3".

I want it auto break line in cell:
Example 1
Example 2
Example 3

It's a possible in table? who can hlep me.

thanks a lot!

General Discussions

answered on 29 Aug 2015

9 answers

111 views

Reporting WCF Self Hosting Service

Hi,
I have a telerik reporting WCF self host service to show the report with silverlight report viewer. I noticed that the WCF function fire twice when I run the report.
can anyone tell me the cause.

Thanks in advance
Chandan

General Discussions

answered on 28 Aug 2015