Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

Integration with VB and Crystal Reports - general questions

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
samic400
Asked:
samic400
  • 3
  • 2
1 Solution
 
mlmccCommented:
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
 
samic400Author Commented:
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
 
samic400Author Commented:
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
 
mlmccCommented:
That is correct.

mlmcc
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now