I have a report, that is databound from code behind.  In order to set up the report quickly, i used the report wizard

During the Wizard setup, I provide it with the SQL query from my stored procedure, minus the parameters.

Once the report is designed, i then sever the link to the DataTableAdapter that was created by the wizard

In the need datasource method of the report, i provide it with a data table that is filled from my sqlcommand

In the report, i remove the link to the datasource that was referenced from the wizard

when i run the report, no data is shown in the viewer, however when i export to PDF or Excel, the data is shown.

am i missing a configuration?  Do i have to do it completely from code behind?...i hope not

obviously when i go into the value of the textbox, and look at the fields, there is no field data...

please help me shed some light as to what i am doing wrong

Thanks

I am creating a report that will render directly to PDF.   There are several pages or elements that will have background images...which we are currently rendering as PNG files.   We exported them at 300 dpi in order to accomodate the highest pdf export resolution possible (intended for print)...but when included in the page they get rendered with about 15% of the image off the right + bottom of the page.

Is there a recommended "pixel" or "dimensions" for a full page background...meaning something that will fill edge to edge without actually going off the edge of the page?  Please advise!

Side note:   I don't know if it will make much difference...but we are placing some elements close to the edge of the page..so have set page margins to 0 all the way around.

Thank you!
-David

In the print detail section, I have customer name print in the first row, and address print in second row.
So my question: Is there any way I can skip second row if address is empty.

Right now, my report print this if Customer B address field is empty:

Header
----------------------------------
Customer A
Customer A's address
Customer B

Customer C
Customer C's address
-----------------------------------
Footer

Instead, I want it to print like this if Customer B address field is empty:

Header
----------------------------------
Customer A
Customer A's address
Customer B
Customer C
Customer C's address
-----------------------------------
Footer

Thanks for any suggestions.

I searched the Reporting forums for any example I could find about combining multiple reports together in to one report, sadly I found none what so ever. Yes there were mentions of using sub reports, but what if you had more than one report you wanted to add in there. There was no examples at all that I could find. So I sat down and started hacking away at this problem. Luckily I did find a solution that works. I hope this helps out anyone that read this, enjoy. There may be some errors here and there, as there always are in examples. But the general idea should be straight forward. Also that only the detail section of each report will be placed in the sub report at the current moment. Thank you for your time.

PageBatch.cs

TestPage.cs

Hi I am using Q2 2007.  I have a report that uses a single integer parameter, and that parameter is referenced in a simple filter "field=parameter".

I have a text box on teh page header that shows the parameter value, so I know it is set.  But none of my header or detail sections shows up when I pass in a value.

Dim clientBatchID As Integer
clientBatchID = CInt(Request.QueryString("clientBatchID"))
Me.ReportViewer1.Report.ReportParameters("clientBatchID").Value = clientBatchID

If I run the report like this, I get the constants values (header text, page numbers etc) and the parameter text box, but no data.

If I do this

Dim clientBatchID As Integer
clientBatchID = 175
Me.ReportViewer1.Report.ReportParameters("clientBatchID").Value = clientBatchID

I get data for batch 175, report looks fine.

Could this be a transaction problem?  In the first example, I have left out some steps in teh pasted code above, where the records I want to report on are assigned the batch ID.  I imagine they might not be committed and the report doesn't see them.  But I follow this same pattern in other reports and do not have this problem...

any ideas?

Hi

I'm having a problem using the ReportViewer with radAjaxManager (Prometheus)

I have a button click event which updates the report datasource
HOWEVER with radAjaxManager enabled,
the report doesn't update correctly and shows zero records

When the radAjaxManager AjaxEnabled is set to false
The report refreshes successfully...

I've tried hooking the radAjaxManager to both the Reportviewer and a panel containing the Reportviewer

Hope someone can help...


Here's the ASPX
===============
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="ButtonRefresh">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="ReportViewer1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>

<asp:Button ID="ButtonRefresh" runat="server" Text="Refresh" />
<br />

<asp:Panel ID="PanelReport" runat="server">
    <telerik:ReportViewer id="ReportViewer1" runat="server">
    </telerik:ReportViewer>
</asp:Panel>


This is the code behind
=======================
    Protected Sub ButtonRefresh_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonRefresh.Click
        Me.ReportBindIt(" FullName LIKE '%hoey%' ")
    End Sub

    Public Sub ReportBindIt(ByVal Criteria As String)

        Dim TelerikReport As New CaseReports.A4_CaseReport1
        Dim sqlSelectCommand1 As New SqlCommand()
        Dim sqlDataAdapter1 As New SqlDataAdapter()
        Dim sqlConnection1 As New SqlConnection()

        sqlConnection1.ConnectionString = GetConnectionString()
        sqlSelectCommand1.CommandText = "dbo.procGetReportCaseList1"
        sqlSelectCommand1.CommandType = Data.CommandType.StoredProcedure

        sqlSelectCommand1.Parameters.AddWithValue("Criteria", Criteria)
        sqlSelectCommand1.Parameters.AddWithValue("SortExpression", "fileref DESC")

        sqlSelectCommand1.Connection = sqlConnection1
        sqlDataAdapter1.SelectCommand = sqlSelectCommand1

        TelerikReport.DataSource = sqlDataAdapter1
        ReportViewer1.Report = TelerikReport


    End Sub

Hello,

We've got a problem for web report viewer when displaying a report containing more than 1 page. The report has a group header and the detail section has a subreport containing data longer than 1 page. On web report viewer, the first page only display the group header, no subreport details, the second page starts to display subreport details. After export the report to PDF, the first page display group header and subreport details correctly.

Could you fix this problem in next release?

Thanks in advance.

mei

We are currently running our builds through TFS. On our local machine, everything with the reports runs just fine, but when it runs through TFS, we end up getting some unusual errors and the build fails. I've copied the 4 required DLLs for web forms out to our additional references folder, which is all we've ever had to do in the past. Anyhow, the first time the build ran we got the following error:

I then decided to remove the "Imports Telerik.Reporting" from the top of my class file and fully qualify all of the references to Telerik.Reporting.Report and Telerik.Reporting.ReportParameterType. I now get the following error.

Hi all,
two question about telerik reporting:

1)  Can convert a report created with XTraReport suite 7.3.7.0 ?
I'm considering various reports tools and I would compare telerik features with xtrareport features.
2) Why there isn't a grid component for report ?


Thanks in advance and best regards,
Diego

I have built a report using Telerik Reporting in VS2008.  Everything works while in VS2008, including running the web application.  The report is generated within the browser without a problem.  However when I migrate it to the webserver and run it all of the icons (next page, previous page, refresh...) show as broken image links and no data is displayed.  I have copied the the following files to the webserver:
Telerik.Reporting.dll
Telerik.Reporting.Interfaces.dll
Telerik.Reporting.Processing.dll
Telerik.ReportViewer.WebForms.dll

The web.config file contains the following lines:

<

assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<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="Telerik.ReportViewer.WebForms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
<add assembly="Telerik.Reporting, Version=2.0.0.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
<add assembly="Telerik.Reporting.Processing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
<add assembly="Telerik.Reporting.Interfaces, Version=2.0.0.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
</assemblies>

<

httpHandlers>
<remove path="*.asmx" verb="*" />
<add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
<add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
<add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false" />
<add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true" />
</httpHandlers>

<handlers>
<remove name="WebServiceHandlerFactory-Integrated"/>
<remove name="ScriptHandlerFactory"/>
<remove name="ScriptHandlerFactoryAppServices"/>
<remove name="ScriptResource"/>
<remove name="Telerik.ReportViewer.axd_*"/>
<add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=2.0.1.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0" />
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
</handlers>

Any help would be welcome.
Steve