I know this isn't .net, but you guys here seem very knowledgeable and I am DESPIRATE for an answer.
We have many reports we run through a VB6 program, setting various parameters before printing or displaying. For most reports, the parameters are not changing, they are staying with older values (last used in testing/dev of actual report).
I'm 99.9% sure I've got the code right. Just that some reports work and other do not, with the same code. All reports use stored procedures as ther source/tables. The only difference we can see is that reports that do not work have a date parameter and the ones that do work do not have a date parameter. For the reports that do not work, no parameters are getting set.
Code sample (is very abbreviated, but wanted to show the basic of the code):
For i = 1 To g_CrystalReport.ParameterFields.Count
Set CRParameter = g_CrystalReport.ParameterFields(i)
With CRParameter
Select Case .Name
Case "{?@Portfolio}"
Call .SetCurrentValue(strPortfolio, crStringField)
End Select
End With
Next i
I tried the new functionality using method AddCurrentValue, but that works worse, if that makes sense! I don't want to get too long in this email.
I'm pushed for time and need this done tonight!
Thanks to anyone who can help!!