Solved

Integration with VB and Crystal Reports - general questions

Posted on 2008-06-19
5
179 Views
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.
0
Comment
Question by:samic400
[X]
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
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
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?

mlmcc
0
 
LVL 13

Author Comment

by:samic400
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?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 21825711
0
 
LVL 13

Author Comment

by:samic400
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?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 21825958
That is correct.

mlmcc
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
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.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

734 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