Questions on Reporting Forum

1 answer

56 views

Report design

Hi

I am new in telerik reporting.i was create one report in webapplication
i have 12 text boxes in report . i need to arrange properly becz if i export to excel
the report will be collopsed and the text should not comes into single cells
how to arrange report rows into stright line

i cant able to paste screen shot?

Regards,
Abdul Ajees

General Discussions

answered on 25 Jun 2009

1 answer

198 views

Passing parameters from Grid to Report

I need the ability to pass a RecordID to a report from a grid. The report is defined in a separate class (with a reference in the project containing the web forms) with the following code behind:

Imports System.ComponentModel
Imports System.Drawing
Imports System.Windows.Forms
Imports Telerik.Reporting
Imports Telerik.Reporting.Drawing
Partial Public Class GoalsCalculatorReport
    Inherits Telerik.Reporting.Report
    Public Sub New()
        InitializeComponent()
        Me.DataSource = Nothing
    End Sub

    Private Sub GoalsCalculatorReport_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.NeedDataSource
        'Transfer the ReportParameter value to the parameter of the select command
        Me.SqlDataAdapter1.SelectCommand.Parameters("@PandLID").Value = Me.ReportParameters("PandLID").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@NetProfitGoal").Value = Me.ReportParameters("NetProfitGoal").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@RaiseFeesByPct").Value = Me.ReportParameters("RaiseFeesByPct").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@IncreaseCrownsPerWeek").Value = Me.ReportParameters("IncreaseCrownsPerWeek").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@ImproveAcceptanceRatePct").Value = Me.ReportParameters("ImproveAcceptanceRatePct").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@ReduceOverheadExpensePct").Value = Me.ReportParameters("ReduceOverheadExpensePct").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@IncreaseNewPatientsFromMarketing").Value = Me.ReportParameters("IncreaseNewPatientsFromMarketing").Value
        Me.SqlDataAdapter1.SelectCommand.Parameters("@IncreaseNewPatientsFromReferrals").Value = Me.ReportParameters("IncreaseNewPatientsFromReferrals").Value
        'Take the Telerik.Reporting.Processing.Report instance and set the adapter as
        'it's DataSource
        Dim report As Telerik.Reporting.Processing.Report = CType(sender, Telerik.Reporting.Processing.Report)
        report.DataSource = Me.SqlDataAdapter1
    End Sub
End Class

And I've been using the following code to send grid data to another web form. I just don't know how to use a value from the grid in a report such that when I click on (a button on) a separate record of a grid, the report will show me the data for that particular record.

    Protected Sub RadGridPLPS_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGridPLPS.ItemCommand
        Dim itmITEM As Telerik.Web.UI.GridDataItem = CType(e.Item, Telerik.Web.UI.GridDataItem)
        Dim cell As TableCell = itmITEM("PandLID")
        '        Response.Write(cell.Text)
        Select Case e.CommandName
            Case "Edit"
                Context.Items("PandLID") = cell.Text
                Server.Transfer("PLPStatEntry.aspx")
            Case "Summary"
                Context.Items("PandLID") = cell.Text
                Server.Transfer("Summary.aspx")
            Case "Analysis"
                Context.Items("PandLID") = cell.Text
                Server.Transfer("PracticeAnalysis.aspx")
        End Select
    End Sub

I would also like to use a similar process to be able to send data from the same web form (that contains the report viewer control) to the report. For example to create my own selection criteria fields and pass them to the report.

Thank you

General Discussions

answered on 24 Jun 2009

3 answers

118 views

grabbing correct info from SQL database

I have 3 tables that I need to pull information from for the report I'll be making (using Telerik Reporting).
tblCWMods (fields ProjectID, Phase, JobName, Dealer, etc.), tblCWModItems (fields ProjectID, Phase, LetterID, Modification), and tblCWModFiles (fields ProjectID, Phase, LetterID, downloadName, description). In my report I need the info from tblCWMods as the main part or grouping. For each report there will only be one main group. Within that, I may have several entries from tblCWModItems (related by ProjectID & Phase to tblCWMods) each having a unique LetterID. Within those groups there may be several entries from tblCWModFiles (related by LetterID to tblCWModItems). So my groups should be like this in the report:

ProjectID & Phase & JobName, etc (tblCWMods)
        LetterID & Modification (tblCWModItems)
                downloadName & description (tblCWModFiles)
        LetterID & Modification (tblCWModItems)
                downloadName & description (tblCWModFiles)

I'm just wondering how I would go about grabbing all this information from my sql database and then apply it to a new report. I think I'm talking myself in circles on this one and have confused myself!! :)   I'm using vb.net 2008 and I'm a beginner using Telerik Reporting. So any information would definitely be appreciated!! Please let me know if any other information is needed. Thanks in advance.

General Discussions

answered on 24 Jun 2009

2 answers

1.3K+ views

How to give page number in page footer of report

Hi
I want to give page number in each pages footer.how can i achieve this?
Please help.

General Discussions

answered on 24 Jun 2009

2 answers

92 views

Telerik Subreport for each line item

I am using Linq to SQL to populate generic non LINQ classes to display report data. I created a method to return a List<T> of the class to the Report Datasource in the report constructor. I also have a subreport in the details section of my report where I want to populate with data related to each line item of the main report. The problem is the NeedDataSource is only called once and results in the first line item contains nothing in the subreport and every line item after that has data from the first line item.

My question is, how do I get a subreport in the details section to contain data related to its containing line item?

General Discussions

answered on 23 Jun 2009

1 answer

212 views

Extract MS Word OLE object from SQL Server BLOB

Hi,

I would like to migrate some complex reports from Crystal to telerik. But one feature gives me a headache.
We have created hundreds of text modules containing preformatted text with MS Word and stored them in a BLOB column as OLE Object. Crystal ist able to extract those OLE objects and renders them to display them in the report.
Can this also be done with telerik?

Best Regards,
Stefan

General Discussions

answered on 23 Jun 2009

5 answers

189 views

Passing Parameters - breaks on the server

After struggling with passing in parameters for several days, I finally got it to work perfectly when on my local machine. However, when I deploy it to the server, it doesn't seem to passing the parameter correctly. No data appears in the report. This is how I'm passing in the parameter from my aspx page. (SummaryReport is the name of my Report.) Is there a reason that this would work locally, but not on the server? Help, I'm so frustrated!

Dim RID As Integer

RID = Request.QueryString("RID")

Dim Report As Telerik.Reporting.Report

Report =

New SummaryReport

Report.ReportParameters(0).Value = RID

Me.ReportViewer1.Report = Report

General Discussions

answered on 23 Jun 2009

1 answer

74 views

from filtered grid to report

hi

I am trying to create the following web app scenario, my user on a web page plays around with a linq based grid , filtering, ordering etc, then they choose to run a report based on the records they have in the grid.

Any good example(s) of sending in the resultant linq data set to a telerik report to produce this

thanks
kevin

General Discussions

answered on 23 Jun 2009

1 answer

84 views

Visual Studio 2008 Report Editor strange behavior with the keyboard

Hello again Telerik friends,

I have a strange situation going on when creating reports with the Editor for VS2008... But first thing first, my system config:

Telerik Reporting 2008 Q2

Windows XP - English

Keyboard config - Portuguese.

Now, when I open an editor tab in the VS2008, my keyboard goes mad, and starts to write non accentuated char, by example, when I try to write an á the output in the screen is ´´a ... but more strange than that is that all the applications I try to write that char, the output will be always the wrong one. When I close that tab, the output becomes to be the expected... odd no? Any thoughts about that?

Note, that I don't have any viruses, or any kind of malicious soft in my machine, thats for sure. This only happens when I open the Editor tab in VS2008 IDE.

Can you help me?

Thanks in advance.

Regards,

Sandro Martins

General Discussions

answered on 22 Jun 2009

3 answers

531 views

Works in VS and not in IIS 7

I have a reportviewer that displays some reports on an .aspx page. When I serve these pages with Visual Studio everything runs as it should. Report displays on the page fine.
However, when I go to serve the pages with IIS 7, I get the following error : "Cannot create an object of type 'Telerik.Reporting.IReportDocument' from its string representation 'ReportingLib.Sales, ReportingLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' for the 'Report' property". "ReportingLib" is the class library where my reports exist. Following info seems to be relevant here.
1)I have all of the telerik trial version dlls installed in the gac on the machine as well as in the web applications bin directory. 2) On the page with the report viewer I have the below code. Also below is my web.config. Note I have placed httphandler sections with relevant info in both the <system.web> and <system.webserver> sections of the web.config(as given in a previous post on the forum). I have tinkered with my web.config settings quite a bit believing this maybe where the issue is. If I eliminate the <validation validateIntegratedModeConfiguration="false"> for the <system.webServer> node IIS7 comes back with an error

HTTP Error 500.23 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Can anyone tell me is there something i need to tell iis7 in my web.config or is there a better way to troubleshoot this?

Jason

<?
 
xml version="1.0"?>
 
<!--
 
Note: As an alternative to hand editing this file you can use the 
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in 
machine.config.comments usually located in 
\Windows\Microsoft.Net\Framework\v2.x\Config 
-->
<
 
configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
 
<
 
appSettings/>
 
<
 
connectionStrings>
 
<
 
remove name="LocalSqlServer"/>
 
<
 
add name="connSomsys" connectionString="Data Source=CMDIVST004\JASON08;Initial Catalog=QuoteDB;Persist Security Info=True;User ID=ggggg;Password=ggggg" providerName="System.Data.SqlClient"/>
 
</
 
connectionStrings>
 
<!--
 
 <compilation debug="false" />
 
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
 
-->
 
<
 
system.web>
 
<
 
httpHandlers>
 
<
 
add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" validate="false"/>
 
<
 
add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true"/>
 
</
 
httpHandlers>
 
<
 
httpRuntime maxRequestLength="512000"/>
 
<
 
compilation defaultLanguage="c#">
 
<
 
assemblies>
 
<
 
add assembly="MonoSoftware.Web.TextBox, Version=1.0.0.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
 
<
 
add assembly="Xheo.Licensing, Version=2.1.5000.0, Culture=neutral, PublicKeyToken=798276055709C98A"/>
 
<
 
add assembly="MonoSoftware.Web.DynamicPopUp, Version=1.5.0.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="MonoSoftware.Web.Helper, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
 
<
 
add assembly="System.Web, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="MonoSoftware.Web.Calculator, Version=1.0.0.0, Culture=neutral, PublicKeyToken=FAF3283597AC56FF"/>
 
<
 
add assembly="Office, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"/>
 
<
 
add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
 
<
 
add assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting.Processing, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting.Interfaces, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.Reporting.HtmlEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
 
<
 
add assembly="Telerik.Reporting.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.ReportViewer.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="Telerik.ReportViewer.WinForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
 
<
 
add assembly="ReportingLib, Version=1.0.0.0, Culture=neutral"/>
 
</
 
assemblies>
 
<
 
buildProviders>
 
<
 
add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
 
</
 
buildProviders>
 
</
 
compilation>
 
<
 
sessionState timeout="45"/>
 
<
 
authentication mode="Forms">
 
<
 
forms timeout="300"/>
 
</
 
authentication>
 
<
 
authorization>
 
<
 
deny users="?"/>
 
</
 
authorization>
 
</
 
system.web>
 
<!--
 
 allow users to access these directories/pages/files without logging in-->
 
<
 
location path="loginhelp.aspx">
 
<
 
system.web>
 
<
 
authorization>
 
<
 
allow users="?"/>
 
</
 
authorization>
 
<
 
compilation debug="true"/>
 
</
 
system.web>
 
</
 
location>
 
<
 
system.webServer>
 
<
 
validation validateIntegratedModeConfiguration="false"/>
 
<
 
defaultDocument>
 
<
 
files>
 
<
 
clear/>
 
<
 
add value="default_loc.aspx"/>
 
<
 
add value="default.aspx"/>
 
</
 
files>
 
</
 
defaultDocument>
 
<
 
handlers>
 
<
 
add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0"/>
 
</
 
handlers>
 
</
 
system.webServer>
 
</
 
configuration>

------------------------------------------------------------------------------------------------------------------------
 
            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="chart.aspx.cs" Inherits="reporting_chart" %> 
        
            <%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" 
        
                Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml">  
        
            <head runat="server">  
        
                <title></title>  
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server">  
        
                <div> 
        
                    <h3>Header</h3> 
        
                <telerik:ReportViewer ID="ReportViewer1" runat="server" Height="482px"   
        
                        Report="ReportingLib.Summary, ReportingLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"   
        
                        Width="686px">  
        
                    </telerik:ReportViewer> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html> 
        
             --------------------------------------------------------------------------------------------------------------------

General Discussions

answered on 22 Jun 2009