Questions on Reporting Forum

1 answer

103 views

ASP.NET Reporting: problem while creating new datasource

Hi,
I m using 30 day trial reporting from: http://www.telerik.com/products/reporting/download.aspx

As per the article at : http://www.telerik.com/help/reporting/quick-start-create-simple-report.html
When I tried to add new data source, I get a blank space with no option to choose from (see attached 'untitled.png').

Please help me out.

Thanks.

General Discussions

answered on 15 Jul 2013

1 answer

82 views

DrillThrough to report in RadWindow

Is it possible to have the DrillThrough report target be a radwindow?
I want to display the drillthrough report in a modal popup window.

General Discussions

answered on 15 Jul 2013

1 answer

155 views

preventing page breaks between nested lists

Hi

I have nested lists in 3 levels in my detail section. When the innermost list is very big, then is forces a page break. it forces a page break.

list 1 has only 1 line - print on top of page 1
list 2 has only 1 line - prints on top of page 2
list 3 has 200 lines - starts printing on top of page 3 and runs over 2 pages pages

I need list 1,2 and 3 to start printing underneath each other on page 1.

I have set keeptogether to false on all 3 lists, with no luck.

Please help

General Discussions

answered on 15 Jul 2013

3 answers

280 views

Alter behavior for export toolbar button?

We'd like to replace the default functionality for the Excel export button on the HTML report viewer. We'd like to write a custom method for each report that will export the underlying data to spreadsheet in a format that is conducive to sorting, totalling, etc. via Excel. We don't need to export the headings, totals, etc.

Can we override the default behavior?

General Discussions

answered on 15 Jul 2013

2 answers

244 views

Parameter Area display

Hello,

I'm new to Telerik Reporting. Is it possible to force parameter fields to be displayed on an new line. In my case the parameters are placed after each other (by 2) . I've 5 parameter fields and I want them to be displayed like:

ParameterField1
ParameterField2 ParameterField3
ParameterField4 ParameterField5

Please let me know how to achieve this.

Regards,
Jos.

General Discussions

answered on 15 Jul 2013

6 answers

667 views

Pivot table programatically

Hi,

I am trying to use column groups and row groups to pivot the data programatically. Following is the code snippet I am working on
crosstab1.RowGroups.Add(tableGrouprow);
                textboxGroup1 = new Telerik.Reporting.TextBox();
                textboxGroup1.Style.BorderColor.Default = Color.Black;
                textboxGroup1.Style.BorderStyle.Default = BorderType.Solid;
                textboxGroup1.Value = "=Fields." + ds.Tables[0].Columns[0].ColumnName;/***giving column index on the column we want to group****/
textboxGroup1.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
                tableGrouprow.ReportItem = textboxGroup1;

but i am unable to do grouping.I have attached the screen shot of the table I want to pivot.I want pivot on month(column group) and drug(row group).I couldn't find any sample projects on this.can you please give some hint on this or a working sample would be more useful.

Thanks you..

General Discussions

answered on 12 Jul 2013

3 answers

241 views

User Function error caused by null value

Hi

I'm trying to apply some custom date formatting.
So I have created a method to format the date (where parameter dt is the Field from the database)

    
            public static string FormatDate(DateTime dt) 
        
                    { 
        
                        string newDt = ""; 
        
                        if (dt != null) 
        
                        { 
        
                            string oid = waSessionState.Current(HttpContext.Current).oid; 
        
                            waOrganisation org = (waOrganisation)HttpContext.Current.Cache[oid]; 
        
                            newDt = dt.ToString(org.DateFormat); 
        
                        } 
        
                        return newDt; 
        
                    }

And for the expression I wrote:

    
            =waMemberDetailsReport.Utilities.FormatDate(IsNull(Fields.[MemberDateRegistered], null))

If a DBNull value is returned from the database then I get the error "The expression contains undefined function call FormatDate()."

I don't understand why the error is occuring when I am using the IsNull() function.

General Discussions

answered on 11 Jul 2013

3 answers

425 views

Dynamic crosstab report

Hi,

I need to know how can I prepare dynamic crosstab report. I used code from examples. But it's generate only header row and one data row.

private void crosstab1_ItemDataBinding(object sender, EventArgs e)

{

//Connections and commands

.....

//get the processing table object since we're in the context of event

Telerik.Reporting.Processing.Table processingTable = (sender as Telerik.Reporting.Processing.Table);

//construct the select statement based on the selected report parameters

SqlDataAdapter sqlAdapter = new SqlDataAdapter(sComm);

sqlAdapter.SelectCommand.CommandTimeout = 3600;

//create a dataset, fill it and set it as datasource to the processing table object

DataSet ds = new DataSet();

sqlAdapter.Fill(ds);

processingTable.DataSource = ds.Tables[0];

//create two HtmlTextBox items (one for header and one for data) which would be added to the items collection of the table

Telerik.Reporting.HtmlTextBox textboxGroup;

Telerik.Reporting.HtmlTextBox textBoxTable;

//we do not clear the Rows collection, since we have a details row group and need to create columns only

this.crosstab1.ColumnGroups.Clear();

this.crosstab1.Body.Columns.Clear();

this.crosstab1.Body.Rows.Clear();

int i = 0;

this.crosstab1.ColumnHeadersPrintOnEveryPage = true;

DataTable dt = ds.Tables[0];

foreach (DataColumn dc in dt.Columns)

{

Telerik.Reporting.TableGroup tableGroupColumn = new Telerik.Reporting.TableGroup();

this.crosstab1.ColumnGroups.Add(tableGroupColumn);

this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));

textboxGroup = new Telerik.Reporting.HtmlTextBox();

textboxGroup.Style.BorderColor.Default = Color.Black;

textboxGroup.Style.BorderStyle.Default = BorderType.Solid;

textboxGroup.Value = dc.ColumnName;

textboxGroup.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));

tableGroupColumn.ReportItem = textboxGroup;

textBoxTable = new Telerik.Reporting.HtmlTextBox();

textBoxTable.Style.BorderColor.Default = Color.Black;

textBoxTable.Style.BorderStyle.Default = BorderType.Solid;

textBoxTable.Value = "=Fields." + dc.ColumnName;

textBoxTable.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));

this.crosstab1.Body.SetCellContent(0, i++, textBoxTable);

this.crosstab1.Items.AddRange(new ReportItemBase[] { textBoxTable, textboxGroup });

}

General Discussions

answered on 11 Jul 2013

3 answers

252 views

HtmlTextBox calculating wrong height

I cannot get a consistent rendering of the content within an HtmlTextBox from the WebReportViewer to Word and Excel exports

In HTML, the outer DIV height renders too short cropping the content.
In Word, one of the lines is not visible until you zoom in even though its the same as the next line
In Excel, the row is rendered to short and the bottom content is hidden.

Grabbing the rendered HTML from the WebForm ReportViewer it renders fine in Firefox, and Chrome but only appears to render correct in Internet Explorer when the Document Mode is set to Quirks or IE7, but this does not explain the Word and Excel issues.

The HtmlTextBox is set to 11pt because the Html Content is wrapped in a <font size=2> in order to target the desired height of 8pt.
Excel is rendering the content at 11pt as the HTML tags have been stripped, but the calculated size is not taken into account.

I assume that HTML do not like decimal font-sizes other then halves. IE 6.7pt => 6.5pt

<div style='font-size:8pt; width:713px;'>

<FONT size=2>

<FONT size=1>

I (We) certify that the information on this Balance Sheet is true and correct to the best of my (our) knowledge.  I (We) have provided this information to xxxxxxxxxxx  Bank to obtain or maintain a loan.  I (We) understand that false statements made may be subject to prosecution.  The xxxxxxxxxxx Bank is authorized to verify the statements contained herin and I (We) request and authorize all individuals or businesses to release information to xxxxxxxxxxx Bank regarding our business relationships.  I (We) agree to all these conditions and terms of this application.  <

BR> <BR> <BR>Signature:________________________________________________________ Date: __________<BR> <BR> <BR> <BR>Signature: ________________________________________________________Date:__________

</FONT>

</div>

<br/>

<hr/>

<br/>

<style type="text/css">

div.htmlTextBox2 { line-height:110%; height:111px; top:535px; width:713px; font-family:Arial; font-size:11pt; margin:0; padding:0; }

div.htmlTextBox2 * { line-height:110%; }

.s67 { font-size: 9.79pt; padding: 0; }

.s68 { font-size: 6.6pt; padding:0; }

</style>

<div title="" class="htmlTextBox2 s64" style="overflow: visible; border:1px solid red;">

<DIV style="MARGIN-TOP: 0px" class=html-root>

<DIV class=s66 style='margin:0;padding:0;'>

<FONT class=s67>

<FONT class=s68>

I (We) certify that the information on this Balance Sheet is true and correct to the best of my (our) knowledge.  I (We) have provided this information to xxxxxxxxxxx Bank to obtain or

</FONT>

<FONT class=s67>

<FONT class=s68>

maintain a loan.  I (We) understand that false statements made may be subject to prosecution.  The xxxxxxxxxxx Bank is authorized to verify the statements contained herin and I

</FONT>

<FONT class=s67>

<FONT class=s68>

(We) request and authorize all individuals or businesses to release information to xxxxxxxxxxx Bank regarding our business relationships.  I (We) agree to all these conditions and

</FONT>

<FONT class=s67>

<FONT class=s68>

terms of this application. <BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

<BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

<BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

Signature:________________________________________________________ Date: __________<BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

<BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

<BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

<BR>

</FONT>

<FONT class=s67>

<FONT class=s68>

Signature: ________________________________________________________Date:__________

</FONT>

</DIV>

General Discussions

answered on 11 Jul 2013

1 answer

91 views

How much of page used before print

Hi.

Is it possible to know how much of page will be used before print it? (The data is dynamic)

The ideia is to know how much of page will be used to decide if I will print in only one page like below or two pages.

customer receipt
some data printed
-------------------------
company receipt
some data printed

If customer receipt pass the size that I tought then I will use two or more pages.

Best regards

Wilton Ruffato Wonrath

General Discussions

answered on 11 Jul 2013