Hi All,
I have copied the standard Check report to the 50000 range to modify as a custom object.
I have kept the GetData and SetData functions to pass values to the Footer for fields that print on the Cheque.
So in the body of the report I have a hidden field that is set with :-
=Last(Fields!DescriptionLine_1_.Value) + Chr(177) +
Last(Fields!DescriptionLine_2_.Value) + Chr(177) +
Last(Fields!CheckToAddr_1__Control7.Value) + Chr(177) +
Last(Fields!CheckToAddr_2_.Value) + Chr(177) +
Last(Fields!CheckToAddr_3_.Value) + Chr(177) +
Last(Fields!CheckToAddr_4_.Value) + Chr(177) etc etc.
In the footer I have :-
=Code.SetData(ReportItems!CheckToAddr.Value,1)
But when I try do a
=Code.GetData(3,1)
I simply get a blank value.
When I look at the dataset in Report Preview->About this report there are two rows in the dataset.
The last row for the dataset does contain the values that I am looking for.
Why does Last not work ?
Any ideas appreciated.
R
0
Comments
Yes it is the first field in the top left hand field
1. The "getdata" textbox must be PHYSICALLY under the "setdata" textbox
2. set an all around red border in your footer section, in order to see if it is fully printed
3. post the getdata and setdata function here, please
after you checked all this, if it still not work, we'll try something else
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Could it be possible that you want to retrieve the value of the dataset field "CheckToAddr_1.Value"? (and accidently took the one with __Control7 in the name?)
What about the other values you Set, can you retrieve their values?
Thanks again for the quick responses.
1. The Get and Set Functions are copied from the Standard Check
2. The Get is indeed under the set.
3. deV.ch I am trying to get Last(Fields!CheckToAddr_1__Control7.Value)
4. I am printing the whole footer.
The interesting bit that I have noticed doing this for one of fields in the footer :-
This is defined by :-
I get a value that is in the first row of the dataset !
WHY ? ](*,)
also, what field are you passing to the setdata? is it the correct one?
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Looking at the dataset in the About this report page I cannot access any values from the Second row in the dataset.
I have shown where I assemble the string and it is all blank except for Chr(117)
In the standard Cheque for the same Journal Line there are also two rows of data but it prints perfectly.
???
can you post a screenshot of the rdlc layout and the classic layout, too?(please indicate what are the involved textboxes)
i think your dataset is populated wrongly...
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
I have attached the screen shots of the layouts.
The simplest example is that I cannot get the Cheque Description line 1.
In the dataset you can see that it is empty on the first row but I have data in the last row.
When defining the string in the body I am using the Last function to get the last row of the Dataset.
Any ideas ?
also take a look at the properties of the rectangle in the footer for the standard check printing...there's probably something you forgot, there...
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog