Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Business Objects InfoView or web interface using Crystal Visual Studio?

Posted on 2011-03-22
Medium Priority
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 101

Accepted Solution

mlmcc earned 2000 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 101

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Loops Section Overview

571 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