Assigning a Dataset to a Rectangle

Hello,
I've created a Rectangle within a SQL Report, and i'd like to tie it
back to a Dataset. Within the Rectangle Properties it lists Data
Region, but none of my Datasets are appearing in the dropdown.
I found the following article on Microsoft's site -
http://technet.microsoft.com/en-us/library/ms159224.aspx - but the
first step is throwing me - "In Layout view, right-click the data
region and then click Properties." Data Region is an option within
the Rectangle Properties and not an object in of itself, so I'm not
sure what "Data Region" it's saying to right-click on.
Can someone point me in the right direction?
Thanks,
AlexOn Feb 14, 9:35=A0am, Alex <sama...@.gmail.com> wrote:
> Hello,
> I've created a Rectangle within a SQL Report, and i'd like to tie it
> back to a Dataset. =A0Within the Rectangle Properties it lists Data
> Region, but none of my Datasets are appearing in the dropdown.
> I found the following article on Microsoft's site -http://technet.microsof=
t.com/en-us/library/ms159224.aspx- but the
> first step is throwing me - "In Layout view, right-click the data
> region and then click Properties." =A0Data Region is an option within
> the Rectangle Properties and not an object in of itself, so I'm not
> sure what "Data Region" it's saying to right-click on.
> Can someone point me in the right direction?
> Thanks,
> Alex
Alex,
First thing to know, a rectangle is not a data region, it is a
graphical "report item" that's more like a container to keep report
items together.
Data regions are table, matrix, chart and list. They can be
associated with a dataset, rectangles cannot.
I'd suggest you try using the list data region as it will give you the
flexibility of freeform layout while still letting you tie back to a
dataset.
Also, take a look at this TechNet article for more info on Data
Regions:
http://technet.microsoft.com/en-us/library/ms157134.aspx
And this one for report items:
http://technet.microsoft.com/en-us/library/ms159268.aspx
HTH
toolman

asp.net worker process runs out of memory when using a large dataset

Hi,

I'm running an application on a server which grabs data from a database table on another server using SqlConnection, SqlDataAdapter and DataSet.

The application then updates every row in that DataSet's DataTable and the updates are saved back using DataAdapter. The code is pretty much straightforward code that you would find on MSDN documentation for using DataSets. The table contains a little over a million rows.

When I run the application, I get an error saying the Server Application is not available. Upon looking into the application event log, I get this message.

aspnet_wp.exe was recycled because memory consumption exceeded the
306 MB (60 percent of available RAM)

How do I get round this? I thought DataSets were supposed to handle large datatables comfortably without having memory issues.

-Thanks

They can, just increase your recycle point. Although with a million rows, it's likely you grind that little box into the ground. Buy more RAM, or expect to wait forever for a response. Using a DataReader instead of a dataset is what will allow your little box to access large tables without consuming a ton of memory.

ASP.Net DS ->SSRS Report? ...or do I?

Is there a "native" way to pass a sorted table or dataset to a SSRS?
Or, is there another way to do the following...
I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
params.
These will use a sProc that executes some dynamic SQL to accomodate the
variations in params passed.
This is all good and working as a prototype in .Net.
However, most of the results sent to the browser also need to be sorted and then
hard copy printed, so...
Option One; Have the ASP.Net app do all .Net datalists and the like presenting
all the data as needed. Then when a user wishes to print that data they click
the printable version link, which would pass the current dataset as sorted to
SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
alone.)
Option Two; Write my sorted data to a dynamic (rather than temp table) and then
call SSRS with params to get all the data as is from the dynamic table.
Option Three; give up, go home, take a nap, be a quiter, start crying like a
little boy, melt into a puddle of goo.
TIA
JeffP....I suggest rethinking a little how you do this. RS has a couple of ways to
integrate with your ASP. It has very good support for stored procedures. So
you can already use your stored procedure. You can integrate either by URL
or by web services. URL integration is the easiest way to go. Try just
creating a report with RS using the stored procedure and the parameters.
Once you have a report working then try out URL integration.
Passing a dataset is the hardest way to go to solve this. People have done
this but it requires a lot of jumping through hoops.
Bruce L-C
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:e6eWkzObEHA.2340@.TK2MSFTNGP10.phx.gbl...
> Is there a "native" way to pass a sorted table or dataset to a SSRS?
> Or, is there another way to do the following...
> I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
> params.
> These will use a sProc that executes some dynamic SQL to accomodate the
> variations in params passed.
> This is all good and working as a prototype in .Net.
> However, most of the results sent to the browser also need to be sorted
and then
> hard copy printed, so...
> Option One; Have the ASP.Net app do all .Net datalists and the like
presenting
> all the data as needed. Then when a user wishes to print that data they
click
> the printable version link, which would pass the current dataset as sorted
to
> SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
> alone.)
> Option Two; Write my sorted data to a dynamic (rather than temp table) and
then
> call SSRS with params to get all the data as is from the dynamic table.
> Option Three; give up, go home, take a nap, be a quiter, start crying like
a
> little boy, melt into a puddle of goo.
> TIA
> JeffP....
>|||Bruce,
I had a friend who is a much better programmer come over and we did a simple
sProc and created a SSRS Report.
We then ran the report as a SSRS report and then via URL; our biggest pain was
overcomming the "...you do not have permission to view this page..." or similar.
We added a default credential process if one was not present as well as a
user/pass textboxes w/cmd button to go to the report as a proof of concept that
we can accept win/auth, (won't be happening in any environment we have before
us) or default creds.
Anyway, back to my pain of displaying a report that was derived from the current
datalist control filtered and sorted as such.
I may try my dyna-temp table method. I think that there is a rumor indicating
that SSRS 05 will enable a method to call a SSRS report and pass it a .Net
DS/table.
I'd have thought that this would have been a first ed. feature(?)
TIA
JeffP...
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ONp0KaPbEHA.3664@.TK2MSFTNGP12.phx.gbl...
> I suggest rethinking a little how you do this. RS has a couple of ways to
> integrate with your ASP. It has very good support for stored procedures. So
> you can already use your stored procedure. You can integrate either by URL
> or by web services. URL integration is the easiest way to go. Try just
> creating a report with RS using the stored procedure and the parameters.
> Once you have a report working then try out URL integration.
> Passing a dataset is the hardest way to go to solve this. People have done
> this but it requires a lot of jumping through hoops.
> Bruce L-C
> "JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
> news:e6eWkzObEHA.2340@.TK2MSFTNGP10.phx.gbl...
> > Is there a "native" way to pass a sorted table or dataset to a SSRS?
> >
> > Or, is there another way to do the following...
> >
> > I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
> > params.
> >
> > These will use a sProc that executes some dynamic SQL to accomodate the
> > variations in params passed.
> >
> > This is all good and working as a prototype in .Net.
> >
> > However, most of the results sent to the browser also need to be sorted
> and then
> > hard copy printed, so...
> >
> > Option One; Have the ASP.Net app do all .Net datalists and the like
> presenting
> > all the data as needed. Then when a user wishes to print that data they
> click
> > the printable version link, which would pass the current dataset as sorted
> to
> > SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
> > alone.)
> >
> > Option Two; Write my sorted data to a dynamic (rather than temp table) and
> then
> > call SSRS with params to get all the data as is from the dynamic table.
> >
> > Option Three; give up, go home, take a nap, be a quiter, start crying like
> a
> > little boy, melt into a puddle of goo.
> >
> > TIA
> >
> > JeffP....
> >
> >
>

Asp.net DataSet Object

I've been using the asp.net's DataSet and it seems to be leaving connections open, I'm not entirly sure if its due to the DataSet or some random code I forgot to close its connection, but I just wanted to cover all of my Basis. Is it possible though, that this DataSet object is leaving connections open?

Thanks for reading!

-Teenprogrammer

Hey,

A dataset works in disconnected mode; it wouldn't be the dataset that might be the problem, but the object querying it, like the command/dataadapter. Could you post any code? That would be helpful. As far as the ADO.NET base objects, I have not heard of that being a problem by someone else.