I'm just curious if there is something special I need to do to import an RDL report? I know you mention ver 2.0 has import capabilities for SQL reporting, and I can import an existiung RDL, but it fails to run.
I'm obviously missing something....
What can you tell us about the report? Does the report have any parameters?
If possible, please send the report to our support staff.
Actually, I was just playing around and used a sample balance sheet from Microsoft in their sample pack. I am gong to assume the next thing you will tell me is that scneario will not work...lol, fair enough. So what does work and how do you make an RDL work with Splendid?
Would it be possible to make available to the community a sample RDL for testing?
Many thanks...
We still need more information on the report. Was the report against the SplendidCRM database, or did it connect to any other data?
The key to understanding what will work and what will not work is that SplendidCRM must read the SQL query, apply the parameters and execute the query using the existing database connection. All access rights in the database still apply.
In your tests, you should start simple. Create a report that just lists all Accounts, selecting data from vwACCOUNTS. Don't go directly to the tables because the SQL user may not have access to the tables (we typically do not provided public access to tables). You should be able to import this kind of RDL into SplendidCRM and run it.
