"sullins602" <ben.sullins@gmail.com> wrote in message
news:1153347590.259453.220070@i3g2000cwc.googlegroups.com...
> Is the data all on the same server? If so is it possible to return this
> in one stored proc? I typically just return all details in one stored
> proc and then group together in the report...
>
> Chris Taylor wrote:
>> I was asked this question today by someone wanting to have multiple
>> datasets
>> in a report. Such as
>>
>> --Main report
>>
>> - GL Account Header
>> - sub report data
>> - GL Account header
>> - sub data
>> - sub data
>>
>> We are making a ton of SQL calls to execute this report and it takes
>> forever
>> to render. We basically want to merge data between the datasets, but
>> don't
>> know how to do so. I know RS offers something with multiple data sets on
>> a
>> report, but not quite sure how that works. Was wondering if anyone else
>> has
>> had this issue.
>>
>> Thanks
>> chris
>

""privatenews"" <petery@online.microsoft.com> wrote in message
news:NhuTmm6qGHA.1572@TK2MSFTNGXA01.phx.gbl...
> Hello Chris,
>
> Thank you for your post in MSDN newsgroup!
>
> I understand that you want to merge data between dataset by using join
> etc.
> If it is incorrect, please let me know.
>
> Per your question, the formal report side join functionality is currently
> on a wish list for a release after RS 2005.
>
> AFAIK, using a report with one data set driving the parameters of a
> subreport for each row of the joined table is the only workaround. This is
> probably going to be a slow run unless you can cache the results before
> running the more expensive query.
>
> Also, as Ben mentioned, you may want to use a SP to merge the results of
> current SPs into one dataset instead of doing this on RS level.
>
> Alternatively you can write your own Data Processing Extension and handle
> combining the results yourself prior to handing them to our server.
> However, this shall bring more complexity.
>
> If anything is unclear or you have concerns on this, please feel free to
> let's know.
>
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>