Integration with VB and Crystal Reports - general questions

Posted on 2008-06-19
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 250 total points
ID: 21825958
That is correct.


Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
Suggested Courses
Course of the Month6 days, 23 hours left to enroll

623 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