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.
LVL 13
samic400Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
That is correct.

mlmcc
0
 
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
All Courses

From novice to tech pro — start learning today.