crystal report 9 filtering records with visual basic 6

I have made a report in crystal report 9 and then I added that report in my visual basic application using the add crystal report from the project menu. My report also contains a sub report. Both the report and sub report return all the records from the tables or view they are connected. I want to filter both the report and sub report to give me the limited result e.g all record from a particular month. How will I do this please help. I am using visual basic 6 with service pack 6, crystal report 9 and sql server 2000
ShakeelAhmedAsked:
Who is Participating?
 
ParsiConnect With a Mentor Commented:
You shall set 'SQLQuery'.
For example:
cr1.SQLQuert = "Select * from Q Where Condition"
In which cr1 is your CrystalReport Object, and Q is the name of the query which your report is using, and ofcourse Condition is your Criteria.

Good Luck.
0
 
keijerjhConnect With a Mentor Commented:
Hi,

I've had the same problem.
You should create a parameterized query in your subreport.

Query:
SELECT * FROM ITEM WHERE ITEM_ID='{?ITEM_ID}'
Parameter:
ITEM_ID

Link the parameter ITEM_ID to a field in your main report.
This should do it.

Good luck.
Yelle...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.