Issue with data page having source as report definition

General
, , , ,
1

Hello People :slight_smile:

I came across a issue with below configuration

  • I have a report definition, this report definition is having a column FullName, this FullName is calculated using declare expression(FirstName+LastName). When I run the report I am able to see FullName column properly.
  • But, Now I am using this report definition as a one of the aggregate source for my data page. And I have a response data transform to map results from report definition to data page. When I run this data page, FullName is getting as blank even though it is mapped properly in response data transform.

When I traced this scenario, I found that FullName is being blank on DataSource pagelist even though values are available in the db. So, there is an issue when I use a column which is calculated declaratively and used as a source for data page.

Everything works fine if I give FirstName and LastName as columns in report definition :>

Is this an expected behavior or some weird issue :open_mouth:

Thanks in advance :slight_smile:

2

@BATTINIRAMESH Hi

I am also facing same issue. do you got any fix for issue? please help with solution if have any.

Thanks.

3

@BATTINIRAMESH,

is Fullname column is exposed column in DB? Did you try to do that and let us know if it works.

4

@ttarun53 Your report definition should have the columns which are being used in the declare expression. Then all the required data will be present on the DataSource page and declare expression will fire properly.

5

@Bala_93 Hello, yes