Resource In SQL Reporting Services

Can someone help me

is SQL reporting services supports the Resource .

HI, Nezo:

Would you please elaborate more about your requirement? Do you want to use some resource files?

|||

Hi Nizar,

I think what you want is to use some Name/Value pairs, in which value can be accessed using name. I dont think there is anything like Resource files as we have in visual studio.

The only way I can think of to do something like this is by using custom assemblies(http://msdn2.microsoft.com/en-us/library/ms153561.aspx) , you should be able to access properties in assemblies.

|||

thanks alot

but i need drop down List which contain Language like (English , Arabic)

when someone choose language the report change the Title and Alignment to Left if English And to Right when arabic

if that possible in SQL reporting or not

please help me

|||

I dont see any direct functionality provided in SSRS to do this, what you can do is to pass the selected language(from list) to the report and set the TextAlign property of Title using Expressions.

RESOLVED - Users Cannot Connect to SQL Server 2000 SP4 After Applying Hotfix (build 8.00.2148)

Users are reporting that they cannot connect to SQL Server using ODBC and Windows Authentication after I applied a SQL Server 2000 SP4 hotfix. The client-side error is:

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied

I installed hotfix for SQL Server 2000 SP4 (sets version to SQL Server 2000 build 8.00.2148 (SP4)); see KB894905. This hotfix was intended to resolve the following issues occurring on the server:

902955 (http://support.microsoft.com/kb/902955/) FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 Service Pack 4

895123 (http://support.microsoft.com/kb/895123/) FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000

Has anyone else experienced this, found a solution, etc.?

Thanks,

David

The server is SQL Server 2000 SP4 on Windows 2003 SP1. The client PC has MDAC 2.8 SP1 on Windows XP SP 2.

|||

double check that windows firewall isn't blocking on both client and server.

on clients run "C:\windows\System32\CliConfg.exe" and make sure that tcp/ip is a configured protocol

on Server, run "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe" and make sure that tcp/ip is configured

|||

Thanks for your reply.

Neither client or server is running Windows Firewall. Both are enabled for TCP/IP. I also ran the MDAC Component Checker on both and neither reported mismatches.

|||

sanity check. . . is the service running?

what happens when you do this from a client -

telnet servername 1433

does the screen go blank, as if waiting for or input? or does it say - "Connecting to servername" and then time out? or something different?

what happens when you do this on the server -

telnet localhost 1433

|||

Yes, the MSSQLSERVER and SQLSERVERAGENT services are both running on the server and I can connect fine using EM from my PC. In fact, I can connect using ODBC from my PC, but a user cannot connect from his PC using the same ODBC setup. An app. server running Windows 2000 SP1 also cannot connect. I've been validating the Windows and MDAC versions and making sure no firewalls are running, etc.

When I run telnet servername 1433 from my PC the window opens and reports "Connecting to servername" and then it disappears. When I run telnet localhost 1433 on the server it does the same thing.

|||

wait a second. . .

sitting at the server, from the start menu, click run . . .

you do:

telnet localhost 1433

a command window opens up and you get a message "connecting to localhost"

and then the command window closes?
If so the connection is being refused from the machine/service.

the telnet should go to a blank/black command window as the sql telnet session awaits more commands.

Is it a named instance of sql server? or default instance?

|||This is a default instance and yes, the telnet window disappears.|||

when you are sitting at the server and trying the telnet, you are logged in as a machine administator and the telent fails?

using enterprise manager, check the server from your machine and confirm that 'servername\Administrators' have server admin permissions.

double check all your logins and db users

are you running NT Authentication or Mixed mode authentication?

|||Yes, I am logged in as an administrator on the server when I run telnet. 'BUILTIN\Administrators' has been removed from the SQL Server logins, but that should not affect users trying to connect with valid registrations. The instance uses mixed-mode authentication (Windows and SQL Server).|||

well, double check your logins and users. . . . no one is denied.

|||

This issue has been resolved. It was related to permissions for the SQL Server Service Account. That account needed permissions adjustments, as described in KB283811.

The permissions changes resolved the ODBC TCP/IP connection failures, but the root cause is still a little perplexing. Connections worked fine for many months, then the failure. The MS Support Engineer that I worked with was convinced that the 2 SP4 hotfixes did not cause the issue. He thinks it may have been the result of a change in Group Policy, which I will have to do more research on.

Resetting Page Number in SQL Reporting Services

Does anyone know of a way to reset page numbering when the group changes?
Thanks,
DennyDenny:
Try this blog that I found on this same group.
http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
Sher
Denny wrote:
> Does anyone know of a way to reset page numbering when the group changes?
> Thanks,
> Denny

reset report parameters back to defaults

I am running SQL 2005 Reporting Services and designing reports via Visual
Studio.
Is there an easy way to reset/clear the report parameters back to the
defaults while viewing the report in IE.
Right now I have create a hyperlink which will re-direct to the URL of the
report which thus sets the paramaters back to their defaults, but it seems
that there must be a better way to do this.Hello,
Reporting Services did not provide the method to reset the parameters back
to the default.
Your solution is the best way I think to achieve your requirement.
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.sql

Requirements to set up on a new server?

I wanted to test drive the reporting services against Crystal.
I have a new stage server system where all servers were just promoted to
Win2003, and SQL 2000 on the data server box.
I understand that I need to put the reporting services on my IIS box. That
has .NET 2003 run time and SP applied.
When I attempt to install Reporting Services I get a lame error back about
lacking resources. This is the Reporting 2000 version. What am I missing?
TIA
__StephenWhat is the error? Please copy in the exact error message, and it's easier
to help. :) What resources are missing?
Have you installed Internet Information Services on your RS box? WIthout IIS
you won't get far with RS.
Kaisa M. Lindahl
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OddBAscHGHA.1132@.TK2MSFTNGP10.phx.gbl...
>I wanted to test drive the reporting services against Crystal.
> I have a new stage server system where all servers were just promoted to
> Win2003, and SQL 2000 on the data server box.
> I understand that I need to put the reporting services on my IIS box.
> That has .NET 2003 run time and SP applied.
> When I attempt to install Reporting Services I get a lame error back about
> lacking resources. This is the Reporting 2000 version. What am I
> missing?
> TIA
> __Stephen
>

Required free eBook on Reporting Services 2005.

Hello Friends,

I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.

Thanks,

Vishal.

Don't know of any ebooks, however I think the most thorough set of tutorials is here:

http://www.databasejournal.com/article.php/1459531

Cheers
Mark
|||The Books On Line help file is a good place to start.|||

Hello Mark,

Thanks for this link, it is very helpful to me.

Bye.

Required free eBook on Reporting Services 2005.

Hello Friends,

I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.

Thanks,

Vishal.

Don't know of any ebooks, however I think the most thorough set of tutorials is here:

http://www.databasejournal.com/article.php/1459531

Cheers
Mark
|||The Books On Line help file is a good place to start.|||

Hello Mark,

Thanks for this link, it is very helpful to me.

Bye.

Required free eBook on Reporting Services 2005.

Hello Friends,

I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.

Thanks,

Vishal.

Don't know of any ebooks, however I think the most thorough set of tutorials is here:

http://www.databasejournal.com/article.php/1459531

Cheers
Mark
|||The Books On Line help file is a good place to start.|||

Hello Mark,

Thanks for this link, it is very helpful to me.

Bye.

Request for extension

I would like to take full control of the entering of parameters, providing my
own UI for that, and would like to somehow extend the reporting framework.
Could you add an extension point for gathering of parameters? Is ther some
other way to do it?There is no way to extend or override the report server controls, but
you could make a web service call to GetReportParameters to find the
parameters for a report, thier type, thier dependencies, and thier
valid values. This would give you enough information to dynamically
build a UI to gather parameter information.
Once you have the parameter values you can pass them along in a URL to
the report server, or in the web service method Render to get the
report displayed.
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sat, 23 Oct 2004 10:09:04 -0700, "John Waters"
<JohnWaters@.discussions.microsoft.com> wrote:
>I would like to take full control of the entering of parameters, providing my
>own UI for that, and would like to somehow extend the reporting framework.
>Could you add an extension point for gathering of parameters? Is ther some
>other way to do it?

Reprting Services 2000 Printing

Hi,
I am using Reporting services 2000 in asp.net application.Everything is working fine ,but when I am trying to get a print using Internet Explorer Printing options ,the toolbar of the report is also coming into the print preview.I want to get rid of it.I want only the report no toolbar.
Can anybody help me?
Thanks!!I am not sure if IE Printing options will allow you to do that. You might need to write some code to do that. I'll see if I can cook up something for you if I get the time.

Representation for Deleted Entities: difficult question

Our customer (of our ecommerce system) wants to be able to preserve
deleted entities in the database so that they can do reporting,
auditing etc.

The system is quite complex where each end user can belong to multiple
institutional affiliations (which can purchase on behalf of the user).
The end user also has a rich trail of past transactions affiliations
etc. Thus in the schema each user entity is related to many others
which in turn relate to yet others and so on.

In the past when a user was deleted all of his complex relationships
were also deleted in a cascading fashion. But now the customer wants
us to add a "deleted" flag to each user so that a user is never
_really_ deleted but instead his "deleted" flag is set to true. The
system subsequently behaves as if the user did not exist but the
customer can still do reports on deleted users.

I pointed out that it is not as simple as that because the user entity
is related to many, many others so we would have to add this "deleted"
flag to every relationship and every other entity and thus have
"deleted" past purchases, "deleted" affiliations - a whole shadow
schema full of such ghost entities. This would overtime degrade
performance since now each query in the system has to add a clause:
"where deleted = 0".

I assume this is a standard problem since many organizations must have
this need of preserving deleted records (for legal or other reasons).
I tried to talk them into creating a simple audit file where all the
deletions will be recorded in XML but they were not too happy with
that.

Is there a more satisfying solution to this than have this "deleted"
flag?

Thanks for your help,

- robertYou didn't post database you're using.

In Oracle you could partition the main table (from where all
'cascaded' is coming from) into deleted/undeleted records. Put a view
on top of the table just as original table would look like with where
clause 'undeleted' and the undeleted partition would always be used.
Only certain versions of oracle allow rows to migrate from partition
to partition, u can look it up.

However, you would still suffer from 'performance' issues on the other
tables, if your data is truly huge.

Best solution would probably be to separate all deleted/undeleted data
into separate tables, and built a union view on top of them for
reporting purposes.

my2c
Someone might have a better idea.

On 13 May 2004 11:32:21 -0700, robertbrown1971@.yahoo.com (Robert
Brown) wrote:

>Our customer (of our ecommerce system) wants to be able to preserve
>deleted entities in the database so that they can do reporting,
>auditing etc.
>The system is quite complex where each end user can belong to multiple
>institutional affiliations (which can purchase on behalf of the user).
>The end user also has a rich trail of past transactions affiliations
>etc. Thus in the schema each user entity is related to many others
>which in turn relate to yet others and so on.
>In the past when a user was deleted all of his complex relationships
>were also deleted in a cascading fashion. But now the customer wants
>us to add a "deleted" flag to each user so that a user is never
>_really_ deleted but instead his "deleted" flag is set to true. The
>system subsequently behaves as if the user did not exist but the
>customer can still do reports on deleted users.
>I pointed out that it is not as simple as that because the user entity
>is related to many, many others so we would have to add this "deleted"
>flag to every relationship and every other entity and thus have
>"deleted" past purchases, "deleted" affiliations - a whole shadow
>schema full of such ghost entities. This would overtime degrade
>performance since now each query in the system has to add a clause:
>"where deleted = 0".
>I assume this is a standard problem since many organizations must have
>this need of preserving deleted records (for legal or other reasons).
>I tried to talk them into creating a simple audit file where all the
>deletions will be recorded in XML but they were not too happy with
>that.
>Is there a more satisfying solution to this than have this "deleted"
>flag?
>Thanks for your help,
>- robert

......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email|||"Robert Brown" <robertbrown1971@.yahoo.com> wrote in message
news:240a4d09.0405131032.6c2e9802@.posting.google.c om...
> I pointed out that it is not as simple as that because the user entity
> is related to many, many others so we would have to add this "deleted"
> flag to every relationship and every other entity and thus have
> "deleted" past purchases, "deleted" affiliations - a whole shadow
> schema full of such ghost entities. This would overtime degrade
> performance since now each query in the system has to add a clause:
> "where deleted = 0".

Blanket statements like this are rarely true.

> I assume this is a standard problem since many organizations must have
> this need of preserving deleted records (for legal or other reasons).
> I tried to talk them into creating a simple audit file where all the
> deletions will be recorded in XML but they were not too happy with
> that.

So you think file is better than DBMS?

> Is there a more satisfying solution to this than have this "deleted"
> flag?

Can I suggest that there is a modelling problem? I can imagine customer
having multiple timestamp columns, for example

table customer (
...
DOB DATE,
married DATE,
divorced DATE,
died DATE
)

but can't possibly see why you need "is_alive", "is_married" boolean
columns.|||andreyNSPAM@.bookexchange.net (NetComrade) wrote in message news:<40a3cbf2.428366208@.localhost>...

> You didn't post database you're using.

Thanks for your answer. This particular customer is using Oracle but
our software is supported on SQL server as well.

> In Oracle you could partition the main table (from where all
> 'cascaded' is coming from) into deleted/undeleted records. Put a view
> on top of the table just as original table would look like with where
> clause 'undeleted' and the undeleted partition would always be used.
> Only certain versions of oracle allow rows to migrate from partition
> to partition, u can look it up.
> However, you would still suffer from 'performance' issues on the other
> tables, if your data is truly huge.
> Best solution would probably be to separate all deleted/undeleted data
> into separate tables, and built a union view on top of them for
> reporting purposes.
> my2c
> Someone might have a better idea.
>
> On 13 May 2004 11:32:21 -0700, robertbrown1971@.yahoo.com (Robert
> Brown) wrote:
> >Our customer (of our ecommerce system) wants to be able to preserve
> >deleted entities in the database so that they can do reporting,
> >auditing etc.
> >The system is quite complex where each end user can belong to multiple
> >institutional affiliations (which can purchase on behalf of the user).
> >The end user also has a rich trail of past transactions affiliations
> >etc. Thus in the schema each user entity is related to many others
> >which in turn relate to yet others and so on.
> >In the past when a user was deleted all of his complex relationships
> >were also deleted in a cascading fashion. But now the customer wants
> >us to add a "deleted" flag to each user so that a user is never
> >_really_ deleted but instead his "deleted" flag is set to true. The
> >system subsequently behaves as if the user did not exist but the
> >customer can still do reports on deleted users.
> >I pointed out that it is not as simple as that because the user entity
> >is related to many, many others so we would have to add this "deleted"
> >flag to every relationship and every other entity and thus have
> >"deleted" past purchases, "deleted" affiliations - a whole shadow
> >schema full of such ghost entities. This would overtime degrade
> >performance since now each query in the system has to add a clause:
> >"where deleted = 0".
> >I assume this is a standard problem since many organizations must have
> >this need of preserving deleted records (for legal or other reasons).
> >I tried to talk them into creating a simple audit file where all the
> >deletions will be recorded in XML but they were not too happy with
> >that.
> >Is there a more satisfying solution to this than have this "deleted"
> >flag?
> >Thanks for your help,
> >- robert
> ......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email|||Note that SQL Server 2000 EE does support partitioned views.

On 14 May 2004 09:14:47 -0700, robertbrown1971@.yahoo.com (Robert Brown) wrote:

>andreyNSPAM@.bookexchange.net (NetComrade) wrote in message news:<40a3cbf2.428366208@.localhost>...
>> You didn't post database you're using.
>Thanks for your answer. This particular customer is using Oracle but
>our software is supported on SQL server as well.
>
>> In Oracle you could partition the main table (from where all
>> 'cascaded' is coming from) into deleted/undeleted records. Put a view
>> on top of the table just as original table would look like with where
>> clause 'undeleted' and the undeleted partition would always be used.
>> Only certain versions of oracle allow rows to migrate from partition
>> to partition, u can look it up.
>>
>> However, you would still suffer from 'performance' issues on the other
>> tables, if your data is truly huge.
>>
>> Best solution would probably be to separate all deleted/undeleted data
>> into separate tables, and built a union view on top of them for
>> reporting purposes.
>>
>> my2c
>> Someone might have a better idea.
>>
>>
>>
>> On 13 May 2004 11:32:21 -0700, robertbrown1971@.yahoo.com (Robert
>> Brown) wrote:
>>
>> >Our customer (of our ecommerce system) wants to be able to preserve
>> >deleted entities in the database so that they can do reporting,
>> >auditing etc.
>>> >The system is quite complex where each end user can belong to multiple
>> >institutional affiliations (which can purchase on behalf of the user).
>> >The end user also has a rich trail of past transactions affiliations
>> >etc. Thus in the schema each user entity is related to many others
>> >which in turn relate to yet others and so on.
>>> >In the past when a user was deleted all of his complex relationships
>> >were also deleted in a cascading fashion. But now the customer wants
>> >us to add a "deleted" flag to each user so that a user is never
>> >_really_ deleted but instead his "deleted" flag is set to true. The
>> >system subsequently behaves as if the user did not exist but the
>> >customer can still do reports on deleted users.
>>> >I pointed out that it is not as simple as that because the user entity
>> >is related to many, many others so we would have to add this "deleted"
>> >flag to every relationship and every other entity and thus have
>> >"deleted" past purchases, "deleted" affiliations - a whole shadow
>> >schema full of such ghost entities. This would overtime degrade
>> >performance since now each query in the system has to add a clause:
>> >"where deleted = 0".
>>> >I assume this is a standard problem since many organizations must have
>> >this need of preserving deleted records (for legal or other reasons).
>> >I tried to talk them into creating a simple audit file where all the
>> >deletions will be recorded in XML but they were not too happy with
>> >that.
>>> >Is there a more satisfying solution to this than have this "deleted"
>> >flag?
>>> >Thanks for your help,
>>> >- robert
>>
>> ......
>> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>> remove NSPAM to email|||This solution is not specific to Oracle. Most DBMS support partitions and
views.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike@.nospam!datamodel.org
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

"NetComrade" <andreyNSPAM@.bookexchange.net> wrote in message
news:40a3cbf2.428366208@.localhost...
> You didn't post database you're using.
> In Oracle you could partition the main table (from where all
> 'cascaded' is coming from) into deleted/undeleted records. Put a view
> on top of the table just as original table would look like with where
> clause 'undeleted' and the undeleted partition would always be used.
> Only certain versions of oracle allow rows to migrate from partition
> to partition, u can look it up.
> However, you would still suffer from 'performance' issues on the other
> tables, if your data is truly huge.
> Best solution would probably be to separate all deleted/undeleted data
> into separate tables, and built a union view on top of them for
> reporting purposes.
> my2c
> Someone might have a better idea.
>
> On 13 May 2004 11:32:21 -0700, robertbrown1971@.yahoo.com (Robert
> Brown) wrote:
> >Our customer (of our ecommerce system) wants to be able to preserve
> >deleted entities in the database so that they can do reporting,
> >auditing etc.
> >The system is quite complex where each end user can belong to multiple
> >institutional affiliations (which can purchase on behalf of the user).
> >The end user also has a rich trail of past transactions affiliations
> >etc. Thus in the schema each user entity is related to many others
> >which in turn relate to yet others and so on.
> >In the past when a user was deleted all of his complex relationships
> >were also deleted in a cascading fashion. But now the customer wants
> >us to add a "deleted" flag to each user so that a user is never
> >_really_ deleted but instead his "deleted" flag is set to true. The
> >system subsequently behaves as if the user did not exist but the
> >customer can still do reports on deleted users.
> >I pointed out that it is not as simple as that because the user entity
> >is related to many, many others so we would have to add this "deleted"
> >flag to every relationship and every other entity and thus have
> >"deleted" past purchases, "deleted" affiliations - a whole shadow
> >schema full of such ghost entities. This would overtime degrade
> >performance since now each query in the system has to add a clause:
> >"where deleted = 0".
> >I assume this is a standard problem since many organizations must have
> >this need of preserving deleted records (for legal or other reasons).
> >I tried to talk them into creating a simple audit file where all the
> >deletions will be recorded in XML but they were not too happy with
> >that.
> >Is there a more satisfying solution to this than have this "deleted"
> >flag?
> >Thanks for your help,
> >- robert
> ......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email|||As Leandro and Mikito point out, you have flaws in your design.
First, deleting the user entity is the only thing that is logically deleted,
but rather than make it an indicator, use a date, as in DELETE_DATE as
nullable. Non-null entities are to be ignored.
In addition, all relationships to the user entity should be evaluated to
determine if they need to be sensitive to the user entity's status. Some
may, and others may not. This is a business question, not a technical
question. For instance, if there are invoices and inventory tables linked
in some way to the user entity, would you really want to *not* display that
information just because an associated user entity had been deleted?

I'd really need to see your design and talk to your business to know exactly
what impact this design change would have on your database.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike@.nospam!datamodel.org
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

"Robert Brown" <robertbrown1971@.yahoo.com> wrote in message
news:240a4d09.0405131032.6c2e9802@.posting.google.c om...
> Our customer (of our ecommerce system) wants to be able to preserve
> deleted entities in the database so that they can do reporting,
> auditing etc.
> The system is quite complex where each end user can belong to multiple
> institutional affiliations (which can purchase on behalf of the user).
> The end user also has a rich trail of past transactions affiliations
> etc. Thus in the schema each user entity is related to many others
> which in turn relate to yet others and so on.
> In the past when a user was deleted all of his complex relationships
> were also deleted in a cascading fashion. But now the customer wants
> us to add a "deleted" flag to each user so that a user is never
> _really_ deleted but instead his "deleted" flag is set to true. The
> system subsequently behaves as if the user did not exist but the
> customer can still do reports on deleted users.
> I pointed out that it is not as simple as that because the user entity
> is related to many, many others so we would have to add this "deleted"
> flag to every relationship and every other entity and thus have
> "deleted" past purchases, "deleted" affiliations - a whole shadow
> schema full of such ghost entities. This would overtime degrade
> performance since now each query in the system has to add a clause:
> "where deleted = 0".
> I assume this is a standard problem since many organizations must have
> this need of preserving deleted records (for legal or other reasons).
> I tried to talk them into creating a simple audit file where all the
> deletions will be recorded in XML but they were not too happy with
> that.
> Is there a more satisfying solution to this than have this "deleted"
> flag?
> Thanks for your help,
> - robert|||robertbrown1971@.yahoo.com (Robert Brown) wrote:
> Our customer (of our ecommerce system) wants to be able to preserve
> deleted entities in the database so that they can do reporting,
> auditing etc.
> The system is quite complex where each end user can belong to multiple
> institutional affiliations (which can purchase on behalf of the user).
> The end user also has a rich trail of past transactions affiliations
> etc. Thus in the schema each user entity is related to many others
> which in turn relate to yet others and so on.
> In the past when a user was deleted all of his complex relationships
> were also deleted in a cascading fashion.

Users are not deleted. They may die, they may be incarcerated, they may
be fired, but they cannot be deleted. Only data is deleted.

> But now the customer wants
> us to add a "deleted" flag to each user so that a user is never
> _really_ deleted but instead his "deleted" flag is set to true. The
> system subsequently behaves as if the user did not exist but the
> customer can still do reports on deleted users.
> I pointed out that it is not as simple as that because the user entity
> is related to many, many others so we would have to add this "deleted"
> flag to every relationship and every other entity and thus have
> "deleted" past purchases,

If I am hit by a bus tomorrow, will the office furniture I ordered (but
which is owned by the company) disappear? Will the patents I've generated
for the company no longer be valid?

> "deleted" affiliations - a whole shadow
> schema full of such ghost entities.

Why would each of these need it's own deleted flag? If they are being
joined against the user table, then they can just rely on the user table to
provide the necessary logic. If they are not being joined against the user
table, then why would you want them to be excluded based on a condition of
a user?

> This would overtime degrade
> performance since now each query in the system has to add a clause:
> "where deleted = 0".

Do they want the reporting to go back indefinately, or would they like
the data to be "really" deleted after a certain time of "virtual" deletion?

> I assume this is a standard problem since many organizations must have
> this need of preserving deleted records (for legal or other reasons).

It is a standard problem, but there is not a standard solution.

Xho

--
------- http://NewsReader.Com/ -------
Usenet Newsgroup Service $9.95/Month 30GB|||>It is a standard problem, but there is not a standard solution.
>Xho

Put a bit column in there and flag it if this record is "deleted".
Or write a trigger and dump the deleted records into an archive
table.

Randy
http://members.aol.com/rsmeiner|||Robert Brown (robertbrown1971@.yahoo.com) writes:
> Our customer (of our ecommerce system) wants to be able to preserve
> deleted entities in the database so that they can do reporting,
> auditing etc.
> The system is quite complex where each end user can belong to multiple
> institutional affiliations (which can purchase on behalf of the user).
> The end user also has a rich trail of past transactions affiliations
> etc. Thus in the schema each user entity is related to many others
> which in turn relate to yet others and so on.
> In the past when a user was deleted all of his complex relationships
> were also deleted in a cascading fashion. But now the customer wants
> us to add a "deleted" flag to each user so that a user is never
> _really_ deleted but instead his "deleted" flag is set to true. The
> system subsequently behaves as if the user did not exist but the
> customer can still do reports on deleted users.
> I pointed out that it is not as simple as that because the user entity
> is related to many, many others so we would have to add this "deleted"
> flag to every relationship and every other entity and thus have
> "deleted" past purchases, "deleted" affiliations - a whole shadow
> schema full of such ghost entities. This would overtime degrade
> performance since now each query in the system has to add a clause:
> "where deleted = 0".

Indeed, this is quite a big change if this was not in the system from
the beginning.

In our system, many items are not deletable, because even if an item
goes away, there might still be plenty of references to it. So in these
tables - accounts, customers, instruments, currencies, to name a few - there
is a deregdate column. This column serves the double purpose of telling
us if the item is still active, and if it is not, when the entity was
deregistered. And, yes it happens that deregistered entities are revived
too!

A non-trivial issue here is to know when a deregistered item should be
included and when it should not. If you are producing a list of last
month's tranactions, it obviously should. But if you are populating a
list of available products to order, deregistered products should not be
included. So when you introduce this concept in your system, you have
a lot to write in your functional specification too.

Another issue which becomes complicated, is referential integrity.
accounts.accresponsible may refer to the users table, but if the account
is active, the user must be too. Currently we do this in triggers, which
is a bit complex, and more difficult than foreign-key constraints. One
thought I've been playing with is to have tables like active_accounts,
active_users etc. This would not be the partition suggested by others,
since active_accounts would only hold the account number, and foreign
keys to other deregisterable items. Thus, active_accounts.accresponsible
would refer to active_users.userid. The full data would still be in
acconts and users, for both active and deregistered items.

I have never considered the performance cost for "AND deregdate IS NULL",
but I would suggest that if you need to access that column, you probably
already access some column which is not in any index, so there is
already a bookmark lookup, so I would not expect any particular penalty.
(This applies to MS SQL Server. Not that I really expect Oracle to be
different, but I don't know Oracle.)

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

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

Repostition Parameters

I would like to know if it's possible and, if it is, how to reposition
parameters when viewing reports accessed through URL reporting and using the
Report Viewer. For example, we have 5 parameters on a report. One is a drop
down dynamic list of customer names, two are dates (start and end) and 2 are
radio buttons. We would like the list of customer names to be first with
nothing to the right of it. Then the two date parameters on the next line.
And lastly, the 2 radio button parameters displayed on the last line. I
cannot find a way to do this within SSRS or by using CSS. I fear it may be
totally controlled by SSRS with no chance for reformating or customization.
Thank you
--
Jeff Loebick
SQL Developer
ProformaOn Mar 14, 12:52 pm, Jeff Loebick
<JeffLoeb...@.discussions.microsoft.com> wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma
As far as I know, you are correct. That said, you can change ordering
of the parameters (i.e., which one is 1st, 2nd, and so on). That would
be done from the Report tab (at the top) -> Report Parameters dialog w/
the up and down arrows. Sorry that I could not be of further
assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||If time permits, you can write your custom screen for all your entry needs
and integrate with reports using web services. Having said that, its not so
easy to write on the fly, but pretty simple if you have some time to write, I
have been using this web services for long and believe me its good. To start
with you can go through some samples available in BOl and pickup the same pgm
and change according to your needs, that will make your development faster.
Amarnath, MCTS
"Jeff Loebick" wrote:
> I would like to know if it's possible and, if it is, how to reposition
> parameters when viewing reports accessed through URL reporting and using the
> Report Viewer. For example, we have 5 parameters on a report. One is a drop
> down dynamic list of customer names, two are dates (start and end) and 2 are
> radio buttons. We would like the list of customer names to be first with
> nothing to the right of it. Then the two date parameters on the next line.
> And lastly, the 2 radio button parameters displayed on the last line. I
> cannot find a way to do this within SSRS or by using CSS. I fear it may be
> totally controlled by SSRS with no chance for reformating or customization.
> Thank you
> --
> Jeff Loebick
> SQL Developer
> Proforma

ReportWriter - Soft Artisans

Anyone have any comments on using SoftArtisans ReportWriter that allows
Word/Excel users to write reports and publish to Reporting Services?
Is it very expensive?
is it worth it?"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
Ha! Funny, see a few subject headings down from this post regarding "Excel
reports to RS."
> Is it very expensive?
>
Yes.
> is it worth it?
>
Not really sure yet. I'm asking the same question, although in finer
granularity.
All the best!
Greg--|||"dm1608" wrote:
> Anyone have any comments on using SoftArtisans ReportWriter that allows
> Word/Excel users to write reports and publish to Reporting Services?
> Is it very expensive?
yes, it is expensive.. 7.500 Euro per cpu
> is it worth it?
no, you must redesign all your reports using ms word with the softartisans
addin, if you want to export the reports to word...
And by the Way, i mean the Support by softartisans ist very bad|||So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
on SQL 2005 says rendering formats for output are the same: Excel, PDF,
DHTML, images... but still no support for Word.
Does this mean Microsoft itself is shying away from its own product, Word,
by not offering native support within SQL RS? Is there a new industry
standard in word processing that I need to be looking at?
I find it truly mind-boggling for Microsoft to not export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
Any other products out there?
Thanks,
Andrew Puente
"cwalloch" wrote:
>
> "dm1608" wrote:
> > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > Word/Excel users to write reports and publish to Reporting Services?
> >
> > Is it very expensive?
> yes, it is expensive.. 7.500 Euro per cpu
> >
> > is it worth it?
> no, you must redesign all your reports using ms word with the softartisans
> addin, if you want to export the reports to word...
> And by the Way, i mean the Support by softartisans ist very bad|||And before I get crucified, let me revise my last paragraph:
I find it truly mind-boggling for Microsoft to export to Excel, XML,
even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
only tool available... ?
It's called Proofreading 101. I failed that course, apparently. :-)
Cheers,
Andrew Puente
"Andrew Puente" wrote:
> So we have SQL Reporting Services in SQL 2000 and 2005. The feature matrix
> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
> DHTML, images... but still no support for Word.
> Does this mean Microsoft itself is shying away from its own product, Word,
> by not offering native support within SQL RS? Is there a new industry
> standard in word processing that I need to be looking at?
> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be the
> only tool available... ?
> Any other products out there?
> Thanks,
> Andrew Puente
> "cwalloch" wrote:
> >
> >
> > "dm1608" wrote:
> >
> > > Anyone have any comments on using SoftArtisans ReportWriter that allows
> > > Word/Excel users to write reports and publish to Reporting Services?
> > >
> > > Is it very expensive?
> > yes, it is expensive.. 7.500 Euro per cpu
> >
> > >
> > > is it worth it?
> > no, you must redesign all your reports using ms word with the softartisans
> > addin, if you want to export the reports to word...
> > And by the Way, i mean the Support by softartisans ist very bad|||I suspect that XPS format and office 12 xml formats will be supported when
released.
--
William Stacey [MVP]
"Andrew Puente" <AndrewPuente@.discussions.microsoft.com> wrote in message
news:1B3A18C9-17C9-4135-B367-5E05253C067A@.microsoft.com...
> And before I get crucified, let me revise my last paragraph:
> I find it truly mind-boggling for Microsoft to export to Excel, XML,
> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
> the
> only tool available... ?
> It's called Proofreading 101. I failed that course, apparently. :-)
> Cheers,
> Andrew Puente
>
> "Andrew Puente" wrote:
>> So we have SQL Reporting Services in SQL 2000 and 2005. The feature
>> matrix
>> on SQL 2005 says rendering formats for output are the same: Excel, PDF,
>> DHTML, images... but still no support for Word.
>> Does this mean Microsoft itself is shying away from its own product,
>> Word,
>> by not offering native support within SQL RS? Is there a new industry
>> standard in word processing that I need to be looking at?
>> I find it truly mind-boggling for Microsoft to not export to Excel, XML,
>> even Adobe's PDF (hello MDI?) - but not Word. And for OfficeWriter to be
>> the
>> only tool available... ?
>> Any other products out there?
>> Thanks,
>> Andrew Puente
>> "cwalloch" wrote:
>> >
>> >
>> > "dm1608" wrote:
>> >
>> > > Anyone have any comments on using SoftArtisans ReportWriter that
>> > > allows
>> > > Word/Excel users to write reports and publish to Reporting Services?
>> > >
>> > > Is it very expensive?
>> > yes, it is expensive.. 7.500 Euro per cpu
>> >
>> > >
>> > > is it worth it?
>> > no, you must redesign all your reports using ms word with the
>> > softartisans
>> > addin, if you want to export the reports to word...
>> > And by the Way, i mean the Support by softartisans ist very bad

reportviewer: code the windows credentials

I have bought a hosting service for reporting services. The server definitions are set to windows authentication.

I'm using a small application and each time I access a report, a windows prompt asks for the username and password. I would like to avoid this message.

How should I pass the credentials through this application and the reportviewer control (which I use) to the server in order to avoid having to insert the user details in the prompt. This application is to be used by several users and they shouldn't need to insert the account's information.

thank you for a quick reply.

There is no way to add credentials to the report viewer.

Does your local login map to a login on the server at all? If so, Internet Explorer only sends credentials automatically to servers in the Intranet zone, but you can have it automatically send credentials to your host.

You could mark your host as a trusted site (Tools -> Internet Options -> Security), and then tell IE to send credentials automatically to sites in the trusted zone. With Trusted Zones highlighted in the tab, click "Custom Level". Scroll down to the bottom and select "automatic login with current username and password".

|||This can be done. First create a class called ReportServerCredentials that implements the IReportServerCredentials interface. You will need to import System.Net and Microsoft.Reporting.WebForms to this class. Overload the New and GetFormsCredentials methods and the NetworkCredentials and ImpersonationUser properties. Here's a class that I use:

Imports Microsoft.VisualBasic
Imports Microsoft.Reporting.WebForms
Imports System.Net

Public Class ReportServerCredentials
Implements IReportServerCredentials

Private _userName As String
Private _password As String
Private _domain As String

Public Sub New(ByVal userName As String, ByVal password As String, ByVal domain As String)
_userName = userName
_password = password
_domain = domain
End Sub

Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser
Get
Return Nothing
End Get
End Property

Public ReadOnly Property NetworkCredentials() As ICredentials Implements Microsoft.Reporting.WebForms.IReportServerCredentials.NetworkCredentials
Get
Return New NetworkCredential(_userName, _password, _domain)
End Get
End Property

Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials
userName = _userName
password = _password
authority = _domain
Return Nothing
End Function
End Class

Next, in the OnLoad of your page with the ReportViewer control, create a new instance of your ReportServerCredentials (I use values stored in AppSettings). Then assign your object to the ReportViewer control's ServerReport.ReportServerCredentials property.

Dim cred As New ReportServerCredentials(ConfigurationManager.AppSettings("MyStoredUser"),_
ConfigurationManager.AppSettings("MyStoredPassword"), _
ConfigurationManager.AppSettings("MyStoredDomain"))

MyReportViewerControl.ServerReport.ReportServerCredentials = cred

A few things can break though-- referenced images on your reports won't render, and you can't use integrated security in your SSRS data sources, unless the account you are impersonating has access to the data as well as SSRS.
|||

Code Salad,

My immeasurable thanks. After three days of searching, your solution was the one that finally got my reports running

|||

It seems CodeSalad's code worked. Can someone explain how it works? Where do I add the code? I am having the same problem. I am using Framework 2.0. Thanks.

DanYeung

|||

I think these links will be helpful -

http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx

http://msdn2.microsoft.com/en-us/library/aa983458(VS.80).aspx

|||

Danyeng,

U have to add a new class file in the app_Code directory

|||

The links and the sample code are very helpful. I still need more help on this. How do I get the ReportViewer control? I am opening the report without using ReportView control. I added the attribute to the button to open the report with Javascript. If I use the ReportViewer control, do I have to open the report differently and how? Thanks.

DanYeung

|||

this is how u doing it.

create a new aspx page and add the report viewer control to ur page by going View Menu -> Toolbox and in the toolbox look under Data.. and then in the properties window, Select the processingmode i.e Remote or local and also specify the report path...

and then in the aspx.vb page in Page_Load sub give this code.

ReportViewer1.ProcessingMode = ProcessingMode.Remote ReportViewer1.ShowCredentialPrompts =True'ReportViewer1.ShowExportControls = False ReportViewer1.ServerReport.ReportServerCredentials =New ReportServerCredentials() ReportViewer1.ServerReport.ReportServerUrl =New Uri("http://IPAddress/ReportServer") ReportViewer1.ServerReport.ReportPath ="/FolderName/Mainrdlfilename" ReportViewer1.ServerReport.Refresh()

ReportViewer1.ServerReport.ReportServerCredentials =New ReportServerCredentials() -- ReportServerCredentials is the base class name of the class that u put in the app_code folder

Hope this helps.

Regards,

Karen

|||

Thanks Karen. I am getting closer. I received the following error:

The path of the item '/Pages/ReportViewer.aspx?nsPortalReports.rptIssuesByRole&rs:Command=Render&intProjectID=119&RunBy=DanYeung' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

The report is located in the different project with the same solution. nsPortalReports is the project name and rptIssuesByRole is the report name. What is wrong in the path? Thanks.

DanYeung

|||

is ur report stored in the report server? and if ur reports are stored in the report server is there any kinda directory structure in it...

if u answer this questions may be i can give u a better answer.

Regards

Karen

|||

Yes, I deployed the reports to the report server. Thanks.

DanYeung

|||

are u able to run the reports using the report viewer...

Since ur reports are in the report server just give the path as i have given and it should work... if u need to pass any parameters to the report also let me know i will help u out..

Regards

Karen

|||

How do I run the report using ReportViewer? Yes, I have to pass parameters. So I am not supposed pass parameters in the ReportPath? Is my path correct?

ReportViewer1.ServerReport.ReportPath = "/Pages/ReportViewer.aspx?nsPortalReports.rptIssuesByRole&rs:Command=Render&intProjectID=" & cboProject.SelectedValue & "&RunBy=" & Session("strEmployeeName")

Thanks.

DanYeung

|||

your report Path doesnt Look right to me.

Instead of specifying the report Path... Specify a the ReportServerURL so that u can access ur report server directly. and the url will behttp://IpAddress/ReportServer.

take a look at this code as to how to specify the parameters and the report Path

ReportViewer1.ProcessingMode = ProcessingMode.Remote ReportViewer1.ShowCredentialPrompts =True ReportViewer1.ShowExportControls =False ReportViewer1.ServerReport.ReportServerCredentials =New ReportServerCredentials() ReportViewer1.ServerReport.ReportServerUrl =New Uri("http://IPAddress/ReportServer") s =CType(PreviousPage.FindControl("ddlReportType"), DropDownList).SelectedItem.ValueIf (s ="/Statements/StatementMain")Then ReportViewer1.ServerReport.ReportPath ="/Statements/StatementMain"Dim ClientIDAs String = Session("ClientId")Dim param(0)As Microsoft.Reporting.WebForms.ReportParameter'param(0) = New Microsoft.Reporting.WebForms.ReportParameter("PeriodId", "") param(0) =New Microsoft.Reporting.WebForms.ReportParameter("ClientId", ClientID,False) ReportViewer1.ServerReport.SetParameters(param)ReportViewer1.ServerReport.Refresh()End If

u can omit the parameters so that u can directly set them while u run the reports.Hope this helps.

Regards,

Karen

ReportViewer with Authentication

I'm new to Reporting Services but have built some reports and have implemented them. I have used the report viewer which works great and has a great tool bar that users really like. One problem, I can't figure out how to pass network credentials using the viewer.

If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar.

I want the best of both worlds without having th build my own toolbar. This must have been done before but I can't seem to find any samples.

So is there a way to pass credentials (Basic Authentication over SSL) while still using the nivce features from the ReportViewer.

Or

Is there a different ReportViewer that has this capability.

Any help will be greatly appreciated.

ThanksDoes anyone have any info on this? Does a ReportViewer control with the ability to pass credentials exist or do I need to create my own?

Thanks,
|||the short answer is "yes".

the devil is in the details...
are you using rs 2000 or 2005 ?
if 2005 I am also trying to get the details down.

I did some work with rs 2000 and see that a lot is the same but the winforms control is new and I hear they "made things better" but so far found few samples of how to get from "A" to "B".
I do know that there are two calls that deal with auth, one to pass data-source credentials and one to pass in "access" credentials.

the access bits seem to have several options.

when I was doing some hacking throuhg they did not seem to work.

I think that was due to messing with the report server and hosing it's settings.

right now I am building a test-lab with a local server and a Virtual PC to run my client app.

I hope I can get a sample working and share....

|||I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

|||

mcatet wrote:

I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

Ok, a few things:

1) you want to use *WINDOWS* credentails
2) look at the docs and as I recall you will see that you needs to create an object and then attach it to your calls.... System.Net.NetworkCredentails
you can create one with user,pass,domain and then pass that to the web services at key points.

I am working 2005 now so I'm not readig the 2000 docs right now but I think that the above will start you in the right direction....|||Ok. So with windows credentials setup on the ReportServer web folder, I just need a windows domain account on the server (LocalServerDomain\RSExec). Then pass those credentials.

I have that part working using the ReportingServices class.

What would be really nice is if I could use the Microsoft ReportViewer control for my reports (because I like the appearance of it) while still passing the credentils to it. The ReprotingServices class has a viewer toolbar but it doesn't look as nice.

Is this possible, and if so, do you have sample code I could look at?

Thanks for your help.

|||Just keeping this up front so people see it.

Anyone else have an additional info pertaining to an RS2000 ReportViewer with authentication being passed?

Thanks,
|||I am using RS2005.
IF i call ReportingService2005 web service, i know how i can use windows credentails. for this i use NetworkCredentails. However, i couldnt find out how i can set reportviewer credentails to windows credentails.
Could u help me?|||

Looks like this has been sitting around for a little while:

for SSL - set the URL of the ReportViewer control to start with https.

for specifying the credentials to use, you should use the IReportServerCredentials Interface

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials.aspx

Hope that helps,

-Lukasz

ReportViewer with Authentication

I'm new to Reporting Services but have built some reports and have implemented them. I have used the report viewer which works great and has a great tool bar that users really like. One problem, I can't figure out how to pass network credentials using the viewer.

If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar.

I want the best of both worlds without having th build my own toolbar. This must have been done before but I can't seem to find any samples.

So is there a way to pass credentials (Basic Authentication over SSL) while still using the nivce features from the ReportViewer.

Or

Is there a different ReportViewer that has this capability.

Any help will be greatly appreciated.

ThanksDoes anyone have any info on this? Does a ReportViewer control with the ability to pass credentials exist or do I need to create my own?

Thanks,
|||the short answer is "yes".

the devil is in the details...
are you using rs 2000 or 2005 ?
if 2005 I am also trying to get the details down.

I did some work with rs 2000 and see that a lot is the same but the winforms control is new and I hear they "made things better" but so far found few samples of how to get from "A" to "B".
I do know that there are two calls that deal with auth, one to pass data-source credentials and one to pass in "access" credentials.

the access bits seem to have several options.

when I was doing some hacking throuhg they did not seem to work.

I think that was due to messing with the report server and hosing it's settings.

right now I am building a test-lab with a local server and a Virtual PC to run my client app.

I hope I can get a sample working and share....

|||I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

|||

mcatet wrote:

I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

Ok, a few things:

1) you want to use *WINDOWS* credentails
2) look at the docs and as I recall you will see that you needs to create an object and then attach it to your calls.... System.Net.NetworkCredentails
you can create one with user,pass,domain and then pass that to the web services at key points.

I am working 2005 now so I'm not readig the 2000 docs right now but I think that the above will start you in the right direction....|||Ok. So with windows credentials setup on the ReportServer web folder, I just need a windows domain account on the server (LocalServerDomain\RSExec). Then pass those credentials.

I have that part working using the ReportingServices class.

What would be really nice is if I could use the Microsoft ReportViewer control for my reports (because I like the appearance of it) while still passing the credentils to it. The ReprotingServices class has a viewer toolbar but it doesn't look as nice.

Is this possible, and if so, do you have sample code I could look at?

Thanks for your help.

|||Just keeping this up front so people see it.

Anyone else have an additional info pertaining to an RS2000 ReportViewer with authentication being passed?

Thanks,
|||I am using RS2005.
IF i call ReportingService2005 web service, i know how i can use windows credentails. for this i use NetworkCredentails. However, i couldnt find out how i can set reportviewer credentails to windows credentails.
Could u help me?|||

Looks like this has been sitting around for a little while:

for SSL - set the URL of the ReportViewer control to start with https.

for specifying the credentials to use, you should use the IReportServerCredentials Interface

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials.aspx

Hope that helps,

-Lukasz

ReportViewer with Authentication

I'm new to Reporting Services but have built some reports and have implemented them. I have used the report viewer which works great and has a great tool bar that users really like. One problem, I can't figure out how to pass network credentials using the viewer.

If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar.

I want the best of both worlds without having th build my own toolbar. This must have been done before but I can't seem to find any samples.

So is there a way to pass credentials (Basic Authentication over SSL) while still using the nivce features from the ReportViewer.

Or

Is there a different ReportViewer that has this capability.

Any help will be greatly appreciated.

ThanksDoes anyone have any info on this? Does a ReportViewer control with the ability to pass credentials exist or do I need to create my own?

Thanks,
|||the short answer is "yes".

the devil is in the details...
are you using rs 2000 or 2005 ?
if 2005 I am also trying to get the details down.

I did some work with rs 2000 and see that a lot is the same but the winforms control is new and I hear they "made things better" but so far found few samples of how to get from "A" to "B".
I do know that there are two calls that deal with auth, one to pass data-source credentials and one to pass in "access" credentials.

the access bits seem to have several options.

when I was doing some hacking throuhg they did not seem to work.

I think that was due to messing with the report server and hosing it's settings.

right now I am building a test-lab with a local server and a Virtual PC to run my client app.

I hope I can get a sample working and share....

|||I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

|||

mcatet wrote:

I'm using RS 2000. We may go to 2005 in the future but the immediate need is for 2000.

Ok, a few things:

1) you want to use *WINDOWS* credentails
2) look at the docs and as I recall you will see that you needs to create an object and then attach it to your calls.... System.Net.NetworkCredentails
you can create one with user,pass,domain and then pass that to the web services at key points.

I am working 2005 now so I'm not readig the 2000 docs right now but I think that the above will start you in the right direction....|||Ok. So with windows credentials setup on the ReportServer web folder, I just need a windows domain account on the server (LocalServerDomain\RSExec). Then pass those credentials.

I have that part working using the ReportingServices class.

What would be really nice is if I could use the Microsoft ReportViewer control for my reports (because I like the appearance of it) while still passing the credentils to it. The ReprotingServices class has a viewer toolbar but it doesn't look as nice.

Is this possible, and if so, do you have sample code I could look at?

Thanks for your help.

|||Just keeping this up front so people see it.

Anyone else have an additional info pertaining to an RS2000 ReportViewer with authentication being passed?

Thanks,
|||I am using RS2005.
IF i call ReportingService2005 web service, i know how i can use windows credentails. for this i use NetworkCredentails. However, i couldnt find out how i can set reportviewer credentails to windows credentails.
Could u help me?|||

Looks like this has been sitting around for a little while:

for SSL - set the URL of the ReportViewer control to start with https.

for specifying the credentials to use, you should use the IReportServerCredentials Interface

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.ireportservercredentials.aspx

Hope that helps,

-Lukasz