Hello.
I am using Telerik Reporting Q3 2010 version,
I have created sqlDataSource1 where "SelectCommandType = StoredProcedure" -> query returns data so this is OK...
...BUT When i start crosstab wizard (or table wizard) and select my sqlDataSource1 there are NO "details" fields in the "Details" section of the wizard!! (see attacched printscreen).
I can only click "finish" button (button Next is DISABLED) and so i can not "drag an drop" fields to create a report (in the next step of the wizard which i can not access)
btw : sqldatasource WITHOUT stored procedure ("SelectCommandType = Text") works OK with the crosstab and table wizard - it displays ALL the wizard steps and allows me to drag and drop fields on the report.
Can you please answer me if this is a bug in crosstab wizard or if this is so by design? Our project is very late so your answer would be wery appreciated.
Thank you.
Damir
2 Answers, 1 is accepted
Please read the last post in Temporary Table in Stored Proc forum thread that elaborates on this matter.
If this is not the case, please send us a sample runnable app that exhibits the problem and we would investigate what is happening.
All the best,
Stephan
the Telerik team
Rank 1
Thank you for your reply.
Your link help me solved the problem.
As stated in the link :
"Note this is a bug with the Microsoft Data Set Designer and not Telerik Reporting.
I found this little trick that will get the Data Set Designer to read your metadata from your stored proc and allow you to use the Graphical Designers rather than hand coding everything.
Add this in the beginning section of your stored proc, you may have to remove the tableadapter from the design surface after you add this for it to show. I added mine right after my AS statement and before my declaration and temptable definitions.
IF 1=0 BEGIN
SET FMTONLY OFF
END"