Telerik Forums
Reporting Forum
0 answers
134 views
Forum, we have a question on how an organization can "automate" telerik reports.  As we pursue BI applications, the Telerik reporting tools do a fabulous job for a user wanting to interact with the system.  When you look at the other components and BI vendors, all of them have a "Publish" capability in an unattended fashion.  Microsoft, IBM, SAP/Business Objects, Infragistics all seem to have an unattended publish solution.  I have to believe there is a way through code to get a Telerik report into an automated publish environment.  Does any have any recommendations on this?  Thanks.  BW
Bruce
Top achievements
Rank 1
 asked on 05 Oct 2010
3 answers
316 views
Hello,

I'm trying to create a dynamic table columns. It's almost working, but the actual data is not showing up:

public partial class ProductsReport : Telerik.Reporting.Report
    {
        public ProductsReport()
        {
            InitializeComponent();
 
            detail.ItemDataBound += detail_ItemDataBinding;
        }
 
        private void detail_ItemDataBinding(object sender, EventArgs e)
        {
            var section = sender as Telerik.Reporting.Processing.DetailSection;
            var processingTable = section.ChildElements.Find("periodsTable", true)[0] as Telerik.Reporting.Processing.Table;
            var dataObject = section.DataObject;
            var productPricingInfos = dataObject.RawData as ProductPricingInfos;
            processingTable.DataSource = productPricingInfos.ProductPricePeriods;
 
            //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 textboxHeader;
            Telerik.Reporting.HtmlTextBox textBoxData;
 
            //we do not clear the Rows collection, since we have a details row group and need to create columns only
            this.periodsTable.ColumnGroups.Clear();
            this.periodsTable.Body.Columns.Clear();
            this.periodsTable.Body.Rows.Clear();
            int i = 0;
            this.periodsTable.ColumnHeadersPrintOnEveryPage = true;
 
            //common fields
            var tableGroupColumnCommon = new Telerik.Reporting.TableGroup();
            periodsTable.ColumnGroups.Add(tableGroupColumnCommon);
            periodsTable.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));
 
            textboxHeader = new Telerik.Reporting.HtmlTextBox();
            textboxHeader.Style.BorderColor.Default = Color.Black;
            textboxHeader.Style.BorderStyle.Default = BorderType.Solid;
            textboxHeader.Value = "Du";
            textboxHeader.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
            tableGroupColumnCommon.ReportItem = textboxHeader;
 
            textBoxData = new Telerik.Reporting.HtmlTextBox();
            textBoxData.Style.BorderColor.Default = Color.Black;
            textBoxData.Style.BorderStyle.Default = BorderType.Solid;
            textBoxData.Value = "=Fields.StartDate";
            textBoxData.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
            this.periodsTable.Body.SetCellContent(0, i++, textBoxData);
            this.periodsTable.Items.AddRange(new ReportItemBase[] { textBoxData, textboxHeader });
             
 
        }
    }

You can see at the bottom textBoxData.Value = "Fields.StartDate". I took this from an example submitted by you guys.

I'm probably missing a bind or something...I really don't know.
Steve
Telerik team
 answered on 05 Oct 2010
0 answers
206 views

Hi everybody..

i've created one SSRS in that i've connected to the database having four fields..

now want i want is to calculate the salary page by page and at the last grand

total..

i've kept one extra column in table and kept one running field and made it as 

hidden. i've taken one textbox and placed in page footer with the 

expression="PAGE RECORD TOTAL="& Last(reportitems("Subtotal1").Value)

where subtotal1 is a running field and i'm taking the last value of that.. and printing in

page footer..

Now my problem is when i run the report the value will be present but when

i click on preview or  take the print the value will be disappeared..

please help me.. 


And when i make the running field hidden=false then it will display while printing also..

i dont want to show the running field i want to hide it..

i've created the report with the following link

http://community.dynamics.com/blogs/navteam/archive/2010/03/17/transfooter-and-transheader-functionality-in-rdlc-40-ssrs-41-reports.aspx

please help me

vinayak.v
Top achievements
Rank 1
 asked on 05 Oct 2010
5 answers
451 views
We recently downloaded and installed the 2010.2 921 version of Telerik Reporting.

We then proceeded by creating a new class library as described on page 6 of your Learning Guide PDF. However, when we try to add a new item to the library, there is no Telerik Report template to add.

There are no Telerik item templates in the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache folder.

I've looked through several forum posts regarding this issue, but couldn't find a real solution for this.

Any help would be appreciated.

Ulrich
Top achievements
Rank 1
 answered on 05 Oct 2010
3 answers
144 views
I have a report that works fine when deployed to a regular web form.  The goal is to get it working in Sharepoint (WSS 3.0) I've used the SmartTemplates from codeplex to build a webpart project and have successfully deployed it to WSS - however, all that displays is a mucked up version of the report viewer toolbar.  Actually, when it first comes up, it shows the "Generating Report..." and then flashes the actual report for a split second but then disappears and I'm left with what's in the attached screenshot.  The code for the webpart is below - pretty basic:

using

 

System;

 

 

 

using System.Web.UI.WebControls;

 

 

 

using System.Web;

 

 


namespace
drc.okc.wss

 

 

 

{

 

public class NWRM_Dashboard : System.Web.UI.WebControls.WebParts.WebPart

 

 

 {

 

protected override void RenderContents(System.Web.UI.HtmlTextWriter writer)

 

 

 {

Telerik.ReportViewer.WebForms.ReportViewer ourReportViewer =

new Telerik.ReportViewer.WebForms.ReportViewer();

 

 

 ourReportViewer.Report =

new drc.okc.iuid.reports.Metrics.NWRM_Summary();

 

 

 

this.Controls.Add(ourReportViewer);

 

 

 ourReportViewer.RenderControl(writer);

}

}

}

 

 

Steve
Telerik team
 answered on 05 Oct 2010
1 answer
142 views
Hi,
I'm just looking for a way to use RDLC directly/indirectly using Telerik Report Viewer. Any guidance please?
Steve
Telerik team
 answered on 05 Oct 2010
4 answers
110 views

Hi
I have a report with several groups. My problem is when I try to copy a text box from another group (region) on the report and past it into the new group. I get the error

“an error occurred while processing this command. Cannot add textbox6 (Telerik.reporting.textbox) to groupHearderSection11 (Telerik.Reporting.GroupHeaderSection)”

Normally with other reports I have been able to copy and past objects between the groups. I am running version Q2 SP1

Do you know what would be causing this as I don’t really want to start the report again from scratch.

Thanks in advance

Derek Boseley
Top achievements
Rank 2
 answered on 04 Oct 2010
1 answer
485 views
Folks,

I am programmatically binding Sharepoint List data to Reports.
I have a subreport inside the Main Report. My Question is that, How do I handle the scenario, when, I have to pass a bool value to report or secion of report or subreport that makes it hide/visible as per the bool value.
I am not sure how to pass the bool value though.
Would be great if you can help me with sample solution to explain the hide/visible of report or subreport using bool value Programmatically.

Thanks
Peter
Telerik team
 answered on 04 Oct 2010
6 answers
396 views
I am trying to set a subreport's datasource at runtime from the master.  This works great when I can pass the foreign key to the master report via parameters so that I can generate the right data at runtime for the subreport.  Now I have a master report that is generated from a date range.  I am getting the value of the foreign key needed for the subreport from a textfield on the master report.  This works great except for the first record in the master report.  It seems the datasource works on the supreport for any record after that.  I have tried everything, and they all ohave the same result.  I am using Telerik.Q2 2008.  I love this product, but I can't get past this one issue.  See screen shot of page 1 of report and then of the code I am using.  Thanks!
Brant
Top achievements
Rank 1
 answered on 01 Oct 2010
5 answers
398 views

Hi,

I am trying to install Q2 2010 of the Reporting on a xp development environment with VS2010.
When I run the msi-file, I get this message. "Telerik Report Q2 2010 Setup Wizard ended prematurely". Then I can close the Finish-button.

When I look at the eventlog I can see this error message:

Windows Installer installed the product. Product Name: Telerik Reporting Q2 2010. Product Version: 4.1. Product Language: 1033. Installation success or error status: 1603.

The installer works fine in other environments. So, the file isn't corrupt....

Hope for some help.

Kind regards,
Morten :)

Mike
Top achievements
Rank 1
 answered on 01 Oct 2010
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?