ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreASP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old September 19th, 2003, 10:25 AM
neetesh neetesh is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 1 neetesh User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Reply With Quote
  #2  
Old November 13th, 2003, 12:02 PM
jokos jokos is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 4 jokos User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreASP Programming > Use Crystal Reports with ASP.


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT