Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Point me in the right direction regarding passing Criteria from VB to 1

Status
Not open for further replies.

RiverGuy

Programmer
Jul 18, 2002
5,011
US
I'm basically pretty lost. My table I'm reporting from has an autonumber ID. Runs off SQL Server. I want to open my report based off a certain ID.

So I have a form, and a use clicks a button, and opens the report showing that Record with the certain ID only.

My only question is--how do I go about this? I am new to Crystal, and I can't find any of those types of properties within the VB code when you make a report with the designer. Do I send a SQL expression, formula field, parameter, or what?

And do I place it on the form that has the viewer, or on the code in the designer itself?

Thanks for any advice.
 
There are several different ways to do this depnding on your integration method and wether you want to pass a recordset or have CR do the record selection. See See faq149-237 for the different integration methods. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
To tell you the truth, I dont know which DLL's I'm using or integration method. All I know is that I'm using the Crystal 8.5 designer method from within VB, which I figured would reference the right files for me to make one from scratch. But now that I check my references, there is a ton of more Crystal files I can reference. I'll start with Crystal Reports Library and see if that gets me anywhere.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top