digitalmetaphors
Comments
-
The table you have is simply full of records and you can use fields in the
table to order the data. Create a query like this and change the ORDER BY
clause at runtime to change the ordering of the data. Also, set the group
object's br… -
You have to order the data first by group and then by product. Then you can
create logical groups in the report. In this example it shows how to create
a group in code:
in Creating hierarchical groups dinamically... Comment by digitalmetaphors July 2003 -
To force N detailbands to print per page see the Detailband.PrintCount
property.
Cheers,
Jim Bennett
Digital Metaphors
-
Set Report.Columns to 2 and then set the DetailBand.ColumnTraversal to
ctLeftToRight.
Cheers,
Jim Bennett
Digital Metaphors
-
RB doesn't support the function series in Teechart. One of the side effects
is that it isn't saved as part of the report template. If you close a report
app, most of the Teechart series functions cause a Teechart destroy bug. We
repor… -
Works fine for me:)
RB 7.02 D6 format example I just created, with RAP pass through function to
create the group with form as owner:
http://www… -
Try creating a RAP passthrough function to create a group. That way you can
pass the report object in the parameter of the pass through so that in the
Delphi code of the pass through, you can pull out the Report.Owner object
which is … -
Use report groups and set the new page property while it is generating. Here
is an example of setting the group object's NewPage property to force group
X to start on a new page when other groups print sequentially down a page.
If you… -
What database are you using and data connectivity? In a given DADE plugin,
ie. daADO.pas for ADO, there is a TdaADOSession.GetTableNames method that is
returning the available tables. Modify this and rebuild to get back views as
table… -
Once you calculate the 3 variable values in the detail, use another 3
variables in the detail to store the running totals. Use the
Variable.CalcOrder to ensure that the first three variables calculate before
the 3 total variables. Thi… -
Ask your user what printer they are using. You may have a static height
control that isn't fitting on the page. Each printer has a different
unprintable area. Increase the report's margins to match those found for
your user's printer … -
Try calling Report.Template.LoadFromDatabase as this uses the
Report.Template.Datasettings property configuration to find the report from
the data pipeline. The pipeline should be the rbItems pipeline which is the
same one used to ret… -
RAP isn't compiling. Can you reproduce this error on a test deployment
machine? Perhaps your deployment exe doesn't include some RAP pass through
functions that you are using in your development app? Where are you calling
LoadFromTemp… -
One thing that may be causing the problem is if there are components that
are not owned, ie. data pipelines and data access components that are
created at runtime in your code should have an owner that is the form or
datamodule in the… -
Make sure that your dataset supports bookmarks as defined in the TDataset
interface. Are you using a TDataset descendent? If you want to do
calculations in the report then use the TppVariable and code its OnCalc
event. Are your subrep… -
Make sure you refresh after a post. When a new record is posted, without
reopening the dataset, make sure you can get back the auto increment field
value that the database created for that new record. Try setting
DataPipeline.RefreshA… -
I'll download it the new project and run it. Thankyou for your patience.
Cheers,
Jim Bennett
Digital Metaphors
-
It still is not letting me restore from backup to recreate the database.
Could you send a SQL script to create and populate the database with some
data to show the error?
Cheers,
Jim Bennett
Digital Metapho… -
[quote](Actually, the setting in the MasterFieldLinks and MasterDataPipeline
are inserted by the system automatically during designation). [/quote]
What do you mean? When is does the designation event take place? I think the
set… -
The backup failed during the restore process. However, I looked at your form
and the problem is that you are parameterizing the queries and then also
setting the MasterFieldLinks and MasterDataPipeline properties on each
detail pipeli… -
Ok, I'll download and take a look. Are you using any service packs for SQL
Server that I'll have to install to restore from backup? We have SP 3 on cd,
but haven't installed any SP's at this time, fearing we need to test using
plain j… -
Are you using RB 7.02? Can you reproduce this with our demo projects? Can
you reproduce it with a slightly modified demo project (to get the error)
and send it to us at support@digital-metaphors.com ?
Cheers,
Ji… -
Use can use DADE in the tempalte, just don't use daIDE in the uses clause.
That is the way I would imbed report into a standard app. Use DADE behind
the scenes, just don't show it in the designer:)
Or, you need to go into DADE a… -
Yes, create calculated fields on the dataview in DADE, and then order the
dataset by one of those calc fields so that the group will work correctly.
Many of the RB crosstab demos show how to create calculated fields on Year
and Month … -
Works for me in this simple project I just put together:
RB 7.02
D6
DADE- DBDEMOS (BDE)
http://www.digital-metaphors.com/tip… -
Are you registering a wizard replacement? What did you change that this
problem started appearing? Is anything coded in the Report.Template.*
events, ie. the OnNew event? Usually, the best thing to do is to start
commenting out some e… -
There isn't any code for expressions, as the expressions you type in are
passed through directly into the SQL of the query. The expressions aren't
parsed at all. You'll have to create a custom query tool to let them build
an expressio… -
Can you see views as tables in DADE when you create a dataview? Not all DADE
plugins return views as tables. To call a stored procedure, you may be able
to use the timing of the BeforeGenerateSQL event to be sure the SQL hasn't
been s… -
You can create autosearch fields for an end user report and then create the
SQL as you have described it using a combination of end user SQL and
autosearch fields. Here is an example that extracts the SQL object from the
report and up… -
Here is an example of replacing the report wizard, which also shows how to
register and unregister a wizard:
http://www.digital-metaphors.com/tips/Repla…