This is a migrated thread and some comments may be shown as answers.

Error: The OVER SQL construct or statement is not supported

5 Answers 288 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Carrie
Top achievements
Rank 1
Carrie asked on 05 Aug 2010, 05:31 PM
I've built a report based on a query which does have the OVER statement in it.  When I originally used the wizard to build this report, it worked great.  I then went back into my .xsd file to "Configure..." this query, and all of a sudden I'm getting this error.  I've been working with this report for a day now (successfully; giving me my desired results), but I can't edit it?  Anyone have any suggestions aside from starting from scratch again (I have it looking the way I want, but I just need to change one line of code in my where statement)??

5 Answers, 1 is accepted

Sort by
0
Carrie
Top achievements
Rank 1
answered on 09 Aug 2010, 10:11 PM
*bump bump*
Anyone else have issues editing complex queries?
0
Ivan
Telerik team
answered on 10 Aug 2010, 09:59 AM
Hi Carrie,

Could you be so kind to elaborate on the exact circumstances when do you get this error message. What kind of data source are you using for the report: SqlDataSource, ObjectDataSource, typed DataSet? Can you explain with more detail what steps are involved so we can reproduce this problem ourselves? It would be very helpful to us if you can send us the problematic SQL statement too.

Since you have mentioned an XSD in your post, I suppose that you are using a typed DataSet for your report and the DataSet designer fails to edit the SQL query for some reason. If that is your case, I am afraid it is not possible for us to fix it, because the DataSet designer is a part of Visual Studio itself, so it is beyond the scope of Telerik Reporting. Our recommendation is to replace your typed DataSet with SqlDataSource, which among other things allows you to edit your SQL query in plain text, so even if the SQL query builder (which is the build-in one from Visual Studio, by the way) fails to recognize your SQL query syntax, you should still be able to modify your query by hand.

Sincerely yours,
Ivan
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Carrie
Top achievements
Rank 1
answered on 10 Aug 2010, 05:07 PM
Hi Ivan!  Yes, you're correct; I've used the DataSet designer.  I'm learning how to use Telerik by the video tutorials, and I'm guessing the one I watched used it as well.  Could you supply me with a link of how to use the SqlDataSource?  I'm assuming I need to add something into my Visual Studio 2008 environment  as I don't see that as an option in my Toolbox when I'm in the report designer.

Thanks again.
0
Steve
Telerik team
answered on 13 Aug 2010, 09:39 AM
Hi Carrie,

The following videos should get you started:
However although we do try to provide videos for important aspects of the product, you should not rely on them entirely and ignore our documentation. Our suggestion is to review the entire Designing Reports section, which contains topics for the SqlDataSource Component as well.

Greetings,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Carrie
Top achievements
Rank 1
answered on 13 Aug 2010, 04:46 PM
Hi Steve:

I'm not sure if it's my own internet provider or not, but I can't view those tutorials.  The window does pop up, but there's an error on both page links.  Also, all the thumbnails for the "Related Videos" are not viewable either. 

I've read most of the documentation, and yes, agreed... I'll run through that section again.

Thanks again.  I'll keep checking the links!
Tags
General Discussions
Asked by
Carrie
Top achievements
Rank 1
Answers by
Carrie
Top achievements
Rank 1
Ivan
Telerik team
Steve
Telerik team
Share this question
or