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!