Group By

[Bob Quintal]

Hi There
Question #1
I have a query that is being grouped by in several fields and
then I have 2 expressions and one of my expressions requires
that a field be in the grid and I have the show check box
turned off, however, I do not want this field to be grouped by
giving me the wrong results. How do I change this field to
not group by?

Change the Group By to Where... It's one of the options in hte
dropdown list.

Question #2
I have a report created based on a crosstab query and I want
to be able to type in a start date and an end date to display
in the Page header of the report. I have this working in all
other reports, except the ones based on a crosstab query.
Does anyone out there have any ideas?

I'm not sure what you want to do here, how does the query know
what the start and end dates are? Once we know that, somebody
might be able to determine how to put it on the report header.

 

[Guest]

Hi There
Question #1
I have a query that is being grouped by in several fields and then I have 2
expressions and one of my expressions requires that a field be in the grid
and I have the show check box turned off, however, I do not want this field
to be grouped by giving me the wrong results. How do I change this field to
not group by?

Question #2
I have a report created based on a crosstab query and I want to be able to
type in a start date and an end date to display in the Page header of the
report. I have this working in all other reports, except the ones based on a
crosstab query. Does anyone out there have any ideas?

 

[Guest]

Thanks Bob, i will try the where for my Q#1 and hopefully I won't have to
define anything on the criteria row for this field
Q#2 is for display purposes only

 

[Guest]

Question #2 - Dates being displayed
Bob, I have used in an unbound control the following and it works on all
other reports except where it's source is a crosstabl query: ="From "&[Enter
Report Start Date]&" To "&[Enter Report End Date]

 

[Bob Quintal]

Question #2 - Dates being displayed
Bob, I have used in an unbound control the following and it
works on all other reports except where it's source is a
crosstabl query: ="From "&[Enter Report Start Date]&" To
"&[Enter Report End Date]

I'll ask again, how does the crosstab query--
Bob Quintal

PA is y I've altered my email address.

 

[Bob Quintal]

On the criteria row for the date field I am using Between 01
Jul 07 And 15 Jul 07 for example to get the records in that
date range only.

Cindy

If you open the crosstab queryin design view, Right click on the
table to get the Parameters popup, create the two parameters
Enter Date From and Enter Date To both with type date/time.

You can actually put these in the criteria row instead of hte
date literals you show.

On hte report, in the header, add two unbound textboxes, label
the first Date From: and put = [Enter date from] as its control
source

Label the other To: and put = [Enter date To] to it's control
source.

Q

Question #2 - Dates being displayed
Bob, I have used in an unbound control the following and it
works on all other reports except where it's source is a
crosstabl query: ="From "&[Enter Report Start Date]&" To
"&[Enter Report End Date]

I'll ask again, how does the crosstab query

know what the start and end dates are? Once we know that,
somebody might be able to determine how to put it on the
report header.

 

[Guest]

On the criteria row for the date field I am using Between 01 Jul 07 And 15
Jul 07 for example to get the records in that date range only.

Cindy

Question #2 - Dates being displayed
Bob, I have used in an unbound control the following and it
works on all other reports except where it's source is a
crosstabl query: ="From "&[Enter Report Start Date]&" To
"&[Enter Report End Date]

I'll ask again, how does the crosstab query--
Bob Quintal

PA is y I've altered my email address.

 

[Guest]

Hi Bob, as my posts have said, I am already doing what you have suggested. I
have a parameter query set up in the crosstab qry, however when i try to
place what you suggested in the report it is not working.

Cindy

On the criteria row for the date field I am using Between 01
Jul 07 And 15 Jul 07 for example to get the records in that
date range only.

Cindy

If you open the crosstab queryin design view, Right click on the
table to get the Parameters popup, create the two parameters
Enter Date From and Enter Date To both with type date/time.

You can actually put these in the criteria row instead of hte
date literals you show.

On hte report, in the header, add two unbound textboxes, label
the first Date From: and put = [Enter date from] as its control
source

Label the other To: and put = [Enter date To] to it's control
source.

Q

in
Question #2 - Dates being displayed
Bob, I have used in an unbound control the following and it
works on all other reports except where it's source is a
crosstabl query: ="From "&[Enter Report Start Date]&" To
"&[Enter Report End Date]

I'll ask again, how does the crosstab query
know what the start and end dates are? Once we know that,
somebody might be able to determine how to put it on the
report header.

 

[Bob Quintal]

Hi Bob, as my posts have said, I am already doing what you
have suggested. I have a parameter query set up in the
crosstab qry, however when i try to place what you suggested
in the report it is not working.

Cindy

I haven't got a clue why it doesn't work for you, because I
built a parametrized crosstab query and a report based on it to
make sure I was telling you the right things, and it does work.

Q

On the criteria row for the date field I am using Between
01 Jul 07 And 15 Jul 07 for example to get the records in
that date range only.

Cindy

If you open the crosstab queryin design view, Right click on
the table to get the Parameters popup, create the two
parameters Enter Date From and Enter Date To both with type
date/time.

You can actually put these in the criteria row instead of hte
date literals you show.

On hte report, in the header, add two unbound textboxes,
label the first Date From: and put = [Enter date from] as its
control source

Label the other To: and put = [Enter date To] to it's control
source.

Q

:

=?Utf-8?B?Q2luZHk=?= <[email protected]>
wrote in

Question #2 - Dates being displayed
Bob, I have used in an unbound control the following and
it works on all other reports except where it's source
is a crosstabl query: ="From "&[Enter Report Start
Date]&" To "&[Enter Report End Date]

I'll ask again, how does the crosstab query
know what the start and end dates are? Once we know
that, somebody might be able to determine how to put it
on the report header.