Integration with VB and Crystal Reports - general questions

Posted on 2008-06-19
Medium Priority
Last Modified: 2010-04-30
I have just built a Crystal Report that points to my DB in SQL Server and it works fine. I have all the fields laid out and it is formatted exactly the way I want it to be.

What concerns do I need to have if I decide that I want to use this report layout, but now I want to dynamically change the SQL string from my VB program, instead of using the SQL that was used to originally build the report to preview.
Question by:samic400
  • 3
  • 2
LVL 101

Expert Comment

ID: 21824685
CHange the SQL string in what way?

Crystal doesn't support changing the SELECT clause on the fly like that.

You can easily change other clauses.

What are you trying to do?

LVL 13

Author Comment

ID: 21824736
I guess I've looked at examples and I'd like to change a parameter on the fly. I misspoke. Is it possible to change a parameter on the fly in my VB code and not have it prompt the user?
LVL 13

Author Comment

ID: 21825822
so basically i set up the parameter on the report and then i just pass the value i want in my vb code to change the parameter and the report, which is already prebuilt, will display reflecting this, correct?
LVL 101

Accepted Solution

mlmcc earned 1000 total points
ID: 21825958
That is correct.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

569 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