Topic: Cross Tab Data Selection Posted: 15 Jul 2011 at 1:26am
Hi,
I am currently putting together a cross tab report for a series of categories of amounts of money, these are all headed under the title standing charge. Within standing charge there are 5 different types of charges. I am trying to tell Crystal to only allow one of these charges where the end date of the data is blank or equal to one certain date. Is this possible or does it need to be an SQL edit?
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 15 Jul 2011 at 7:17am
im not sure, but you could try creating a formula with this criteria and use it in crosstab, as far as formula goes it would be something like if isnull(end date) or (end date) = (sp_date) then (specific_charge)
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
IP Logged
