Queries and problems

rbuser

?Hi,
Thanks all for your help .I was able to solve many of my problems.
But i still have some problems in my application and i am not able to
solve them.I am using RB7 and Teechart 4.04.

1) In the report builder i have daily,weekly and monthly reports. The
dates are being calculated in RAP and assigned to autosearch dialog box.
Now the problem is that i don't want user to see the search panel for
date or even if it is visible it should be disable.Also user must be
able to view other search panels like for 'company name'.How it is
possible to hide the search panel for some fields and visible for
others .Or how can i assign currentdate directly in the query in query
designer.

2)How can end user save his reports in pdf,text or excel format.

3)I am not able to see the dataset in the dbteechart .Which version
should i use .Can i get the link for it.

4)If there is no data in the report what code should be written so that
user can get the information that there is no data available.

Thanks
lucy



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Lucy,

1. Autosearch has the capability to execute without showing the autosearch
form. If you would like to disable the edit boxes in the dialog, you will
need to create a custom autosearch dialog. It would be worth while to spend
some time with the autosearch demos located in the \RBuilder\Demos\3.
AutoSearch\... directory. The Custom AutoSearch Dialog and End User
AutoSearch demos would be very helpful to what you are trying to do.

2. As I mentioned in my previous post, ReportBuilder 9 can only natively
export reports to PDF, Text, and Archive (.raf) files. If you need other
formats or are using an earlier version of RB, you will need to download a
third party export device. Please see the Output Devices page of our web
site for more information and links.

http://www.digital-metaphors.com/download/output_devices.html

3. Are you using the DBChart at designtime or runtime? TeeChart 4.04 does
not support report data access at designtime. Please see the ReportBuilder
Reference | TeeChart | Delphi X |... section of the ReportBuilder help for
information on the different versions of TeeChart that are compatable with
your version of ReportBuilder, and the limitations of your own version.

4. See the help topic for the TppReport.NoDataBehaviors property. Setting
this property to ndMessage will allow you to automatically show your users a
message if the report has no data.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico
Thanks a lot for helping me out.But there are still some problems.I am
using RB7.

1. I looked through the example of custom autosearch but was not able to
figure out how to implement this in RAP.I have a query
'select * from table where cname='tata' and date='29-sep-05'
Both the cname and date field are autosearch fields. I have to print
reports for current date so i have written code on the event 'OnCreate'
report.searchexpression[1]:=report.autosearchfields[1].values[0];
Now what the enduser want is that auto search dialog should show
only 'cname' and not 'date'. I have to do all my coding using rap.

2. How can i make pass through function for 'Extractfilepath' so that
reports can be saved in text format . Here too coding is to be done using
RAP.My application has all reports in report explorer.

Regards
Lucy.



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Lucy,

1. I strongly recommend upgrading to RB 9.02. This version contains the
needed events (OnBeforeOpenDataPipeline) and objects (TdaSQLBuilder) in
order to manually alter the AutoSearch criteria at runtime in RAP.

2. There is a full coded example of creating a RAP pass-thru function in
the ReportBuilder Developer's Guide located in the \RBuilder\Developer's
Guide\... directory. Create a pass-thru function for ExtractFilePath will
be very similar (but simpler) to implement being that there will probably
only be one parameter and you are only using one Delphi function.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com