Problem with the report Design [Closed]

[Desperado]

Hi All,

I have an issue with a report.

I'm designing a list report with one column as section.

lets say the underlying table has 20 records. The requirement is like this.
1. for a set of rows say 4 or  5 or 6 rows specifeid there should be a single space

how to do this ?

the layout should be like this:

Product Name (This is section)

Product Type   Product Code  Quantity
type1               code1             1
type 3              code 3             3
type 4              code4             4
type 7              code 7             7

type 5              code5               5
type2               code2              2
type6               code6              6
type9               code9              55
type11              code11             22

type12             code12               12 
type14             code14                 1
type 8              code8                  8

how to do this ?
i tried using multiple lists and case statement. but its giving me an error when i'm tring to assosiate with the section.
please let me know if there is any workaround. i even tried with table in the list also. But it didnt work. :(

Thanks in Advance

[rockytopmark]

Please verify... you wish to have a child list object, contained within a parent list object (section), correct?  ... and in the child list, you would like a blank row every now and again? 

You wrote "4 or 5 or 6 rows specified"  can you elaborate on this?

[Desperado]

i can go for a child list object with a master detail , but the problem is, then i have to go for 5 child lists . I have 5 grouped items where the data is comming from the same column of a table.
to explain it simply , if we display it as a list report  the data will be like this

1
2
3
4
5
6
7
8
9

but the user want it like this

9
6
5

1
3
4

2
7
8

that means a single line space in between the rows.
hope i made it clear this time  :(
Please let me know, if i have to add some more details.
Thanks for the response

[rockytopmark]

So in your example, 9, 6 and 5 are of the same family, 1, 3 and 4 are from another family and the others in a yet a third family... yes?

I think you need 3 lists.  List 1 is the Product Name and is the Master to List 2, which is the Product family and list 3 is the product IDs.  List 2 will be the master to list 3, by Product Family

1. Create a list report
2. Drag the 3 levels for the Product into the list.
3. Section the top level
4. Section the middle level
5. remove the class from the Middle level's section title box
6. set the Box Type for the lowest level's list title to None

THe results look like what I think you want.  I use the Great Outdoors Company power cube as source to write a report that emulates what I am thinking you need.  This XML is attached.

[Desperado]

Thank you for the reply. I tried to do what you said.

1.Created a list and associated the query2 to the page
2. Inserted another list and created the master detail relation between query1 and query2
3. Inserted one more list and created master detail relation between query2 and query 3
4. created the sections, when i run the report, the output is as follows:

it it displaying all the data for the first list for all the sections and then displaying data for the second list

ie,

say for the first list the data is
section1

product type list1

section 2

product type list1


for the second list the data is :

section1

product type list2


But i want the data like this:

section1

Product type list1
Product type list2

Section2

product type list1


Thats y I unlocked the first list and inserted the second list in the first one. i did the same for third list also inserted in List 1.

when i run the report it's displaying the first page properly and the last page properly. If i try todo a pagedown or view the report in pdf, it's throwing me an sql error.
I don't know if i'm doing ny mistake or if it is a mistake from the db.

and one more error is i'm using a case stmt to define the family

case
when [ClaimsEncounter].[Operational Perfomance Summary].[Aggregation Name]='Total New Claims Processed' then 'Total New Claims Processed'
when [ClaimsEncounter].[Operational Perfomance Summary].[Aggregation Name]='Total New Claims Paid' then 'Total New Claims Paid'
else null
end


with this case, the o/p is as follows
Total New Claims Processed
Total New Claims Paid
blank column
the blank one is because it's aggregating all the remaining values and giving it to me in a blank cell.
Actually i dont want that... how to remove that one ? I think in my scenarion i cant use a row num also ....

Please do the needful

[rockytopmark]

Did you run the example agains the Great Outdoors Sample cube?  It matches what I thought you needed.

You don't need to associate any query to the page... I didn't say to do that.

I did leave out to remove the Middle list section's test.  There should be nothing displaying from the middle list.  The 1st list should contail the 2nd list only.  The 2nd list should contain the 3rd list.

Below is the actual output from the report I wrote and posted in this topic.  If this isn't what you are looking for then I don't think I understand your needs... sorry.

-----------------------------------------------------------------------------

Camping Equipment

TrailChef Water Bag
TrailChef Canteen
TrailChef Deluxe Cook Set
TrailChef Double Flame
TrailChef Kettle
TrailChef Kitchen Kit
TrailChef Cup
TrailChef Cook Set
TrailChef Single Flame
TrailChef Utensils


Hibernator Extreme
Hibernator Self - Inflating Mat
Hibernator Lite
Hibernator
Hibernator Pad
Hibernator Camp Cot
Hibernator Pillow


Canyon Mule Journey Backpack
Canyon Mule Extreme Backpack
Canyon Mule Climber Backpack

[trevorp]

Hi

You could try and create a seperate group by for the grouping (if value in (1,2,3,) then (1) etc etc.

Then group by this in the report, set a footer, then CUT the column out of the report. The footer will give the spacing (hopefully).

[Desperado]

Thank you trevor. It worked.