Free Hand SQL Reports and Query Builder

general discussion
1

Hi BO Gurus,

Can anyone please tell me is there a way to findout free-hand sql reports from query builder.

Thanks
Madhuri

madhum1078 (BOB member since 2007-07-20)

2

No; that’s in the report structure, not in the CMS. And the last time I looked, it wasn’t exposed in DeskI VBA either.

joepeters :us: (BOB member since 2002-08-29)

3

Hi,

As far as I know there is an SQL property of a data provider object in VBA that gives you the SQL even of a free-hand data provider. But it’s a read-only property, it’s not possible to modify the query.

Marek Chladny :slovakia: (BOB member since 2003-11-27)