Add group return error

[Saima Gul]

Hi
I upgraded my reports to new version Q3 2010 and after upgrading my reports return error "Some internel error occur" 
Problem occur when i add group field in report. I did grouping on Fields.ReceivedDate
My query is
string strQuery = @"Select TS.*, Convert(varchar(10), DATEADD(hh,4, TS.ReceivedTime), 101) as ReceivedDate, 
                  DATEADD(hh,4, TS.ReceivedTime) as ReceivedTime 
                  From TrackStatus TS  
                 ORDER BY TS.ReceivedTime ";

i have defined this query in Need_DataSource event

In Q1 2010 version my report was running well but after upgrading it returns error when we preview report
However if i create database function for above query and use function then reports work well
Please help me what is wrong

[Steve]

Hello Saima,

We can only guess what is the problem without a full stacktrace with the exact error or better yet a runnable report that exhibits the problem. Generally speaking, we highly recommend using our SqlDataSource Component for directly connecting to your database instead of using NeedDataSource. You can change the query in the data source component by wiring up the data source parameter with report parameter.

Greetings,
Steve
the Telerik team

[Saima Gul]

I have created a new report by using sqlDataSource having simple query
Select AccountType,AccountType,AccountTitle,GroupAccNo From AccTable
And create group on accountType

Returns error

An error has occurred while processing Report 'tlkFines':
Method not found: 'Int32 System.String.Compare(System.String, System.String, System.Globalization.CultureInfo, System.Globalization.CompareOptions)'.

It seems that new version has some bug as we created group it returns error
you can see attach file of report design

[Steve]

Hello Saima Gul,

We have not been able to reproduce the issue on our end and in fact the sample Product Catalog demo report that we ship with the Telerik Reporting installation is very similar to your setup.
After some searching, we found the following thread: http://social.msdn.microsoft.com/Forums/hu-HU/vstsdb/thread/c97c5dbe-6b5c-42f4-85ed-3ca2ab23d1ba where it is indicated that the problem is missing service pack of the framework.
Indeed if you open the String.Compare Method in MSDN, and navigate to the Version Information section, you would notice that it is supported in: 4, 3.5 SP1, 3.0 SP2, 2.0 SP2 i.e. if you do not have the service packs installed, you might get the error.
If the problem persists after installing the latest service pack for your target framework, we would appreciate if you provide us with a sample runnable project that exhibits the problem, so we can investigate what is happening.

All the best,
Steve
the Telerik team

[Saima Gul]

Thanks for your response
I can not understand why this happen to me. i have created a very simple report. If this is the issue of Framework then why same report run correctly on the previous version Q1-2010 on same PC.

[Saima Gul]

I download and install .NEt Framework SP1 and my problem has been resolved
Thanks for your support

[Mohammad]

hi
what about .netframework 4?
I have installed .net framework 3.5 (not 3.5 sp1) and then installed .net framework 4 without vs.net 2010
and missing method error repeated
what can I do Know?
do you prefer that I installed Framework 3.5sp1?

[Massimiliano Bassili]

if your project targets 3.5, then yes you should install the service pack.

Cheers