Telerik Forums
Reporting Forum
1 answer
1.5K+ views
Hi,

I was going through the SubReport video in Telerik trainer, except when assigning the filter I get the exact error described in the notes of the Filter wizard:

Cannot perform '=' operation on System.Int32 and System.String

Now, I'm following the exact instructions in the video, both fields from the database are indeed integers and even in checking the datasources I can see that my postID fields are both being read as integers.  I've tried every possible combination of different ='s and no ='s for the Filter property, but the only time I can get it to not throw the error is if I put an exact value in for the parameter, so instead of putting =Paramater.postID I just put in 30 (a known value in the postID's).  Any ideas as to why this error is being thrown?

I know it says right there that this will be thrown in preview mode, but when put into production the error persists.  No clue how to avoid this as it is breaking the exact project that is in the trainer.  Any ideas would be welcome. :)

Also, one issue I do notice is when I go into the Filter wizard, instead of the items I can pick they are all displayed as =Field.accID, =Field.postID, instead of just Field.accID, Field.postID.  Could this have anything to do with it?
Steve
Telerik team
 answered on 14 Oct 2008
1 answer
150 views
I have already  web application of RadControl ASP.NET. 
 I added RadAjaxManager of ASP.NET AJAX. but following error occured. How can I solve this problem?

Compiler Error Message: CS0433: The type 'Telerik.Web.UI.AjaxUpdatedControl' exists in both 'c:\WINDOWS\assembly\GAC_MSIL\Telerik.Web.UI\2008.2.826.35__121fae78165ba3d4\Telerik.Web.UI.dll' and 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\bt2009\f2afd4b4\7ca6f680\assembly\dl3\0ed21d71\001e5fb8_9ed0c701\Telerik.Web.UI.DLL'



 

Steve
Telerik team
 answered on 14 Oct 2008
1 answer
330 views
Hi,

We are currently using Telerik Controls for ASP.NET. We are evaluating the use of Telerik Reporting for our application.

I would like to know if the following is supported or is planned to be supported.
a) Sorting of Columns once the report is rendered
b) Filtering of data
c) Customising the report by removal or addition of columns
d) Ad Hoc Query - Expose our application data model and allow the end user to create their own reports through the web.

I am very keen to include Telerik Reporting in our solution, just given the ease of use and excellent support that my team has been receiving.

Would appreciate your response.

Regards,
Santosh
Steve
Telerik team
 answered on 13 Oct 2008
3 answers
210 views

Hello,
 
I have a data set which changes always. In my report I want to display all data tables of the data set programmatically.

I want to ask, if I can realise this by adding new sub reports. If so, could you kindly give me an example of C#?

Thanks a lot!

Svetoslav
Telerik team
 answered on 13 Oct 2008
1 answer
82 views
Hi there,

You have a great product but I wondered why visual studio express edition is not supported and if it ever will be. At the moment I cannot use it due to this limitation :sad:

Kind regards,
Martin.
Steve
Telerik team
 answered on 13 Oct 2008
4 answers
226 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
322 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
365 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
1,000 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
121 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
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?