Questions on Reporting Forum

1 answer

190 views

I have the telerik report assemblies that I want to use in my web project and libraries in one location, lets call it c:\telerik.
If I add a reference c:\telerik\Telerik.Reporting.dll to my web project it gets added but the location is actually C:\Program Files (x86)\Telerik\Reporting Q2 2010\bin\Telerik.Reporting.dll. I assume this has something to do with it being in the GAC.

How can I get it to add it from the location I want?

General Discussions

answered on 06 Oct 2010

3 answers

435 views

User Functions

Is it possible to pass a Report.Parameter to a user function by way of an expression? This expression doesn't work:

= MyReportsLibrary.MyReport.myUserFunction(Parameters.parameter1,Parameters.parameter2)
The expression is attached to the value of a text-box.
parameter1 and parameter2 are strings.

This is the user function:

public static string myUserFunction(string str1,string str2)

{

return str1 + "/" + str2;
}

This is what gets populated into the text-box:

An error has occured while processing TextBox 'textBox1':
The expression contains undefined function call myUserFunction().

General Discussions

answered on 06 Oct 2010

3 answers

163 views

how to get dynamic reports

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

201 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

104 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

99 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

131 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

313 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

202 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

449 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