Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Guys,
User apparently can only execute one stored proc. from a Crystal Reports. There are lots of different types of queries and he would like to cut-down on the number of Crystal Reports he would need. He wishes to create
Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Paula
I don't know
Crystal reports so I'm not sure what you are trying to achieve,
but...
1) If you're
using 8i and can fix the number of bind variables (or don't need to use them at
all) then native dynamic sql (NDS
Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Yes,
it looks like NDS may be able to be used - Reading Johnathon Lewis' Practical 8i
with refcursor. I think this is a better approach then global temporary
table. I will see if there are limitations to this using Crystal
Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS
Need
bind variables, can't fix them yes will go with global temporary tables but
understand that this is going to place I/O on system that may not be
necessary.
-Original Message-From: Lord, David - CSG
[mailto
Hi
Sanjay!
You can
usethe shareware tool TabExp to generate
Excel
compatible CSV
Files.
http://www.materialdreams.com/products.html
Cheers
DO
Original
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Sanjay KumarSent: Tuesday, March 06, 2001 2:40
AMTo: