September 25th, 2003, 01:41 AM
|
|
Junior Member
|
|
Join Date: Sep 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Crystal Reports Query
1. I created a parameter field effective_date & have called that in the sql query with the “?’ syntax but when I run the report I get the following error:
ODBC error: [MERANT][ODBC Oracle 8 Driver] Value has not been specified for parameter1.
Error detected by database DLL
Where is the error? Pls let me know.
2. I want the sum of amount of every transaction done by a particular agent – using group header. I will be running this report for all the agents of an organization group by agent code. I created a formula field and placed it in the group footer but it does not calculate the sum with respect to the agent code.
What should I do?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
