Error 723 Failed to open a rowset?

[Ed Dror]

Hi there,

We are using MS Dynamics SL
I tried to add to the Invoice report (08760.rpt)
The column NoteID from sNote.nID
I attached the table sNote into the report and create a relationship
between ARTran.NoteID to sNote.nID

But when I try to print this invoices report I'm getting error message
Error 723 - failed to open a row set

How do I solve this problem?

Thanks,
Ed Dror
Andrew Lauren

[Barry Flynn]

Andrew

Did you use an Outer Join?
If you used an Inner Join, then it will fail to select any ARTran which does
not have a note, and that could cause it to select 0 rows.

Just a thought...

Barry
--
Barry Flynn
Complete Solutions DG

Post by Ed Dror
Hi there,
We are using MS Dynamics SL
I tried to add to the Invoice report (08760.rpt)
The column NoteID from sNote.nID
I attached the table sNote into the report and create a relationship
between ARTran.NoteID to sNote.nID
But when I try to print this invoices report I'm getting error message
Error 723 - failed to open a row set
How do I solve this problem?
Thanks,
Ed Dror
Andrew Lauren

[Oded Dror]

Barry,

Microsoft suggest to un check the select distinct in Crystal Reports

Ed

Post by Ed Dror
Andrew
Did you use an Outer Join?
If you used an Inner Join, then it will fail to select any ARTran which
does not have a note, and that could cause it to select 0 rows.
Just a thought...
Barry
--
Barry Flynn
Complete Solutions DG

Post by Ed Dror
Hi there,
We are using MS Dynamics SL
I tried to add to the Invoice report (08760.rpt)
The column NoteID from sNote.nID
I attached the table sNote into the report and create a relationship
between ARTran.NoteID to sNote.nID
But when I try to print this invoices report I'm getting error message
Error 723 - failed to open a row set
How do I solve this problem?
Thanks,
Ed Dror
Andrew Lauren

[Thomas Malia]

Did you update the data source references for the original tables in the
report before you added the Note table? When the Solomon reports are
created they are associated with a particular data source name which is
probably not the same data source name that you got the notes table from.

Before modifying a Solomon report, the first thing you should do is save the
report file to the usr_rpts directory... then go to the Database menu and
choose Set Location and "remap" the data source for all tables to the
Solomon application database you are planning on using for your report
development.

I don't know if this is the cause of your particular problem or not, but I
thinks there's a chance it might be.

regards,
Tom Malia

Post by Ed Dror
Hi there,
We are using MS Dynamics SL
I tried to add to the Invoice report (08760.rpt)
The column NoteID from sNote.nID
I attached the table sNote into the report and create a relationship
between ARTran.NoteID to sNote.nID
But when I try to print this invoices report I'm getting error message
Error 723 - failed to open a row set
How do I solve this problem?
Thanks,
Ed Dror
Andrew Lauren