DBgrid connected to ADOTable

[ciruscontrols]

Ok guys I need some help!
I have a DBgrid connnected to a adotable. All of this is on a tabbed form with multiple different tabs.

The thing im having problems with and want to be able to do is have a user press a check box (or button) on any tab and have it query the cells that are associated with the DBgrid. The button or check box will have a set (fixed)'Item Id' (<--thats the name of the top cell) number to look for. I also need to be able to eliminate/lockout lines that have the same Item Id but parts that I dont want to transfer.
This program is a packing slip and I dont want to show parts (screws) inside our products

I would like to spit this info out on another tabs memo or label box. Im not sure which way is best or what components are best to use since Im new with Delphi but I to be able to print it out as well.
If anyone could give me tips I would appreciate it
Thanks

 

[roo0047]

It sounds like what you really need is a reporting utility. Most DB aware versions of Delphi included some reporting utility. Unfortunately, different versions of Delphi included different reporting component sets. Those that do usually include a set of demo apps that demonstrate how to generate various report forms from a variety of database types.

The best tip I can give you is; start there and see if you can find one that's close to what you need, them modify it to suit your needs.

Hopefully your Delphi version has what I described. Unfortunately, I personally am only familiar with what came with Delphi 7.0 (Rave Reports) and before (Quick Reports and Crystal Reports).

Also, try looking here:

http://delphi.about.com/sitesearch.htm?terms=db reports&SUName=delphi&TopNode=99

Best of luck!


Roo
Delphi Rules!

 

[ciruscontrols]

Great, thanks for the quick reply.
I have delphi 6 so I will have to see tomorrow if it has the reports (hopefully it does)
The delphi.about link should help lots thanks again!

 

[ciruscontrols]

ok, I do have Quick reports,I have the header etc done (easy stuff). Now have a question on best way to attach data when its selected from form1--ADOTable(dbgrid1)to the report. What I want is a user to push a button on one of the tabs I have on form1 have it query the adotable on form1 and spit it out on the report.

Just need some code advice to get me going. One of the cell headers are "item id", with part number "020109".
Thanks guys!

 

[roo0047]

Well I skipped D6 (went from D5 to D7) but I'm quite sure D6 used QuickReports. IF you chose to include the demos when you installed D6, they should be in "..\\Delphi6\Demos\Quickrpt\Qr2\" and "..\Qr3\".

In the event they won't run, look for dclqrt60.bpl in your "..\delphi6\bin\" directory.

To install, go to the IDE menu and select the "Component" menu item. From there, select "Install Packages". In the dialog select the "Add" button and then browse to the \bin directory of Delphi.

Roo
Delphi Rules!