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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports Integration Problems

Status
Not open for further replies.

chrispchenry

Programmer
Nov 12, 2002
16
CA
Hey,
I'm still working away on that dB program I had questions about before. We need to use some sort of Report function, and we decided that Crystal Reports (v4.5) would probably be the easiest way to do it. Boy, were we in for a surprise.

There's very little documentation about how to use it in reference to VB6. I've got the creation of the reports down pat, that was simple enough. Now i need to define the report perameters during runtime.

If I brought up one employees ID number, how would I go about defining the report to only have it display that one person and thier related assignments.

I've been trying to use the .SQLQuery function, but I can't figure out the proper syntax to make it work. CR help has nothing specific about how it works, or the syntax.

I've got the assignments and the employee info. divided into seperate tables, w/ the Employee ID being used as a link between the tables. Oh, and under report options, the report prints on every load.

So, how can I make only the information I want to appear in the report?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top