I have a slight problem, that I'm not sure can even be solved. Any help would be MUCH appreciated!
Problem:
I'm writing some simple reports (test reports for an actual system that I'm going to implement) and I'm using the RDC in Visual Basic 6 to layout the reports. The reports will need to obtain some interesting information such as which Sales Rep(s) to display, for which Publication(s) and which date(s) .. Lots of choices here. I'm finding that the parameter field in Crystal itself is limiting, so I want to design a query screen in VB and pass these parameters to the report to chew up.
I might be completely missing the point here, and please correct me if I'm wrong...
So my approach is to use some code like the following:
'Add a parameter, in this case a publication name.
Report.ParameterFields.Add "test", crStringField
With Report.ParameterFields.Item _(Report.ParameterFields.Count)
.AddCurrentValue "INTELLIGENCER JOURNAL"
End With
So now what? I can't find any way to relate it to the selection criteria! I've been searching through docs and faqs and cannot find any relevant information.
To clear it up a bit, I want to perform something similar to what happens with the Select Expert, ie you create a parameter field, relate it to the relevant field using the select expert. Is this even possible through code?
Thanks in advance!
Jason Hunter
hunterjrj@hotmail.com
Problem:
I'm writing some simple reports (test reports for an actual system that I'm going to implement) and I'm using the RDC in Visual Basic 6 to layout the reports. The reports will need to obtain some interesting information such as which Sales Rep(s) to display, for which Publication(s) and which date(s) .. Lots of choices here. I'm finding that the parameter field in Crystal itself is limiting, so I want to design a query screen in VB and pass these parameters to the report to chew up.
I might be completely missing the point here, and please correct me if I'm wrong...
So my approach is to use some code like the following:
'Add a parameter, in this case a publication name.
Report.ParameterFields.Add "test", crStringField
With Report.ParameterFields.Item _(Report.ParameterFields.Count)
.AddCurrentValue "INTELLIGENCER JOURNAL"
End With
So now what? I can't find any way to relate it to the selection criteria! I've been searching through docs and faqs and cannot find any relevant information.
To clear it up a bit, I want to perform something similar to what happens with the Select Expert, ie you create a parameter field, relate it to the relevant field using the select expert. Is this even possible through code?
Thanks in advance!
Jason Hunter
hunterjrj@hotmail.com