Urgent Help required - Agregate Error

[Max E]

Dear All
I have a serius problem and can not find a solution!
unfortunately I've got not one responce on my posting a
few days ago. Please Help.

Because I have to run a front-end on a citrix server I
have to start a application (main menu) from a mde file
and refere to objects in an ade access project.

In reports I get a known error >> aggregate function
error << - this because I use group function of records
in the report.

Till now I just found information in an article kb 225992
(I'm not using sum or count statements in the report or
the query) and on the web site

http://techrepublic.com.com/5100-6329-5034488.html

but this is not helping me solving the problem.

Is there any possibility to solve this issue or do I have
to redevelope all my reports?? About 40!
aaaaaaaaaaahhhhh .

I'm sorry to not provide my email address but after an
earlier posting I've received hundreds of spam mails.

Thanks for your help in advance
max

 

[Duane Hookom]

Apparently you are using domain aggregate functions in your report or
report's record source. Is this correct? If so, perhaps you should describe
how and why you are using them. I have found that dom agg functions are
rarely if ever required in reports. Simple aggregate functions like Sum()
and Count() are much more efficient.

 

[Guest]

Dear Duane
Thanks for your answer

I was working in adp's till I had to migrate the application to a citrix environment. because adp's are exclusive opened we are not able to use them anymore on the application server
The solution is to use a mdb with a kind of small menu. all forms and reports are in the adp - the mdb (mde) is using the objects of the adp. both are connected via a reference

so far so good

In reports I'm using the grouping function to show main order information in the order header and the order details in the detail section. when I use this report in Access 2002 (XP) I don't get any error. when using the same report I get the error described in the kb - http://support.microsoft.com/default.aspx?scid=kb;en-us;22599

After checking the report I'm not using any aggregate function in the report but still retrieving the error. as soo as I remove the header of a section (grouped by order main information) the error is gone and the report opens the normal way. It does not matter if I have a bounded report (to a function or query) or adding the record source to the report in the "on open even"

The grouping function is important for me: almost all of the reportsare useing it. report items grouped by customer, per order, ...

I hope this information is enough for you to understand what I mean and reproduce the error

mdb (containing menu-form) start u


adp (containing reports, forms, functions and is connected to MS SQL 2000 Server) refering to mdb

I see this as a serious problem and can also provide an example file to understand the issue better
So I'm having this issue without using agregate function (at least sum, count, ...) behalfe grouping in a heade
Do you have any ideas?

Best greeting

Ma
----- Duane Hookom wrote: ----

Apparently you are using domain aggregate functions in your report o
report's record source. Is this correct? If so, perhaps you should describ
how and why you are using them. I have found that dom agg functions ar
rarely if ever required in reports. Simple aggregate functions like Sum(
and Count() are much more efficient

 

[Duane Hookom]

Could you provide your sorting and grouping expressions for the report? It
might also help to see the SQL of an offending report.

--
Duane Hookom
Microsoft Access MVP

Dear Duane,
Thanks for your answer.

I was working in adp's till I had to migrate the application to a citrix

environment. because adp's are exclusive opened we are not able to use them
anymore on the application server.

The solution is to use a mdb with a kind of small menu. all forms and

reports are in the adp - the mdb (mde) is using the objects of the adp. both
are connected via a reference.

so far so good.

In reports I'm using the grouping function to show main order information

in the order header and the order details in the detail section. when I use
this report in Access 2002 (XP) I don't get any error. when using the same
report I get the error described in the kb -
http://support.microsoft.com/default.aspx?scid=kb;en-us;225992

After checking the report I'm not using any aggregate function in the

report but still retrieving the error. as soo as I remove the header of a
section (grouped by order main information) the error is gone and the report
opens the normal way. It does not matter if I have a bounded report (to a
function or query) or adding the record source to the report in the "on open
even".

The grouping function is important for me: almost all of the reportsare

useing it. report items grouped by customer, per order, ...

I hope this information is enough for you to understand what I mean and reproduce the error.

mdb (containing menu-form) start up
I
I
adp (containing reports, forms, functions and is connected to MS SQL 2000 Server) refering to mdb.

I see this as a serious problem and can also provide an example file to understand the issue better.
So I'm having this issue without using agregate function (at least sum,

count, ...) behalfe grouping in a header