Link two dataSet in the same report

Hi !
I use ms sql server 2005, and I have a problem
I have a dataBase where I have a lot of data, I have a webServices which calculate indicator for a time period and an id indicator. The time period must be specific and choose by the user, so I can't dto automatically by integrating the data from my webService in a dataBase (with IntegrationServices).
So I create a report with 2 dataset, one which recover the indicator value for each equipment (the webService send a list of {<idEquipment> and <value>}) , and I want to link the idEquipment with the IdEquipement in my dataBase, it would allow me to know other informations about the equipment :
equipement ID | Indicator value (from webServices) | equipment name | eq number | cumul of event duration for this eq....
All in the same grid...
Does it possible ?
If it is possible with the report designer, does it possible with report builder, as report builder need a model, how can i do to make a model from 2 dataSource...
thank you for your answer...

You may want to explore using SSIS as a data source or a custom object, or connect to the web service from SQL Server passing the parameters to it.

I was once able to use hash tables in custom code to store the data, with hidden fields for setting the values, but I'm not sure if that is feasable anymore as I could not replicate it.

cheers,

Andrew

|||Hi Andrew, and thank you for your answer.
As i explain, it is not possible to us to integrate our data with SSIS because our webService need parameter define by user, if we pass our own parameter, there will have too much data and user cannot change them after.
So I need to call my web Service methode in my report, because it is at this moment that the user can and have to choose his param. So I have already doing a dataSet which recover the data from the web Service.
Now I need to know if it possible to do like a 'inner join' between two dataSet (one from my web Service, and the other from my olap cube) ?
I already use BIRT (Java) and it is possible to do it, but I didn't see this 'option' in Reporting Services. Maybe there is an easy way or another way to do that... I hope so.

Thank you to read...
|||

Hi Alineo,

It's not possible to join two different datasets inside the report itself.

Hope you can find alternate means. You should be able to pass parameters to a web service by using SSIS or SQL Server.

cheers,

Andrew

|||excuse me, but I don't understand how, to do.
I need just this information when the user run the report... so it isn't possible to use integrating services, because (it is what I understand) the integration will generate automatically and before... So the user cannot give it param to it, just the developper can do it, and as I told you, the developper cannot do all the possibility in parameter.
The parameter in a time period (from ... to ...) so ....
Ok so it is not possible !!
thank you for your answer....
|||

Here's how to use a parameter from SSIS if you want to go down this road.

http://blogs.msdn.com/bimusings/archive/2006/07/19/using-a-parameterized-ssis-package-as-a-data-source-for-sql-reporting-services.aspx

Integration services runs when the report runs.

cheers,

Andrew

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!!!
> > >
> > >
> >
> >
> >

Line location as expression

Is it possible to move lines based on the values from dataset(trying to draw graph kinda thing by joining points using lines) ?Let me know if I am not clear here.

Thanks

Yes, it is possible if I understand you correctly and if you are willing to do some custom rendering. Check out CustomReportItem and look at the Polygons sample in the RS sample stuff.

If you go this route, take it from me you will find out it's not all about 1's and 0's <rofl>.

But, yes, you are really not being clear <g>. So maybe I've misunderstood...

>L<

sql

Line Chart Empty

I have a dataset that can be viewed as columns chart. But when I change to
line chart, the data is shown only partly, or not shown at all.
I noticed that if I have one set of data that covers the full lenght of
x-axis, and another set of data that covers only the right side of x-axis,
then what you will see will be the start of the line representing the first
set, then it stops completely and another line starts representing the second
set.
Anybody knows why it happends and how to fix it?
D>Are you using the RTM version of RS 2000, and SP1 or SP2 is not installed?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"uiwork" <uiwork@.discussions.microsoft.com> wrote in message
news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
>I have a dataset that can be viewed as columns chart. But when I change to
> line chart, the data is shown only partly, or not shown at all.
> I noticed that if I have one set of data that covers the full lenght of
> x-axis, and another set of data that covers only the right side of x-axis,
> then what you will see will be the start of the line representing the
> first
> set, then it stops completely and another line starts representing the
> second
> set.
> Anybody knows why it happends and how to fix it?
> D>|||It is RS 2000, and I have only SP1 installed. Is it a problem?
"Robert Bruckner [MSFT]" wrote:
> Are you using the RTM version of RS 2000, and SP1 or SP2 is not installed?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "uiwork" <uiwork@.discussions.microsoft.com> wrote in message
> news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
> >I have a dataset that can be viewed as columns chart. But when I change to
> > line chart, the data is shown only partly, or not shown at all.
> > I noticed that if I have one set of data that covers the full lenght of
> > x-axis, and another set of data that covers only the right side of x-axis,
> > then what you will see will be the start of the line representing the
> > first
> > set, then it stops completely and another line starts representing the
> > second
> > set.
> > Anybody knows why it happends and how to fix it?
> > D>
>
>|||Yes, you are running into a known issue with line charts using multiple data
series and the datapoints having interleaved category (x-axis) values. The
fix is available in RS 2000 SP2.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"uiwork" <uiwork@.discussions.microsoft.com> wrote in message
news:991368D7-2E58-4566-AB34-68027D9FC856@.microsoft.com...
> It is RS 2000, and I have only SP1 installed. Is it a problem?
> "Robert Bruckner [MSFT]" wrote:
>> Are you using the RTM version of RS 2000, and SP1 or SP2 is not
>> installed?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "uiwork" <uiwork@.discussions.microsoft.com> wrote in message
>> news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
>> >I have a dataset that can be viewed as columns chart. But when I change
>> >to
>> > line chart, the data is shown only partly, or not shown at all.
>> > I noticed that if I have one set of data that covers the full lenght of
>> > x-axis, and another set of data that covers only the right side of
>> > x-axis,
>> > then what you will see will be the start of the line representing the
>> > first
>> > set, then it stops completely and another line starts representing the
>> > second
>> > set.
>> > Anybody knows why it happends and how to fix it?
>> > D>
>>

Line 1: Incorrect syntax near =

Hi,

I'm getting the above error when i try to fill a Dataset through a
dataAdapter.

I presume it is to do with the sql statement. Below is the relevant
code:

string strPntUnitID = patientCodeLbl.Text;
string strPntFName = fNameLbl.Text;
string strPntLName = lNameLbl.Text;

// Create DataAdapter & Dataset
SqlDataAdapter daRelateDocToPnt = new SqlDataAdapter("SELECT patientNo,
doctorNo FROM tblPatient" +
"WHERE (pntUnitID = '"+ strPntUnitID +"') AND (pntFName = '"+
strPntFName +"')"+
"AND (pntLName = '"+ strPntLName +"')", conn);

DataSet dsDocNoToPnt = new DataSet();

// Create command builder, automatically generates the update commands
SqlCommandBuilder pntCmd = new SqlCommandBuilder(daRelateDocToPnt);

// Set the MissingSchemaAction property to AddWithKey because Fill will
not cause primary
// key & unique key information to be retrieved unless AddWithKey is
specified.
daRelateDocToPnt.MissingSchemaAction = MissingSchemaAction.AddWithKey;

// Use dataAdapter to fill DataSet
daRelateDocToPnt.Fill(dsDocNoToPnt, "Patient");

// place intDocNo into the dataset schema
dsDocNoToPnt.Tables["Patient"].Rows[0]["doctorNo"] = "intDocNo";

// Update The Database
daRelateDocToPnt.Update(dsDocNoToPnt, "Patient");

Can anyone spot the problem?

ThanksAt a quick glance, it seems that you have no space between tblPatient
and WHERE, but without seeing the actual command, it's hard to say. If
you build a SQL string dynamically, it's a good idea to provide a debug
mechanism - perhaps you can build up the string first and display it,
then instantiate the adapter using the string?

You might also want to consider writing a stored procedure to return
the results, and pass the ID and names as parameters.

Simon|||Thanks Simon , your quick glance worked, the space was the problem.|||Assimalyst (c_oxtoby@.hotmail.com) writes:
> I presume it is to do with the sql statement. Below is the relevant
> code:
> string strPntUnitID = patientCodeLbl.Text;
> string strPntFName = fNameLbl.Text;
> string strPntLName = lNameLbl.Text;
> // Create DataAdapter & Dataset
> SqlDataAdapter daRelateDocToPnt = new SqlDataAdapter("SELECT patientNo,
> doctorNo FROM tblPatient" +
> "WHERE (pntUnitID = '"+ strPntUnitID +"') AND (pntFName = '"+
> strPntFName +"')"+
> "AND (pntLName = '"+ strPntLName +"')", conn);

Rather than building the entire command this way, use parameterised
commands:

"SELECT patientNo, doctorNo FROM tblPatient " +
"WHERE (pntUnitID = @.PntUnitID AND (pntFName = @.strPntFName " +
"AND (pntLName = @.PntLName "

The use the parameters collection on the command object to define the
parameter.

If you wonder why, try your current code with someone whose last name
is O'Brien.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Limiting Dataset for Chart but not Table

I have a report that has a single dataset that is used to populate both a
chart and a table. I want to limit the rows used by the chart but I want
the table to display all rows. I'm having difficulty determining how to
apply some sort of "rowcount <=10" condition to the chart's dataset. I
would like to avoid executing the same query twice.
I have been unable to find any references to this searching through this
group or the web (via google). Nor could I find anything in the Books
Online.
Is this possible or must I create two datasets, one that limits the number
of rows returned and another that returns all rows? If this can be done,
can someone please point me to an article that explains how?
Thanks,
ChrisChristopher,
SQL Server 2000 Reporting Services supports filtering on data regions
(table, matrix, list, and chart). Please see Reporting Services Books On
Line (BOL) for more information.
To access the filtering option for charts:
* Open the chart properties dialog
* Click on the Data tab
* Add or Edit a Category group (same applies to Series groups)
* Click on the Filtering tab
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Walls" <msnews@.travantsolutions.com> wrote in message
news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> I have a report that has a single dataset that is used to populate both a
> chart and a table. I want to limit the rows used by the chart but I want
> the table to display all rows. I'm having difficulty determining how to
> apply some sort of "rowcount <=10" condition to the chart's dataset. I
> would like to avoid executing the same query twice.
> I have been unable to find any references to this searching through this
> group or the web (via google). Nor could I find anything in the Books
> Online.
> Is this possible or must I create two datasets, one that limits the number
> of rows returned and another that returns all rows? If this can be done,
> can someone please point me to an article that explains how?
> Thanks,
> Chris
>|||My category is on a field named "TargetOpenDate", so how do I setup the
filter? I cannot find any guidance either in the BOL or searching on Google
(web or groups).
I just want to limit the number of rows to the Top 5. I cannot leave the
Expression field blank. It seems no matter which field I select (either the
field I'm using for the category or some other arbitrary field), I get an
error "Fail to evaluate FilterExpression/FilterValues".
Expression: =Fields!TargetOpenDate.Value
Operator: Top N
Value: 3
Thanks,
Chris
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:u7%23BJyVVEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Christopher,
> SQL Server 2000 Reporting Services supports filtering on data regions
> (table, matrix, list, and chart). Please see Reporting Services Books On
> Line (BOL) for more information.
> To access the filtering option for charts:
> * Open the chart properties dialog
> * Click on the Data tab
> * Add or Edit a Category group (same applies to Series groups)
> * Click on the Filtering tab
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > I have a report that has a single dataset that is used to populate both
a
> > chart and a table. I want to limit the rows used by the chart but I
want
> > the table to display all rows. I'm having difficulty determining how to
> > apply some sort of "rowcount <=10" condition to the chart's dataset. I
> > would like to avoid executing the same query twice.
> >
> > I have been unable to find any references to this searching through this
> > group or the web (via google). Nor could I find anything in the Books
> > Online.
> >
> > Is this possible or must I create two datasets, one that limits the
number
> > of rows returned and another that returns all rows? If this can be
done,
> > can someone please point me to an article that explains how?
> >
> > Thanks,
> > Chris
> >
> >
>|||There is a trick. You need the value to be =3 instead of just 3. The
expression evaluator guesses that 3 is a string.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Walls" <msnews@.travantsolutions.com> wrote in message
news:Or7f3JwVEHA.644@.tk2msftngp13.phx.gbl...
> My category is on a field named "TargetOpenDate", so how do I setup the
> filter? I cannot find any guidance either in the BOL or searching on
Google
> (web or groups).
> I just want to limit the number of rows to the Top 5. I cannot leave the
> Expression field blank. It seems no matter which field I select (either
the
> field I'm using for the category or some other arbitrary field), I get an
> error "Fail to evaluate FilterExpression/FilterValues".
> Expression: =Fields!TargetOpenDate.Value
> Operator: Top N
> Value: 3
>
> Thanks,
> Chris
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:u7%23BJyVVEHA.4048@.TK2MSFTNGP12.phx.gbl...
> > Christopher,
> >
> > SQL Server 2000 Reporting Services supports filtering on data regions
> > (table, matrix, list, and chart). Please see Reporting Services Books On
> > Line (BOL) for more information.
> >
> > To access the filtering option for charts:
> >
> > * Open the chart properties dialog
> > * Click on the Data tab
> > * Add or Edit a Category group (same applies to Series groups)
> > * Click on the Filtering tab
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> > news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > I have a report that has a single dataset that is used to populate
both
> a
> > > chart and a table. I want to limit the rows used by the chart but I
> want
> > > the table to display all rows. I'm having difficulty determining how
to
> > > apply some sort of "rowcount <=10" condition to the chart's dataset.
I
> > > would like to avoid executing the same query twice.
> > >
> > > I have been unable to find any references to this searching through
this
> > > group or the web (via google). Nor could I find anything in the Books
> > > Online.
> > >
> > > Is this possible or must I create two datasets, one that limits the
> number
> > > of rows returned and another that returns all rows? If this can be
> done,
> > > can someone please point me to an article that explains how?
> > >
> > > Thanks,
> > > Chris
> > >
> > >
> >
> >
>|||Thanks, that worked.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ub6EY%23wVEHA.1656@.TK2MSFTNGP09.phx.gbl...
> There is a trick. You need the value to be =3 instead of just 3. The
> expression evaluator guesses that 3 is a string.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> news:Or7f3JwVEHA.644@.tk2msftngp13.phx.gbl...
> > My category is on a field named "TargetOpenDate", so how do I setup the
> > filter? I cannot find any guidance either in the BOL or searching on
> Google
> > (web or groups).
> >
> > I just want to limit the number of rows to the Top 5. I cannot leave
the
> > Expression field blank. It seems no matter which field I select (either
> the
> > field I'm using for the category or some other arbitrary field), I get
an
> > error "Fail to evaluate FilterExpression/FilterValues".
> >
> > Expression: =Fields!TargetOpenDate.Value
> > Operator: Top N
> > Value: 3
> >
> >
> > Thanks,
> > Chris
> >
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> > news:u7%23BJyVVEHA.4048@.TK2MSFTNGP12.phx.gbl...
> > > Christopher,
> > >
> > > SQL Server 2000 Reporting Services supports filtering on data regions
> > > (table, matrix, list, and chart). Please see Reporting Services Books
On
> > > Line (BOL) for more information.
> > >
> > > To access the filtering option for charts:
> > >
> > > * Open the chart properties dialog
> > > * Click on the Data tab
> > > * Add or Edit a Category group (same applies to Series groups)
> > > * Click on the Filtering tab
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> > > news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > > I have a report that has a single dataset that is used to populate
> both
> > a
> > > > chart and a table. I want to limit the rows used by the chart but I
> > want
> > > > the table to display all rows. I'm having difficulty determining
how
> to
> > > > apply some sort of "rowcount <=10" condition to the chart's dataset.
> I
> > > > would like to avoid executing the same query twice.
> > > >
> > > > I have been unable to find any references to this searching through
> this
> > > > group or the web (via google). Nor could I find anything in the
Books
> > > > Online.
> > > >
> > > > Is this possible or must I create two datasets, one that limits the
> > number
> > > > of rows returned and another that returns all rows? If this can be
> > done,
> > > > can someone please point me to an article that explains how?
> > > >
> > > > Thanks,
> > > > Chris
> > > >
> > > >
> > >
> > >
> >
> >
>

limit to the number of rows a dataset can store?

hI,

I am using visual c# 2003 and sqlserver 2000 and i am trying to query a column in the sql server and store it into a dataset but i got an error msg:

The number of rows for this query will output 90283 rows.

------------------------
Query :

SELECT L_ExtendedPrice, COUNT (*) AS Count FROM LINEITEM GROUP BY L_ExtendedPrice ORDER BY Count DESC";

------------------------
Error msg :

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.
-------------------------

is there a limit to the number of rows a dataset can store?That's a lot of rows....

Can I ask what you plan to do with them?

And it's not really a sql server question...|||hi,

It is because I am a university student and i am doing my final year project on querying and i need these data to proceed on. I am researching on Small Group Sampling.

I was thinking that i am using sql server 2000 and maybe i can post this question in here as I am really in need of help for this.

thks|||Whatever you thought you wanted to do with the "dataset", why don't you want to do it on the server? All this "C#" and stuff is good, but only when used appropriately. Having a front-end with 90K+ rows is not a good idea, unless it's a report. But if that's the case, - it shouldn't be going into a "dataset."|||Originally posted by sunspot
hi,

It is because I am a university student and i am doing my final year project on querying and i need these data to proceed on. I am researching on Small Group Sampling.

I was thinking that i am using sql server 2000 and maybe i can post this question in here as I am really in need of help for this.

thks

OK, I'll byte...what's your major going to be in....|||Hi,

It is because I need to use the data in thwe dataset to do something else. This question is actually related to a question I posted on :

visual studio.net and sql server 02-12-04 22:01

I do not know what is the wrong things that I have done and that is why I am asking how many rows a dataset can store as I got error msg when I run the program.