Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Hooking Report to Dynamic DataSet Post Reply Post New Topic
Author Message
regularguy
Newbie
Newbie


Joined: 10 Jul 2015
Online Status: Offline
Posts: 1
Quote regularguy Replybullet Topic: Hooking Report to Dynamic DataSet
    Posted: 22 Jul 2015 at 6:56am
Hi, I have been struggling with this problem for quite some time:

Users of program that we are developing need to have a ablity to create new reports and view them but they can NOT have a direct access to our database and here come the problems:

In order to view report in CrystalViewer You need to login to database or set it in code via TableLogonInfo but we don't want that so what we have already tried:

          We have a WebService which gets desired data from MySql Database based on SQL Query taken from actual report:

SQL_Query ----> WebService ---->MySql ----> WebService ----> Returned DataSet for user and SetdataSource

As You may know DataSet based on SQLQuery returns only 1 table with pulled out results and if we have more than one table in our Report it doesn't work because Crystal is expecting DataSet with the same ammount of tables with identical names.

How we got around it?

We are actually decomposing returned DataSet to the DataSet with the same ammount of tables with the idenctial names - it was working great until we tried to pull out SQLQuery from SubReports inside of Report.
Sadly using GetSqlStatement on SubReport is not supported.

How are we trying to solve it?

Right now we are trying to reconstruct original SQL_Query of Report and SubReports by analyzing TableLinks structure inside ReportDocument.Database property but it is not as simple as we thought and we think that this is a real AROUND WAY for doing what we are trying to achieve.

Any help would be greatly appreciate.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.