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

Help w/SubReport

6 Answers 144 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Will
Top achievements
Rank 1
Will asked on 22 Nov 2007, 02:14 AM
Hello
Well, I have a SubReport that "seems" to work.  However, it only displays data for one parent/master id, not all of the ones in the report. 

I set up my report like the Help file states, except I chose to use stored procedures instead of plain T-SQL query to get the data from our sql server.

The SubReport ONLY seems to display the default value that I set on the Detail Report's SQL Adapter's Parameters property, in design time.  The parameter is an integer (for an ID) and when I set it to any existing ID, the SubReport ONLY shows data for that ID...none of the other ones on the report.  The Master/Parent report passes the parameter and sets it to a value for one of the fields, but apparently this doesn't work or I am doing something wrong.

Any help would be appreciated.
Thanks
 will

6 Answers, 1 is accepted

Sort by
0
Svetoslav
Telerik team
answered on 22 Nov 2007, 01:25 PM
Hello Will,

Please review this example that illustrates how to create master/detail reports using SubReport items and report parameters.

I hope this information helps. Let me know if I can assist you any further.
Thank you.

Regards,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Will
Top achievements
Rank 1
answered on 22 Nov 2007, 05:03 PM
Thanks for the example.  As I posted in my support ticket, I think I figured out my problem.

What would be nice is if you guys had some examples that used stored procedures as well.  We rarely use in line sql statements...for many reasons.

thanks
 - will
0
Svetoslav
Telerik team
answered on 23 Nov 2007, 08:35 AM
Hello Will,

Thank you for getting back to us.

Telerik Reporting does not provide its own data layer handling the data source parameters (what exactly the stored procedure's parameters are) and therefore, is not possible at moment. However, we realize that this is a kind of limitation and will continue to search for possible solutions.

Thank you for your cooperation.

Greetings,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Will
Top achievements
Rank 1
answered on 23 Nov 2007, 06:32 PM
I understand, but you could at least have some examples where the report is built, not with the wizard but uses the sql data adapter and then goes on to show how the person creating the report can select the stored proc, etc. 

regards
 will
0
Svetoslav
Telerik team
answered on 26 Nov 2007, 10:41 AM
Hello Will,

We are aware that our help materials are not good enough yet, but we are working hard to improve it. We believe that soon we will have a strong product reference and examples that will make the use of Telerik Reporting easier.

However, we have a movie that demonstrates how to use an SqlDataAdapter as a report data source. There we use the SqlDataAdapter's wizard to configure the connection and the select query for the data we will display. This wizard allows you to use a stored procedure too.

For more information on data adapter wizards please refer to this KB article. We understand that there are certain differences between using SQL query and stored procedure but the movie demonstrates the main idea and the pros and cons of using a data adapter as a report data source.

I hope this information helps. Please let us know if we can be of any further help.

All the best,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Carla Lewis
Top achievements
Rank 2
answered on 03 Aug 2009, 08:56 PM
Will,

Do you think you could share you solution.  I too use only stored procedures.  Just as you described, my subreport only uses the value if the one parameter that I set during design time in the data adapter.  I've hit brick wall.
Tags
General Discussions
Asked by
Will
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
Will
Top achievements
Rank 1
Carla Lewis
Top achievements
Rank 2
Share this question
or