Nested Table

I have a table nested inside another table. Within the nesting, I want my
data to show me the detail, and not do a grouping. Unfortunately, the inner
table wants to keep doing an aggregate of the data, but I want to show the
detail. So I have a part number that has multiple customers being impacted
by supply limitations, I want to pull the part number with all of its data as
a single record, and then have a nested group that shows all the customer
name, like this:
AAAA
Acme Inc.
Acme Botanical
Acme Logistics
BBBB
Acme Inc.
Acme Environmental
When I add fields to the nested table, I keep having aggregate functions
appear, and if I don't use the aggregates, and specify scope, the data
element is acting like it is pulling from the parent table.
Thanks for any info.
ShaneI have a similar problem. I have a line of header information, then
multiple lines of detail, all coming from the same data source. RS
documentation says you can nest data regions, but I haven't found any
examples. I tried nesting groups and defined the header group as the parent
of the detail group. But, like Shane, I found that the RS insisted on
treating the detail lines as aggregates.
Is there example somewhere of a nested group that produces output in the
form that Shane shows below?
Thanks
Al
Shane Castle" <ShaneCastle@.discussions.microsoft.com> wrote in message
news:DB333B89-E614-48FC-943B-73163C9B735B@.microsoft.com...
> I have a table nested inside another table. Within the nesting, I want my
> data to show me the detail, and not do a grouping. Unfortunately, the
inner
> table wants to keep doing an aggregate of the data, but I want to show the
> detail. So I have a part number that has multiple customers being
impacted
> by supply limitations, I want to pull the part number with all of its data
as
> a single record, and then have a nested group that shows all the customer
> name, like this:
> AAAA
> Acme Inc.
> Acme Botanical
> Acme Logistics
> BBBB
> Acme Inc.
> Acme Environmental
> When I add fields to the nested table, I keep having aggregate functions
> appear, and if I don't use the aggregates, and specify scope, the data
> element is acting like it is pulling from the parent table.
> Thanks for any info.
> Shane|||My work around for this is to have your first report get all the
parts. You would add just one table. The first detail row you place
the part fields. In your second detail row place a subreport.
Make another report for companies. place only a table into this report
and have company fields in a single row. You might have to mess with
page border width stuff.
Use the part id or whatever and pass that into the subreport.
What will happen is that for each part. You'll print your part fields,
then it'll go to the second detail line and run the subreport which
gets all your companies for that part id.
Maybe not the best way to do this, but it's very simple, easy, and
clean.
Shane Castle <ShaneCastle@.discussions.microsoft.com> wrote in message news:<DB333B89-E614-48FC-943B-73163C9B735B@.microsoft.com>...
> I have a table nested inside another table. Within the nesting, I want my
> data to show me the detail, and not do a grouping. Unfortunately, the inner
> table wants to keep doing an aggregate of the data, but I want to show the
> detail. So I have a part number that has multiple customers being impacted
> by supply limitations, I want to pull the part number with all of its data as
> a single record, and then have a nested group that shows all the customer
> name, like this:
> AAAA
> Acme Inc.
> Acme Botanical
> Acme Logistics
> BBBB
> Acme Inc.
> Acme Environmental
> When I add fields to the nested table, I keep having aggregate functions
> appear, and if I don't use the aggregates, and specify scope, the data
> element is acting like it is pulling from the parent table.
> Thanks for any info.
> Shane

nest subreport in a tables detail section

I'm running ssrs 2k and need to put a sub report in a table row. I ran a
simple test by creating a sub report with no data source and just has
textboxes with different colored backgrounds and named it zColors.rdl. I
dragged zColors into a table cell in the detail section. I also dragged a
valid data field into another table cell and ran the report. I can see the
data cell but zColors does not show. I even resized the table row big
enough to assure being able to see the contents of zColors.
Is this even possible in ssrs 2k? and if so, how do I do this?
Thanks.
--
moondaddy@.newsgroup.nospamHello moondaddy,
It is possible.
Instead of increase the main report table cell size, you could reduce the
subreport body size to only include a textbox.
This will be OK.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||Thanks its working now.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OWtVsdm%23HHA.5604@.TK2MSFTNGHUB02.phx.gbl...
> Hello moondaddy,
> It is possible.
> Instead of increase the main report table cell size, you could reduce the
> subreport body size to only include a textbox.
> This will be OK.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> 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.
>|||Hello Moondaddy,
My pleasure. If you have any questions, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.

Needs Help in Making Database

Please see the detail of tables with fields in SQL server 2000.

TableStudent .Table Good Qualities
( It is a list of Students) (It is a list of Good Qualities)
1-Student Id (P.Key)1- Serial No. (P. Key)
2-Student Name 2- Good Quality

Table Bad Qualities .Table Future Plans
(It is a list of Bad Qualities) (It is a list of Plans)
1-Serial No. (P. Key) 1- Serial No. (P. Key)
2-Bad Quality 2- Future Plans

Table-Personality
1-Student Name/ID
2-Good Qualities
3-Bad Qualities
4-Future Plans

Data will store in Personality table like that

Student IDG.Q.No B.Q.NoF.P.No
101 3 2 1
101 4 5 NUll
101 8 Null Null
202 4 8 9
202Null 3 1

Required ResultNow I have to generate a report of One student and
sometimes of many students comprising of their Name, G.qualities, Bad
Qualities and Future Plan. To generate report User input will be only
student id.

I Need help in making relationship of these tables as well as in
Making a Query. Any suggestion to get the required result. Specially
please look at the Personality Table because I do not understand
Primary key for it. Should I just include the Serial No. as Primary
key.
Please make necessary changes to get the required result.

I shall be really thankful to you for your kind favor.Hi

It is better to post the DDL (Create table statements) for your tables
rather than a pseudo-schema

You should have student id in the personality table (as I assume this should
be static and names can change!) if Student -> Personality is a one to one
relationship, student id can be made the primary key of the Personality
Table. Your personality table should have foreign keys for Serial No in each
of the other tables.

John

"Waqas" <waqasdeura@.hotmail.com> wrote in message
news:d1bc2061.0406191203.16d22a43@.posting.google.c om...
> Please see the detail of tables with fields in SQL server 2000.
> Table Student .Table Good Qualities
> ( It is a list of Students) (It is a list of Good Qualities)
> 1- Student Id (P.Key) 1- Serial No. (P. Key)
> 2- Student Name 2- Good Quality
> Table Bad Qualities .Table Future Plans
> (It is a list of Bad Qualities) (It is a list of Plans)
> 1- Serial No. (P. Key) 1- Serial No. (P. Key)
> 2- Bad Quality 2- Future Plans
> Table-Personality
> 1- Student Name/ID
> 2- Good Qualities
> 3- Bad Qualities
> 4- Future Plans
> Data will store in Personality table like that
> Student ID G.Q.No B.Q.No F.P.No
> 101 3 2 1
> 101 4 5 NUll
> 101 8 Null Null
> 202 4 8 9
> 202 Null 3 1
> Required Result Now I have to generate a report of One student and
> sometimes of many students comprising of their Name, G.qualities, Bad
> Qualities and Future Plan. To generate report User input will be only
> student id.
> I Need help in making relationship of these tables as well as in
> Making a Query. Any suggestion to get the required result. Specially
> please look at the Personality Table because I do not understand
> Primary key for it. Should I just include the Serial No. as Primary
> key.
> Please make necessary changes to get the required result.
> I shall be really thankful to you for your kind favor.|||On 19 Jun 2004 13:03:17 -0700, Waqas wrote:

(snip)

>I Need help in making relationship of these tables as well as in
>Making a Query. Any suggestion to get the required result. Specially
>please look at the Personality Table because I do not understand
>Primary key for it. Should I just include the Serial No. as Primary
>key.

Hi Waqas,

I can understand that you don't understand this table. The design is
wrong. Each table has to have a primary key. No columns in the primary key
may allow NULL values. In this design, only the StudentID column disallows
NULLS, and this column by itself clearly is not a primary key. The design
error is that multiple independent n:m relations are stuffed together in
one table.

As I have a strong hunch that this is a homework assignment, I'll stop
here and leave it up to you to use my hints and figure out the correct
model. Apologies if I'm incorrect about this being homework.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||John Bell (jbellnewsposts@.hotmail.com) writes:
> It is better to post the DDL (Create table statements) for your tables
> rather than a pseudo-schema

My guess is that the guy does not have the DDL yet. This looks like
a class assignment to me. And those we are usually not very helpful
with...

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp