 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 4) |
| Author | Comment |
|
Florian
Jul 31, 05 - 12:13 AM |
MARS can't see parameters?
I am writing a dynamic schedule. I am referencing a report that does have a parameter. Yet the wizard does not want to let me proceed stating that "I need to reference a report with parameters". What's going on? |
|
Mars Support
Jul 31st, 2005 - 9:51 AM |
Re: MARS can't see parameters?
MARS cannot reference "parameters" which are in the report design element as these cannot be programatically read. Place your parameter in a query and use the query to write a report so that is the query which is "asking" for the value and not the report design element. MARS will recognize your parameter and all will be ok. |
|
James Winborough
Jan 25th, 2006 - 4:38 PM |
Re: MARS can't see parameters?
But my parameters are in the query behind the report and MARS will still not read them |
|
Mars Support
Jan 25th, 2006 - 4:48 PM |
Re: MARS can't see parameters?
There are several possible reasons for this: You have not defined your parameters ------------------------------------- The first line of the query must define the parameter in this manner: Here is a simple example: PARAMETERS [?CustID] ( 255 ) Select [first name], [Customer ID] from mytable where [Customer ID] = [?CustID] You can see that the above clearly distinguishes between which is a parameter value and which is a table column. Your database has corruption or your environment is incorrect --------------------------------------------------- Compact your database. If this doesn't work, create a new empty database and copy all the objects from the old to the new. This will leave the corruption behind. We also advise that you update Access with the very latest service pack and also your Operating System. Oher than the above we know of no other reason why MARS will not see a parameter in a report query. |
| First |
Prev |
Reply |
Forum |
Next |
Last |