Member Avatar for eng.amira
eng.amira 0 Newbie Poster

Hello......

i want to select from the drop down list ID then all information connecting to the ID will
appear in the report , i wrote this SQL statement but only information related to the first ID appear each time when i select different ID from the drop down list


The SQL statement is


SELECT [ID], [FACULTYNAM], [DEP], [SITENAME], [SLOCATION], [VISITPURPO], [VDATE1], [TIMEFROM1], [TIMETO1], [FEMALENO], [MALENO] FROM [data0004] WHERE ([ID] = ?)


in the choose data source for the report viewer i select for the data source instance the sql data source that contains the statement above

plz help me....

Edited by eng.amira because: n/a
  • 1 Contributor
  • 0 Replies
  • 40 Views
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.