parameter problem with report

I am trying to build a report based on the following query .
I want the user to enter the date value for the R.ANNLAPPT_DATE but when I try to run the query I get the following msg
ORA-00904: invalid column name

The data source for this report is an oracle db

SELECT C.PREFERRED_NAME, C.SURNAME, R.ANNLAPPT_DATE, R.CLNP_CODE, R.CONS_MD_CODE, P.SURNAME AS CLINICIAN, R.DEPT_CODE,
D.DEPT_TITLE, R.PT_CODE, R.REFLREAS_DESC, R.HOSP_CODE, R.REFP_CODE, RP.REFP_TITLE, A.APAT_CODE, MAX(A.APPT_DATE) AS EXPR1,
R.ANNLAPPT_DATE AS EXPR2
FROM ORACARE.K_REFLREG R, ORACARE.K_CPIREG C, ORACARE.K_DEPTLIST D, ORACARE.K_PROFREG P, ORACARE.K_REFPLIST RP,
ORACARE.K_APPTREG A
WHERE R.PT_CODE = C.PT_CODE AND R.DEPT_CODE = D.DEPT_CODE AND R.HOSP_CODE = D.HOSP_CODE AND R.CONS_MD_CODE = P.MPROF_CODE AND
R.REFP_CODE = RP.REFP_CODE AND R.EVENT_NO = A.EVENT_NO (+) AND

(R.ANNLAPPT_DATE < "@.ANNALAPPT_DATE")

GROUP BY C.PREFERRED_NAME, C.SURNAME, R.ANNLAPPT_DATE, R.CLNP_CODE, R.CONS_MD_CODE, P.SURNAME, R.DEPT_CODE, D.DEPT_TITLE,
R.PT_CODE, R.REFLREAS_DESC, R.HOSP_CODE, R.REFP_CODE, RP.REFP_TITLE, A.APAT_CODEI don't think you want to enclose the parameter name in quotes, and if you are using Oracle, you may need to use a ? in place of @.ANNALAPPT_DATE. I think that depends on which driver you are using, though.|||Thanks for the reply,

sql server automaically inserted the double quotes I will try ?.
|||Thanks for the help the ? did the trick.|||

Can you mark the helpful response as an answer?

parameter 3608 errors

sql2000 build 818
i was using kb article 224071 to move model and msdb to a new drive.
after i add the parameter -T3608 and restart the server, the server will
die with the error, 2004-06-09 18:16:44.61 spid52 WARNING: problem
activating all tempdb files. See previous errors. Restart server with
-f to correct the situation.
the log says it's only recovering master, but it dies at random points.
sometimes it will die after it starts up the first user db. sometimes
it gets all the user db's started before it dies with that error.
what causes this error? this has happened to me on two servers so far.
i have to try to sneak in the detach and attach commands before sql
server decides to quit working while 3608 is enabled. once i get model
and msdb detached, moved to new location, reattached, and then restart
the server without 3608 enabled, everything is fine.My guess is that tempdb cannot be created and the first access to tempdb mak
es SQL Server "bomb". Did you try
starting using -f, as the error message say? Or using 3809?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ch" <ch@.dontemailme.com> wrote in message news:40C8580F.8D08149F@.dontemailme.com...eagreen">
> sql2000 build 818
> i was using kb article 224071 to move model and msdb to a new drive.
> after i add the parameter -T3608 and restart the server, the server will
> die with the error, 2004-06-09 18:16:44.61 spid52 WARNING: problem
> activating all tempdb files. See previous errors. Restart server with
> -f to correct the situation.
> the log says it's only recovering master, but it dies at random points.
> sometimes it will die after it starts up the first user db. sometimes
> it gets all the user db's started before it dies with that error.
> what causes this error? this has happened to me on two servers so far.
> i have to try to sneak in the detach and attach commands before sql
> server decides to quit working while 3608 is enabled. once i get model
> and msdb detached, moved to new location, reattached, and then restart
> the server without 3608 enabled, everything is fine.

parameter 3608 errors

sql2000 build 818
i was using kb article 224071 to move model and msdb to a new drive.
after i add the parameter -T3608 and restart the server, the server will
die with the error, 2004-06-09 18:16:44.61 spid52 WARNING: problem
activating all tempdb files. See previous errors. Restart server with
-f to correct the situation.
the log says it's only recovering master, but it dies at random points.
sometimes it will die after it starts up the first user db. sometimes
it gets all the user db's started before it dies with that error.
what causes this error? this has happened to me on two servers so far.
i have to try to sneak in the detach and attach commands before sql
server decides to quit working while 3608 is enabled. once i get model
and msdb detached, moved to new location, reattached, and then restart
the server without 3608 enabled, everything is fine.
My guess is that tempdb cannot be created and the first access to tempdb makes SQL Server "bomb". Did you try
starting using -f, as the error message say? Or using 3809?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ch" <ch@.dontemailme.com> wrote in message news:40C8580F.8D08149F@.dontemailme.com...
> sql2000 build 818
> i was using kb article 224071 to move model and msdb to a new drive.
> after i add the parameter -T3608 and restart the server, the server will
> die with the error, 2004-06-09 18:16:44.61 spid52 WARNING: problem
> activating all tempdb files. See previous errors. Restart server with
> -f to correct the situation.
> the log says it's only recovering master, but it dies at random points.
> sometimes it will die after it starts up the first user db. sometimes
> it gets all the user db's started before it dies with that error.
> what causes this error? this has happened to me on two servers so far.
> i have to try to sneak in the detach and attach commands before sql
> server decides to quit working while 3608 is enabled. once i get model
> and msdb detached, moved to new location, reattached, and then restart
> the server without 3608 enabled, everything is fine.
sql

parameter 3608 errors

sql2000 build 818
i was using kb article 224071 to move model and msdb to a new drive.
after i add the parameter -T3608 and restart the server, the server will
die with the error, 2004-06-09 18:16:44.61 spid52 WARNING: problem
activating all tempdb files. See previous errors. Restart server with
-f to correct the situation.
the log says it's only recovering master, but it dies at random points.
sometimes it will die after it starts up the first user db. sometimes
it gets all the user db's started before it dies with that error.
what causes this error? this has happened to me on two servers so far.
i have to try to sneak in the detach and attach commands before sql
server decides to quit working while 3608 is enabled. once i get model
and msdb detached, moved to new location, reattached, and then restart
the server without 3608 enabled, everything is fine.My guess is that tempdb cannot be created and the first access to tempdb makes SQL Server "bomb". Did you try
starting using -f, as the error message say? Or using 3809?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ch" <ch@.dontemailme.com> wrote in message news:40C8580F.8D08149F@.dontemailme.com...
> sql2000 build 818
> i was using kb article 224071 to move model and msdb to a new drive.
> after i add the parameter -T3608 and restart the server, the server will
> die with the error, 2004-06-09 18:16:44.61 spid52 WARNING: problem
> activating all tempdb files. See previous errors. Restart server with
> -f to correct the situation.
> the log says it's only recovering master, but it dies at random points.
> sometimes it will die after it starts up the first user db. sometimes
> it gets all the user db's started before it dies with that error.
> what causes this error? this has happened to me on two servers so far.
> i have to try to sneak in the detach and attach commands before sql
> server decides to quit working while 3608 is enabled. once i get model
> and msdb detached, moved to new location, reattached, and then restart
> the server without 3608 enabled, everything is fine.

Pagination for Large data

I want to build a system that will have about 1 million rows in a
table in sql server database.I am using this for a web application and
accessing it via JDBC type 4 driver.But display 20 records at a time
only using pagination(as in google).What will be the best way to go
about this.On 10 Oct 2003 04:04:11 -0700, nik_sharma75@.hotmail.com (Nikhil
Sharma) wrote:

>I want to build a system that will have about 1 million rows in a
>table in sql server database.I am using this for a web application and
>accessing it via JDBC type 4 driver.But display 20 records at a time
>only using pagination(as in google).What will be the best way to go
>about this.

Figure how many anyone is actually ever going to page through.
Obviously no one is going to page through to the end. How many google
pages would you look at before refining your search? Then construct
your query and restrict it with TOP. Cache the results and handle the
paging in your app.

Page Setup

Hi There,

I want to build a report in Crystal Reports XI but the problem is that i have to report on around 20-30 fields.

Is there a way to increase the width of the reporting page as I'm not able to increase it by more than A3 size.

Please help.

regards
PrashU can increase the size of the sheet provided that ur printer supports that particular sheet. Else u can try using the custom settings to set the size of the page. But then it might not print if your printer does not support that particular size.|||Thnx for the advice, but how can i do the custom setting.|||In ver 8.5, select

File --> Printer Setup

click on properties button and select paper tab. In the dialog box, u can see a "custom" button next to the "size" drop down list. You can click on the custom button and set the custom size of the page.

But note that, the custom button will be disabled if the printer does not support it.