how to pass the value of subquery?

[m.issa]

Hello all

this is my query:

SELECT M.MnuTextEn,(select MnuTextEn from Menu where MnuType = 'SubMenu' and M.MnuParentID = MnuPermissionID) as PName,
M.MnuParentID FROM Menu M WHERE M.MnuVisible = 'True' AND M.MnuType ='Command'

AND M.MnuPermissionID IN ({Permission})

i used in my textboxes in my report this expression after i added the Menu Table in my datasource: Menu.MnuTextEn,
but how i can use the subquery colomn in the textbox? i used this expression : Menu.PName, but the error message genereted tell that (PName) Colomn doesnot exist.

Thank you

[HighAley]

Hello.

We couldn't reproduce your issue.
Which viewer and version do you use?
Please, send us your report template.

Thank you.

[m.issa]

Hello

Iam using 2012.2 and fx viewer.

In the attachment you can find my report, please see my query inside the report
I want use the value (PName) in the subquery in (Text12) and in the Condition of GroupHeaderBand1

Thank you

[Alex K.]

Hello,

In your report the query return only three column, but your datasource have more of three columns. Please try to remove all columns and run "Retrieve Columns".

Thank you.