dynamic connection string

hi all,

i've been reading through the forum on this subject but couldn't find the solution. i'm using RS2005.

it's mentioned that dynamic connection string is not applicable for shared data source. is there a workaround for this?

thanks!

Dynamic connection strings cannot be used with shared data sources.

Other suggestions can be found in this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16395&SiteID=1

-- Robert

|||

Thanks Robert for your reply.

however, do methods for RS2000 apply for RS2005? i've never used RS2000 before and i'm not sure where to start either.

Thanks!

|||

Yes, everything mentioned for RS 2000 works for RS 2005 the same way.
RS 2005 offers expression-based connection strings in addition.

-- Robert

|||

I wrote an application using VS2005 that has a generic report viewer and rdlc files stored in a database with the stored procedures necessary to run each report.

Then I took the report, replaced the dataset stored in the rdlc file programmatically with the generic dataset which accepts the result of the stored procedure and use it to populate the report.

It wasn't that straight forward, but now it works dynamically and I have an application now which I can add a new record to my database storing my rdlc files and stored procedure names and the list of reports that drop down in my application is completely dynamic, including parameters required appearing in a datagrid with controls for calendars and drop-down lists.

Just an idea of how you might get that dynamic dataset.

dynamic columns: in search of the Tatrix data region

This subject has been much discussed but I haven't found a solution
that really works in my situation.
What we need here is a hybrid table/matrix data region with static
columns on the left and (at least) one dynamic column on the right.
Thus do I reveal my cultural bias and no doubt my ignorance of
Reporting Services as well. Maybe this can be done, but I haven't
figured it out.
Wishlist for this "Tatrix" data region:
1) No corner cell
2) A header row that runs straight across the top like a table
3) Header row repeats on each new page
4) Ability to define n static columns at left or right of region
5) Ability to define at least one dynamic column at right or left of
data region, respectively.
In my case I have an inventory with the usual ItemID, ItemName,
ItemCategory fields in the Dataset. These and other fields are
enterprise-level, common across all business units. An ItemRetailPrice
field is potentially unique to each business unit. Therefore I'd like
to have a Tatrix that would display the enterprise-level fields as
static columns and the business-unit-level field(s) as dynamic columns.
Ideally you could have repeating groups of dynamic columns
growing/shrinking out to the side.
The only kludge so far that looks something like what the customer
wants is a Matrix with an Image in the corner cell, simulating the
headers for the static columns. It's hard to get the Image right since
the dimensions of the corner cell change from format to format. The
corner cell graphic seems to shrink on export to Excel. There's no way
to dynamically change the embedded Image to display the product group
you're looking at in a given report.
Apologies if this has been done and described and I didn't find it,
Highly ObscureHi,
I'm sorry that I could not find a way to do this with Matrix in Reporting
Services. You are welcome to send suggestions for product enhancements that
you would like to see in future versions of Microsoft products to us by
submitting MS Wish to mswish@.microsoft.com. By submitting your concerns,
you can get your voice into the design plans for upcoming versions.
Microsoft takes customer requests and suggestions very seriously. MSWISH is
your voice to the development team. A significant number of the design
change requests come from our customers through the MSWISH alias and the
MSWISH web site. http://www.microsoft.com/mswish. I encourage you to submit
this request.
Sincerely,
William Wang
Microsoft Online Partner 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.
--
>NNTP-Posting-Date: Thu, 10 Mar 2005 08:20:34 -0600
>From: "HighlyObscure" <HighlyObscure@.nospam.nospam>
>Subject: dynamic columns: in search of the Tatrix data region
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>User-Agent: XanaNews/1.17.1.2
>MIME-Version: 1.0
>Content-Type: text/plain; charset=iso-8859-1
>Message-ID: <-oGdnd2P_48vyq3fRVn-hw@.giganews.com>
>Date: Thu, 10 Mar 2005 08:20:34 -0600
>Lines: 42
>X-Trace:
sv3-AdcAxaYs02709d1QLmyISb8L5LZ1SscpiD0Uxn9maeA2kWFvFAuwfshGnq4q+8NXAFKwvaVH
CDw2zH1!3UOd+sBB1baL2C/VrYQhkqjo1KZExYUfZWDixZF1cqFUrf7vda8YFYzxJeLF9A==>X-Complaints-To: abuse@.giganews.com
>X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
>X-Postfilter: 1.3.32
>Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP0
8.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.c
om!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews