I wanted to know if I can display an HTM page from the report event BeforeAutoSearchDialogCreate and then I would retrieve the values from the page and pass them off to the report? Thanks
I've just done this... it's not quite that simple. If you're using RB Server, you may as well just let it take care of the work.
Otherwise (if you're in the same boat as me - where your server has to be an ISAPI), you can get a list of Criteria from the report using the daSQL objects (there's a demo on setting Autosearch values in code that shows you how to do this)... then you have to build the HTML page to accept the end user's input values for the search fields... then you have to convert these back to the criteria values when the form gets posted and finally generate the report (with ShowAutoSearch set to false, obviously) using the Waler extra devices... then you have to return that report in either HTML or PDF format to the browser.
This should take you a good week or so (it took me about a week and a half). Also, I'm still waiting for a response on how to determine the default values for autosearch date fields... other than that, everything seems to be working swimmingly.
ReportBuilder 7.02 adds this capability. See the RBServer demos realated to custom parameters:, the example work together (i.e. you must use the custom parameters server with the custom parameter client and web tier). Each example contains a ReadMe.doc.
Comments
Hi Gary,
I've just done this... it's not quite that simple. If you're using RB
Server, you may as well just let it take care of the work.
Otherwise (if you're in the same boat as me - where your server has to
be an ISAPI), you can get a list of Criteria from the report using the
daSQL objects (there's a demo on setting Autosearch values in code that
shows you how to do this)... then you have to build the HTML page to
accept the end user's input values for the search fields... then you
have to convert these back to the criteria values when the form gets
posted and finally generate the report (with ShowAutoSearch set to
false, obviously) using the Waler extra devices... then you have to
return that report in either HTML or PDF format to the browser.
This should take you a good week or so (it took me about a week and a
half). Also, I'm still waiting for a response on how to determine the
default values for autosearch date fields... other than that, everything
seems to be working swimmingly.
Best Regards,
James Crosswell
Software Engineer
Microforge.net Limited
http://www.microforge.net
ReportBuilder 7.02 adds this capability. See the RBServer demos realated to
custom parameters:, the example work together (i.e. you must use the custom
parameters server with the custom parameter client and web tier). Each
example contains a ReadMe.doc.
RBServer\Demos\Clients\Custom Parameters
RBServer\Demos\Servers\Custom Parameters
RBServer\Demos\WebTier\Customer Parameters.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com