Cross Tab Results in InfoPath 2003

[Paul Mayer]

I am using InfoPath 2003. I want to use a crosstab query
from an Access database. I want to have a start date and
end date, date select boxes on the InfoPath form that are
used as parmeters for the crosstab query (i.e.
"where cmpltd between [startdate] and [enddate]" in the SQL
statment that access generates. I cannot find any way to pass
the startdate and enddate values from the infopath form to the
sql statment in the data connection sql statment. When I try
to use applying the filter on the data between the startdate
and enddate I have to include the CompletedDate in the field
list and this alters my results and includes duplicate crosstab
data in my results. Is there another way of tackling this
problem which will allow me to get the correct crosstab results
on my infopath form?

 

[Clay Fox]

I am assuming this is a secondary connection. If you build a database type
template you have query and submit on one set of tables and can do this
action but that may not be what you need.

Best practice is to use web services such as the Database Accelerator
download from http://www.qdabra.com

Here is a post for a workaround to to be able to pass a variable to your SQL
statement.
http://www.infopathdev.com/forums/t/6765.aspx
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Paul Mayer]

Actually, I was trying to use a primary data connection to create this report.

I am assuming this is a secondary connection. If you build a database type
template you have query and submit on one set of tables and can do this
action but that may not be what you need.

Best practice is to use web services such as the Database Accelerator
download from http://www.qdabra.com

Here is a post for a workaround to to be able to pass a variable to your SQL
statement.
http://www.infopathdev.com/forums/t/6765.aspx
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

I am using InfoPath 2003. I want to use a crosstab query
from an Access database. I want to have a start date and
end date, date select boxes on the InfoPath form that are
used as parmeters for the crosstab query (i.e.
"where cmpltd between [startdate] and [enddate]" in the SQL
statment that access generates. I cannot find any way to pass
the startdate and enddate values from the infopath form to the
sql statment in the data connection sql statment. When I try
to use applying the filter on the data between the startdate
and enddate I have to include the CompletedDate in the field
list and this alters my results and includes duplicate crosstab
data in my results. Is there another way of tackling this
problem which will allow me to get the correct crosstab results
on my infopath form?

 

[Clay Fox]

Then all you need to do is add your data values in the query fields and when
you run the query it will return what you want.

You should be able to use the default setup of a new form to test.

Drag the query and data fields into their respective places.

Type your data parameters into the fields and run the query.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

Actually, I was trying to use a primary data connection to create this report.

I am assuming this is a secondary connection. If you build a database type
template you have query and submit on one set of tables and can do this
action but that may not be what you need.

Best practice is to use web services such as the Database Accelerator
download from http://www.qdabra.com

Here is a post for a workaround to to be able to pass a variable to your SQL
statement.
http://www.infopathdev.com/forums/t/6765.aspx
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

I am using InfoPath 2003. I want to use a crosstab query
from an Access database. I want to have a start date and
end date, date select boxes on the InfoPath form that are
used as parmeters for the crosstab query (i.e.
"where cmpltd between [startdate] and [enddate]" in the SQL
statment that access generates. I cannot find any way to pass
the startdate and enddate values from the infopath form to the
sql statment in the data connection sql statment. When I try
to use applying the filter on the data between the startdate
and enddate I have to include the CompletedDate in the field
list and this alters my results and includes duplicate crosstab
data in my results. Is there another way of tackling this
problem which will allow me to get the correct crosstab results
on my infopath form?