Telerik Forums
Reporting Forum
3 answers
161 views
Hello: I am noticing a strange behavior with the PDF export of a Telerik Report and am hoping you can help me with it. I have a Report where I added content via the designer, notably a report header that has a table containing underlined fields, something like:

John Smith (border on bottom of cell)            800-123-4566 (border on bottom of cell)            asdf@aol.com (border bottom)
Name                                                             Phone                                                                  Email

....

and then rows of data are appended in the details section. The report views fine in the ASP.NET application. When the file is exported to PDF it shows fine if you go out to the file system and double-click the file to open it in Acrobat. The same PDF, when loaded from the browser (instead of going to the file system c:\inetpub\wwwroot\filename.pdf, go to ie, and navigate to the PDF) loads the report initially but fails to render content that is underlined on the report. So in the above table, John Smith, the phone, and email address would not show up. If the page is resized or zoom changes, the content then tends to load. It also shows up on printing. For the most part, the problem appears to be with content in the report header and it seems to me like the page isn't quite loading 100% (even though Adobe says it is loaded 100%).

I'm not sure if this is an Acrobat problem, an IE problem, or a Telerik problem. Any help is appreciated.
Steve
Telerik team
 answered on 13 Jul 2010
2 answers
843 views
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
PRABHU
Top achievements
Rank 1
 answered on 13 Jul 2010
3 answers
167 views
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
Massimiliano Bassili
Top achievements
Rank 1
 answered on 13 Jul 2010
1 answer
221 views
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

 

Steve
Telerik team
 answered on 13 Jul 2010
1 answer
110 views
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

Steve
Telerik team
 answered on 13 Jul 2010
2 answers
167 views
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?
Jaymie
Top achievements
Rank 1
 answered on 12 Jul 2010
1 answer
219 views
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
Steve
Telerik team
 answered on 12 Jul 2010
1 answer
114 views
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.
Peter
Telerik team
 answered on 12 Jul 2010
1 answer
113 views
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?

           private void LoadReports(List<Report> reports)
        {
            foreach ( Report report in reports ) {
 
                if ( report != null ) {
 
                    SubReport sr = new SubReport();
                    sr.ReportSource = report;
                    this.detail.Items.Add(sr);
                }
            }
        }

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.
Peter
Telerik team
 answered on 12 Jul 2010
0 answers
96 views
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
Joel
Top achievements
Rank 2
 asked on 10 Jul 2010
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?