RE: [sqr-users] Problem with output

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

You need to check the database connection is the same and the parameters are
the same.  The easiest way to check this is to turn on job factory debugging
(set jf_debug=true in the startup script).  Then the job factory will keep
the sqr command it used to run the report.  This is kept in the
.../server/JFxxxxxxx/tmp directory.  You might either see the problem
straight away, or you can rerun the SQR command (sqrexec.bat or sqrexec.sh)
outside portal and debug that way.

Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Darshil Mehta
Sent: Friday, 13 August 2004 9:23 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Problem with output


Hi all,

I am generating a report with appox. 60 input parameters. When I execute
this report on Brio Portal, I do not get output. But when I use the same
query in database, I do get around 20,000 rows.

What could be the reason?

Thanx in advance....

Best regards,

Darshil Mehta


______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users