October 14, 2013 at 11:14 am
I have one dataset which has the following fields
ProdID CustomerId Quantity Rate Total Amount.
1 1 2 50 100
1 2 200 50 10000
Each combination of ProdId and CustomerId has a Unique Area manager and I want his name to be displayed above this table.(All the information is together in One table in SQL)
So the final output should look like:
Territory Manager : XYZ
ProdID CustomerId Quantity Rate Total Amount.
1 1 2 50 100
Territory Manager :ABC
ProdID CustomerId Quantity Rate Total Amount.
1 2 200 50 10000
P.S : I already tried page break , but all records should be one below the other
Also, I do not want to type or select any parameters . It should display everything one below the otheras soon as I click preview.
(Kind of complex ...Kindly suggest .)
October 14, 2013 at 12:01 pm
I am able to get values when I pass parameters but how do I get it without typing any values.?
October 15, 2013 at 7:10 am
Hi
Please look at the attached picture, I think it is what you are trying to do.
This is how I did it.
1. Created a new report using the wizard.
2. Chose Tabular report type.
3. Used Territory manager as a page field (on the group data screen).
4. Added all other fields under Details on the group data screen.
5. Finish report creation.
6. Preview report and notice that it is page breaking each territory manager
7. Go back to design view and click on the territory manager under row groups (this will be at the bottom of you screen the go to properties.
8. Expand Group then expand PageBreak and change BreakLocation to none.
Done
October 15, 2013 at 9:22 am
Wonderful !
Thank you so much. You made my day:)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply