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
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?
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
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.
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
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
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).
Thank you trevor. It worked.