Telerik Forums
Reporting Forum
1 answer
55 views
I need a description how to bind two openaccess datasources (master/detail) to a Report.
Steve
Telerik team
 answered on 30 Jun 2009
0 answers
429 views
Been working with Telerik Reporting for three days now, and not particularly pleased (no drilldown, not much direct supported event handling, would have done better to RadGrid this output...). Here, however, is how to add a control to the Telerik toolbar. I want a single generic "Report Viewer" that all my reports can leverage. One benefit is being able to have a central process for user input to control the report display. But the Telerik Reporting toolbar is missing a "height" parameter. And, no direct way I can find to add it. Eck.

Reflection and IE Dev Toolbar to the rescue. IE Dev Toolbar tells me that there exists a <div> entry named ctl_rptvw_ReportToolbar as a child of the report viewer (named "rptvw" in my ascx):

<%

@ Control Language="C#" AutoEventWireup="true" CodeBehind="TelerikReportViewer.ascx.cs"

 

 

Inherits="ArchG2.Portal.rg2SupportingControls.Misc.TelerikReportViewer" %>

 

<%

@ Register Assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

 

 

Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

 

<

 

asp:HiddenField ID="hdnExplicitHeight" runat="server" Value="0" />

 

<

 

div id="telerikViewer">

 

 

<telerik:ReportViewer ID="rptvw" runat="server" Height="300px" Width="100%"

 

 

oninit="rptvw_Init">

 

 

</telerik:ReportViewer>

 

</

 

div>

So I override the oninit and start exploring with  debugger:

 

 

protected void rptvw_Init(object sender, EventArgs e)

 

{

 

string flag = "";

 

 

try

 

 

 

 

{

 

// find the toolbar

 

 

 

 

flag =

"locate_toolbar";

 

 

Control ctlToolbar = rptvw.FindControl("ReportToolbar");

 

 

if (ctlToolbar == null) throw new ApplicationException("No toolbar; new Telerik version?");

 

 

// this is reverse engineered from telerik; might work

 

 

 

 

flag =

"create_controls";

 

 

Table tblHeight = new Table();

 

tblHeight.ID =

"PageHeight";

 

tblHeight.CssClass =

"ReportToolbarGroup";

 

Abr.CodeLibrary.Utils.

Global.MergeCssStyleAttributes(tblHeight.Attributes, "float:left;");

 

tblHeight.CellPadding = 0;

tblHeight.CellSpacing = 0;

 

TableRow rowHeight = new TableRow();

 

rowHeight.ID =

"row";

 

 

TableCell cellHeight = new TableCell();

 

cellHeight.ID =

"cell";

 

 

Label lblHeight = new Label();

 

lblHeight.ID =

"lblHeight";

 

lblHeight.AssociatedControlID =

"txtHeight";

 

lblHeight.Text =

"Height: ";

 

_txtHeight =

new TextBox();

 

_txtHeight.ID =

"txtHeight";

 

_txtHeight.Width =

Unit.Parse("5em");

 

 

LinkButton btnResize = new LinkButton();

 

btnResize.ID =

"btnResize";

 

btnResize.Text =

"Resize";

 

btnResize.Click +=

new EventHandler(btnResize_Click);

 

flag =

"add_controls";

 

cellHeight.Controls.Add(lblHeight);

cellHeight.Controls.Add(_txtHeight);

cellHeight.Controls.Add(btnResize);

rowHeight.Cells.Add(cellHeight);

tblHeight.Rows.Add(rowHeight);

ctlToolbar.Controls.Add(tblHeight);

}

 

catch (Exception ex)

 

{

LH.error(

"Problem at ", flag, ": ", ex);

 

NotifyError(

"Report: " + ex.Message);

 

}

//try

 

 

 

 

}

 

Reflection at first told me that the first child of the ReportToolbar control is of type Telerik.ReportViewer.WebForms.PageNavigationGroup. Too bad that type is not directly supported--it must be a private class. So I instead use good old F12 in the IE browser to turn on Dev Toolbar and take a peek at what Telerik actually generated, which was this:

<table class="ReportToolbarGroup" id="ctl_rptvw_ReportToolbar_NavGr" style="float: left;" cellSpacing="0" cellPadding="0">

Ah, says I, if they can generate a table then I can too! Which led to the code above and a LinkButton. (I could not use a regular Button, *someone* <ahem> put a style of "visible: false !important" on the generated input control. But the LinkButton works great, I get notified, I can respond to requested height changes and Bob's Yer Unkl.

In my btnResize_Click event, I simply set the Height of the wrapped report control (which, btw, I load dynamically from an ASCX property name hyuck hyuck) and I get the effect I want.

Score: 1 for us, zero for them.

Manny
Top achievements
Rank 1
 asked on 29 Jun 2009
0 answers
105 views

I  have created telerik report in web application using Visual studio 2008 and Report viewer version is 

(Telerik.ReportViewer.WebForms, Version=3.0.9.430, )

Its working fine in my lacol system but when i upload into server domain
it will through some error 

http://www.isms.shreema.com/incidents.aspx

 

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 1:  <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Incidents.aspx.cs" Inherits="Incidents" %>
Line 2:  
Line 3: <%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"Line 4:      Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
Line 5:  

My remote server(web hosters) allowed only in frame work 2.0 because when i upload all .cs files into remote server
i got one error in following  namespace(its not supported)

 

using

 

System.Linq;

 

using

 

System.Xml.Linq;

 

 

So i removed that two namspace but i have problem in report viewer how to solve taht version problem

Regards

Abdul

Azees
Top achievements
Rank 1
 asked on 29 Jun 2009
3 answers
367 views
Greetings,

As a parameter i am using a dropdown with organisations. Each organization has settings which i select in a NeeddataSource event for a chart.
When using these settings to update the background color of the header section, set a new picturebox image or use the parameters to fill textboxes in the detail section the report doesn't show these changes.
Only after a click on the refresh button of the reportviewer the changes are shown.

Any ideas how to get this to work?

With regards,

Peter
Steve
Telerik team
 answered on 29 Jun 2009
1 answer
86 views
Hi, I am new to using any reporting suite. Usually I query data from the db and manually parse it out and generate my html layout. I was hoping using a reporting toolset would make things easier.

I've been reading and following along some telerik reporting guides.

It looks like paramaters and filtering do not take place at the db-level and are instead after the data is pulled. This is a big problem for me. I need to use params when i pull the data. I could be pulling a million records if i can't have the report pull only the records for a specific userID and then report on it.

Is there any way to make it work like i expected it to?
Or am i going to have to stick to using a grid?
Steve
Telerik team
 answered on 27 Jun 2009
3 answers
225 views
Hi ,

In a dataset there are more than 10 records, while populating these records to telerik report it displays only one record.
kindly suggest me the options for showing all the records in telerik report.

Regards,
Parthiban.
Steve
Telerik team
 answered on 27 Jun 2009
1 answer
315 views
Goodmorning,

I have a problem with a report involving a subreport section containing some data picked up from a stored procedure.
The subreport data consists of a kind of "invoice detail" section (some items with their description, prices etc).

The problem is that when there are lot of items in the detail section of the subreport, the subreport itself does not maintain the limits of the subreport section declared in the master page (I've already set the KeepTogether property of the subreport to "False") and keeps "growing" in order to contain all the data. This way the data AFTER the subreport section goes on the next page, instead of having a new page with the remaining of the subreport data.

So, the main problem is hot to keep a subreport within the bounds declared in the subreport size?

Thank you,
Best regards,
Marius.
Steve
Telerik team
 answered on 27 Jun 2009
1 answer
253 views
Hi ...
I`ve just came to know about the Telerik Reports.
How to pass sql parameter value in run time in Telerik Reports.

Any help would be greatly appreciated
Regards
Robins


Steve
Telerik team
 answered on 27 Jun 2009
1 answer
130 views
I'm using an object as my data source.  The object has a function that returns another object.  I wish to use a function return value of that returned object as the value in a TextBox, but the report is not happy and shows an exception box pertaining to not being able to find the lower function.  For example, my TextBox value field looks something like this: =GetSubObject().GetValue( p1, p2).  The report would be  complaining "The expression contains undefined function call GetValue."
Is there any way to do this?  I'm guessing a subreport that uses the GetSubObject return value as its data source would be an option?
Chris Gillies
Top achievements
Rank 1
 answered on 26 Jun 2009
1 answer
170 views
Hi .
 This is suriya .,
 sir i have doubt in retriving the next row record and calculating in another field....

Date                        days
4-Jan-2009 0
7-Jan-2009 3
9-Jan-2009 2
10-Jan-2009 1

i need the above answer, but u have the date field only., it is possible or not in teleriks.,
please reply as soon as possible.,

By
Suriya narayanan

Steve
Telerik team
 answered on 26 Jun 2009
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?