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

Displaying Characteristics on every row in Report

Hello,

My report is as follows:

Branch Date Amt Qty

100 01/01/2009 5 1

(blank cell) 02/01/2009 12 1

200 01/01/2009 10 1

by default, whenever we execute the report in BW, result is as above as branch 100 has two records for two different. But what I need is following

Branch Date Amt Qty

100 01/01/2009 5 1

100 02/01/2009 12 1

200 01/01/2009 10 1

I need to display specific branch on all cells rather than showing empty cell. This is needed as I am passing this file to some external DB. How it can be achieved? I looked into all properties in Query designer, but could not find anything.

Regards

Pank

Edited by: Pankaj Nimje on Jan 13, 2009 1:46 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2009 at 08:20 PM

    Hi Pankaj,

    You were almost there, it is query properties, display...

    Do not suppress/ uncheck - hide repeated key values..

    Regards,

    Sunmit.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      When we excecute the report on Bex Browser, click setting --> tab 'Table' and under Data-Specific setting, we hava option for 'Displaying Repeated Text'. And this is working fine.

      But we do not have such option in Query Designer so that I need not have to set this everytime of execute the report. In query Designer properties, we have option 'Repeated KEY values'.

      Any thoughts would be appreciated.

      Regards

      Pank

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.