Community
Showing results for 
Search instead for 
Do you mean 
Reply

Crystal Reports 2008 data source options

Accepted Solution Solved
Master Commentator
Posts: 287
Country: USA
Accepted Solution

Crystal Reports 2008 data source options

Hello,

 

I am more familiar with Crystal then ACT, so I hope my question makes sense.

With other databases in Crystal, there are other data source options like SQL and views.

Does ACT support the other data source options besides tables?

I don't think so, but I wanted to confirm that with someone that has more ACT experience then I do.

 

Thank you.


Accepted Solutions
Solution
Accepted by topic author training2go
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 43
Country: USA

Re: Crystal Reports 2008 data source options

You are correct.  Even though ACT runs on SQL server and ACT provides the OLEDB interface they do not allow the developer to create stored procedures or views.  To do this you would need and administrator level access to the SQL instance, unrelated to the act security model.

 

 

 

C. Joseph Keesey III, MCAD ACC
ACT! Certified Consultant®
Microsoft Certified Application Developer®

SystemsNet

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 14,384
Country: Australia
Master Commentator
Posts: 287
Country: USA

Re: Crystal Reports 2008 data source options

Thank you Mike.

I viewed the pp presentation and came to the conclusion that the answer is no, ACT only supports tables.

Thank you.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Crystal Reports 2008 data source options

Solution
Accepted by topic author training2go
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 43
Country: USA

Re: Crystal Reports 2008 data source options

You are correct.  Even though ACT runs on SQL server and ACT provides the OLEDB interface they do not allow the developer to create stored procedures or views.  To do this you would need and administrator level access to the SQL instance, unrelated to the act security model.

 

 

 

C. Joseph Keesey III, MCAD ACC
ACT! Certified Consultant®
Microsoft Certified Application Developer®

SystemsNet
Master Commentator
Posts: 287
Country: USA

Re: Crystal Reports 2008 data source options

 

Thank you for letting me know that there are fewer options with an ACT database.

I keep running into differences that I can't explain.

 

 

 


jkeesey wrote:

You are correct.  Even though ACT runs on SQL server and ACT provides the OLEDB interface they do not allow the developer to create stored procedures or views.  To do this you would need and administrator level access to the SQL instance, unrelated to the act security model.