Re: Crystal Report - From stored proc. to unbound fields
From: Mike (inluvwitiou_at_bluemail.ch)
Date: 09/29/04
- Next message: Jason: "Connection pool in WinForms app using Data Access Block is exhausting"
- Previous message: Thad: "Re: Inserts and the Identity field"
- In reply to: Mike: "Crystal Report - From stored proc. to unbound fields"
- Messages sorted by: [ date ] [ thread ]
Date: 29 Sep 2004 07:11:59 -0700
Well i got it after some tests and documentation. My approach was not
right in fact. First of all from the data returned in xml format (clob
parameter) from my proc., i genereated an xml schema file. This was
done very easily using the xmltextwriter stuff from .Net. Then, from
the design of my report, i added a new connection, selected the
ADO.NET(XML) from the more data sources tab and selected the generated
file.
I was then able to see the available columns (only the definition no
data), which correspond each xml field returned in my clob parameter
from the proc.
I had to drag and drop the one i wanted on my report. Then from the
code, using the setdatasource method from the report class worked
perfectly.
I was not getting the whole concept before, now it's done !!
Mike
- Next message: Jason: "Connection pool in WinForms app using Data Access Block is exhausting"
- Previous message: Thad: "Re: Inserts and the Identity field"
- In reply to: Mike: "Crystal Report - From stored proc. to unbound fields"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
