Multiple db fields each with different conditions?
I need desparate help for creating Crystal Report.
I have the Advanced Edition version 9 and I have a report that is bound to an XML file with multiple data tables (the XML file is generated by a dataset).
One of the datatables is a master table, and the rest are supporting data, such as localisation, formatting and etc. I want to be able to produce fields on the screen each with different conditions (think Select Formatting.Title from Formatting where Formatting.ID = 'xxx').
Since it is an XML datasource, the SQL Expression Field is not available. I tried using Select Expert but once I set a condition, all other Database fields are displayed with that one condition i.e. you cannot have multiple Database fields with the same name on the screen each with different conditions. Help!
Siew Fai.
Siew Fai
|
