Display with #/ data in reporting

[Vijay4]

Hi experts,

One of the field in Quivery Displaying with #/ infant of the value,

the Actual date :INVIJAY

But it displays :#/INVIJAY (wrong display)

I have checked the hole data flow right from source, RSA3-PSA-InfoObject-Infoset.

the hole flow is being displyed in rightway like INVIJAY.

In RSRT also it displayed wrong like #/INVIJAY

1. what is the solution for this issue, what I have to do to get like INVIJAY.

2. when data is not available it displays #, I want empty instead of #

I am in BI 7.0 environment. in object Properties also everything ok.

Regards

Vijay

[Former Member · Accepted solution]

Vijay,

Your infoobject is compounded with any other infoobject and compounded infoobject is blank.

There are 2 things to do.

First, load the compounded infoobject so that you will get correct value like XX/VIJAY

Secondly, if you do not want to see the value of compounding infoobject 'XX' then insert this compounded infoobject just above the main infoobject in query designer and hide it.

Let me know if this is not clear to you.

Thanks,

Harry

[Vijay4 · Accepted solution]

Hi Harry,

My problem has been solved by your answer, I choose the secound method for my problem,

Now data is displaying good in reporting. this is perfect answer.

and CSM Reddy for my first question your answer is very helpfull.

I am assigning full points for your both.

Regrads.

[Vijay4]

Hi Harry and CSM Reddy,

My problem has been solved by your answers.

full points are assigned

Regrads

Vijay

[chemicala_srimallikarjuna]

Hi,

Please go through this thread

Regards

CSM Reddy

[Vijay4]

Hi CSM Reddy,

thanks for your answer one of questions, .

my problem is values are comming with #/. (eg., #/INVIJAY).

for this only field data is displaying like this. rest of all fields are displaying good in the report.

regards

Vijay

[former_member213877]

Hi Vijay,

In the query designer, for that particular field, set the display property to Display only Text.

Try if this works..

-Pradnya