Telerik Forums
Reporting Forum
4 answers
214 views
Hello telerik team,

I am building a Master-detail-detail-etc. report but I'm  having difficulties in showing the right results in subreports. I'll try to explain the problem:
I do something like this in a property in the MasterReport: 

Dim

objReport1 As New SubReportClass
objReport1.ConnectString = ConnectString
objReport1.DateID = DateID
objReport1.StudentID = StudentID
objReport1.ID = value
Me.SubReport1.ReportSource = objReport1 


The detailsection shows the results. Works fine.
In subReport1 I want to show another subreport which uses an ID from recordresults from the MasterReport.
In DetailSection1_ItemDataBinding in subReport1 I do:

Dim

section As Processing.DetailSection = (TryCast(sender, Processing.DetailSection))Dim dataRowView As DataRowView = TryCast(section.DataItem, DataRowView)
Dim objReport2 As New SubReportClass2
objReport2 .ConnectString = ConnectString
objReport2 .DateID = DatumID
objReport2 .StudentID StudentID
objReport2 .GoalID =
Integer.Parse(dataRowView("ID").ToString)
Me.SubReport2.ReportSource = objReport2

This shows results but what happens is that the first record of subreport2 shows no results in subreport1 and the second record of subreport2 shows results that belong to the previous record. This how it shows in the ReportViewer. A real print however shows a different result. The first record of subreport2 shows the last record and the second record and further each shows results that belong to the previous record.
I've tried lots of things so far but I can't find a solution.
I hope you understand my explanation and can you offer me some help with this.

Thanks.
Geert

Geejay
Top achievements
Rank 1
 answered on 10 Oct 2008
2 answers
311 views

I am building a solution that includes Telerik controls.  A third-party developed the application for us, and when I try to build it, I get the below error.  It is on my local PC, using Visual Studio 2005 Sp1, so I don't think Full Trust is an issue.

Invalid Resx file. Could not load file or assembly 'Telerik.Reporting, Version=2.8.8.723, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)

 

Steve
Top achievements
Rank 1
 answered on 09 Oct 2008
3 answers
348 views
Hello, 
(sorry if my english isn't  good, i'll try to explain as clear as possible)
When i want to assign a report to a report viewer via code, i do it like that:
Me.ReportViewer1.report = new ReferenceReport.Report1 


ReferenceReport is my dll, who contains report1, report2 and report 3

In my form, i have a combobox that let you choose between Report1, report2, report3. So you can view the report you want
So here is my problem: how can i assign the right report to my reportViewer (via Code)
with the Winforms.ReportViewer i could do this by changing the reporPath, but with telerik reportViewer, i don't know how.. Can you help me?
thanx,
i hope i was clear enough


Steve
Telerik team
 answered on 09 Oct 2008
6 answers
970 views
I am getting the following error when I build (asp.net 2.0). Has anyone ran into this? I don't have version 1.0.0.0 so I'm not sure why it's looking for that version. Thanks for any help.

Could not load file or assembly 'Telerik.Reporting, Version=1.0.0.0,
Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies.
The located assembly's manifest definition does not match the assembly reference.
(Exception from HRESULT: 0x80131040)

I uninstalled the telerik reporting exe and installed it again. Removed the reference and added it again but it still doesn't work. I have the 1.1.0.0 version of Reporting.


Michael
Top achievements
Rank 1
 answered on 09 Oct 2008
2 answers
112 views
I have a windows form with the ReportViewer control on it which I re-use to show various reports. I also have properties on that form to set the report parameters. The first time I show a report with the form it works fine. But for some reason after that I get conversion errors with what seems to be the passing of the report parameters. It's as if it's not closing down the form fully or something.

The start of my form code is like this (I pass in the report I want to view):

    public partial class ReportTester : Form
    {
        public ReportTester(Telerik.Reporting.Report Report)
        {
            InitializeComponent();

            reportViewer1.Report = Report;
            reportViewer1.RefreshReport();
        }

        public int UserId
        {
            set { reportViewer1.Report.ReportParameters["UserID"].Value = value; }
        }
...

And then in my main form I launch reports like this:

                    ReportTester report;
                    if (type == ReportTypeEnum.Regular)
                    {
                        report = new ReportTester(new BPReports.Report1());
                    }
                    else
                    {
                        report = new ReportTester(new BPReports.Report2());
                    }

                   report.UserId = _currUser;
                   report.ShowDialog();
....

But the second time I show a report even if it's the same report I get an error in the viewer about not being able to convert int to string or string to datetime.

Any ideas?

Steve
Telerik team
 answered on 09 Oct 2008
1 answer
233 views
Hi,

I have report with 10 columns inside, all textboxes inside report have CanShrink=True, and user before generation report choose, what columns he want to display(I'm just setting Visible property to True/False based on user choise). The problem is that if user want to display only one or two column report is left aligned with standart width of columns. I need something like GridView has -
gridView1.MasterGridViewTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;  
gridView1.MasterGridViewTemplate.BestFitColumns(); 
Steve
Telerik team
 answered on 08 Oct 2008
6 answers
310 views

1. We need to show the filtered time in report header.
 A textbox added to the position, and assigned to the time string, but empty showed after generation.
2. We need to show empty table when the report query no record, but when i set the datasource to empty IEnumerable<BusinessObject> or null, such error appear as following:

#ERROR# The expression contains object 'CategoryName' that is not defined in the current context.

Appreciated for any response.
Steve
Telerik team
 answered on 07 Oct 2008
2 answers
258 views
Hello,

I'm trying to build a simple ASP.NET web application with two pages. One containing controls that determine the filter parameters for a report that I would like to display on another web page.
As the documentation lack good examples, I've searched in your support web site and found a video that explains how to create a similar project using Telerik Reporting 2007. While trying to do the same with Telerik 2008 SP1, I can't seem to find the SqlDataAdapter in the Telerik Reporting ToolBox (VS 2005).
Can you please guide me in the right direction?

Regards,
Tzach. 
Vishal
Top achievements
Rank 1
 answered on 06 Oct 2008
2 answers
109 views
We use Telerik.Reporting.Processing.ReportProcessor.Render to output barcode programmatically, everything goes fine, but the Render step speed cost 1 sec. I'v tried the barcode font method, the graphics renders much faster, i dont' know why the reporter render cost so much time in render a simple barcode, 1 sec really not good for us when we generate 100 codes at a time in web interface.
Appreciated for any response.
Sonic
Top achievements
Rank 1
 answered on 06 Oct 2008
6 answers
1.2K+ views
I have a text box on the report called txtTotal and I am using function =Sum(Fields.Amount) to get the total of all the txtTotalAmount values. I have placed this field in the  ReportFooterSection1 so I can get all totals on the last page only.

When I get the data back from the server, it will have multiple Total values that will be visible on txtTotal . Then I want to get the grand total amount in text box, txtTotalAmount. On the design time, I am getting the total, but when I view the report on the Web, the report shows the list of all the total values, not the Sum.
How do I resolve this issue?

Thanks
Khan
Top achievements
Rank 1
 answered on 03 Oct 2008
Top users last month
Top achievements
Rank 1
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ivory
Top achievements
Rank 1
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
YF
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?