Link Reports to System.Data.DataSets?

The mechanism to link a Crystal Report to data is by giving it a
System.Data.DataSet, I was wondering if this same option is possible in
Reporting Services.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!Today you have to create a data processing extension. In the future
(Widbey/Yukon) there will be a webform control and winform control that
would allow this. If you don't want to create a data processing extension
then the dataset needs to be generated from RS (either embed the SQL or call
a stored procedure). I suggest first looking at using RS without a data
processing extension and make sure you understand RS capabilities then if
you decide you have to do it with a data processing extension.
Remember, RS is a different architecture than Crystal so there will be
plenty of places where you need to approach things differently.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> The mechanism to link a Crystal Report to data is by giving it a
> System.Data.DataSet, I was wondering if this same option is possible in
> Reporting Services.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
>|||Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can be rendered from data tha only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||uhh... I meant:
Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can't be rendered from data that only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||Well, you can do it, it is just more complex, version 2 this will be much
simplier.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OPn72Nn0EHA.2192@.TK2MSFTNGP14.phx.gbl...
> uhh... I meant:
> Thank you. The point is that not allowing to generate the reports from a
> system.data.DataSet mean that reports can't be rendered from data that
only
> exists in memory and this is something that Crystal allows and that one of
> my customers supposedly needs.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing
extension
> > then the dataset needs to be generated from RS (either embed the SQL or
> call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then
if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible
in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
>|||Hi
I am not sure that I fully understand your suggestions. I have an ASP.NET
application that uses a web form to update an XML dataset. I would like to be
able to produce a report from the dataset and ideally I would like to
serialize it and pass it as a data source to an RS web service but RS does
not seem to support this. I could serialise and persist to SQL Server as a
single ntext field that could then be queried to return a complete XML
document. Again RS does not seem to handle this. I do not wish to create a
full set of SQL Server tables to persist the dataset at the field level just
to produce the report (there are rather a lot of items).
You indicated that a "data processing extension" might help with this. Could
you possibly expand a little more or point me in the right direction?
Thanks
"Bruce L-C [MVP]" wrote:
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>
>|||I have had some further thoughts and I would be interested to know if the
following approach might work:
1. Create a web-service report that accepts a string parameter and uses a
stored procedure as a data source to which it passess the parameter.
2. Write the stored procedure to accept a parameter of type ntext which it
passes to sp_xml_preparedocument and then generates the required output using
OPENXML().
3. From the asp.net application, serialise the xml from the dataset as a
string and pass as a parameter to the web-service report.
Thanks
"njr" wrote:
> Hi
> I am not sure that I fully understand your suggestions. I have an ASP.NET
> application that uses a web form to update an XML dataset. I would like to be
> able to produce a report from the dataset and ideally I would like to
> serialize it and pass it as a data source to an RS web service but RS does
> not seem to support this. I could serialise and persist to SQL Server as a
> single ntext field that could then be queried to return a complete XML
> document. Again RS does not seem to handle this. I do not wish to create a
> full set of SQL Server tables to persist the dataset at the field level just
> to produce the report (there are rather a lot of items).
> You indicated that a "data processing extension" might help with this. Could
> you possibly expand a little more or point me in the right direction?
> Thanks
> "Bruce L-C [MVP]" wrote:
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing extension
> > then the dataset needs to be generated from RS (either embed the SQL or call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
> >

link crystal report 10 with vb 6.0

1. how can i link crystal report 10 with vb6.0
2. how can get the (picture or image) in crystal report 10 from direct to the file through vb6.0 application
send me answer please.......There is a special forum for crystal reports so please ask your request there. I think thats the place you would get help|||I want to connect crystal report 11 with vb 6.0
please tell me the code for it .
reply me as soon as possible|||please tell me the code|||I want to connect crystal report 11 with vb 6.0
please tell me the code for it .
reply me as soon as possible|||I want to link crystal report 11 with vb 6.0, but I am not geting any output,
so please tell me the code for it.
reply me as soon as possible.|||I want to coonect crystal report with vb 6.0, please tell me the code for it.
please reply me as soon as possible.|||I want to coonect crystal report with vb 6.0, please tell me the code for it.
please reply me as soon as possible. i have the code for crystal report 8 but in it crystal report 11 is not showing any output|||i have the code for crystal report 8 but in it crystal report 11 is not showing any output.,|||Send your code for crystal 8 and that could be a better start than repeating your posts|||I want to connect crystal report 11 with vb 6.0
please tell me the code for it .
reply me as soon as possibleShow your code, what you have done so far so we can see what the problem is. Are you using DE (Dataenviroment ) ?

Line Count in Crystal Report

Is there any function or way to get the no of lines displayed in the detail section of the report.

Hlp me.

Thx in advance.

Ashok Sis that not a group function.. something you would put in the group footer (a total)?

i cant be too specific because im still learning crystal myself!|||You need to use two formulae
Formula1 @.Reset having the code
Numbervar n;
WhilePrintingRecords;
n:=0;
Formula2 @.Count having the code
Numbervar n;
WhilePrintingRecords;
n:=n+1;
Now Place Formual1 at PageHeader
Formula2 at Details Section.
Now the last value is the total number of records of that page|||Or you could just use the inbuilt RecordNumber function. It works fine if you are not hiding any records in your record set

- Jukka|||My Problem is not getting the recordcount. I need to get the line count.
A Record may be displayed in multiple lines.

To be Specific, I have four Detail sections, and in that for three sections i have used can grow property except the first one. In this case I need to get the Line nos of the detail section.

Thx,

Ashok