Hi
I am trying to create an SSRS report that uses information from the QSalesRP table, but there are certain fields that I want that seem to be missing.
Can I add these in somehow? Or do I need to create a new table? The fields I want are the sales rep’s mobile phone number and job title.
Any help would be great.
The QSalesRP table is very basic. Its basically just a table to supply basic sales rep info on a quote.
The information you need to get to is held on the SalesRep table.
Depending on the RDD you’re working with, the SalesRep table may be there… or available as a linked table on the QSalesRP table.
For example, on QuotForm (RDD) QSalesRP has a Linked Table called SalesRepCode (not sure why they can’t just use system table names?).
That will get you to things like CellPhoneNumber & Titale fields.
Keep in mind, you’ll also have to add any fields you need to your RDL query as well.
If you use a linked table… you’ll have to see how QSalesRP is joined into the query. For example, if it is joined as T5, then adding the linked table field would look like:
T5.SalesRepCode_CellPhoneNumber
@dcamlin you rock! That’s exactly what I would’ve suggested. I love those linked tables.
@dcamlin Thanks for this. I think I have added the fields from the linked table
Do I edit the RDL query in Microsoft Report Builder?
yup.
The benefit of using linked tables is that you don’t have to add a new JOIN to your RDL query (in Report Builder). You just have to add the new field references to the query.
Oh, and add them AS query fields as well.
If you’re not familiar, I can grab some screen shots for you… or just search for other threads on here on adding to RDL queries, etc. I’ll see if I can find one, there are plenty on here.
@dr_dan has some nice screen shots on this one as an example:
That is great thank you!
