You’re offline. This is a read only version of the page.
529
Hi all,
This should be a very simple expression probably, But I haven't got the result yet. Please give a hand with the following.
I am customizing the ProdCalcTrans SRSS report. I have added the SalesTable and SalesLine tables to the datasource query (the query is working properly). I just want to display the Customer name at the header of the report and that is outside of the report. Note: the ProdId group has a page brake so each single prodId would be attach to each page header
if I have this expresion inside the ProdId group: =Fields!salesTableName.Value it shows the related customer name properly.
But I want to this outside the tablix just at the page header and I have made something like this: =Lookup(Fields!ProdId.Value, ReportItems!ProdId.Value, Fields!SalesName.Value, "ProdCacTransDS_Sales")
but it is not working (Lookup is invalid: invalidIdentifier)
Hi Nestor,
Have you tried to add SalesName to tablix somewhere, hide it and use it as ReportItem in header?
Hi Nestor,
That's quite interesting and quite new to me. To be honest, haven't used ReportsItems and usually put only static data to the header (except page numbers).
In this case, I assume you need to switch 1st and 2nd parameters according to the syntax docs.microsoft.com/.../report-builder-functions-lookup-function (check also example explanation)
1st parameter is a source
2nd parameter is a destination
=Lookup(ReportItems!ProdId.Value, Fields!ProdId.Value, Fields!SalesName.Value, "ProdCacTransDS_Sales")
Mmm somthing is telling its possible,
I have at the header the ProdId displayed of the current ProdId on each page. and its working As you can see in the screenshot.
I just need to build an expression to lookup at the query the SalesName where the ProdId is =ReportsItems!ProdId.Value
Hi Nestor,
I assume you want to see on each page different sales names based on the production order on the same page. And you can't use the header in this case. The header is the same for all pages (as footer as well). If you want to implement this kind of change you need to utilize the same tablix and simulate header in it.
Hi Sergei, Thanks for replay,
I can get the sales name Inside the tablix without any problem. But as you said. How to get the same but in the Page Header ( outside the tablix) what would be the expression for that?
I just have the related ProdId which I can get in the textbox field called ProdId
Hi Nestor,
Outside the tablix you need to use aggregated functions. Why you can't add sales name to tablix headers as well as each production order is printed on separated page?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (