How to enumerate all Datasources defined in a report
I know I can get a names datasource with report.GetDataSource() but there seems to be NO way to get a list of all datasources defined in a report.
I'm trying to convert some SRSS reports to Fast-Reports and those reports have multiple seperate queries in them that I added as seperate datasources. Since I also need to have an in( lsit of ID's) that is variable I need to update the SQL. SRSS can take care of this with a paramater that has Multiple value enabled but now I have to do it my self. Since I want some code ot automatically update toe SQL, since all my queries van a part "CLID in (@CLID)" in them I want to replace the "in (@CLID)" with a list of id's like "in (1,2,3,4,5)".
But there seems to be no way to enumerate the Datasources? The reason I go this route is because I want the frx file to be as selfcontained as possible, like the .rdl files in SRSS so I'm trying to build a generic paramater dialog and the fix the SQL queries embedded in the frx before running it.
I guess most people have static reports , an/or use assigning a Dataset (ie a query executed outside the Fast-Report, but still you need to now the name of the dataset, so the code is tightly bound to the frx file, which I want to prevent.
Does amnyone have a good idea or method to get to the Datasources, or should I go another route?