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
0
Carrie
Top achievements
Rank 1
Rank 1
answered on 09 Aug 2010, 10:11 PM
*bump bump*
Anyone else have issues editing complex queries?
Anyone else have issues editing complex queries?
0
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
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
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.
Thanks again.
0
Hi Carrie,
The following videos should get you started:
Greetings,
Steve
the Telerik team
The following videos should get you started:
- Connecting to Data in Telerik Reporting with the SqlDataSource Component
- Connecting to Data and Using Expressions in Telerik Reporting
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
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!
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!