Help w/SubReport

7 posts, 0 answers
  1. Will
    Will avatar
    45 posts
    Member since:
    Aug 2007

    Posted 21 Nov 2007 Link to this post

    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
  2. Svetoslav
    Admin
    Svetoslav avatar
    649 posts

    Posted 22 Nov 2007 Link to this post

    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
  3. DevCraft banner
  4. Will
    Will avatar
    45 posts
    Member since:
    Aug 2007

    Posted 22 Nov 2007 Link to this post

    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
  5. Svetoslav
    Admin
    Svetoslav avatar
    649 posts

    Posted 23 Nov 2007 Link to this post

    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
  6. Will
    Will avatar
    45 posts
    Member since:
    Aug 2007

    Posted 23 Nov 2007 Link to this post

    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
  7. Svetoslav
    Admin
    Svetoslav avatar
    649 posts

    Posted 26 Nov 2007 Link to this post

    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
  8. Carla Lewis
    Carla Lewis avatar
    6 posts
    Member since:
    Nov 2004

    Posted 03 Aug 2009 Link to this post

    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.
Back to Top
DevCraft banner