Morning Bob (UK time) and what a beautiful day it is…even SE London looks pleasant (almost)!
Anyway, here’s my problem: I have 4 tables and 4 charts for each Section in a Report. I’d like to place each table in a Section of it’s own (Section based on the table name) to aid navigation in WebI. Have browsed the forum but didn’t find an answer.
Is it possible to create a Section based on the Table/Chart name and then use that to split your report? I want to end up with 4 Sections within the Sections I already have (Company, Region, etc), so would create a new Section which somehow takes the TableName value. Couldn’t see anything within Functions that was obvious.
There’s an interesting requirement. You can only create sections on objects or variables. That said, I wonder if there is a sneaky way to do this. I wonder if you can create some kind of variable based upon something that is different in each of the tables…
If =1 then “table1”
Else If = 2 then “table2”
etc.
then section on this variable. I’m not convinced it’ll work but I would have a play if I was you. There aren’t any functions out of the box…actually, have a look at document functions…there are things like block number…also you’ve always got the VBA option
You have similar thoughts to me on this Nick. I tried using Block Number, but (just to make things more complex) I need 1 chart AND 1 table in the same Section. BlockNumber will give me a Section per Table/Chart, so it’s almost but not quite right.
I can fiddle around with creating a Variable based on something in the charts/tables to denote each different set of info. I thought BO may have already included something to that effect in their Functions (just under a name I didn’t recognise), but they haven’t. I’ll have a tinker around.
Definitely staying away from VBA , it’s a whole new learning curve. This application is hard enough to learn without throwing that one in there to confuse me
There is a function for section number, isn’t there? Here’s an idea… create a section, and put all four block combinations (table + chart) in each section. Then use the Hide Block function to show only the block that is appropriate for that section, based on the number…
I’m rushed, so I don’t have time to test this right now, but it sounds like it might work… :?
Sounds good Dave, I’ll have a go. It’s OK, I don’t expect you to test it all out as well …though I have 10 or so other reports in Development, now if you want to have a look at those…
Here is something I have done in the past, you have to be carefull with section because if you just create a variable to create the section, you will limit your data to only rows that have that value. Anyway, try creating a spreadsheet that has your section names and some value that you can link to all the rows of your query. Say, in your query pull an object that is just the letter “A”, then in your spread sheet pull in 2 columns, the names of your section, and of course a column that is the letter A. Make the names a detail of A and pull it on as a section. Now you can have a different section for each table.
(BOB member since 2002-08-22)
(BOB member since 2002-08-15)
VBA 
(BOB member since 2002-06-06)
…though I have 10 or so other reports in Development, now if you want to have a look at those… 