I'm having an issue that began when I added a CTE and an additional left join table (for a total of 2 inner joins and 2 left joins) to my select statement in my data source.
My data source is mostly used by a tree grid to show totals/summary fields.... All data checks out when I save my tree grid pops up with an error when I load into my application. I'd really like to not be limited by the use of CTE OR left joins if that is what is triggering the issue.... screen shots attached. There is another application I'm using that is similar with the same issue... Thank you!
My data source is mostly used by a tree grid to show totals/summary fields.... All data checks out when I save my tree grid pops up with an error when I load into my application. I'd really like to not be limited by the use of CTE OR left joins if that is what is triggering the issue.... screen shots attached. There is another application I'm using that is similar with the same issue... Thank you!
Comment