Member Avatar for vjeshemv2000

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

datareport1.JPG 109.12 KB datareport2.JPG 46.11 KB
  • 2 Contributors
  • 1 Reply
  • 77 Views
  • 10 Months Discussion Span
  • Latest Post Latest Post by elaek
Member Avatar for elaek

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'"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.