I’m awaiting our installing of XIR3 Edge, most of my experience is with XIR2 and I’m fairly sure this couldn’t be done in XIR2… wondering if XIR3 has enhanced this…
My requirement is that our clients are using old unicode reports, which have ‘templates’ that determine some of the layout elements, such as Column order, and Column contents.
I know dynamically changing column contents is going to be a problem due to formatting (Col 1 might be a number in one template, another might be date etc…).
So I’m hoping perhaps that based upon a parameter (or ideally a security group match) I would be able to display/hide specific columns, and have the rest ‘move over’.
I think we can get away with telling our clients that column order is no longer able to be customized, but at least this way I could use one document and have it dynamically change which columns show/hide based on the client viewing it, otherwise I have to make up a few HUNDRED documents which are all basically the same one with various columns hidden/shown. (And no we can’t force the clients to customize and maintain these themselves sadly).
If anyone knows if/how Webi XIR3 can do this , or has another solution I’d love to hear about it.
That will not work, I’ve done that in the past, but changing the color to the background has problems:
The data is still there - Just colored white on white
The other columns are ‘moved over’ to remove gaps.
My current requirement has a report with approx 20-30 columns, however each client has a custom view… about 5 columns are static for all clients, and the rest are mix-n-match based on the clients particular needs. I don’t want a bunch of gaps between every column, not to mention it probably won’t fit on 8x11 paper.
I’m looking for a true Hide (or do-not-display if you will) function. Again I’m not sure if BOBJ XIR3 can handle that or not, and if not I have to go back and try to find another way around this problem with the various clients.
What we really need is the ability to source a WebI report from another WebI report. That would be the equivalent of a report view. That way each person could have their own copy of the format without having to run the query.
I’ve faced with the same problem on one project.
I used one kolumn with joined strings. The problem was of course with witdh of the virtual column wich I solved by using corier font.
But if it’s not good for you a have other solution.
Put one main table and next to it one on one all tables for special client. Filter each table by client name and hide them where they are empty.
This way you will have special layout for each client.
Thanks Maniek, I’ve actually used that technique in the past and it’s a great way to separate ‘standard’ vs ‘custom’ content on a typical row/column report. I had forgotten about this technique.
Using various filters and alerters to hide blocks and change titles etc…
This particular requirement unfortunately has some strict rules about placement of items (Many of the reports are employee payroll related that are visible to an end user as as a sort of paycheck review.)
However I MIGHT be able to utilize a set of blocks instead of the typical 3 Im’ used it… (One static, 2 variable).
I’m thinking that I might be able to acomplish this by having one main block, and several smaller 1-2 column blocks for each ‘section’ so to speak… then each client can choose which blocks to utilize… I could even duplicate blocks so that it would appear as if the order had changed by hiding one and showing another… hmmm The more I think about it, I probably can get it to work since there isn’t any sort of total line…
I’m working on the Universe now (Software is FINALLY installed), so maybe by this time next week I can report back as to whether or not it worked out.
(BOB member since 2006-06-26)
(BOB member since 2002-06-25)