SBX - Search With Button

SBX - Forum Post Title

Add field to dataset SSRS report data is not show

Microsoft Dynamics AX Forum

Yuttapong-B asked a question on 14 Sep 2018 5:10 AM

Question Status

Suggested Answer

Hello all, i need help

field is standard from system, i would customize SSRS reports

add field to dataset

data is not show help me pls.

Reply

Hi Yuttapong-B,

Did you do CIL compilation and try to refresh report server cache from Tools menu?

Reply
Yuttapong-B responded on 14 Sep 2018 5:50 AM

Sorry SIR. where is it?

Thank you.

Reply
Yuttapong-B responded on 14 Sep 2018 6:11 AM

Not show. T^T

Reply

Did you do CIL ? Also did you check that value gets populated in DP ?

Reply
David Hu - Fusion Alliance responded on 14 Sep 2018 10:13 AM
My Badges

Hello Yuttapong-B

Did you try restarting SQL reporting service?

Thanks

Reply

Try restarting SSRS service.

Reply
Zeeshan Adeel responded on 19 Sep 2018 2:16 AM
My Badges

Tool> Cache >

Refresh data

Refresh dictionary

Refresh elements

Refresh report server

then Refresh dataset in your report.

Restart AOS and SSRS services.

Reply
Mariano Gracia responded on 19 Sep 2018 4:23 AM
My Badges

You're copying a field which name's begins with DEL_, have you checked the configuration key?, may be is a SysDeleteObject. Each time I have had those kind of problems, in addition what the other colaborators says,  I also delete the auc files from my user folder

Reply
Dinkar responded on 19 Sep 2018 4:39 AM
My Badges
Suggested Answer

Hi

if you are PurchReqTable form in your first screen shot then you are following wrong approach.

Check form this is method name is vendName() in PurchReqLine Table.

Take name EDT in your TMP table and justuse this method in DP Class.

I have not used DEL_ type EDT so not sure it will work or not

Reply
Udhaya Chandran Rajendran responded on 19 Sep 2018 5:06 AM
My Badges
Suggested Answer

Hi,

Try hard coding the value in the text box of the report in the design and check whether you able to get the hard coded value in the report. If yes,  you're able to see the hard coded value then the problem with the logic to bring the value (debug the dp class). If you're not able to see the hard coded value, then the problem with field string control, try deleting the field and create a new field and follow the same.

Best,

Uday.

Reply
Dinkar responded on 19 Sep 2018 4:39 AM
My Badges
Suggested Answer

Hi

if you are PurchReqTable form in your first screen shot then you are following wrong approach.

Check form this is method name is vendName() in PurchReqLine Table.

Take name EDT in your TMP table and justuse this method in DP Class.

I have not used DEL_ type EDT so not sure it will work or not

Reply
Udhaya Chandran Rajendran responded on 19 Sep 2018 5:06 AM
My Badges
Suggested Answer

Hi,

Try hard coding the value in the text box of the report in the design and check whether you able to get the hard coded value in the report. If yes,  you're able to see the hard coded value then the problem with the logic to bring the value (debug the dp class). If you're not able to see the hard coded value, then the problem with field string control, try deleting the field and create a new field and follow the same.

Best,

Uday.

Reply

SBX - Two Col Forum

SBX - Migrated JS