Business Objects InfoView or web interface using Crystal Visual Studio?

Posted on 2011-03-22
Last Modified: 2012-06-27
I was all set to go ahead with my plan to use BusinessViews for some reports and SQL Views for others but alas it is not yet to be...

I just came out of a meeting with my supervisor and now I need to look into the pros and cons of using Visual Studio to get the same results that I can get from InfoView - namely the ability to requery the database and change the parameters at run-time.  Am I saying that right - is it Visual Studio that can do that?  The crux of the matter is the price of the licenses from SAP - we don't want to pay that much when we might have the talent in house to create a web interface that can accomplish the same thing.

Thank you.
Question by:lcallah93
  • 2
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 35193323
Before exploring what is it you are trying to do?

If you only need to view reports when a user requests then you can probably build an application to do that relatively easily.

Depending on the nature of the reports and the parameters you can either build an application which calls the reports and uses the Crystal interface to handle parameters or you could build your own forms to handle parameters and pass them to the database.

One advantage of using your own form is you could to some degree enforce some level of row security on the database thus limiting what the user can see.  You can also restrict access to certain reports or report types based on user id or other considerations.

Another advantage of your own form is you can have dynamic and cascading parameters regardless of the version of Crystal.

Another advantage of your own application is the ability to change it as needed to meet new requirements and include new reports.  
Depending on the complexity of the applicatiion you may also want to look at 3rd-party viewers and other tools  This list is by no means all of the available tools but it does have a good variety

If you are looking for the ability to schedule reports for overnight running or emailing to users then you might want to look at the tools on that list with that capability.  There are some good ones at trelatively low-cost.

A simple viewing application is not that difficult to write and doesn't take that much coding.  I have written very simple ones in a few hours.


Author Comment

ID: 35193448
As always, thank you for your reply.  

The interesting thing is that we already have Crystal server with 5 concurrent licenses that is currently only used as a scheduler that generates PDF files nightly.  We are looking into expanding our reporting services to include the ability for our development officers to query the data, hence this issue.

It sounds like the creation of your own form will accomplish the same end as buying additional licenses for Crystal Server - namely allowing users to request data based on criteria and also allowing them to requery.

One more question - I have no Visual Studio experience and am hoping I can still write the report in Crystal 2008 and then just hand it off to the programmer to put it up on the web.  Is that how it works?
LVL 100

Expert Comment

ID: 35193543
It should be that easy.  There is a fair amunt of help at the Crystal site and the Crystal samples.  They even include sample viewing programs.


Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question