Telerik Forums
Reporting Forum
2 answers
273 views
I'm trying to pass a DataSet to a SubReport. I don't want the DataSet to be the SubReport's DataSource. The SubReport has a chart and table in it which will display the contents of the passed DataSet.

The only way I see to pass values to a SubReport is via ReportParameters. That, however, does not allow passing objects. Doing SubReport.ReportSource on DetailSection.ItemDataBound leaves the first detail section without a DataSet.

 
private void detail_ItemDataBound(object sender, EventArgs e) 
    Telerik.Reporting.Processing.DetailSection detailSection = (Telerik.Reporting.Processing.DetailSection)sender; 
 
    DataRow row = (DataRow)detailSection.DataObject.RawData; 
 
    TUsageSubReport subReport = (TUsageSubReport)this.UsageSubReport.ReportSource; 
 
    DataSet ds = null
 
    DB.Reports_GetAccountUsages(Convert.ToInt32(row["UserId"]), new DateTime(2009, 10, 1), new DateTime(2009, 10, 31), m_ConnectionString, out ds); 
 
    subReport.Usages = ds; 
 

Is it possible to get to the actual report object (SubReport.ReportSource) per detail section?
Steve
Telerik team
 answered on 02 Nov 2009
1 answer
201 views
Hello,

I have another problem. This time I am trying to display "Stacked Line chart" and bind DataTable on NeedDataSource.
DataTable source has 3 columns: DateTime, double, double
I want to show DateTime values on X axis and 2 series on chart. Each for the column. LINK TO CHART

I have tried to find similar example in Documentation but I found only very simple examples.

DataTable looks like that:

10-Jan-2000    1.1    2.0
20-Feb-2000    1.4    2.2
24-Apr-2000    1.3    2.5
...
...
...

Could you please also explain me how the binding work? How to create series, legend etc?

Regards,
Michal.  
Steve
Telerik team
 answered on 02 Nov 2009
3 answers
194 views
Hi,

is there any idea when Telerik reporting will be fully supported e.g. the designer in VS 2010


Regards


Alex
Steve
Telerik team
 answered on 02 Nov 2009
10 answers
336 views
Hi
Can you please tell me how to remove unwanted modules from sitefinity admin part in 3.7
I tried removing from the web config below part

 <modules>
        <add type="Telerik.Cms.Engine.GenericContentModule, Telerik.Cms.Engine"/>
        <add type="Telerik.News.NewsModule, Telerik.News"/>
        <add type="Telerik.Blogs.BlogsModule, Telerik.Blogs"/> This two when i try to remove i was getting the error like
        <add type="Telerik.Lists.ListModule, Telerik.Lists"/>

        <add type="Telerik.Polls.PollModule, Telerik.Polls"/>
        <add type="Telerik.Forums.ForumsModule, Telerik.Forums"/>
        <add type="Telerik.Libraries.LibrariesModule, Telerik.Libraries"/>
        <add type="Telerik.Events.EventsModule, Telerik.Events"/>
        <add type="Telerik.Notifications.Newsletters.NewsletterModule, Telerik.Notifications"/>
        <add type="Telerik.Wiki.WikiModule, Telerik.Wiki" />
      </modules>

Server Error in '/' Application.

Could not load file or assembly 'Telerik.Polls]]' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'Telerik.Polls]]' or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 54: 			{
Line 55: Telerik.Web.IControlPanel ctrlPnl = (Telerik.Web.IControlPanel)this.contolPanel;
Line 56: foreach (Telerik.Web.ICommandPanel cmdPnl in ctrlPnl.CommandPanels)
Line 57: this.ToolBoxHolder.Controls.Add((Control)cmdPnl);
Line 58: }

Source File: d:\Program Files\telerik\Sitefinity3.2\WebSites\ProjectName\Sitefinity\Admin\Modules.aspx.cs    Line: 56

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Telerik.Polls]]' could not be loaded.




v
Top achievements
Rank 1
 answered on 02 Nov 2009
1 answer
93 views
Hi

I was watching this video
http://tv.telerik.com/reporting/video/telerik-reporting-+-design-time-support-for-parameterized-queries
I have the version Telerik Reporting Q1 2009,   and is not the same than the video.
I need this example with Parameterized Queries for vb Q1 2009 and the viewer in asp.net
I suggest you.. Make again this video or videos with the last versions

Thank you. 
Steve
Telerik team
 answered on 30 Oct 2009
3 answers
173 views
Hello...
My several customer want to print with dot printer.
does radcontrol for winform has the function which is control dot printer?
Chris Gillies
Top achievements
Rank 1
 answered on 30 Oct 2009
1 answer
235 views
Hi there.

I had a PDF report working fine a bit ago and it stopped working and I think the only thing that changed was the database. One of my co-workers did a bunch of cleanup on his local version of the db, made a backup and I used that backup on my db now.

Anyway, that may or may not be the problem and I am looking for ideas.

A few important things to note about my report:

I am using a stored procedure, so I am manually making that binding happen in the code behind:

 

public My_Report()

 

{

InitializeComponent();

 

this.DataSource = null;

 

 

this.NeedDataSource += new System.EventHandler(this.My_Report_NeedDataSource);

 

}

 

private void My_Report_NeedDataSource(object sender, System.EventArgs e)

 

{

 

this.sqlConnection1.ConnectionString = ConfigurationManager.ConnectionStrings["MyDataContext"].ConnectionString;

 

 

 

//Transfer the ReportParameter value to the parameter of the select command

 

 

this.sqlDataAdapter1.SelectCommand.Parameters["@PersonID"].Value = this.ReportParameters["PersonId"].Value;

 

 

this.sqlDataAdapter1.SelectCommand.Parameters["@OperatorID"].Value = this.ReportParameters["OperatorId"].Value;

 

 

//Take the Telerik.Reporting.Processing.Report instance and set the adapter as it's DataSource

 

Telerik.Reporting.Processing.

Report report = (Telerik.Reporting.Processing.Report)sender;

 

report.DataSource =

this.sqlDataAdapter1;

 

 

// set the table datasource as well

 

table1.DataSource = report.DataSource;

 

// get the picture paths for the person and the company logo

 

pbPerson.Value =

this.ReportParameters["PersonPicturePath"].Value;

 

pbContractor.Value =

this.ReportParameters["ContractorPicturePath"].Value;

 

pbOperator.Value =

this.ReportParameters["OperatorPicturePath"].Value;

 

}

}

Also, I am creating the pdf and saving it to the file system, then opening the pdf as content in my page. Here is how I am save the pdf report to the file system:

 

 

void SaveReport(Telerik.Reporting.Report report, string fileName)

 

{

 

ReportProcessor reportProcessor = new ReportProcessor();

 

 

RenderingResult result = reportProcessor.RenderReport("PDF", report, null);

 

 

using (FileStream fs = new FileStream(fileName, FileMode.Create))

 

{

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

}

}

Then, my pdf shows as embedded content in my aspx page like this:

 

 

<EMBED id="showPDF" runat="server" type="application/pdf" width="750" height="550"></EMBED>

A bit more info:

I am able to run the sproc standalone from inside sql-server management studio with no problems. Also, a pdf report does get created, but it only has header information. The detail section which has the table based on the sproc and a picture box is simply blank.

Anyway, all of this was working in the very recent past and is not working now.

Any ideas on why this is happening would be greatly appreciated!

Mike

 

Michael Love
Top achievements
Rank 1
 answered on 30 Oct 2009
1 answer
102 views
Hi

The default method for getting a value from  the datasource to the report is with =Fields.Datafield.

This assumes Table(0). If I have multiple selects returning multiple tables how to I get to these data items.

Andy
Steve
Telerik team
 answered on 29 Oct 2009
2 answers
199 views
Hi,
I need to localize my reports for Swedish and English.
I have read the article: http://www.telerik.com/help/reporting/advanced-localizing-reports.html but I don't understand how for example the column "Birth date" know what field in the resx file to pick.

If I have for example name/value pair in resx file:
Label_BirthDate     "Birth date"

Then I need to set Label_BirthDate on the textbox in the report, right? So, how do I do that?

Regards,
Mattias
Steve
Telerik team
 answered on 29 Oct 2009
1 answer
222 views

We are working on a telerik controls based project in which we have to generate a report and export it to a PDF format.

Everything is working fine and I am getting a pop-up the moment I click on ExportToPdf button. It asks to open, save or cancel. Save is working but if I select Open I am getting the following error.

Adobe Reader could not open 'RadGrid Export[2].pdf' because it is either not a supported file type or because the file has been damaged.

When I googled I found few links which says to download latest dlls’ which also is not working.

Any kind of help is appreciated.

Daniel
Telerik team
 answered on 29 Oct 2009
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?