Physical query generating with different table

3295028

Hi all,

I have one logical column with case statement. When I create report with this column its sql gets with wrong table as well that table is not available in LTS.

When I create column with same logic in report it works fine with correct sql.

Can any one help me out in this. What I am missing?

Thanks,

Ajit

[Deleted User]

Edit: Missed a line there.

So for case 1 - are you sure it's referencing the correct column of the RPD and there isn't an old alias being referenced that acutally points elsewhere? Have you checked the XML?

Also: How do the two queries differ in detail? Does the error tell you precisely what's going wrong where? In log level 5 you should be able to see the actual flow throguh the RPD and where what happens and / or goes wrong.