Any Problem with this code?
-
I am trying to insert multiple records on crystal report 10 using the following codes. I have multiple columns, too. But the following code displays only the first record in the dataset. when i put the last two lines before the word "next" it displays only the last record. Can any one fix it or give me some suggestions? I thank any efforts made to solve this problem NB: param3 is the parameter field that is found on crystal report For c.rowIndex = 0 To c.ds.Tables("studreport").Rows.Count - 1 discvalue = New ParameterDiscreteValue discvalue.Value = c.custView(c.rowIndex)("coursename") param3.CurrentValues.Add(discvalue) paramfields.Add(param3) Next
-
I am trying to insert multiple records on crystal report 10 using the following codes. I have multiple columns, too. But the following code displays only the first record in the dataset. when i put the last two lines before the word "next" it displays only the last record. Can any one fix it or give me some suggestions? I thank any efforts made to solve this problem NB: param3 is the parameter field that is found on crystal report For c.rowIndex = 0 To c.ds.Tables("studreport").Rows.Count - 1 discvalue = New ParameterDiscreteValue discvalue.Value = c.custView(c.rowIndex)("coursename") param3.CurrentValues.Add(discvalue) paramfields.Add(param3) Next
Normally you set your crystal report up and throw a query/stored procedure/dataset at it and it does the rest... why are you using this code?
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
Normally you set your crystal report up and throw a query/stored procedure/dataset at it and it does the rest... why are you using this code?
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
i used this code because the final data to be displayed on crystal report depends on user data input. everytime user input changes the report data changes.
Parameters generally used as a selection or displaying some information ie user name, department. They are not meant for passing in the report data itself. The Crystal Report should take the data from data sources like dataset, object collections, or directly from the database itself, not by passing in as parameters one by one.