Can we capture DataSet?

hi,
I would like to use the generated dataset in rdl file to generate
charts(third party component) if needed, As of now just the report is
displayed with out any graph.
In order to achieve this i have to capture the dataset (mdx query) through
custom code or any other means which will allow me to use the same dataset to
populate the chart if required.
Any examples would be very useful.
Many ThanksThis is hard to achieve within RS 2000.
RS 2005 will have a new CustomReportItem feature which will expose the
(processed, RDL grouped, filtered, sorted) data to a custom processing
control which can then generate an image/chart from the data.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"VP" <VP@.discussions.microsoft.com> wrote in message
news:A8F4ADE7-66B4-46C6-87A0-263FDAE43DFD@.microsoft.com...
> hi,
> I would like to use the generated dataset in rdl file to generate
> charts(third party component) if needed, As of now just the report is
> displayed with out any graph.
> In order to achieve this i have to capture the dataset (mdx query) through
> custom code or any other means which will allow me to use the same dataset
> to
> populate the chart if required.
> Any examples would be very useful.
> Many Thanks
>|||Thanks for the information.
VP
"Robert Bruckner [MSFT]" wrote:
> This is hard to achieve within RS 2000.
> RS 2005 will have a new CustomReportItem feature which will expose the
> (processed, RDL grouped, filtered, sorted) data to a custom processing
> control which can then generate an image/chart from the data.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "VP" <VP@.discussions.microsoft.com> wrote in message
> news:A8F4ADE7-66B4-46C6-87A0-263FDAE43DFD@.microsoft.com...
> > hi,
> >
> > I would like to use the generated dataset in rdl file to generate
> > charts(third party component) if needed, As of now just the report is
> > displayed with out any graph.
> > In order to achieve this i have to capture the dataset (mdx query) through
> > custom code or any other means which will allow me to use the same dataset
> > to
> > populate the chart if required.
> > Any examples would be very useful.
> >
> > Many Thanks
> >
> >
>
>

can this be done?

I have a text file that is generated from a host transaction. I have a batch
program that loads the text file into SQL and does a boatload of validation.
Is it possible to create DTS job or do this some how in SQL to make it
pretty less painful?you can create a dts package using import/export wizard in mssql server
enterprise manager, store it somewhere ( either on the server, or as a
file ), and then call this package from your app, and supply all dynamic
variables, including the filename, etc.
Ilyan Mishiyev
IGM Consulting Corporation
Enterprise Web Solutions
www.igmcc.com
"microsoft.news.com" <CSharpCoder> wrote in message
news:exxPynAUFHA.1432@.TK2MSFTNGP09.phx.gbl...
>I have a text file that is generated from a host transaction. I have a
>batch program that loads the text file into SQL and does a boatload of
>validation. Is it possible to create DTS job or do this some how in SQL to
>make it pretty less painful?
>
>|||would i still have to do all the business rules, validation etc, in the
batch program or could I use SQL to do all of that?
"Ilyan Mishiyev" <msnewsaccountREMOVE@.THISigmcc.com> wrote in message
news:exhFJ5AUFHA.2556@.TK2MSFTNGP12.phx.gbl...
> you can create a dts package using import/export wizard in mssql server
> enterprise manager, store it somewhere ( either on the server, or as a
> file ), and then call this package from your app, and supply all dynamic
> variables, including the filename, etc.
> --
> Ilyan Mishiyev
> IGM Consulting Corporation
> Enterprise Web Solutions
> www.igmcc.com
>
> "microsoft.news.com" <CSharpCoder> wrote in message
> news:exxPynAUFHA.1432@.TK2MSFTNGP09.phx.gbl...
>|||after you load all the data, you can call a stored proc by the same app
that proc might be used for validation
Ilyan Mishiyev
IGM Consulting Corporation
Enterprise Web Solutions
www.igmcc.com
"microsoft.news.com" <CSharpCoder> wrote in message
news:Of5CG$AUFHA.2056@.tk2msftngp13.phx.gbl...
> would i still have to do all the business rules, validation etc, in the
> batch program or could I use SQL to do all of that?
> "Ilyan Mishiyev" <msnewsaccountREMOVE@.THISigmcc.com> wrote in message
> news:exhFJ5AUFHA.2556@.TK2MSFTNGP12.phx.gbl...
>|||is there somewere online i could read about or look at this being done or
something like it being done?
"Ilyan Mishiyev" <msnewsaccountREMOVE@.THISigmcc.com> wrote in message
news:uxYGZUBUFHA.3652@.TK2MSFTNGP10.phx.gbl...
> after you load all the data, you can call a stored proc by the same app
> that proc might be used for validation
> --
> Ilyan Mishiyev
> IGM Consulting Corporation
> Enterprise Web Solutions
> www.igmcc.com
>
> "microsoft.news.com" <CSharpCoder> wrote in message
> news:Of5CG$AUFHA.2056@.tk2msftngp13.phx.gbl...
>|||not sure about that
actually it's really not that complicated
step 1 - create dts package
step 2 - call tht package from the app to load data
step 3 - call stored proc that validates loaded data
Ilyan Mishiyev
IGM Consulting Corporation
Enterprise Web Solutions
www.igmcc.com
"microsoft.news.com" <CSharpCoder> wrote in message
news:ebXU5cBUFHA.736@.TK2MSFTNGP10.phx.gbl...
> is there somewere online i could read about or look at this being done or
> something like it being done?
> "Ilyan Mishiyev" <msnewsaccountREMOVE@.THISigmcc.com> wrote in message
> news:uxYGZUBUFHA.3652@.TK2MSFTNGP10.phx.gbl...
>|||that appears easy, but how will i define what data goes into what column in
the table since my data in the file looks like this:
BMW325i20051212 65222 John Smith
its:
Car: BMW
Model: 3251
Year: 20051212
Price: 65222
Buyer: John Smith
and so on.
"Ilyan Mishiyev" <msnewsaccountREMOVE@.THISigmcc.com> wrote in message
news:O0YBSwBUFHA.2556@.TK2MSFTNGP12.phx.gbl...
> not sure about that
> actually it's really not that complicated
> step 1 - create dts package
> step 2 - call tht package from the app to load data
> step 3 - call stored proc that validates loaded data
> --
> Ilyan Mishiyev
> IGM Consulting Corporation
> Enterprise Web Solutions
> www.igmcc.com
>
> "microsoft.news.com" <CSharpCoder> wrote in message
> news:ebXU5cBUFHA.736@.TK2MSFTNGP10.phx.gbl...
>|||Is it a fixed length file?
Do you know the layout of this file?
For example,
from 1st character to 5th, field 1
from 6th character to 12th, field 2, etc.
If this is a fixed length file and you do know what the layout is, then you
can specify that when creating a dts package.
If it's a delimited file ( i don't think it's a delimited file by looking at
data ), then specify what the delimiter ( comma, semicolon, pipe, etc. ) is
so dts knows how to split that data into fields.
Then, when that package is called by your application, all the data will
automatically be loaded into the specified fields.
Try creating a package first and load that data manually.
Ilyan Mishiyev
IGM Consulting Corporation
Enterprise Web Solutions
www.igmcc.com
"microsoft.news.com" <CSharpCoder> wrote in message
news:uIr9U8BUFHA.2820@.tk2msftngp13.phx.gbl...
> that appears easy, but how will i define what data goes into what column
> in the table since my data in the file looks like this:
> BMW325i20051212 65222 John Smith
>
> its:
> Car: BMW
> Model: 3251
> Year: 20051212
> Price: 65222
> Buyer: John Smith
> and so on.
>
> "Ilyan Mishiyev" <msnewsaccountREMOVE@.THISigmcc.com> wrote in message
> news:O0YBSwBUFHA.2556@.TK2MSFTNGP12.phx.gbl...
>

Can report content be generated dynamically?

SSRS 2005
I have figured out how to use a custom code assembly to dynamically control
the content of the textboxes in the footer of my report.
For example, I have an expression like this in one of the textboxes:
=Code.OakRptLib.BuildPageFooterLeft()
This approach assumes that the textboxes already exist in the report footer.
I am trying to build custom code assemblies that allow my reports to be
dynamically configured in a consistent, standard manner at run time.
Ideally when the report starts up I would like to dynamically create these
text boxes in the report footer so that I can make sure they all use the same
font settings, positioning, content, etc.
Is there a way that I can dynamically create these text boxes in the report
footer when the report first starts processing? For example with code in the
OnInit() method?
--
Chris, SSSIHello Chris,
Based on my research, you could not dynamically create a report item in the
code.
The only thing you may do is using a program to dynamically create a rdl
file.
Since the RDL file is a XML format, you could use the .NET program to
generate a RDL file.
Hope this will be some help for you.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thanks Wei!
Did Steven Cheng have any ideas about this?
-- Chris
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> Based on my research, you could not dynamically create a report item in the
> code.
> The only thing you may do is using a program to dynamically create a rdl
> file.
> Since the RDL file is a XML format, you could use the .NET program to
> generate a RDL file.
> Hope this will be some help for you.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Chris,
I have discussed with Steven, and he also confirmed this.
I suggest you may try some suggestion from Chris Conner in other post: "Can
I obtain a reference to a report item?"
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.