digitalmetaphors
Comments
-
Not all of the features in SQL are supported visually. Union is one that
isn't supported visually. You'll have to choose to edit the SQL manually to
ues this SQL in a dataview. You will lose the query tools support on this
dataview on… -
The data values aren't aliased and it isn't supposed to be customizable as
it is the actual data values. You'll have to create a custom autosearch
dialog to display different text visually than what you want to use as
values in the se… -
I did receive an error. However, we submit this directly to the server, so
it is up to the database to determine if it is valid SQL. I did try using
Employee.FirstName + 'hello world' and that does give an error. Then I tried
Employee… -
What are the steps necessary to reproduce the error?
Here is one test I tried.
1.Open the RBuilder\Demos\EndUser\AutoJoin example project
2.Ran the project without modifications
3.Create an Employee query … -
The Field SQL Alias isn't able to be changed. It should be auto generated
correctly. This is an expression type string calc field? What database are
you using? Can you recreate this with the DBDemos database? It works fine in
tests he… -
We recommend steering away from the BDE if at all possible. Search the web
for known issues with the BDE. I remember an article a while back in the
Delphi Mag which talks about resource leaks with the session. There is a
listing of BD… -
When you get "Engine configuration not found" this means you have to at
least restart Delphi. If that doesn't help, then reboot the machine. The BDE
leaks resources and eventually it goes south and won't run anymore. This is
why the 3… -
For your users, you can always create your own autoserach dialog. For
example, we ship a demo that has a data time picker component in the
autosearch dialog for a date range. You can default your custom autosearch
dialog to show Now a… -
This can be done. However, there are some considerations. Are you creating
search criteria on the dataviews in code? First, when you or your user
create dataviews, they are persistent search criteria. When the form loads,
these search… -
Set the subreport's datapipeline to nil. Then set the
Subreport.Report.Autostop property to true. This will end you endless pages.
No, page numbering CAN be reset, but only if Subreport.ResetPageNo is true:)
Cheers,
<… -
Yes, you'll have to add a footer to each subreport that is a section style
subreport. Section subreports are special in that they take control of the
page inside of a main report. They always start on a new page and have their
own hea… -
Create section style subreports- one for each page/rich text control.
Section style will always begin printing on a new page. You should resize
the detail band to be the page height and make it static height. That should
do the trick.… -
Try setting Report.Template.FileName. That way when the report template
tries to save itself, it will point to the filepath + filename in the save
dialog.
As far as the OnLoadEnd event not firing, that should not be the case,1. See my first response on setting the folder name. The code shown is what
I used and it worked in my tests.
2. To set the file path with a file name on the file save menu, simply set
the Report.Template.FileName property in th…You can save to file or database. By default, the report explorer will try
to save the reports to database if you are in the designer and choose Save.
There is an property on the designer that is AllowSaveToFile. You'll need to
set t…You need to use the Report.Template.OnLoadEnd event to configure the report
after they have opened/loaded a report. This is a public event. You'll have
to assign it to an event handler in code. You'll also need to assign the
Report.Te…Set DetailBand.BandsPerRecord to 100. This way the detail band will reprint
100 times for a single record. You can change this value for each record so
each detail band can print N times.
Cheers,
Jim Bennett
Check out the daADO.pas unit. This is the unit that has the ADO adapter
classes for DADE dataviews that connect to an ADO connection. Remove daDBBDE
from the uses clause because that will link in the BDE, which you don't want
to do if…You simply need to create and install a Delphi design time package whcih
includes your daODBCExpress plugin unit and whatever else is required to
compile this package. Check out the other packages for DADE plugins in the
End User Demo…Yes, there is no runtime object inspector for ReportBuilder. It would be a
cool feature. It would be possible if you have to have it, to modify your
copy of our source and add one. The code that deals with the current
selection is lo…Thanks for the suggestion. The only current way to do this is at Delphi
design time where you can use the object inspector to change a common
property across a selection of components.
Cheers,
Jim Bennett
Digital…Thanks for the suggestion. They are simply listboxes at this time. We can
look into changing them to scroll to width, as it does for the height. Try
setting the ScrollWidth property of the listbaxes in our dialog to
accomplish this. T…When you create criteria, they are persistent. Check to make sure that the
report template doesn't have it defined on the dataview. Most likely you
created the criteria once and then saved the report. Now the report doesn't
need the C…Stacey,
A template that has the criteria persistently saved on the dataview must be
hiding somewhere. If you run the report and create and autosearch criteria
object at runtime in RAP, and then save the template after it has exe…Check the autosearch checkbox for the criteria (in the Data tab of the end
user designer) on the dataview to make it an autosearch criteria. Otherwise,
you have the criteria on the dataview that is set to not be an Autosearch
criertia…Yes, you can do this:
http://www.digital-metaphors.com/tips/ShowReportWizardOnNew.zip
Cheers,
Jim Bennett
Digita…I deleted your post as it had an attachment and we got one to
support@digital-metaphors.com to use.
The problem is that you need to perform the preview yourself by checking
NextAction after the dialog is closed. Here I just did …We don't have an example of launching the query wizard, but here is an
example of launching the query designer in code.
http://www.digital-…If you have edited the SQL, then you have to update the where clause. Here
is an example of do this on an manually edited dataview.
http://www.digita…You'll have to programatically change the SQL object to have SQL generated
for the WHERE clause. Here is an example of dynamically creating a criteria
object on a dataview:
in Passing values to later use in the SQL. Comment by digitalmetaphors May 2003