Questions on Reporting Forum

3 answers

156 views

Hello there,

So now my project can produce reports successfully, what I want to do is when users select different calendars, they will see different reports which have the events selected from the different calendars. I use Request.Cookies("checkedCalendars").Value in my web application code. How can I pass the cookie "checkedCalendars" to my Report.Designer.vb file, in which i have
Me.SqlDataSource1.SelectCommand = "SELECT Subject, Start, [End], aLocation" & Global.Microsoft.VisualBasic.ChrW(13) & Global.Microsoft.VisualBasic.ChrW(10) & "FROM tblActivities WHERE aCalendarID IN ("checkedCalendars") ;" ?

How can i do this?

Thank you very much.

General Discussions

answered on 06 Oct 2010

3 answers

197 views

Telerik Reporting and IIS

I created report using Class Library, copy connection string from app.config to web.config, on web site add reference to Class Library and add control ReportViewer, set Report property and run solution. When run with ASP.NET Development Server report looks normal and data is displayed. But when I run web site directly from IIS, ReportView control is not showing correctly (see pictures).

Files for web site is in c:\inetpub\wwwroot\sitename

in c:\inetpub\wwwroot\sitename\bin is dll, pdb and xml from ReportClassLibrary

Class Library project is elsewhere but within same solution.

Why ReportViewer is normally shown on Developer Server and VS Designer preview but on IIS is not working?

A used almost every control from ASP.NET AJAX controls and they looks identical on IIS and Development server.

General Discussions

answered on 06 Oct 2010

2 answers

101 views

Error showing report with CloudServices

Hi,

I am using telerik reports in Windows Azure Cloud Service (WEBROLE).
when i preview the report in the PREVIEW tab of the report, it works fine.
but when i see the report in the viewer the following error message is shown after the "Generating Report" Progress.

"Not running in a hosted service or the Development Fabric."

i've tried it in simpe Web Project and it worked fine.
if anyone has any idea about it, please guide me.

Regards,
Samee

General Discussions

answered on 06 Oct 2010

1 answer

97 views

telerik reporting with asp.net mvc2

I have a web application and introduced one single asp.net mvc page.

the pages are working fine.

In one page, I am calling an *.ashx which inturn calling the telerik reporting project dll.

the problems:

1. I cannot open the report in designer mode in VS2010
2. the application hangs on in the report class

I am using telerik Q2 2008 version and VS2010 and ASP.NET MVC2

any help?

General Discussions

answered on 06 Oct 2010

0 answers

127 views

"Automated" Excel - PDF generation for Telerik Reports

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

General Discussions

asked on 05 Oct 2010

3 answers

311 views

Table textbox.value blank

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.

General Discussions

answered on 05 Oct 2010

0 answers

199 views

running fields value not printing in page footer in SSRS

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

General Discussions

asked on 05 Oct 2010

5 answers

446 views

Can't create new class library - missing templates?

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.

General Discussions

answered on 05 Oct 2010

3 answers

140 views

problem getting report to display in Sharepoint

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();