Ambientguitar
Programmer
Hi guys,
First of all I don't use Crystal too often but I have been tasked with changing a label for a customer of ours.
No matter what I try doesn't seem to work.I will explain. I have a prices table with two values in it pricelevel and unit price
pricelevel 1 is promotional price
price level 0 is retail price
The customer wants it to work like this, if there is a promotional price display that and display the retail price as scored out. if there is no promotional price the display the retail price.
I have tried joins and various other things but I'm at a lose. I did get it to work but it would only work if the product had a promotional price if it only had a price level 1 price it showed all blank??? Any help or guidance would be appreciated.
Thanks in advance!
First of all I don't use Crystal too often but I have been tasked with changing a label for a customer of ours.
No matter what I try doesn't seem to work.I will explain. I have a prices table with two values in it pricelevel and unit price
pricelevel 1 is promotional price
price level 0 is retail price
The customer wants it to work like this, if there is a promotional price display that and display the retail price as scored out. if there is no promotional price the display the retail price.
I have tried joins and various other things but I'm at a lose. I did get it to work but it would only work if the product had a promotional price if it only had a price level 1 price it showed all blank??? Any help or guidance would be appreciated.
Thanks in advance!