BBay
November 17th, 2009, 01:57 PM
Hello all
I'm only a basic user (I have basic VB knowledge but have no sub report experience etc) of Crystal (v11) and hoping you can point me in the right direction for my problem.
Trying to extract data from our SQL database to create a report regarding stock and pricing.
Can do this for normal straight forward items, but my slightly more complex issue is that I wish to return several prices against 1 stock item.
ie Stock Sku1 has 4 prices assigned to it (say Euro, Sterling, US and RRP etc)
When I create a report and run it, I get the pricing appearing 'randomly' ie some lines it is Euro and some are Sterling etc.
Think this is due to the way data stored against each item in the table (ie 1st item in the priceing table is returned)
(if in selection expert select Euro etc it only shows the ones it has encountered with the euro info not all info with euro data)
Please could someone point me in the direction of how to do a secondary search or report that ties in.
Hope makes sence and someone can help.
Many thanks!!
I'm only a basic user (I have basic VB knowledge but have no sub report experience etc) of Crystal (v11) and hoping you can point me in the right direction for my problem.
Trying to extract data from our SQL database to create a report regarding stock and pricing.
Can do this for normal straight forward items, but my slightly more complex issue is that I wish to return several prices against 1 stock item.
ie Stock Sku1 has 4 prices assigned to it (say Euro, Sterling, US and RRP etc)
When I create a report and run it, I get the pricing appearing 'randomly' ie some lines it is Euro and some are Sterling etc.
Think this is due to the way data stored against each item in the table (ie 1st item in the priceing table is returned)
(if in selection expert select Euro etc it only shows the ones it has encountered with the euro info not all info with euro data)
Please could someone point me in the direction of how to do a secondary search or report that ties in.
Hope makes sence and someone can help.
Many thanks!!