I need some help. This is probably a ‘duh’ moment, but on my Credit Form on the header I have the InvoiceNum as
=First(Fields!InvoiceNum.Value,“ARForm”)
When our Finance person goes to run the Group in ARInvoice all of the InvoiceNum’s stay the same in the group. Meaning every Credit Memo has the same Invoice Number. BUT!!! If you print them individually they each have their own InvoiceNum.
What am I missing? Today is our first day after Migration and I’m sooo tired.
Well the First() function means First item on the data set, so when you print on an Invoice Group you have many different Invoices so First() isn’t going to work.
However since you are saying this is the header, unless that header is inside the Tablix it will not let you reference the “Current” record. You’ll have to assign a variable inside the Detail Tablix and display it at the header level.
The code.GetValue is the route I used here but in the future, if you can’t get that working, you could try this.
What I have done in the past is create a hidden field in the tablix the pulls the information I wanted and in the header reference it as a ReportItem. Example would be the InvoiceNum in ARForm. You could create a hidden field in the tablix named ‘rpt_InvoiceNum’ with expression: Fields!InvoiceNum.Value
*Notice that I didn’t use First on the expression. This will let it use current one instead of only the first item.
Then in the header, add a new textbox and add this expression to it: reportitems!rpt_InvoiceNum.value
*Notice the after the ! it uses the name of the textbox that holds the data you want to clone. When the tablix updates the field, the header box you created will update with it.
Hi! I am going through the same issues with a report (SO Pick List). I am trying to add the CALC Ship To Adress on each page.
I am trying to follow the steps but not getting it. Started playing around with SSRS. I understand how to add tables to the reports and view them etc.
So i added multiples tables as datasets. But i only have the OrderHed table in the fields section (which displays each field instead of the first like the datasets.
So is there a way to add the table to the fields section? If not, i am trying to do the steps above but not sure where to start. I need to add a matrix anywhere in the report. Hide it and then create a field in the header that shows the matrix each record. Where i keep getting stuck is creating the matrix. Any more detail guidelines?
