Hello,
I am trying to create a form in Visual Basic.Net with a dynamically
created Menu bar. I need the drop down part of a menu item (Reports)
to be dynamically generated according to the values of a SQL 200
table.
for Example, let's say I have this SQL table with the following fields:
Orders ReportName
_____ ______________
89BB BBReport_Order
89BB BBReport_Invoice
89BB BBReport_Customer
32NN NNReport_Order
32NN NNReport_Invoice
32NN NNReport_Customer
...
Now, let's assume my form is finished and working. The current user is
a 'NN' person. Therefore, I need to display the NN reports in my form
Menu toolbar. I need the Reports Menu Item to be '32NN' and underneath
show the name of the reports as submenus. The same would be for an
user that's a 'BB' but showing the 89BB field as the menu item and the
BB reports as submenus instead.
Here's a visual representation of my menu bar. (user's a NN)
File Reports Help
Exit 89NN About
NNReport_Order
NNReport_Invoice
NNReport_Customer
Does anyone know how to accomplish this? Is there an example similar
to this that I could use? What the user will do is to click a report
name and then either preview it in a Crystal report Viewer or send it
directly to the printer.
Thanks as always for all your help.
|