Need to Sort on a Calculated field

rbuser

I need to try to set up a report that shows the following
If a Customer has more than 5 Contacts then show that Customer with their
Contacts.
I have tried creating a Calculated field Calc_1 using Sum to get the amount
of Contacts for the current account and doing a Search on Cal_1 > 5 but it
doesn't seem to work.
I can't go into the source code as this is just not possible.
Am i going about this the wrong way ?

Hope someone can help me with this

Many thanks
John

digitalmetaphors

What version are you using? Older versions of RB didn't support this. If
you have RB 6 or later it should work.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

digitalmetaphors

The onyl limitation on this is that it doesn't work when using master detail
linked dataviews. Otherwise it should work. I ran the demo DBISAM end user
project. I am using DBISAM 3.17 for D6. I ran with the data dictionary and
ran without the datadictionary. Try converting the DBDemos paradox tables
to DBISAM format using the DBISAM utility. Then connect to them in DADE. I
created a Orders dataview with a calc field on AmountPaid. Then in the sort
tab of the query designer, I see AmountPaid(2) as the calc field in the
available fields list. I selected it and ran the query. It ordered by the
calc field in the generated magic SQL(Ctrl-click over dataview). I could
send you my demo project and data tables if that would help. The only other
possibility is that you aren't running RB 6, but RB 5.5. Check your
installation for old source files. Search for rb source files and dcus as
listed in the corrupt installation cleanup procedure in the tech-tips
newsgroup installation thread.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I did what you suggested and converted the tables and ran the demo.
I can, as you say create a calc field and it does indeed appear in the Sort
tab.
I however need to have the field appear in the Search Tab so that i can get
a report which will only print for example...
Customers and their Order details where only Customers that have more than 2
orders each are printed.
What i am doing is clicking on any field in Calc Tab and then changing it to
Count. I am hoping that i can then specify (somehow), what i want that Count
to check for (Example >2).
As we are now running with the same tables, do you think you could see if
this is possible please.
If it is then i would be really, really greatfull if you could send it to me
because i am getting really confused by this type of report.

Thanks for sticking with me on this one.

John

digitalmetaphors

This was added in the latest release of RB 7. You'll need to download the
latest RB 7 to get this feature. Contact info@digital-metaphors.com and
we'll get you setup with an upgrade from 6.03. In the meantime, you can
download the trial edition of Pro or Enterprise to check it out:

http://www.digital-metaphors.com/subpages/reportbuilderent/main_download.htm
l


Cheers,

Jim Bennett
Digital Metaphors

rbuser

> This was added in the latest release of RB 7. You'll need to download the


Ok, at least i can stop trying now then.
Can't upgrade though (unless it's free ;-)

One for the future i think.
Many thanks

John

rbuser

Ah, i see now.
I can get the upgrade FOC.
Before i make the upgrade, could you confirm the following for me.
I have, made som changes in the Report Builder source code so i will need to
make these changes again after the upgrade ?
I am using the Dbisam Plugin so will i need a new version of this and if so
is it available yet and from where ?
I am also using the ASTA Plugin so will i need a new version of this and if
so is it available yet and from where ?

Thanks
John

digitalmetaphors

We modified the daDBISAM plugin for use in RB 7. It has been tested to work
with DBISAM 3.17. The daASTA plugin was not changed by Digital Metaphors
and we're not sure if there has been any enhancements to it at this time
since it is mantained primarily by ASTA and its customers. There needs to
be a 6.03 and prior version as well as a RB 7 and later version, since the
interface section had to change in order to support thread safety in DADE
for the Server Edition. You could post a question in the ASTA newsgroups to
see if anyone has modified the plugin for ASTA to work with RB7 yet. If
not, then we can help you create it, at a minimum, it just requires a few
method changes in a standard plugin.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Many thanks.
I may get back you you on this then.

John