[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Kory

1/10/2006 5:35:00 PM

I am using the Report Wizard and I have dragged a table in the Query's data
source
node. I need a count of a field. When I choose count from the menu, the
other fields disappear - How can I have both?
2 Answers

Lennart Conrad

1/11/2006 1:10:00 PM

0

I am not sure how and if you can do this in the report wizard.

If you want both fields and count fields, you can do it from the AOT. You
must have the following set up in the AOT:

1. your datasource must have Ordermode = group by
2. You must include the fields you need in the sorting

Then you can use the fields from your sorting together with sum/count etc.

of course your report will be grouped by the sorting

hope it helps
/Lennart Conrad




"Kory" wrote:

> I am using the Report Wizard and I have dragged a table in the Query's data
> source
> node. I need a count of a field. When I choose count from the menu, the
> other fields disappear - How can I have both?

Kory

1/11/2006 1:29:00 PM

0

Thank you for your answer Lennart, I had already tried that, but it didn't
work!

"Lennart Conrad" wrote:

> I am not sure how and if you can do this in the report wizard.
>
> If you want both fields and count fields, you can do it from the AOT. You
> must have the following set up in the AOT:
>
> 1. your datasource must have Ordermode = group by
> 2. You must include the fields you need in the sorting
>
> Then you can use the fields from your sorting together with sum/count etc.
>
> of course your report will be grouped by the sorting
>
> hope it helps
> /Lennart Conrad
>
>
>
>
> "Kory" wrote:
>
> > I am using the Report Wizard and I have dragged a table in the Query's data
> > source
> > node. I need a count of a field. When I choose count from the menu, the
> > other fields disappear - How can I have both?