Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 14 Dec 2015 at 11:46am
When you use a shared or global variable, it must be declared as the same data type in all places.
I do not understand why you have declared as a number in one place and a string in another place, but you say it is a date. FYI: For most databases, a date is really a number internally.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 15 Dec 2015 at 7:05am
First off, so that you can get the value to show in the sub-report. Either remove the shared variable from the main report or created a new shared variable (for testing purposes) that is a datevar datatype and see if you can assign the database field to that variable. If that works, then change the datatype of the variable to the datevar. Otherwise, keep trying other datatypes until you can get it work (I do not know why it would not work as datevar, but then I do not now your database).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum