Newly added field in the report is empty

(0) Share

Report

Posted on by Community Member

Hello everyone,

Ever experience that you add new field in your SSRS TempTable, populated correctly in Data Provider Class, but after add it to existing report, the new field / column still empty ?

During debug of my Data Provider, as it is X++ Query, I managed to trace it, and confirmed it is has value. In the report object it self, I have restore Data Set, add the field in AutoDesign Data node. But after Build successfully and Deploy report. These newly added still empty.

Any suggestion what should I do ?

Thanks,

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Pete Alberts 3,542 on at

Like (0)

Report
Copy link

Link copied!

Hi Wwwong

I feel you - I have spent many hours struggling with such SSRS reporting issues. Time and again they can be solved by restarting the report server, restarting the VM, iisreset or project rebuild. Restarting the report server is a good place to start.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Pete,

Yeah.. it's testing patience. I solved it by give the report's field a bait, by giving a fixed "trash word". (maybe he deserved)

It appeared then I just switch back to supposed field.

Thanks.

Was this reply helpful? Yes No
Verified answer

Pete Alberts 3,542 on at

Like (0)

Report
Copy link

Link copied!

lol nice one. That reminds me of something. I often need to go through the process of figuring out whether the report is still responding to changes I make. Which can be done by something like that which you described (specifying a fixed value somewhere). And then also, the VS report editor sometimes becomes detached in some way. Don't know what the correct description is - but when you close the designer (or VS) and reopen, your changes will be gone.

So I think what happened is your changes were not "going through" and then before, after or during the trash word procedure something magically got fixed. In any case, I'm glad you managed.

Was this reply helpful? Yes No