UD Table in SSRS

Yahoo Archive
1
Whilst asking the question, I had a thought - how does it know the table schema?

I remembered in the RDD that it automatically populated with "Erp" - so this made me believe it was accessing the tables, and I was stuck in the tables thinking how do I access the table value through a join in the F(x) query.

This lead me to take a step back and think, what's the best way of cumulating a large amount of data, then sending only  what I want to see? A view.

So I looked in the views table, and low and behold, there is a dbo.QuoteHed. Expanding the columns list shows my extra UD field that I defined in the RDD.

Simply modifying the existing F(x) query inside the original Quote dataset allowed me to simply put in the extra column, using alias.Column without having to add in yet another join.

Fully available in SSRS now. So happy I figured this one out, haha. 

Cheers,

Dave.
2

Hey all,


*Edit: I've answered my own question, but this may be useful for someone else or good for a future reference, so I thought I'd finish asking the question*


Some newbie questions from me lately, this one is no different.


I've followed these instructions: http://www.datixinc.com/ssrs-report/
SSRS Report: Modify Out of the Box Report in Epicor 10
In this tutorial the expert consultants at Datix share with you how to modify an out of the box SSRS report; a common question asked by Epicor 10 users.
Preview by Yahoo

 

And cannot for the life of me access the user-defined table in SSRS - it keeps on coming up as "Invalid object name 'QuoteHed_UD'."


Now it definitely exists as I've been writing to the table, and reading from it. Checking through SSMS shows it there, and is accessible through the same F(x) query that I have written in SSRS, obviously minus the Parameters.GUID for the tables.


What I've tried so far:

  • Created a new Report Style within the Quote report, using the QuotForm
  • Created a new Report Data Definition as a duplicate of the existing QuotForm, including the UD table and it's relationship to the header table.
  • SSRS - added the LOJ on the table, aliased and tried adding the column in that way.
  • SSRS - added a new Dataset for that table, with the most basic of F(x): ="SELECT * FROM QuoteHed_UD"

Any help would be greatly appreciated, I've modified the RDD's and RS's heaps of times.

Cheers,

Dave.