Connecting Data with Groups

I'm creating Reporting Services reports in Visual Studio. I'm in the
interface that shows the Data, Layout, and Preview tabs.
I've recently learned that I can drag a list control onto the design surface
from the toolbox, then drag a field from the dataset onto the list control.
I can click the list control properties, click "Edit details group..." In
the top line of the expression list, I choose my field from the dropdown. I
check "Page break at end." If my data is from "select name from mytable", and
there's 4 names, I get 4 pages. This works great!
Here's the problem. I want my data to be from "select name, itemsordered,
itemsbought from mytable". I want itemsordered and itemsbought to go into a
table, leaving name in the list control. How do I reference the table control
to the list control?
I have 4 records. In everything I've tried, pages 1-4 show the names in the
list control, and pages 5-8 show the items in the table. Page 1 should show
the name from record 1, and the items in the table from record 1. Page 2
should show the name from record 2, and the items in the table from record
2...
--
RandyI believe I was one of those who answered before and thought this may be an
issue. There are a couple of approaches you can take. The first is to
continue using the list control. You can actually drag any fields you want
into it. Resize it if you don't have enough room. You can arrange the
additional fields in a table format.
If you want a real table format then you should replace the list control
with the table control.
You'll start out with three rows, the header, detail and footer.
Right click on the gray row selector on the far left of the detail row.
Click "Insert Group"
In the first row of the expressions list pick the name field from the combo
box.
Check the "Page break at end" check box below.
Click "OK"
You'll now have two new rows in the table, one above and one below the
detail row. These are the group header and footer rows.
You can drag the name field to the group header.
You can drag the other fields to the detail row.
Based on your first post it sounds like you'll need more than one detail row
to accomodate all of the fields. If this is the case, simply right click on
the row selector for the detail row and click "Insert row above" or "Insert
row below" and this will add detail rows. You can also right click on the
group footer row selector and choose "Delete rows" to delete it if you don't
need a group footer. You should also know that if you need more columns to
arrange your fields you can right click on the column selectors and insert
additional columns.
Hope that helps.
"randy1200" wrote:
> I'm creating Reporting Services reports in Visual Studio. I'm in the
> interface that shows the Data, Layout, and Preview tabs.
> I've recently learned that I can drag a list control onto the design surface
> from the toolbox, then drag a field from the dataset onto the list control.
> I can click the list control properties, click "Edit details group..." In
> the top line of the expression list, I choose my field from the dropdown. I
> check "Page break at end." If my data is from "select name from mytable", and
> there's 4 names, I get 4 pages. This works great!
> Here's the problem. I want my data to be from "select name, itemsordered,
> itemsbought from mytable". I want itemsordered and itemsbought to go into a
> table, leaving name in the list control. How do I reference the table control
> to the list control?
> I have 4 records. In everything I've tried, pages 1-4 show the names in the
> list control, and pages 5-8 show the items in the table. Page 1 should show
> the name from record 1, and the items in the table from record 1. Page 2
> should show the name from record 2, and the items in the table from record
> 2...
> --
> Randy|||Hi Randy,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to show
reference a table in a list. If I misunderstood your concern, please feel
free to point it out.
You can just drag a table in to the list control and put the fields into
the table.
Hope this will be helpful.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Many thanks for the responses. They are appreciated. Your previous response
did help a lot.
The idea is I'd like to sync different toolbox containers to display from
the same record.
I get the idea that I can just position items from the DataSet within a
large listbox. I'm just surprised that Microsoft didn't provide a facility
to allow items from the same record to display in different tools such as
table and list. I can imagine times when it would be very useful.
Randy
"Limey" <Limey@.discussions.microsoft.com> wrote in message
news:F8DA3AB0-25D7-4EF6-ACEB-0CF0E6CF899B@.microsoft.com...
>I believe I was one of those who answered before and thought this may be an
> issue. There are a couple of approaches you can take. The first is to
> continue using the list control. You can actually drag any fields you
> want
> into it. Resize it if you don't have enough room. You can arrange the
> additional fields in a table format.
> If you want a real table format then you should replace the list control
> with the table control.
> You'll start out with three rows, the header, detail and footer.
> Right click on the gray row selector on the far left of the detail row.
> Click "Insert Group"
> In the first row of the expressions list pick the name field from the
> combo
> box.
> Check the "Page break at end" check box below.
> Click "OK"
> You'll now have two new rows in the table, one above and one below the
> detail row. These are the group header and footer rows.
> You can drag the name field to the group header.
> You can drag the other fields to the detail row.
> Based on your first post it sounds like you'll need more than one detail
> row
> to accomodate all of the fields. If this is the case, simply right click
> on
> the row selector for the detail row and click "Insert row above" or
> "Insert
> row below" and this will add detail rows. You can also right click on the
> group footer row selector and choose "Delete rows" to delete it if you
> don't
> need a group footer. You should also know that if you need more columns
> to
> arrange your fields you can right click on the column selectors and insert
> additional columns.
> Hope that helps.
>
> "randy1200" wrote:
>> I'm creating Reporting Services reports in Visual Studio. I'm in the
>> interface that shows the Data, Layout, and Preview tabs.
>> I've recently learned that I can drag a list control onto the design
>> surface
>> from the toolbox, then drag a field from the dataset onto the list
>> control.
>> I can click the list control properties, click "Edit details group..." In
>> the top line of the expression list, I choose my field from the dropdown.
>> I
>> check "Page break at end." If my data is from "select name from mytable",
>> and
>> there's 4 names, I get 4 pages. This works great!
>> Here's the problem. I want my data to be from "select name, itemsordered,
>> itemsbought from mytable". I want itemsordered and itemsbought to go into
>> a
>> table, leaving name in the list control. How do I reference the table
>> control
>> to the list control?
>> I have 4 records. In everything I've tried, pages 1-4 show the names in
>> the
>> list control, and pages 5-8 show the items in the table. Page 1 should
>> show
>> the name from record 1, and the items in the table from record 1. Page 2
>> should show the name from record 2, and the items in the table from
>> record
>> 2...
>> --
>> Randy|||Many thanks for the response.
What you said here is exactly right. The problem is that my DataSet is a
select statement which uses both inner and outer joins. If there's not a
one-to-one relationship for a joined record, then the table can end up
displaying more than one record for a given item in the list control.
It really seems funny to me that Microsoft doesn't provide a mechanism to
link different tools from the toolbox (such as table and list) to a given
record.
Randy
"Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
news:OHaY6b9RGHA.3492@.TK2MSFTNGXA03.phx.gbl...
> Hi Randy,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You want to show
> reference a table in a list. If I misunderstood your concern, please feel
> free to point it out.
> You can just drag a table in to the list control and put the fields into
> the table.
> Hope this will be helpful.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||I have needed to do what you are talking about many times (if I understand
correctly). When using list boxes ... if you have multiple groupings then
you need to nest the list boxes within each other. For instance ... if you
have data like city, state, country. You can create a table that has
groupings by country, state, and city and display detail info about the city
within the table. If you want to have a similar display using lists ... then
you must have 3 list boxes nested. The outer is grouped by country, next
inner list is state, and inside state is city. That might get you started.
"Randy" wrote:
> Many thanks for the response.
> What you said here is exactly right. The problem is that my DataSet is a
> select statement which uses both inner and outer joins. If there's not a
> one-to-one relationship for a joined record, then the table can end up
> displaying more than one record for a given item in the list control.
> It really seems funny to me that Microsoft doesn't provide a mechanism to
> link different tools from the toolbox (such as table and list) to a given
> record.
> Randy
> "Wei Lu" <t-weilu@.online.microsoft.com> wrote in message
> news:OHaY6b9RGHA.3492@.TK2MSFTNGXA03.phx.gbl...
> > Hi Randy,
> >
> > Welcome to use MSDN Managed Newsgroup Support.
> >
> > From your description, my understanding of this issue is: You want to show
> > reference a table in a list. If I misunderstood your concern, please feel
> > free to point it out.
> >
> > You can just drag a table in to the list control and put the fields into
> > the table.
> >
> > Hope this will be helpful.
> >
> > Wei Lu
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> > =====================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
>
>