Common Features/Functionalities in Workbook ???

[Former Member]

Hi Experts,

I need some suggestions regarding some common features/functionalities in Workbook that companies/clients normally use with version 3.5 in all the queries in a workbook. I mean for Example: Common fonts, style, word wrap, column titles that is common in all the quries in a workbook. Features like word wrap, navigation bar and others common across all the queries in a workbook. Please forward me some documents, links that can be useful to setup this across the workbooks.

Basically I am looking for some features that I can suggest to clients that are possible in the workbook in the queries instead of the client guiding me as to what all they could imagine and suggest me to produce in the workbook.

All the feedback will be very much appreciated. Please ask if my description is not clear enough.

Thanks

BBM

[Former Member]

Hi BBM,

I think that a client is always right.

All these workbooks features are completely determined by the client's reporting requirements (definite report formats). I doubt that there are some common features accross clients.

Best regards,

Eugene

[Former Member]

Eugene,

Thanks for replying. Sorry couldn't reply earlier as for some reason, it just wouldn't let me sign into my account. Actually below are the specifics that I would like to have in my workbook. Obviously, if there is something more that I could add would be great, but I would like to have the below ones at least

Experts, feel free to pour in your thoughts. All the help is very much appreciated.

1. Column Compression, Font wrap for the text in the queries. Would like to fit as many columns on 1 page as possible.

2. I would want to deactivate the gridlines from the query so it is not present while printing the query results.

3. Features like Navigation block (with push button, check box or drilldown) in one worksheet and then data available in other worksheets based on the selections from Worksheet1.

4. Some formatting with Hierarchy. Stuff like removing sign of the top node and bolding that hierarchy selection and replacing the sub-nodes with some indentations.

5. Highlighting the totals in the queries.

I would really appreciate if you guys could throw in some ideas on this. Also, if you could point me to some links/documents/sample codes which give some examples close to the above, that will be really helpful.

All the help is very much appreciated.

[Former Member]

Hi BBM,

Just for clarification. I'd distingeesh between reports formatting (as a customer wants to see it for submitting somewhere, some mandatory reports format etc.) and enhancing of workbooks (for a daily work).

If the latter, I think pp. 3 and 4 are somewhat relevant. But from my point of view, make a little sense for a daily analytical client's job.

If you are talking about report's formatting, then it's another issue.

Best regards,

Eugene

[Former Member]

Eugene,

I am talking about enhancing the workbook for daily stuff. I was checking out macros and tried in one of my workbooks. I need to have a code in my macro that would meet all my needs. Some sample VB codes or any other articles/links that would help me do it will be very much appreciated. Let me know if I made myself clear this time.

Thanks,

BBM

[former_member188975]

Hi BBM,

You can find a lot of VB code examples in this forum. But for many of the things that you have mentioned: column width, fonts, gridlines etc you can also create a workbook template and use it to insert queries into. Have you looked intothis option or would it not suit your needs...

[Former Member]

Bhanu,

I think that would suit my needs just perfect if all that would be possible. I don't really need to take the VB route. Could you point me to some links/documents that highlight how to do all that stuff in the workbook (formatting and all the bells & whistles). Although, some good VB codes would be helpful for my knoweldge, and if easy enough, I could use them in my case as well.

Thanks

[former_member188975]

Hi BBM,

Please take a look at this link:

http://help.sap.com/saphelp_nw04/helpdata/en/33/746e393cf65c1ae10000000a114084/content.htm

Also try to search the BI forum for posts by Peter Knoer...you will be able to find a lot of good VB code.

Hope this helps...

[Former Member]

Thanks Bhanu. I did go over that link earlier and also had searched on Peter's posts. I will try another keyword as I did not have much luck before finding codes.