Creating reports and dashboards | Stimulsoft community forum

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

Hello.

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

Thank you.

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

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.