Hello,

I am building an application that uses Telerik Reports and I need to figure out a way to be able to create a report independent of any database and then at runtime bind it to a DataSet created completely in code.  To make matters worse, I am unable to add the reporting project to a solution that contains the project I need the report for because that project is a Web Site and there doesn't appear to be any way of getting that done.  What I am able to do is to build the Report Project and then upload the binaries from the Report Project to the website.  From there I can view the Report on the page using the ReportViewer.

Since I am not using a database, I am unable to use the Telerik Reporting Wizard to automatically create my dataset and databind the fields to the data.  What I have done is added a DataSet to my Report Project and built it by hand using the designer to have the exact schema of my results DataSet that I am creating at runtime.

Here is essentially what I'm doing right now
1) Pull records I need in the report from the database into my code
2) Perform relatively complex business logic on the rows that is either impossible or unwise to do in SQL
3) While processing the rows, manually add the results to a DataTable which I then add to a DataSet
4) After processing, create a new instance of my report set myReport.DataSource = myDataSet
5) Add the report to the viewer

When I bring up the page that holds the viewer, the desired report appears in the viewer, but does not contain any data.  Obviously there is a gap in my understanding of how Telerik Reporting works.  Is it possible to bind data to a report without it necessarily being pulled from a database?

Thanks

Does anybody know how to populate a list of reporting services reports from a report server, without manually recreating a list of reports and reportlinks?

Purpose: I have a ReportViewer on a webpage and I want to pass the reportname/link along with some parameters to the report viewer.

I'm not sure if this is the correct forum. Please point me in the right direction if I am off base.

Thanks for any help.
-Megan

Hi..
I added property to my report called   _total_cost

 

public partial class  Total_Tons : Telerik.Reporting.Report

 

{

 

    public decimal _Total_Cost { set; get; }


I have code that calculates the the total cost in the ctor of the Report

this.DataSource = _lstInvoices

 

 

var ct = _lstInvoices.Sum(c => c.cost);

 

_Total_Cost =

Convert.ToDecimal(ct);


How can I use this value in the TEXTBOX ?

When I set the text value to.....
Value =   "= (Sum(Fields.cost)/_Total_Cost)*100"

I get an error 

"_TOTAL_COST is NOT DEFINED IN THE CURRENT CONTEXT'


thanks in advance

 

Hi,

For give me this this has been answered already in this forum.  I tried to find it.

Here's the scenario:
In a Windows Form applicainn, I have a report that contains several sub-reports .  Each sub report binds against business objects that refer to a global singleton object to get their necessary query/look up parameters, like date range.

Currently, the container report handles the .._ItemDataBinding event and sets the global business objects.  Each sub-report handles the .._ItemDataBinding where the business objects are updated and then bould to report.

Well, my data seems to binding late.  It works if i press the preview button twice.

So, it seems like the report has already rendered when the ItemDataBinding event is called.  Does that make sense?

I don't get it.

Is there a better event I could utilize?

Thanks,
Michael

I need to create a datasource in code for a parameter.
The issue I have is when I create the parameter, I set the ValueMember and DisplayMember in the designer and then in the code behind I do this:

    Private Sub ChangeoverRunTimeChart_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.NeedDataSource
        ReportParameters("WorkCentres").AvailableValues.DataSource = GetWorkCentresForDDL()
        ReportParameters("WorkCentres").AvailableValues.DisplayMember = "WorkCentreCode"
        ReportParameters("WorkCentres").AvailableValues.ValueMember = "ID"
    End Sub

Which is the needdatasource event for the report.
When I load up the report, it just shows an empty textbox for the WorkCentres parameter. I can not get it to show a combobox.
Could someone tell me what I am doing wrong please?

Hi,

I have a horizontal bar chart which is currently sized to a full page size. It works fine for about 40 bars but looks too cramped for more. How can I get a chart to split into multiple pages?

Many thanks,
Jason

Hi,

I am using Telerik Reports with my Silverlight 4 application.  I have a MultiValue parameter and when I select values at runtime, it displays a list of values instead of names.  It works in design mode. 

Is this a bug?

Please help.

Hello, I'm trying to load small reports into a larger report. However the full report has lots of whitespace that shouldn't be there.

This base report has our company logo and some other information.

Is my logic wrong for adding reports to a base report?


I've checked the small reports, and each one only takes up their correct amount of space. I checked it by making the background color different from the main report.

Thanks in advance for any advice/help.

Curious what the best practice would be for this situation.

I have a report I am building with about 700 groups.  Each group has approx 75 detail rows.  I am passing a datatable to the report as the datasource.  The datatable has 21 columns and approx 50000 rows.  The report works great excluding the problem below.

In the group header section there is a long string of text (varchar(max)) which serves as the description for the group.  It seems the "best way" is to return that description iteratively for each row as a column in the datatable.  This is of course quite inefficient on several levels.

What would be the best practice to have the items that display only in the group header portion only sent once, not 75 times, in this instance?

Thanks.

-Joel

Hi, telerik! 
    I have silverlight application, wich use Telerik Silverlight  ReportViewer. raise an error:
" Unhandled Error in Silverlight Application An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at Telerik.Reporting.Service.SilverlightClient.ListRenderingExtensionsEventArgs.get_Extensions()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnListRenderingExtensionsCompleted(Object state)
"
Can you help me , please, with this question!