coding

[Former Member]

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

[Former Member · Accepted solution]

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......

[Former Member · Accepted solution]

sorry to all for replying late....

the report layout is as follows...

heading 1: batchwise opening stock/cost value

column: opening stock, amount, expiry date

heading 2:receipt/cost value

column: receipt stock, amount, expiry date

heading 3: transfer/cost value:

column: transfer stock, amount, expiry date

heading 4: sales/retail value

column: sold stock, amount, expiry date

heading 5: closing stock

column: closing stock,amount, expiry date

do u need any more information....waiting for a reply

[Former Member · Accepted solution]

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...

[former_member184494]

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

[former_member188975]

Hi Chandamita,

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