Combining details from two datasets

Hi. I'm just starting to develop reports using Visual Studio 2005 and
Reporting Services 2005 and am still trying to get my head round things. One
immediate problem I could use some advice on is this.
I'm trying to reproduce a report that, in its original incarnation as an asp
page, displayed data returned by two Stored Procedures. The report displayed
the data returned by SP1 in the first 5 columns and for each Group returned
by SP1, SP2 returned an associated figure that was displayed as column 6.
How would I do this in a RS Report since those report objects that are
associated with Datasets - i.e. Tables, Lists and Matrices - can only be
associated with one Dataset?
I'd appreciate any pointers anyone would care to give me on this.
Regards,
YaHozna.You do this with subreport. A subreport can be put into the field of the
table control. First create two reports. The main one with all the data.
Then the report that will be a subreport. Get the second report to work
stand alone first (create it with parameters). Then drag and drop the second
report into a cell of the table object. Do a right mouse click on the sub
report, parameters and bind the parameters to a field of the dataset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
> Hi. I'm just starting to develop reports using Visual Studio 2005 and
> Reporting Services 2005 and am still trying to get my head round things.
> One
> immediate problem I could use some advice on is this.
> I'm trying to reproduce a report that, in its original incarnation as an
> asp
> page, displayed data returned by two Stored Procedures. The report
> displayed
> the data returned by SP1 in the first 5 columns and for each Group
> returned
> by SP1, SP2 returned an associated figure that was displayed as column 6.
> How would I do this in a RS Report since those report objects that are
> associated with Datasets - i.e. Tables, Lists and Matrices - can only be
> associated with one Dataset?
> I'd appreciate any pointers anyone would care to give me on this.
> Regards,
> YaHozna.|||Bruce, many thanks. That worked perefectly. I wonder if I might presume upon
your patience once more? I can't seem to set the formatting of the subreport
cell in my table to match the rest of the row, which is a different colour
and font. I've tried changing the formatting of the subreport but to no
avail. Is there a way to do this?
Regards,
YaHozna.
"Bruce L-C [MVP]" wrote:
> You do this with subreport. A subreport can be put into the field of the
> table control. First create two reports. The main one with all the data.
> Then the report that will be a subreport. Get the second report to work
> stand alone first (create it with parameters). Then drag and drop the second
> report into a cell of the table object. Do a right mouse click on the sub
> report, parameters and bind the parameters to a field of the dataset.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
> news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
> > Hi. I'm just starting to develop reports using Visual Studio 2005 and
> > Reporting Services 2005 and am still trying to get my head round things.
> > One
> > immediate problem I could use some advice on is this.
> >
> > I'm trying to reproduce a report that, in its original incarnation as an
> > asp
> > page, displayed data returned by two Stored Procedures. The report
> > displayed
> > the data returned by SP1 in the first 5 columns and for each Group
> > returned
> > by SP1, SP2 returned an associated figure that was displayed as column 6.
> >
> > How would I do this in a RS Report since those report objects that are
> > associated with Datasets - i.e. Tables, Lists and Matrices - can only be
> > associated with one Dataset?
> >
> > I'd appreciate any pointers anyone would care to give me on this.
> >
> > Regards,
> >
> > YaHozna.
>
>|||You need to do the formatting in the subreport, not for the cell in the
master report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
news:DE1CEE92-572C-446F-9C17-85E7C4D3F19D@.microsoft.com...
> Bruce, many thanks. That worked perefectly. I wonder if I might presume
> upon
> your patience once more? I can't seem to set the formatting of the
> subreport
> cell in my table to match the rest of the row, which is a different colour
> and font. I've tried changing the formatting of the subreport but to no
> avail. Is there a way to do this?
> Regards,
> YaHozna.
>
> "Bruce L-C [MVP]" wrote:
>> You do this with subreport. A subreport can be put into the field of the
>> table control. First create two reports. The main one with all the data.
>> Then the report that will be a subreport. Get the second report to work
>> stand alone first (create it with parameters). Then drag and drop the
>> second
>> report into a cell of the table object. Do a right mouse click on the sub
>> report, parameters and bind the parameters to a field of the dataset.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
>> news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
>> > Hi. I'm just starting to develop reports using Visual Studio 2005 and
>> > Reporting Services 2005 and am still trying to get my head round
>> > things.
>> > One
>> > immediate problem I could use some advice on is this.
>> >
>> > I'm trying to reproduce a report that, in its original incarnation as
>> > an
>> > asp
>> > page, displayed data returned by two Stored Procedures. The report
>> > displayed
>> > the data returned by SP1 in the first 5 columns and for each Group
>> > returned
>> > by SP1, SP2 returned an associated figure that was displayed as column
>> > 6.
>> >
>> > How would I do this in a RS Report since those report objects that are
>> > associated with Datasets - i.e. Tables, Lists and Matrices - can only
>> > be
>> > associated with one Dataset?
>> >
>> > I'd appreciate any pointers anyone would care to give me on this.
>> >
>> > Regards,
>> >
>> > YaHozna.
>>|||Seems to be displaying old subreport formatting in the main report that has
subsequently been changed. However I shall persevere :)
Many thanks for the help.
Regards,
YaHozna.
"Bruce L-C [MVP]" wrote:
> You need to do the formatting in the subreport, not for the cell in the
> master report.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
> news:DE1CEE92-572C-446F-9C17-85E7C4D3F19D@.microsoft.com...
> > Bruce, many thanks. That worked perefectly. I wonder if I might presume
> > upon
> > your patience once more? I can't seem to set the formatting of the
> > subreport
> > cell in my table to match the rest of the row, which is a different colour
> > and font. I've tried changing the formatting of the subreport but to no
> > avail. Is there a way to do this?
> >
> > Regards,
> >
> > YaHozna.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You do this with subreport. A subreport can be put into the field of the
> >> table control. First create two reports. The main one with all the data.
> >> Then the report that will be a subreport. Get the second report to work
> >> stand alone first (create it with parameters). Then drag and drop the
> >> second
> >> report into a cell of the table object. Do a right mouse click on the sub
> >> report, parameters and bind the parameters to a field of the dataset.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
> >> news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
> >> > Hi. I'm just starting to develop reports using Visual Studio 2005 and
> >> > Reporting Services 2005 and am still trying to get my head round
> >> > things.
> >> > One
> >> > immediate problem I could use some advice on is this.
> >> >
> >> > I'm trying to reproduce a report that, in its original incarnation as
> >> > an
> >> > asp
> >> > page, displayed data returned by two Stored Procedures. The report
> >> > displayed
> >> > the data returned by SP1 in the first 5 columns and for each Group
> >> > returned
> >> > by SP1, SP2 returned an associated figure that was displayed as column
> >> > 6.
> >> >
> >> > How would I do this in a RS Report since those report objects that are
> >> > associated with Datasets - i.e. Tables, Lists and Matrices - can only
> >> > be
> >> > associated with one Dataset?
> >> >
> >> > I'd appreciate any pointers anyone would care to give me on this.
> >> >
> >> > Regards,
> >> >
> >> > YaHozna.
> >>
> >>
> >>
>
>

Combine many rows to one row?

Dear friends,

I have a problem that need some help from expert.Is there any way I could combine many rows into a row in Access using Visual Basic. I want to change the below table from TABLE A to TABLE B

TABLE A SampleCode Test Name Result ID Name Sex 9300105Peripheral Blood Film....
a few poikilocytes are present.S7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
No blast cells seen.S7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
microcytes, elongated cells andS7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
hypochromic but normocytic: . SomeS7585512EDHANDAPANI MAHESHM9300105Peripheral Blood Film....
Majority of rbcs appear slightlyS7585512EDHANDAPANI MAHESHM

Output:

TABLE B SampleCode Test Name Result ID Name Sex 9300105Peripheral Blood Film....
a few poikilocytes are present, No blast cells seen.microcytes, elongated cells and hypochromic but normocytic. Some Majority of rbcs appear slightlyS7585512EDHANDAPANI MAHESHM

Your help would be greatly appreciated

Thanks a lot,

Chicky

---

Chicky

You might want to give this thread from yesterday a look:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1335992&SiteID=1

Combine 2 datasources in one report?

I have loaded up the newest latests, greatest Visual Studio, SQL reporting etc. I have a need to pull in data from multiple sources. Currently I have DTS packages I have to run to dump information into 1 data source to report on. Has anybody figured out a way to have multipled data sources available when in the query builder?

I am scratching my head on this one.

Your report can have 2 datasets, each with a different datasource, but you cannot combine them into a single dataset within the report.

If you need to combine the data from 2 datasources into a single dataset, you'll need to handle this in your query/stored proc via a linked server or something similar.|||Thanks Andy for your quick response. It interesting that one can pull this off in MS Access with a simple ODBC but I cant in SQL reporting. I am not sure what you mean by linked server in this case.|||Linked Servers:
http://msdn2.microsoft.com/en-us/library/aa213778(SQL.80).aspx

Distributed Query:
http://msdn2.microsoft.com/en-us/library/aa172738(sql.80).aspx

collation settings for codepage 1255

Hi,
I am parsing some HTML and getting text from one of the tags encoded in 1255.
In visual studio everything looks ok, but after the text is saved to the DB,
all I can see is '?' standing for each letter.
I tryed playing around with the collation settings for that colomn, but I
just can`t seem to get it to work.
Any ideas?
Thank you in advance,
Elad.
Hi Elad,
I understand that you found that when the text encoded in 1255 was added to
the database, the letters were converted to '?'.
If I have misunderstood, please let me know.
To let me better understand your issue, I would like to know the following
questions:
1. Did you add the text by your application or manually run T-SQL statement
in Query Analyzer?
I recommend that you run the T-SQL statement in QA to see if this issue
persist.
2. Could you please give the table definition and the text content if this
issue can be reproduced in QA?
3. What is the database access provider that you used in your application?
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||I actually solved this a few hours ago.
All I needed to do was add a capital N before opening the '.
That forces SQL server to save the string as unicode.
Problem solved.
Thank you!
|||Hi Eladla,
Thanks for your updating and response.
I am glad to hear that you have resolved this issue by yourself. If you
have any other questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

collation settings for codepage 1255

Hi,
I am parsing some HTML and getting text from one of the tags encoded in 1255.
In visual studio everything looks ok, but after the text is saved to the DB,
all I can see is '?' standing for each letter.
I tryed playing around with the collation settings for that colomn, but I
just can`t seem to get it to work.
Any ideas?
Thank you in advance,
Elad.Hi Elad,
I understand that you found that when the text encoded in 1255 was added to
the database, the letters were converted to '?'.
If I have misunderstood, please let me know.
To let me better understand your issue, I would like to know the following
questions:
1. Did you add the text by your application or manually run T-SQL statement
in Query Analyzer?
I recommend that you run the T-SQL statement in QA to see if this issue
persist.
2. Could you please give the table definition and the text content if this
issue can be reproduced in QA?
3. What is the database access provider that you used in your application?
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||I actually solved this a few hours ago.
All I needed to do was add a capital N before opening the '.
That forces SQL server to save the string as unicode.
Problem solved.
Thank you!|||Hi Eladla,
Thanks for your updating and response.
I am glad to hear that you have resolved this issue by yourself. If you
have any other questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

collation settings for codepage 1255

Hi,
I am parsing some HTML and getting text from one of the tags encoded in 1255
.
In visual studio everything looks ok, but after the text is saved to the DB,
all I can see is '?' standing for each letter.
I tryed playing around with the collation settings for that colomn, but I
just can`t seem to get it to work.
Any ideas?
Thank you in advance,
Elad.Hi Elad,
I understand that you found that when the text encoded in 1255 was added to
the database, the letters were converted to '?'.
If I have misunderstood, please let me know.
To let me better understand your issue, I would like to know the following
questions:
1. Did you add the text by your application or manually run T-SQL statement
in Query Analyzer?
I recommend that you run the T-SQL statement in QA to see if this issue
persist.
2. Could you please give the table definition and the text content if this
issue can be reproduced in QA?
3. What is the database access provider that you used in your application?
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||I actually solved this a few hours ago.
All I needed to do was add a capital N before opening the '.
That forces SQL server to save the string as unicode.
Problem solved.
Thank you!|||Hi Eladla,
Thanks for your updating and response.
I am glad to hear that you have resolved this issue by yourself. If you
have any other questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============