Skip to Content
author's profile photo Former Member
Former Member

coding

i have to design the layout of a query in the folowing way:

i have 5 headings under which I have different coloumns. The columns which are present in one heading is different from others. this is applicable to all the 5 headings. can anyone tell me wht coding should i write in vba macro to perform the task..... thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2006 at 12:59 PM

    Hi Chandamita,

    Can you please tell me what are the 5 headings and whether they are coming from any InfoObject? Secondly, What are the columns in each heading and their respective IonfoObjects?

    Here, you can have 2 solutions.

    One:

    If the headings is something like company code having 5 codes ...you can follow the below.

    In the columns:

    Drag the Company code IO.

    Under that create a structure and give the columns you want.

    But the columns for each heading will not vary but will get data for respective haeding.

    Two:

    If the columns under each heading should vary, then you need to go for a workbook I believe.

    Pls give more details so that we can arrive to a solution clearly.

    Hope this helps you......

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Well, in this case you need to go for a heading in each column. For example,

      batcchwise opening stock/cost value - opening stock

      batcchwise opening stock/cost value - amount

      batcchwise opening stock/cost value - expiry date.

      Since the columns under each structure varies you can't go for a fixed structure under an infoobject as I said in above post of mine. And still if you want as mentioned by you in your post you should go for a workbook I believe.

      Hope this helps you...

  • Posted on Aug 30, 2006 at 12:38 PM

    Hi Chandamita,

    Can you please explain with an example...it may be possible to do this with a structure and presentation hierarchy...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 30, 2006 at 12:54 PM

    Chandamitha,

    What you have given is very unclear and vague , please give a layout as hanu has suggested.

    Also one more thing to be kept in mind is that you cannot influence the report layout using a VBA macro , you would have to write some exits or whatever that might be used in BW for the same , if you are talking about manipulating the results in terms of refresh , cell level calculations etc , then you could use the VBA macro.

    My 0.02

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.