Sales report issue while saving the query

[Former Member]

Hi,

I am working on Sales reports and that i came across a senario and facing a problem, can anyone help me over this

Senario:

I created a structure in Rows and added few keyfigures to the New structure which is in Rows.

After that i added 2 charcteristics.

Now the problem is that when i save the query i am getting the Keyfigure structure first and then characteristics

But, i need the 2 charcteristics first and then i need the Keyfigures

I changed the query as i want it like i placed 2 charcteristics first and then the keyfigure (structure) and the query saved sucessfully.

The problem is that when i open the query again i found that the Keyfigure (structure) first and then the 2 charcteristics

I did it all my possible ways still the problem perstists

Edited by: MAHESH MUMAR on Oct 6, 2008 2:22 PM

Edited by: MAHESH MUMAR on Oct 6, 2008 2:32 PM

[Former Member]

thanks a lot

[Former Member]

mahesh,,,

can u xplain more what xactly is ur need.

"After that i added 2 charcteristics."

so do u want chars & keyfig in Rows only.

this way i dont think u will have report output ..

Take simple e.g. below:

-

---

$----

---

Quantity

Material

-

---

Channel112--

---

1

-

---

Channel223--

---

34

Is this how u want ur report to display?

that means u will need material and channel in rows and keyfigures ($ & quantity ) in Columns.

if this is not what u seek what else is your rek.

sometimes such display helps to understand.

Yes u can add chars in Rows and then add structure of keyfigure.

Yes you can change the sequence of display in Rows among different structure.

But do u still have something in columns.

It is intersection of Rows & Columns that displays result data set...

let us know in more detailed e.g.

[Former Member]

Did you actually change the chars above the kf in the query designer - or did you do it in the workbook?

[Former Member]

i am doing it in query designer and i am not adding any new chars i am just modifying the structure as previously explained

Edited by: MAHESH MUMAR on Oct 6, 2008 2:41 PM

[Former Member]

Hi

First create structure in Columns and add char to Rows. Save the query then move the structure to Rows and save the query.

Regards,

Chama.