Can we hide some parameters

There will be a pararmeters panels when we browse reports.
The user can modify the parameters there.
But there are some parameters I do not want the usrs to modify.
How can I hide these parameters of restrict user to modify?In the report manager go to the report properties and then to the Parameters
section. Specify a default value for the parameter and then delete the prompt
string (DO NOT uncheck the "Prompt user" check box)
Of course, the parameter value will always be the same, no matter which user
runs the report or what he/she does.
I hope this helps.
--
Please mark the correct/helpful answers!

Can we drill down reports in a another different pages with different layouts?

Hi, all experts here,

Thank you for your kind attention.

I am wondering if we can drill down reports in a different page with different layouts and columns? e.g. I have too many columns desired to see in a report, so I want to direct the users to another page with different layouts and columns, so the first view in the report wont display so many columns in a page. Is it possible to make it in SQL Server 2005 Reporting Services? And if it is possible then how? Hope my question is clear for your help.

Thanks a lot in advance and I am looking forward to hearing from you.

With best regards,

Yours sincerely,

Yes, you can use the Action property of your column textbox. When you look at the options, you can either jump to a new report or to a bookmark or to an URL. In your case, you may like to use Jump to Bookmark. Use BookmarkID for the tables or lists which are displayed in subsequent pages and use that ID to jump to, from your first page columns.

Shyam

|||

Hi, Shyam,

Thank you for your kind help and advice.

Yes, in the navigation property (action property), I can set the actions accordingly. But the pages I am going to will still get the same columns as in the first page. What I want is drill down to a page with different columns displayed? Is that possible? Thank you very much. And I am looking forward to hearing from you further.

With best regards,

Yours sincerely,

|||

In that case, you may have to navigate to a subreport which will have different layout. Create a subreport and jump to this subreport providing the necessary parameters.

Shyam

|||

Hi, Shyam,

Thanks a lot for your kind help.

With best regards,

Yours sincerely,

can we deploy RDL files into report server without using web services through .Net

how can we deploy the reports into report server with out using web services from .Net. Is it possible.

Hi vidya
It is possible, after the initial deployment and folders were created. You could do the following:
Browse to your reportserver. Normally [server]/reports
Browse to the report and click on it. Select the report's 'Properities' Tab. Under the heading 'Report Definition' are 2 options 'Edit' and 'Update'. Use the 'Update' to upload the new rdl file. This will deploy a new version.
Hope this helps
,l0n3i200n

Can we create shared report parametres?

Hi, all experts here,

Is it possible to create shared report parametres passing among different reports on SQL Server 2005 Reporting Services? If it is possible, and how?

Thanks a lot in advance for your advices. And I am looking forward to hearing from you.

With best regards,

Yours sincerely,

No, it's not possible to create a shared parameter, though you can pass the parameter values from one report to another either on user action or to subreports.

Shyam

Can we create free-form report in report builder?

I only can create reports based on three predefined templates. It is very
restricted.Jun Yuan,
Don't choose the Wizard or you will be forced to use the templates.
Right click on your project. Choose Add new item... then choose Report.
You should be given a blank report and asked to specify a data source.
"Jun Yuan" wrote:
> I only can create reports based on three predefined templates. It is very
> restricted.sql

Can we change the style of reports just like css of html

it is stupidity to change color and background for each reports.."Template" report is provided so that you fix up all the things you require
for each report and then copy in a particular folder, so whenever you go for
creating a new report this template can be selected.
Amarnath
"lieshengren" wrote:
> it is stupidity to change color and background for each reports..
>
>|||thanks very much.
My friend give me another way to change the color some other options of
report.
"write the vb expression @.column color, put color configuration in database
"...
oh . so it is hard to write first time. but easy to change.
User's information is about 1000 reocords in the system, so i build a table
to save some color schemas then let user to save a schema to session
information which they want .
^_^!...
but low performance when there is a big user's information.
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:14D750CC-8A50-4CB6-A4FoA-D639AE6AA2DD@.microsoft.com...
> "Template" report is provided so that you fix up all the things you
> require
> for each report and then copy in a particular folder, so whenever you go
> for
> creating a new report this template can be selected.
> Amarnath
> "lieshengren" wrote:
>> it is stupidity to change color and background for each reports..
>>|||If you want to avoid the performance issue you could do something like this
instead of the dynamic vb expression:
* -- create the original report with a custom property indicating the "style
element" -- would be the class -- of as many individual textboxes and other
layout items as you want
* -- when a user wants to assign a color scheme, load the original RDL up as
XML and use the class information to adjust the color and any other
attributes you support in the RDL metadata. You can do this through the DOM
if you like -- I do it through XSLT but people here are probably tired of
hearing about that <g>. It doesn't matter how you implement it.
* -- save a copy of the RDL to a new name -- include a theme ID or something
concatenated with the original report name. Save the user's preference.
* -- at runtime, look up whether the user has a theme associated with that
report (or, if the user picks one theme for all reports, look up to see if
this user has picked a theme). If they have, swap the name of the report to
run for the correct "themed" version.
Now you have a very small hit at runtime and a very flexible reporting
application -- which can support anything that CSS can support and that is
also supported by RDL. You can choose to support more attributes over time,
if you like, even if you just start with color.
>L<
"lieshengren" <lieshengren@.163.com> wrote in message
news:uFhCZT7hHHA.3472@.TK2MSFTNGP04.phx.gbl...
> thanks very much.
> My friend give me another way to change the color some other options of
> report.
> "write the vb expression @.column color, put color configuration in
> database "...
> oh . so it is hard to write first time. but easy to change.
> User's information is about 1000 reocords in the system, so i build a
> table to save some color schemas then let user to save a schema to
> session information which they want .
> ^_^!...
> but low performance when there is a big user's information.
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:14D750CC-8A50-4CB6-A4FoA-D639AE6AA2DD@.microsoft.com...
>> "Template" report is provided so that you fix up all the things you
>> require
>> for each report and then copy in a particular folder, so whenever you go
>> for
>> creating a new report this template can be selected.
>> Amarnath
>> "lieshengren" wrote:
>> it is stupidity to change color and background for each reports..
>>
>sql

Can we build Web UIs with SSRS?

If all one needs is a bunch of reports, then, instead of going the
whole hog writing a UI in a bespoke ASP.NET application, can one take
the sole refuge of SQL Server 2005 Reporting Services to do a neat UI
along with the reports?
As in, one of the parameters for a report may be a period range. Can
SSRS help me build a form with two date pickers that I can:
1. program the events of, package the date ranges, pass it to the
report and call my report file from?
2. publish the form as a Web form?
Or, does one have to rely on a bespoke ASP.NET app to do it? What are
the limits of SSRS?SSRS has its limitations.
SSRS relies greatly on how the SQL code is written.
For example, if you are using date ranges - reporting services is there
to be the middle man between presentation and data. Nothing more. All
reporting services will require is 2 parameters(start date and end
date).
Meaning SSRS will have to TEXTBOX's where the user will just enter 2
dates and it will run the report between the 2 dates. In this case
there is no validation of the paramters but i can all be handleled on
the DB side. So reporting services doesnt have built in controls where
the user will enter dates, its only there to GET parameters. These
parameters are provided in a text box.
SSRS is not a web application where the user has easy to read UI to
enter paramters. It does have a VERY nice way of displaying the
results. Its buily to display a result of a DB call, not to present the
user with a web form.
regards,
Stas K.|||Thanks, Sorcerdon. I understood what you're saying. Now let me present
a broader picture of what I'm thinking might just be possible.
I have to build a bespoke ASP.NET app, which mostly requires to use
SSRS as a backend for reporting. So, in effect, this bespoke Web app is
just to provide UI forms and call SSRS with parameters.
I was considering if it might be possible to use any of the SQL Server
2005 services (Integration, Application, Reporting, Anything Else) to
get the UI functionality also as it is, out-of-the-box.
After all, what I'll be building a bespoke application is to get a UI
to call my reports. Surely, Microsoft, with its DSI and software
factories initiative might have as well provided with some tool to
automate that as well out-of-the-box.
Thoughts?|||Actually, in SSRS 2005, there is a better implementation of the Date type
parameters, with a calendar control and input validation controls.
Thiago
--
Regards,
"Sorcerdon" wrote:
> SSRS has its limitations.
> SSRS relies greatly on how the SQL code is written.
> For example, if you are using date ranges - reporting services is there
> to be the middle man between presentation and data. Nothing more. All
> reporting services will require is 2 parameters(start date and end
> date).
> Meaning SSRS will have to TEXTBOX's where the user will just enter 2
> dates and it will run the report between the 2 dates. In this case
> there is no validation of the paramters but i can all be handleled on
> the DB side. So reporting services doesnt have built in controls where
> the user will enter dates, its only there to GET parameters. These
> parameters are provided in a text box.
> SSRS is not a web application where the user has easy to read UI to
> enter paramters. It does have a VERY nice way of displaying the
> results. Its buily to display a result of a DB call, not to present the
> user with a web form.
> regards,
> Stas K.
>|||I was solely speaking of Reporting Services 2000. My bad.
There is a UI for reporting that is built in for reporting
services(report manager). People can log in subsrcibe to report and get
it in their mail every morning. All of that is built in. And they can
run the reports at will.
The problem is that in RS2000 (I have not yet started working with 2005
until very recently) it wasnt as nice of a UI. So, perhaps a RS 2005
PRO can answer this?
As for out-of-the-box - there is always report manager. The users input
their parameters - or they are defualted to defualt parameters. It DOES
have it built in, yes!
Here are some screenies of what the report manager looks like:
http://www.windowsitpro.com/Files/09/40529/Figure_07.gif
http://msdn.microsoft.com/library/en-us/dnhcvs04/html/408dobson5.jpg
http://www.codeproject.com/books/MSReportingServices/img005.jpg
In that last screenie you can see how the parameters are inputed - in
those text boxes.
regards,
Stas K.|||Hi,
Ofcourse RS is meant for reporting and not giving some fancy UI. But yes in
2005 they have provided what is called "Report Viewer" (comes with VS2005)
which you can use it in your Asp.Net along with your UI. Want to explore ?
search for "ReportViewer Controls (Visual Studio)" in VS 2005 documentation.
Amarnath
"Water Cooler v2" wrote:
> Thanks, Sorcerdon. I understood what you're saying. Now let me present
> a broader picture of what I'm thinking might just be possible.
> I have to build a bespoke ASP.NET app, which mostly requires to use
> SSRS as a backend for reporting. So, in effect, this bespoke Web app is
> just to provide UI forms and call SSRS with parameters.
> I was considering if it might be possible to use any of the SQL Server
> 2005 services (Integration, Application, Reporting, Anything Else) to
> get the UI functionality also as it is, out-of-the-box.
> After all, what I'll be building a bespoke application is to get a UI
> to call my reports. Surely, Microsoft, with its DSI and software
> factories initiative might have as well provided with some tool to
> automate that as well out-of-the-box.
> Thoughts?
>|||Thanks everyone.
Sorcerdon and Amarnath,
Where do I find these "Report Manager" and "Report Viewer"? I cannot
see "ReportViewer Controls" in my toolbox. Do I have to import them (as
in set a reference to some assembly containing them)?
Or, is it because I do not have the complete Visual Studio 2005
Enterprise Architect Edition. I only have SQL Server 2005 Business
Intelligence Development Studio (which is basically a stripped down
version of VS .NET 2005 with only data-centric project templates).|||This is so wrong on so many levels.
I don't usually say this sort of thing but please until you learn more about
the product DO NOT jump in and answer questions.
Let's start with the most glaring problem. You state that the date would be
text with no validation. In RS 2000 there was not a date picker. In RS 2005
there is a date picker. BUT, even assuming you are on RS 2000 you are still
totally wrong. If you go to the menu Report->Report Parameters you can set
the data type for each parameter. So, even in RS 2000 there is validation
for a date field (or an integer field etc), they cannot put in a non-date if
the field should be a date field.
To say RS is not a web app that the user can enter parameters in easily is
also so totally wrong. Yes, some people prefer to have more control over
placement of controls and other things but RS comes with a totally usable
portal called Report Manager. You can have the parameters be based on a
query (so you that pick from a dropdown list). You can have cascading
parameters where the second parameter list is based on the previous
parameter. You can set defaults for the parameters, etc etc. Each report you
can place a description with it so when the user sees the list of reports
each report has a brief description. In RS 2005 you can have multi-select
parameter lists.
So in short, your answer has set this guy off on a totally wrong tangent. It
could be that the existing portal that ships with RS would fullfill all his
needs.
I know you were trying to be helpfull but you are lacking in knowledge about
the product.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1144686176.448071.239430@.i40g2000cwc.googlegroups.com...
> SSRS has its limitations.
> SSRS relies greatly on how the SQL code is written.
> For example, if you are using date ranges - reporting services is there
> to be the middle man between presentation and data. Nothing more. All
> reporting services will require is 2 parameters(start date and end
> date).
> Meaning SSRS will have to TEXTBOX's where the user will just enter 2
> dates and it will run the report between the 2 dates. In this case
> there is no validation of the paramters but i can all be handleled on
> the DB side. So reporting services doesnt have built in controls where
> the user will enter dates, its only there to GET parameters. These
> parameters are provided in a text box.
> SSRS is not a web application where the user has easy to read UI to
> enter paramters. It does have a VERY nice way of displaying the
> results. Its buily to display a result of a DB call, not to present the
> user with a web form.
> regards,
> Stas K.
>|||Hey Bruce,
Thanks for that RS2000 validation control re-answer. I seem to have
never known it existed - perhaps because I am running all my reports of
a web app.
Same for the second answer.
regards,
Stas K.|||I have noticed other posts of yours after my harsh response here and you
have good answers in other areas. I got a little excitable on my post.
You obviously do know other areas of the product, just not Report Manager.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1144787538.172402.57350@.g10g2000cwb.googlegroups.com...
> Hey Bruce,
> Thanks for that RS2000 validation control re-answer. I seem to have
> never known it existed - perhaps because I am running all my reports of
> a web app.
> Same for the second answer.
> regards,
> Stas K.
>|||Bruce,
I am actually a software developer not a report writer although I do
both.
So I really should go answer questions in other forums. In these forums
I hope to help myself learn and perfect my technique when writing
reports.
Although some questions here come from N-Users... So I am able to think
of solutions.
As for Report Manager, in this case I am the N-user ^_^ - I dont like
how it looks as a matter of fact. I want a whole new look for the whole
thing. I like a sharepoint type of look(if your familiar).
regards,
Stas K.

Can we add tooltip to the Reports available in Report Manager?

Hi,
In my Report Manager window, I have created the Folder "Test" and under this folder I have uploaded 2 .rdl file. When I am placing the cursor over the Report Items, it shows 'Items in Test' instead I want to show Some Other Message.

Is it possible?

ThanksI'm sorry, this is not possible.

-Daniel

Can we add tooltip to the Reports available in Report Manager?

Hi,
In my Report Manager window, I have created the Folder "Test" and under this folder I have uploaded 2 .rdl file. When I am placing the cursor over the Report Items, it shows 'Items in Test' instead I want to show Some Other Message.

Is it possible?

ThanksI'm sorry, this is not possible.

-Daniel

Can we add templates to SSRS?

Hi. Is it possible to add a custom template to SSRS for new reports? We'd like to create a template that has our logo and colors. Can you point me to a tutorial on this? Your help is much appreciated.

Yes, it is possible. For more details, check out this blog entry:

http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

can we add our own te,plates in crystal reports 9

Presently i am working generation of reports from
Crystal Reports 9 by connecting this with PeopleSoft.

1)Can we create our own templates in Crystal Reports 9
? if it can be, how we can do that?
2)how we can make that template as a default one?

sir plz help me in resolving this problem b'coz my
task should be started with this.

plz reply me back what ever maybe the answer

thank uDo you mean user defined template at run time?|||Do you mean user defined template at run time?

yes userdefined templates like our company logo and backgrounds at design time or runtime|||I think you can use Logoes in Crystal Report. Use Insert image option|||I think you can use Logoes in Crystal Report. Use Insert image option

thanku

but what abt backgrounds, i have my company logo and background with company name on the whole page in shaded manner i have to create the report on that.

number3|||Yes we can add our own templates.

normal reprot can be used a template.

if u get an error it can be of the problem in CRystal Reports 9, for this u should get the service pack from the following address
this service pack will help to resolve the error for crw32.exe error also.
downlaod the service pack which is only for crystal reports 9.other service packs also there.but if ur need is only for crystal reports u can downlaod this.

http://support.businessobjects.com/downloads/updates/service_packs/default.asp#Crystal%20Reports%20Service%20Packs

bye
enjoy
manosql

Can we a use a CSS or equivalent for a reports(RDLC File)

Hi,

I will be using RDLC files to display reports in various pages.

My Question is this.

I need to use the same type of formatting of color,fonts,font sizes and the background colors so that the same can be used across the reports.

This is somewhat like using a CSS file for aspx pages.

Any ideas... , solution........, .......

Hi,

Just wondering!

We have CSS for the aspx and the HTML pages.

Are there no ways to set a golbal standard for the Reports( Ok, be it a Server report or a local report.). Is it not correct what I am asking.

|||I've been looking into this also, and I found some old threads stating that themes and css are not supported but that they may be in the next version.|||

Hello,

Formatting for reports can be expression based. Create your reports using a standard formula for similar items and pass in values through a dataset. Another option would be to take formatting information in as parameters. The RDL file is just an XML file, you could modify it directly if you want. Here is a link to information on programmatically generating RDLs: http://technet.microsoft.com/en-us/library/ms154583.aspx. RDLs and RDLCs are very similar, and the same techniques could be used.

Good luck,

Larry

|||I need a clarification.

How do I assign a class in the css to a text box.

Say I have a class .txtboxTahomaBold in the CSS, how do I assign the class to the textbox. I do not find any property for the controls (textbox, table .... )|||

I am sorry to have misslead you. You do not get to assign CSS to the textboxes, but you can assign the regular SSRS formatting to each text box on a report prior to displaying it. The easiest way would be to create formulas within the report based on data that you provide through a dataset. For example, set the Font formula to =FieldsTextBoxTahomaBold.Value and have the dataset pass in the string "Normal, Tahoma, 11pt, Bold". Of course, you could also modify the XML, but that is more trouble than it is worth.

I will try and get an example written up on my blog. I will post a link here when I do.

Larry

|||

Thanks.

Waiting for your reply.

|||

Formatting your report based on the user or the data is relatively straight forward once you get the trick. To demonstrate, create a report with a valid connection to an instance of Microsoft SQL Server and use the following SQL as your query:

Code Snippet

SELECT
CASE @.param
WHEN 0 THEN 'Blue'
WHEN 1 THEN 'Red'
END AS color,
CASE @.param
WHEN 0 THEN '12pt'
WHEN 1 THEN '24pt'
END AS size

and create five text boxes with the following attributes:
TextBox1
Value: Color
Color: =First(Fields!color.Value)

TextBox2
Value: Size
Font: Normal, Arial, =First(Fields!size.Value), Normal

TextBox3
Value: Both
Color: =First(Fields!color.Value)
Font: Normal, Arial, =First(Fields!size.Value), Normal

TextBox4
Value: =First(Fields!color.Value)

TextBox5
Value: =First(Fields!size.Value)

Sorry for the delay. The article at http://smithmier.com/blog/?p=38 has a picture of the results, but it really isn't required to understand the concept.

|||

Hi Larry,

Thanks for the post.

I will check it out.

Can we a use a CSS or equivalent for a reports(RDLC File)

Hi,

I will be using RDLC files to display reports in various pages.

My Question is this.

I need to use the same type of formatting of color,fonts,font sizes and the background colors so that the same can be used across the reports.

This is somewhat like using a CSS file for aspx pages.

Any ideas... , solution........, .......

Hi,

Just wondering!

We have CSS for the aspx and the HTML pages.

Are there no ways to set a golbal standard for the Reports( Ok, be it a Server report or a local report.). Is it not correct what I am asking.

|||I've been looking into this also, and I found some old threads stating that themes and css are not supported but that they may be in the next version.|||

Hello,

Formatting for reports can be expression based. Create your reports using a standard formula for similar items and pass in values through a dataset. Another option would be to take formatting information in as parameters. The RDL file is just an XML file, you could modify it directly if you want. Here is a link to information on programmatically generating RDLs: http://technet.microsoft.com/en-us/library/ms154583.aspx. RDLs and RDLCs are very similar, and the same techniques could be used.

Good luck,

Larry

|||I need a clarification.

How do I assign a class in the css to a text box.

Say I have a class .txtboxTahomaBold in the CSS, how do I assign the class to the textbox. I do not find any property for the controls (textbox, table .... )|||

I am sorry to have misslead you. You do not get to assign CSS to the textboxes, but you can assign the regular SSRS formatting to each text box on a report prior to displaying it. The easiest way would be to create formulas within the report based on data that you provide through a dataset. For example, set the Font formula to =FieldsTextBoxTahomaBold.Value and have the dataset pass in the string "Normal, Tahoma, 11pt, Bold". Of course, you could also modify the XML, but that is more trouble than it is worth.

I will try and get an example written up on my blog. I will post a link here when I do.

Larry

|||

Thanks.

Waiting for your reply.

|||

Formatting your report based on the user or the data is relatively straight forward once you get the trick. To demonstrate, create a report with a valid connection to an instance of Microsoft SQL Server and use the following SQL as your query:

Code Snippet

SELECT
CASE @.param
WHEN 0 THEN 'Blue'
WHEN 1 THEN 'Red'
END AS color,
CASE @.param
WHEN 0 THEN '12pt'
WHEN 1 THEN '24pt'
END AS size

and create five text boxes with the following attributes:
TextBox1
Value: Color
Color: =First(Fields!color.Value)

TextBox2
Value: Size
Font: Normal, Arial, =First(Fields!size.Value), Normal

TextBox3
Value: Both
Color: =First(Fields!color.Value)
Font: Normal, Arial, =First(Fields!size.Value), Normal

TextBox4
Value: =First(Fields!color.Value)

TextBox5
Value: =First(Fields!size.Value)

Sorry for the delay. The article at http://smithmier.com/blog/?p=38 has a picture of the results, but it really isn't required to understand the concept.

|||

Hi Larry,

Thanks for the post.

I will check it out.

can view reports created in RS after upgrading to RS sp1?

Hi,
My server is currently running Reporting Services. I want to upgrade it
to reporting services sp1 or sp2. I wanna know after upgrading it to
sp1, will I will be able to view my older reports which is created
using reporting services?No problem. I suggest sp2. Also, upgrade your designer as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sheerin" <susheelkaur@.gmail.com> wrote in message
news:1141189981.337655.34260@.e56g2000cwe.googlegroups.com...
> Hi,
> My server is currently running Reporting Services. I want to upgrade it
> to reporting services sp1 or sp2. I wanna know after upgrading it to
> sp1, will I will be able to view my older reports which is created
> using reporting services?
>

can u help me to set dynamic database option to crystal reports

hi
I am having 120 crystal reports of 9 and when ever I want to change the DBuser I am facing problem and i have to change for all the 120 reports
IS THERE ANY EASY SOLUTION FOR ME..?
PL HELP ME...:thumb:Hi paste this code in all the view pages of the report and try ...this is working for me in XI verison.
Please do reply me after trying

'' New Code for Passing the DB in Run-Time for CR-XI
Set mainReportTableCollection = Session("oRpt").Database.Tables

For Each mnTable in mainReportTableCollection
With mnTable.ConnectionProperties
.Item("user ID") = DB_UID
.Item("Password") = DB_PWD
.Item("DSN") = CRYSTAL_RPT_DSN
.Item("Database") = DB_NAME
End With
' response.write mnTable.ConnectionProperties.Item("DSN")
mnTable.Location = DB_NAME & ".dbo." & mnTable.name
'mnTable.Location ="crbard.dbo." & mnTable.name
Next

Dim CRXSections, CRXSection, CRXobject, CRXSubreport, CRXsubreports, CrSubtable
Set CRXSections = session("oRpt").Sections
For each CRXSection in CRXSections
For each CRXObject in CRXSection.ReportObjects
If CRXObject.Kind = 5 then 'Subreport
Set CRXSubreport = CRXObject.OpenSubreport
for each crSubTable in CRXSubreport.Database.Tables
' StripLocation(crSubTable)
' crSubTable.SetLogonInfo CRYSTAL_RPT_DSN,DB_NAME , DB_UID, DB_PWD

With crSubTable.ConnectionProperties
.Item("user ID") = DB_UID
.Item("Password") = DB_PWD
.Item("DSN") = CRYSTAL_RPT_DSN
.Item("Database") = DB_NAME
End With
crSubTable.Location = DB_NAME & ".dbo." & crSubTable.name
'crSubTable.Location = "crbard.dbo." & crSubTable.name
next
End IF
next
next
'' Code End for Passing the DB in Run-Time for CR-XI

Can this be used as a replacement for Crystal Reports?

I am not familiar with this tool. Can I create reports that can be run
from a C# application with parameters passed to it?
Any help is greatly appreciated.VS 2005 has two new controls: winform and webform. The controls can be used
in local or server mode. In server mode you give it the parameters and call
the server which the control then shows the rendered report. In local mode
you give it the report and the tableset data. However, you have to do lots
more work to handle subreports and other types of reports. My feeling is, if
you plan on not having a server around that Crystal reports is designed more
along the lines of your app providing the data. Reporting Services is
designed as a service oriented architecture and although in local mode you
can give it the data, it was not designed with that in mind. With a server
in the picture then the answer is absolutely yes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg Smith" <gjs@.umn.edu> wrote in message
news:eu9RG9ZYHHA.4440@.TK2MSFTNGP03.phx.gbl...
>I am not familiar with this tool. Can I create reports that can be run
>from a C# application with parameters passed to it?
>
> Any help is greatly appreciated.

Can the code.Functions be shared between reports?

hey,
I have created some vb functions in report->Properties->Code page, they are some common converting and formating functions, can these be shared between reports or I have to write it for every reprot? Or I have to write it into a dll and ref that dll in my report?

Thanks.

You should move those functions into a custom assembly and reference that in the reports. Please check this link on MSDN: http://msdn2.microsoft.com/en-us/library/ms345237.aspx

Particularly, scroll to the bottom and check the last two entries in that table about custom assemblies (and calling static functions which is most likely what you are looking for) and custom class instances.

-- Robert

Can SubReports be from SubProjects in the same solution

We have a bunch of small single pupose reports (individual charts, tables, etc.) that we used as subreports across several larger reports. I want to sperate the subreports into their own folder on the Reporting Server and I tried to tdo this by creating a solution with subprojects and specifying different publishing folders. That seems to be going well, but when I want to add a subreport from one project to a report in another project Visual Studio doesn't seem to like this at all. It won't let me drag them to the layout surface.

Shoudl this work? Is there something different I need to be doing since I'm working with multiple projects now?

Thanks,

-p

I'm not sure it's going to work that way -- somebody else will have to confirm, not really my area -- but, if it does not, could you create a custom post-build step that copied the RDLs from their source folders to where they needed to go within each individual project?

I realize it's not ideal to replicate the files, but this would keep them up to date/synched.

>L<

|||

Actually -- one more thought -- I'm not sure if this utility will do what you want, but it looks like it might -- you could check it out...

http://www.sqldbatips.com/showarticle.asp?ID=73

>L<

|||

That tool is for taking one report and publising it multiple places. I want to do the exact opposite publish a set of subreports to one location and reuse them in another. The idea being that then people don't have to see the noise of all the subreports we can just use the nice well formatted project reports which include a variety of subreports as needed.

I don't think a post-build script would be very easy to maintain (or even possible) it seems that the subreport control can't refer to a report outside of its own namespace (i.e., its own folder).

|||

I understand what the tool does, and in essence the post-build script I suggested does the same thing, I just thought the tool would be more "automatic".

What I did *not* understand was why you wanted to do it (the "noise" of the subreports) -- I thought it was a maintenance issue. IOW, let's assume (as we both think so far) that a subreport can't refer to a report "somewhere else". Since we don't have control over that, both the tool and the postbuild at least make sure you don't have to *update* all the copies of a single subreport that you've had to "litter" all of your projects with, if changes have to be made.

I agree with you 100% about the "noise/litter" issue and I wish I had a better solution to offer.

FWIW, I have a similar problem: I wanted to set different deployment folders for different reports in a *single* project <shrug>. Yes I know you can do this in different configurations. I want to have my "Production" configuration deploy all reports to the same server, but different locations on that server. IOW, I would like to have a single reporting project that serves a whole bunch of different departments, each of which has a different reporting folder with its own set of permissions assigned to it.

I suspect the problems are connected. IOW, if it's really true that reports can only reference other reports in one folder, then if you could deploy the way I want to it would break the subreport references...

>L<

|||

Interesting note:

You can specify project interdependance, among subprojects, which implies that one subproject can reference another somehow. (otherwise, why would you need to set one project to be dependant on another)

|||

Of course one project can reference another <s>. That applies when (say) I build a report that references a custom code DLL or -- more commonly in my case -- I build a solution that has some black box code in C# and white box code in VB.

The "somehow" is by instancing classes from other DLLs...

I think what we've been saying in this thread is that, if the same applies to different *report* projects, we don't understand how it works and haven't gotten it to work the way we might have expected it to.

As an example, and one we haven't discussed in this thread yet: suppose I create a second report project in a solution and make it dependent on my first report project. When I want to create a report, can I use a shared data source from the first project? As far as I know... not. FWIW: I have tried referencing the shared datasource in a "solution folder" but that doesn't seem to do the trick.

>L<

|||

Ah, I had wondered what it was for. I have not delved much into custom code for RS yet. I am still primarily a SQL person.

The only solution I have found thus far is to use Source Safe to share my subreports between projects, ala the tool mentioned previously.

To get around the messy listings all these subreports creates, we're building a simple web front end to redirect the users to the correct report.

|||

I have one big project,

within that I have sub projects that publish the reports under them to a different folder on the report server... something like..

Accounts Receivable.

AR Reports

Accounts Payable

AP Reports

etc...

Data Sources has it's own folder.

If I have a AR subreport I want to share with other reports in that folder I simply share them.

If you are going to have a sub report span multiple projects then you need to copy the sub report from one project to the other which in vs2005 is simple as highlighting the sub report, ctrl-c then goin to your other project and press ctrl-v.

you can also have a sub folder in your main folder to hold sub reports.

lots of ways to do it.

|||

You can have one solution and multiple sub projects and have each sub project publish to a different server and/or folder, That seems to work just fine and I think as long as there was no overlap in the reports it would meet your needs.

For reports you want to put in multple locations you'd either need to use the tool you reccomended or copy the report into each project as a later poster reccomends.

I think we're all in agreement that there is no way (or we don't know how) to have a subreport be from a different project than the main report.

Anyway, I guess I'll go back to a single project and make up some clever naming schema so the main reports are at the top of the list and the subreports are at the bottom OR mark the subreports as Hidden. I've not played much with that. I hope I can do that from Visual Studio or if not that when I set it in the Web UI its not overwritten each time I deploy.

Thanks,

-p

|||

Are you letting your users see the reportserver directory as it stands?

You might want to consider doing a little webpage that reads a table that lists where the reports are.

My company has implemented this type of thing.

We have a webpage where the user selects which report group they want and then hit a button and get a list of reports that match...

It is two tables, a group table and a reports table. inthe reports table we have a friendly name for the report and the location to where it is..

works fine for us and the users NEVER see what we don't want them to.

|||

The Original querstion was not answered, but I worked around this by keeping all of the reports in one project and then marking the sub reports as Hidden on the server side.

This setting is preserved even after you re-dpeloy a report. Kind of hard to setup, but bearable.

I wish the original method of using projects with different target folders woudl work though, that would be best.

|||

If I understand your original question correctly, you can use a report from a different project as a subreport.

Let's say that your subreport is "MySubReport.rdl" in project "MyProjectA" and you want to use it from a project in "MyProjectB". Both projects have the same TargetServerURL and the same parent folder (e.g. TargetReportFolder is set to "MySolution/MyProjectA" and "MySolution/MyProjectB").

In Report Designer, drag and drop a subreport item onto your report. Set its subreport property to "./../MyProjectA/MySubReport" and manually set any parameters.

Hope this helps.

Can SubReports be from SubProjects in the same solution

We have a bunch of small single pupose reports (individual charts, tables, etc.) that we used as subreports across several larger reports. I want to sperate the subreports into their own folder on the Reporting Server and I tried to tdo this by creating a solution with subprojects and specifying different publishing folders. That seems to be going well, but when I want to add a subreport from one project to a report in another project Visual Studio doesn't seem to like this at all. It won't let me drag them to the layout surface.

Shoudl this work? Is there something different I need to be doing since I'm working with multiple projects now?

Thanks,

-p

I'm not sure it's going to work that way -- somebody else will have to confirm, not really my area -- but, if it does not, could you create a custom post-build step that copied the RDLs from their source folders to where they needed to go within each individual project?

I realize it's not ideal to replicate the files, but this would keep them up to date/synched.

>L<

|||

Actually -- one more thought -- I'm not sure if this utility will do what you want, but it looks like it might -- you could check it out...

http://www.sqldbatips.com/showarticle.asp?ID=73

>L<

|||

That tool is for taking one report and publising it multiple places. I want to do the exact opposite publish a set of subreports to one location and reuse them in another. The idea being that then people don't have to see the noise of all the subreports we can just use the nice well formatted project reports which include a variety of subreports as needed.

I don't think a post-build script would be very easy to maintain (or even possible) it seems that the subreport control can't refer to a report outside of its own namespace (i.e., its own folder).

|||

I understand what the tool does, and in essence the post-build script I suggested does the same thing, I just thought the tool would be more "automatic".

What I did *not* understand was why you wanted to do it (the "noise" of the subreports) -- I thought it was a maintenance issue. IOW, let's assume (as we both think so far) that a subreport can't refer to a report "somewhere else". Since we don't have control over that, both the tool and the postbuild at least make sure you don't have to *update* all the copies of a single subreport that you've had to "litter" all of your projects with, if changes have to be made.

I agree with you 100% about the "noise/litter" issue and I wish I had a better solution to offer.

FWIW, I have a similar problem: I wanted to set different deployment folders for different reports in a *single* project <shrug>. Yes I know you can do this in different configurations. I want to have my "Production" configuration deploy all reports to the same server, but different locations on that server. IOW, I would like to have a single reporting project that serves a whole bunch of different departments, each of which has a different reporting folder with its own set of permissions assigned to it.

I suspect the problems are connected. IOW, if it's really true that reports can only reference other reports in one folder, then if you could deploy the way I want to it would break the subreport references...

>L<

|||

Interesting note:

You can specify project interdependance, among subprojects, which implies that one subproject can reference another somehow. (otherwise, why would you need to set one project to be dependant on another)

|||

Of course one project can reference another <s>. That applies when (say) I build a report that references a custom code DLL or -- more commonly in my case -- I build a solution that has some black box code in C# and white box code in VB.

The "somehow" is by instancing classes from other DLLs...

I think what we've been saying in this thread is that, if the same applies to different *report* projects, we don't understand how it works and haven't gotten it to work the way we might have expected it to.

As an example, and one we haven't discussed in this thread yet: suppose I create a second report project in a solution and make it dependent on my first report project. When I want to create a report, can I use a shared data source from the first project? As far as I know... not. FWIW: I have tried referencing the shared datasource in a "solution folder" but that doesn't seem to do the trick.

>L<

|||

Ah, I had wondered what it was for. I have not delved much into custom code for RS yet. I am still primarily a SQL person.

The only solution I have found thus far is to use Source Safe to share my subreports between projects, ala the tool mentioned previously.

To get around the messy listings all these subreports creates, we're building a simple web front end to redirect the users to the correct report.

|||

I have one big project,

within that I have sub projects that publish the reports under them to a different folder on the report server... something like..

Accounts Receivable.

AR Reports

Accounts Payable

AP Reports

etc...

Data Sources has it's own folder.

If I have a AR subreport I want to share with other reports in that folder I simply share them.

If you are going to have a sub report span multiple projects then you need to copy the sub report from one project to the other which in vs2005 is simple as highlighting the sub report, ctrl-c then goin to your other project and press ctrl-v.

you can also have a sub folder in your main folder to hold sub reports.

lots of ways to do it.

|||

You can have one solution and multiple sub projects and have each sub project publish to a different server and/or folder, That seems to work just fine and I think as long as there was no overlap in the reports it would meet your needs.

For reports you want to put in multple locations you'd either need to use the tool you reccomended or copy the report into each project as a later poster reccomends.

I think we're all in agreement that there is no way (or we don't know how) to have a subreport be from a different project than the main report.

Anyway, I guess I'll go back to a single project and make up some clever naming schema so the main reports are at the top of the list and the subreports are at the bottom OR mark the subreports as Hidden. I've not played much with that. I hope I can do that from Visual Studio or if not that when I set it in the Web UI its not overwritten each time I deploy.

Thanks,

-p

|||

Are you letting your users see the reportserver directory as it stands?

You might want to consider doing a little webpage that reads a table that lists where the reports are.

My company has implemented this type of thing.

We have a webpage where the user selects which report group they want and then hit a button and get a list of reports that match...

It is two tables, a group table and a reports table. inthe reports table we have a friendly name for the report and the location to where it is..

works fine for us and the users NEVER see what we don't want them to.

|||

The Original querstion was not answered, but I worked around this by keeping all of the reports in one project and then marking the sub reports as Hidden on the server side.

This setting is preserved even after you re-dpeloy a report. Kind of hard to setup, but bearable.

I wish the original method of using projects with different target folders woudl work though, that would be best.

|||

If I understand your original question correctly, you can use a report from a different project as a subreport.

Let's say that your subreport is "MySubReport.rdl" in project "MyProjectA" and you want to use it from a project in "MyProjectB". Both projects have the same TargetServerURL and the same parent folder (e.g. TargetReportFolder is set to "MySolution/MyProjectA" and "MySolution/MyProjectB").

In Report Designer, drag and drop a subreport item onto your report. Set its subreport property to "./../MyProjectA/MySubReport" and manually set any parameters.

Hope this helps.

Can someone, MS?, please explain the Reporting Server security?

I just installed the evaluation version and am comparing it to Crystal
Reports. I can't seem to figure out the user level security.
My set-up:
Web server Win2003: Has IIS6 and Report server
DB SQL Server Win 2003: has Sql Server 2k
These boxes are not on a domain, they are test machines.
I open the report server up and get the home page, I can add folder, files,
etc but I no user level security. I went into site settings and all I can
find is roles, but no logins, etc.' I can go to the site and do everything
with no login?
Help.you are correct. Where you've gone awry is the difference between
authentication and authorization.
authentication is the process of determining who you are, most commonly done
via a username and password.
authorization is the process of determining what you can do now that we know
who you are.
In the Reporting Services world, RS relies on external authentication. In
other words, somebody other than RS has to authenticate the user. In most
cases that will be windows. So all user accounts are created in windows.
Users are managed there as per normal.
In the security settings you then create roles. Those roles have specific
permissions on report items etc. You then assign windows users and groups
these roles.
So if we take Joe User... His user account is maintained in windows (userID,
Password etc) either at the domain or the server level. Joe's account is
then assigned to roles in RS which determine what he can do with RS.
Make sense?
Regards,
Rob Labbé, MCP, MCAD, MCSD, MCT
Lead Architect/Trainer
Fidelis
Blog: http://spaces.msn.com/members/roblabbe
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
>I just installed the evaluation version and am comparing it to Crystal
> Reports. I can't seem to figure out the user level security.
> My set-up:
> Web server Win2003: Has IIS6 and Report server
> DB SQL Server Win 2003: has Sql Server 2k
> These boxes are not on a domain, they are test machines.
> I open the report server up and get the home page, I can add folder,
> files,
> etc but I no user level security. I went into site settings and all I can
> find is roles, but no logins, etc.' I can go to the site and do
> everything
> with no login?
> Help.|||then why is there several tables that house roles, users, and their assigned
roles then is Sql Server?
Also, Crystal take sit to the lowest level via a "Universe" to a record
level. Does MS Report Serv. not do this either?
Are you saying that I have to add everyone to the windows box? That doesn't
make sense for web reporting, the IUSR account can access everything?
thanx.
"Rob Labbe (Lowney)" wrote:
> you are correct. Where you've gone awry is the difference between
> authentication and authorization.
> authentication is the process of determining who you are, most commonly done
> via a username and password.
> authorization is the process of determining what you can do now that we know
> who you are.
> In the Reporting Services world, RS relies on external authentication. In
> other words, somebody other than RS has to authenticate the user. In most
> cases that will be windows. So all user accounts are created in windows.
> Users are managed there as per normal.
> In the security settings you then create roles. Those roles have specific
> permissions on report items etc. You then assign windows users and groups
> these roles.
> So if we take Joe User... His user account is maintained in windows (userID,
> Password etc) either at the domain or the server level. Joe's account is
> then assigned to roles in RS which determine what he can do with RS.
> Make sense?
> Regards,
>
> --
> Rob Labbé, MCP, MCAD, MCSD, MCT
> Lead Architect/Trainer
> Fidelis
> Blog: http://spaces.msn.com/members/roblabbe
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
> >I just installed the evaluation version and am comparing it to Crystal
> > Reports. I can't seem to figure out the user level security.
> > My set-up:
> > Web server Win2003: Has IIS6 and Report server
> > DB SQL Server Win 2003: has Sql Server 2k
> >
> > These boxes are not on a domain, they are test machines.
> >
> > I open the report server up and get the home page, I can add folder,
> > files,
> > etc but I no user level security. I went into site settings and all I can
> > find is roles, but no logins, etc.' I can go to the site and do
> > everything
> > with no login?
> >
> > Help.
>
>|||As you've discovered, the security model is vastly different in RS as
compared to Crystal. You're going to drive yourself nuts if you try to do a
one-to-one mapping of security features between the two.
You're best bet is to look at the end result you're after, not "how" it was
implemented in Crystal. Then look at RS security and set it up to get the
same end result. If you describe your scenario, and what the result you're
after is, we may be able to help you out here.
Regards,
Rob Labbé, MCP, MCAD, MCSD, MCT
Lead Architect/Trainer
Fidelis
Blog: http://spaces.msn.com/members/roblabbe
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:65196924-819E-4F4E-AD10-78D60F4A729C@.microsoft.com...
> then why is there several tables that house roles, users, and their
> assigned
> roles then is Sql Server?
> Also, Crystal take sit to the lowest level via a "Universe" to a record
> level. Does MS Report Serv. not do this either?
> Are you saying that I have to add everyone to the windows box? That
> doesn't
> make sense for web reporting, the IUSR account can access everything?
> thanx.
> "Rob Labbe (Lowney)" wrote:
>> you are correct. Where you've gone awry is the difference between
>> authentication and authorization.
>> authentication is the process of determining who you are, most commonly
>> done
>> via a username and password.
>> authorization is the process of determining what you can do now that we
>> know
>> who you are.
>> In the Reporting Services world, RS relies on external authentication.
>> In
>> other words, somebody other than RS has to authenticate the user. In
>> most
>> cases that will be windows. So all user accounts are created in windows.
>> Users are managed there as per normal.
>> In the security settings you then create roles. Those roles have
>> specific
>> permissions on report items etc. You then assign windows users and
>> groups
>> these roles.
>> So if we take Joe User... His user account is maintained in windows
>> (userID,
>> Password etc) either at the domain or the server level. Joe's account is
>> then assigned to roles in RS which determine what he can do with RS.
>> Make sense?
>> Regards,
>>
>> --
>> Rob Labbé, MCP, MCAD, MCSD, MCT
>> Lead Architect/Trainer
>> Fidelis
>> Blog: http://spaces.msn.com/members/roblabbe
>> "Chris" <Chris@.discussions.microsoft.com> wrote in message
>> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
>> >I just installed the evaluation version and am comparing it to Crystal
>> > Reports. I can't seem to figure out the user level security.
>> > My set-up:
>> > Web server Win2003: Has IIS6 and Report server
>> > DB SQL Server Win 2003: has Sql Server 2k
>> >
>> > These boxes are not on a domain, they are test machines.
>> >
>> > I open the report server up and get the home page, I can add folder,
>> > files,
>> > etc but I no user level security. I went into site settings and all I
>> > can
>> > find is roles, but no logins, etc.' I can go to the site and do
>> > everything
>> > with no login?
>> >
>> > Help.
>>|||if there is no central login then how do you restrict it as a web app in the
manager? The roles don't appear to be machine or AD roles?
Are we saying that all users get "everything".
I'm still not seeing this. I thought maybe the eval version doesn't have
login dilaogs or something?
thanx.
"Rob Labbe (Lowney)" wrote:
> As you've discovered, the security model is vastly different in RS as
> compared to Crystal. You're going to drive yourself nuts if you try to do a
> one-to-one mapping of security features between the two.
> You're best bet is to look at the end result you're after, not "how" it was
> implemented in Crystal. Then look at RS security and set it up to get the
> same end result. If you describe your scenario, and what the result you're
> after is, we may be able to help you out here.
> Regards,
>
> --
> Rob Labbé, MCP, MCAD, MCSD, MCT
> Lead Architect/Trainer
> Fidelis
> Blog: http://spaces.msn.com/members/roblabbe
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:65196924-819E-4F4E-AD10-78D60F4A729C@.microsoft.com...
> > then why is there several tables that house roles, users, and their
> > assigned
> > roles then is Sql Server?
> > Also, Crystal take sit to the lowest level via a "Universe" to a record
> > level. Does MS Report Serv. not do this either?
> >
> > Are you saying that I have to add everyone to the windows box? That
> > doesn't
> > make sense for web reporting, the IUSR account can access everything?
> >
> > thanx.
> >
> > "Rob Labbe (Lowney)" wrote:
> >
> >> you are correct. Where you've gone awry is the difference between
> >> authentication and authorization.
> >>
> >> authentication is the process of determining who you are, most commonly
> >> done
> >> via a username and password.
> >>
> >> authorization is the process of determining what you can do now that we
> >> know
> >> who you are.
> >>
> >> In the Reporting Services world, RS relies on external authentication.
> >> In
> >> other words, somebody other than RS has to authenticate the user. In
> >> most
> >> cases that will be windows. So all user accounts are created in windows.
> >> Users are managed there as per normal.
> >>
> >> In the security settings you then create roles. Those roles have
> >> specific
> >> permissions on report items etc. You then assign windows users and
> >> groups
> >> these roles.
> >>
> >> So if we take Joe User... His user account is maintained in windows
> >> (userID,
> >> Password etc) either at the domain or the server level. Joe's account is
> >> then assigned to roles in RS which determine what he can do with RS.
> >>
> >> Make sense?
> >>
> >> Regards,
> >>
> >>
> >> --
> >> Rob Labbé, MCP, MCAD, MCSD, MCT
> >> Lead Architect/Trainer
> >> Fidelis
> >>
> >> Blog: http://spaces.msn.com/members/roblabbe
> >>
> >> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> >> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
> >> >I just installed the evaluation version and am comparing it to Crystal
> >> > Reports. I can't seem to figure out the user level security.
> >> > My set-up:
> >> > Web server Win2003: Has IIS6 and Report server
> >> > DB SQL Server Win 2003: has Sql Server 2k
> >> >
> >> > These boxes are not on a domain, they are test machines.
> >> >
> >> > I open the report server up and get the home page, I can add folder,
> >> > files,
> >> > etc but I no user level security. I went into site settings and all I
> >> > can
> >> > find is roles, but no logins, etc.' I can go to the site and do
> >> > everything
> >> > with no login?
> >> >
> >> > Help.
> >>
> >>
> >>
>
>|||Role and groups are two different things. I do the following. I create a
local group called Reports. For that group I add either individual users or
I add domain groups. Then in the home page of Report Manager, Properties,
New Role Assignment. For the user/group I put in Reports (the local group I
created previously) and I give it Browse rights.
RS is totally integrated with Windows security. If you are not going to be
using that (for instance over the internet) then you need to create your own
authentication that you integrate in with Reporting Service. Search the
books on line on authentication. Lots of good info. Just remember,
authentication and roles are two different thing. Once someone is
authenticated to be in a particular group (or authenticated to be a
particular user) then RS allows them rights based on the role assignment for
that group/user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:7DABBC90-778B-4991-8177-1E7495A87788@.microsoft.com...
> if there is no central login then how do you restrict it as a web app in
the
> manager? The roles don't appear to be machine or AD roles?
> Are we saying that all users get "everything".
> I'm still not seeing this. I thought maybe the eval version doesn't have
> login dilaogs or something?
> thanx.
> "Rob Labbe (Lowney)" wrote:
> > As you've discovered, the security model is vastly different in RS as
> > compared to Crystal. You're going to drive yourself nuts if you try to
do a
> > one-to-one mapping of security features between the two.
> >
> > You're best bet is to look at the end result you're after, not "how" it
was
> > implemented in Crystal. Then look at RS security and set it up to get
the
> > same end result. If you describe your scenario, and what the result
you're
> > after is, we may be able to help you out here.
> >
> > Regards,
> >
> >
> > --
> > Rob Labbé, MCP, MCAD, MCSD, MCT
> > Lead Architect/Trainer
> > Fidelis
> >
> > Blog: http://spaces.msn.com/members/roblabbe
> >
> > "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > news:65196924-819E-4F4E-AD10-78D60F4A729C@.microsoft.com...
> > > then why is there several tables that house roles, users, and their
> > > assigned
> > > roles then is Sql Server?
> > > Also, Crystal take sit to the lowest level via a "Universe" to a
record
> > > level. Does MS Report Serv. not do this either?
> > >
> > > Are you saying that I have to add everyone to the windows box? That
> > > doesn't
> > > make sense for web reporting, the IUSR account can access everything?
> > >
> > > thanx.
> > >
> > > "Rob Labbe (Lowney)" wrote:
> > >
> > >> you are correct. Where you've gone awry is the difference between
> > >> authentication and authorization.
> > >>
> > >> authentication is the process of determining who you are, most
commonly
> > >> done
> > >> via a username and password.
> > >>
> > >> authorization is the process of determining what you can do now that
we
> > >> know
> > >> who you are.
> > >>
> > >> In the Reporting Services world, RS relies on external
authentication.
> > >> In
> > >> other words, somebody other than RS has to authenticate the user.
In
> > >> most
> > >> cases that will be windows. So all user accounts are created in
windows.
> > >> Users are managed there as per normal.
> > >>
> > >> In the security settings you then create roles. Those roles have
> > >> specific
> > >> permissions on report items etc. You then assign windows users and
> > >> groups
> > >> these roles.
> > >>
> > >> So if we take Joe User... His user account is maintained in windows
> > >> (userID,
> > >> Password etc) either at the domain or the server level. Joe's
account is
> > >> then assigned to roles in RS which determine what he can do with RS.
> > >>
> > >> Make sense?
> > >>
> > >> Regards,
> > >>
> > >>
> > >> --
> > >> Rob Labbé, MCP, MCAD, MCSD, MCT
> > >> Lead Architect/Trainer
> > >> Fidelis
> > >>
> > >> Blog: http://spaces.msn.com/members/roblabbe
> > >>
> > >> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > >> news:B6C6072D-63BC-422F-9DF9-A4400B300EF8@.microsoft.com...
> > >> >I just installed the evaluation version and am comparing it to
Crystal
> > >> > Reports. I can't seem to figure out the user level security.
> > >> > My set-up:
> > >> > Web server Win2003: Has IIS6 and Report server
> > >> > DB SQL Server Win 2003: has Sql Server 2k
> > >> >
> > >> > These boxes are not on a domain, they are test machines.
> > >> >
> > >> > I open the report server up and get the home page, I can add
folder,
> > >> > files,
> > >> > etc but I no user level security. I went into site settings and all
I
> > >> > can
> > >> > find is roles, but no logins, etc.' I can go to the site and do
> > >> > everything
> > >> > with no login?
> > >> >
> > >> > Help.
> > >>
> > >>
> > >>
> >
> >
> >|||There is a Reporting Services 2005 book screaming to be written, here -
I know I'd buy multiple copies for work if someone could clearly
present this topic.
As is, it would make Oppenheimer stagger across the room for a
Tylenol...