Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-09 : 08:05:39
|
| Jarrod writes "I am currently running a project in Visual Basic6 that allows the user to connect to a DB (at runtime), Choose a Crystal Report, and then load the Report through their node selection on the tree view. I want the end user to be able to choose his own report (this part currently works), then he will select a node from the tree view, which may or may not have children nodes. After he has selected the desired node he will click "load report" button and view only the personnel to the report that fall within the node. All Personnel within the nodes are located in an Access database. The Crystal Reports have been referenced within a .mdb converted to a .sys file. I currently can print the report they choose to the preview report section, but I cannot seem to figure out how to view only the personnel that fall within the nod they have selected. Any help would be much appreciated.Respectfully,Jarrod HolmesProgramming ChiefMCRDSD, San Diego" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-07-09 : 19:07:30
|
| Hey JarrodIs your problem the design of the report, or just being able to query for children of a node?Check this out...[url]http://www.sqlteam.com/item.asp?ItemID=8866[/url]And let me know if that's not what you're looking for.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Changing Crystal Reports SQL within VB