<%@ 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>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 = rBookEnd SubPrivate 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 SubHello, 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;
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
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!
Hi all,
I have a TRDX report, and several chart diagrams on it. But since I create and form datasource for report dynamically in code-behind, I would like to know whether it is possible to bind the additional datasource in code-behind dynamically to the chart, without setting it in Telerik Report Designer?
I have a MVC project. I created a report successfully, but I can't get a report viewer to work. In my view I have the line
@(Html.TelerikReporting().ReportViewer()When I run the project, I get the error
CS1061: 'System.Web.Mvc.HtmlHelper<dynamic>' does not contain a definition for 'TelerikReporting' and no extension method 'TelerikReporting' accepting a first argument of type 'System.Web.Mvc.HtmlHelper<dynamic>' could be found (are you missing a using directive or an assembly reference?)I've tried setting CopyLocal = True on all the Telerik references, copied all the Telerik reporting files to the bin folder, added using lines to the view, but nothing seems to work. I'm about to give up on Telerik reporting. Any suggestions on what I can do to get this to work?