Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get the name of the printer from BOE

Status
Not open for further replies.
cmmrfrds

cmmrfrds

Programmer
Feb 13, 2000
4,690
US
I tried this query in QueryBuilder.

SELECT top 100 SI_ID, SI_NAME, si_processinfo.si_printer_info FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport' and SI_NAME like 'HBOC4%'
and si_processinfo.si_printer_info.si_name like '\\Oak%'

I am trying to search for reports with a particular printer.

Appreciate any ideas. Thank you.

 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
258
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
476
hilfy
hilfy
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
227
RoknRole
RoknRole
tlbrown88
  • Locked
  • Question
How to duplicate data from main report lines for sorting purposes
Replies
2
Views
252
lbass
lbass
GCL2007
  • Locked
  • Question
How to get consistent field width in Note field 1
Replies
7
Views
199
IdoMillet
IdoMillet

Part and Inventory Search

Sponsor

Back
Top