crosstab

[OCM]

Greetings,
I designed a fiscal year report based on a crosstab query. When you click the FY begining date and FY ending date, the report should give you the result. Lately, I keep getting "Enter Parameter Value...." once clicked ok, another window appears to ask 'enter parameter value' etc. Can you please help?

Thanks,
OCM

OCM

 

[PHV]

The crosstab query should have an explicit PARAMETERS instruction:
PARAMETERS [FY begining date] DateTime, [FY ending date] DateTime;
TRANSFORM ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[OCM]

The two dates are controls on a form. The query part works fine. However, on the report, only the total appears and the other data are missing.

As you suggested, I also tried declaring the parameters explicitly as follows:
[07/01/2004] DateTime
[06/30/2005] DateTime
When I run the query, I get : Enter Parameter 07/01/2004 , Enter parameter 06/30/2005 etc.

Thanks,
OCM


OCM

 

[lespaul]

As you suggested, I also tried declaring the parameters explicitly as follows:
[07/01/2004] DateTime
[06/30/2005] DateTime

That's not what he suggested at all. He suggested:

PARAMETERS [FY begining date] DateTime, [FY ending date] DateTime;

yours isn't structured the same at all. For one, you're completely missing the PARAMETERS declaration.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[OCM]

I realize what I did worng and tried the following:

[Forms]![NameOfForm]![BeginningDate] and
[Forms]![NameOfForm]![EndingDate] where NameOfForm is the name of the Fiscal Year Dialog form.

The query is fine, but the report only shows the totals.

Thanks,
OCM


OCM

 

[lespaul]

then I would have to guess there's a problem with the report source. Do the totals come from a DSUM lookup?

 

[OCM]

I finaly was able to get the data in the report, except that some of the the number do not add up correctly. I'm not sure about your question 'DSum'.

Thanks,
OCM

 

[lespaul]

DSUM is a function that you can use to sum on a specific criteria (try the help for a more detailed explanation) and some people use it as the "total" of a report. I was asking if that's where the totals on your report come from, a DSUM function.

Why don't you post the ENTIRE SQL statement that your using? What did you do to get the data in the report? Are there specific sections that don't add up correctly? Can you identify any pattern to what's not correct?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[OCM]

Hi,
To get the data in the report, I used query and based my report on this query. As I stated before the query runs fine and the numbers add up correctly. However, when I run the report, I only get the totals and do not see the data.
Please let me know how to post the query or the SQL statement you asked above and I'll post it.






Thanks,


OCM

 

[lespaul]

in the query design grid, switch to the SQL view, you should be able to copy and paste the SQL text.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual