944,179 Members | Top Members by Rank

Ad:
Jul 6th, 2006
0

datareport creation doubt

Expand Post »
hai all,
i have created a vb project and stored data into a databse named faculty. now i want to extract the details from the database. the fields included in the table are slno,faculty,subject,batch,ctr1...ctr6,overall per...
my requirement is when i selected any one of the faculty then the report will shows like in fig2(datareport 2.jpg which is attched.). the currect report design is shown in fig1(datareport1.jpg which is also attached)

it is possible if yes pls reply me

thank you
Attached Thumbnails
Click image for larger version

Name:	datareport1.JPG
Views:	18
Size:	109.1 KB
ID:	2141   Click image for larger version

Name:	datareport2.JPG
Views:	8
Size:	46.1 KB
ID:	2142  
Last edited by Comatose; Jul 6th, 2006 at 7:32 am. Reason: Improper Use Of Code Tags.....(What?)
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vjeshemv2000 is offline Offline
11 posts
since Jun 2006
May 6th, 2007
0

Re: datareport creation doubt

You can use :
Reportobjectname.SelectionFormula="{TableName.FieldName}=Criterium".

If the Crystal report object name is: Report1
If your tanlename=Table1
If your field name for selection =Faculty
If Creterium is "Faculty=Mascara"

So you have to write:
Report1.SelectionFormula="{Table1.Faculty}='Mascara'"
Reputation Points: 10
Solved Threads: 0
Newbie Poster
elaek is offline Offline
6 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Dynamic crystal report with VB4/5/6
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Restrict Paste in RichTextbox





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC