|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Use Crystal Reports with ASP.
TO connect report object with database we use
Set Database = session("oRpt").Database then import data from this database. Can we create reports without connecting directly to database. Data is available in arrays. Now we want to rad this array and then generate the report. |
|
#2
|
|||
|
|||
|
this code might be usefull for you
' Determine the index of the table we want to retrieve indexTable = Session("oClientDoc").Database.Tables.FindByAlias("Employee") ' Retrieve the data fields from the Database Table ' Set dbFields = Session("oClientDoc").Database.Tables.Item(0).DataFields Set dbFields = Session("oClientDoc").Database.Tables.Item(indexTable).DataFields ' Create a list of the fields we want to add to the report arrFields = Array("Last Name", "First Name", "Salary") For Each newField in arrFields 'Determine the index of the database field in the table indexField = dbFields.Find(newField, 0) ' Add the field to the client document through the ResultFieldContoller object ' -1 specifies to add the field to the end of the ResultFields collection Session("oClientDoc").DataDefController.ResultFieldController.Add -1, dbFields.Item(indexField) Next |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Use Crystal Reports with ASP. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|