query - specify multiple items

Hi,
I am trying to develop a report where the user is able to specify the
information to be pulled from one specific field.
For example... the table has 2 fields... Company ID, Company Name
I only want to see information where Company ID = ABC and XYZ
but I want the user to be able to specify multiple Company ID's in the
report parameter
Thanks,
JenI've got part of the query figured out:
SELECT Company ID, Company Name
FROM Company Profile
WHERE (Company ID (@.CompanyID))
But this only lets me query one company id at a time. how can I alter the
query to allow users to query multiple company id's?
thanks
jen
"Jennifer Mar" <jmar@.cityharvest.org> wrote in message
news:O6rTcrxZHHA.1300@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I am trying to develop a report where the user is able to specify the
> information to be pulled from one specific field.
> For example... the table has 2 fields... Company ID, Company Name
> I only want to see information where Company ID = ABC and XYZ
> but I want the user to be able to specify multiple Company ID's in the
> report parameter
> Thanks,
> Jen
>|||Hello Jennifer,
If you are using the SQL Server 2005, you could use the Multi-value
Parameter.
When you enable the Multi-value for the parameter, you could get a dropdown
list in the report.
Then you need to use the IN statement to query the data.
You could refer this article:
Adding a Multivalue Parameter
http://msdn2.microsoft.com/en-us/aa337396.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||We're currently running sql server 2000. i am using visual studio .net to
build the reports.
The way the query is build now, it allows the user to enter the parameters
in a seperate text box for each company id they query. how can i build the
query so that they can just enter a string of unlimited company id's?
thanks!
jen
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OO42Wm4ZHHA.1784@.TK2MSFTNGHUB02.phx.gbl...
> Hello Jennifer,
> If you are using the SQL Server 2005, you could use the Multi-value
> Parameter.
> When you enable the Multi-value for the parameter, you could get a
dropdown
> list in the report.
> Then you need to use the IN statement to query the data.
> You could refer this article:
> Adding a Multivalue Parameter
> http://msdn2.microsoft.com/en-us/aa337396.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Jen,
You could use the parameter as the String and use the comma mark to
seperate each company id.
And in the query, you could use the parameter like this:
Select * from tbl_companies where companyid in (@.Parameters)
Hope this will be helpful.
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.|||hi wei,
thanks so much for checking in. everything worked out great :)
jen
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:5JytuQ7aHHA.1028@.TK2MSFTNGHUB02.phx.gbl...
> 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.
>|||Hello Jen,
My pleasure!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Query -- 11 seconds in SSMS but times out after 30 minutes in

We're having a weird problem -- a particular report will time out
after 30 minutes running in Reporting Services. However, if we grab
the query from Profiler and run it in SSMS, it runs in about 11
seconds. The profiler trace shows an error of 2 - Abort.
The query itself is found below -- I won't include DDL because each of
the items in the FROM clause is a view that is very long.
Any explanation as to why the query would take so long when running
from reporting services?
Our environment -- SQL 2005 Standard x64, SP2 (9.00.3054.00 / Build
3790). Running on Windows Server 2003 Enterprise x64 SP2.
There are some things I'd like to clean up after seeing it, but
nonetheless it still runs pretty quick in SSMS.
SELECT
e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2
WHEN 3 THEN b.desc_3
WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN
b.desc_6
WHEN 7 THEN b.desc_7 ELSE b.desc_8 END AS Plan_Option
, e.SHORT_NAME, e.SSN
, SUM(bck.COST)
, e.STATUS
,case when e.terminated ='1753-01-01 00:00:00.000' then ' '
else LEFT( CONVERT(varchar,e.terminated, 120), 10) end as term_date
FROM
ahr_custom.sls.nocorp_ckreg ck
inner join ahr_custom.sls.nocorp_prckreg p ON p.ck_no = ck.ck_no AND p.ck_style = ck.ck_style AND p.company = ck.company
inner join ahr_custom.sls.nocorp_beckreg bck ON p.ck_no = bck.ck_no AND p.ck_style = bck.ck_style AND p.company = bck.company
inner join ahr_custom.sls.nocorp_beneplan b on b.company = bck.company and b.plan_no = bck.plan_no
inner join ahr_custom.sls.nocorp_employee e on e.company = ck.company and e.emp_no = p.emp_no
inner join ahr_custom.sls.nocorp_empbene eb on bck.company = eb.company and e.emp_no = eb.emp_no and eb.plan_no = bck.plan_no
inner join ahr_custom.sls.nocorp_clients c on ck.company = c.company and c.client_no = e.client_no1
WHERE
bck.PLAN_NO IN (20676)
AND p.COMPANY IN ('OK','CA','C2','CO','TX')
and Left(CONVERT(varchar,ck.ck_date,120),10)
between cast(year(getdate()-20) as varchar(4)) +'-'+ (right( '0'
+cast(month(getdate()-20) as varchar(2)),2))+ '-01'
and LEFT( CONVERT(varchar,
ahr_custom.dbo.lastdayofmonth(getdate()-20) , 120), 10)
GROUP BY
e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2 WHEN 3
THEN b.desc_3
WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN b.desc_6
WHEN 7 THEN b.desc_7 ELSE b.desc_8 END
, e.SHORT_NAME, e.SSN
,e.STATUS
,case when e.terminated ='1753-01-01 00:00:00.000' then ' ' else
LEFT( CONVERT(varchar,e.terminated, 120), 10) endHow many rows of data is returned?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<stephen.lee.moore@.gmail.com> wrote in message
news:ac49df7d-bd90-4f6d-b7c8-44012e8e9bb3@.w56g2000hsf.googlegroups.com...
> We're having a weird problem -- a particular report will time out
> after 30 minutes running in Reporting Services. However, if we grab
> the query from Profiler and run it in SSMS, it runs in about 11
> seconds. The profiler trace shows an error of 2 - Abort.
> The query itself is found below -- I won't include DDL because each of
> the items in the FROM clause is a view that is very long.
> Any explanation as to why the query would take so long when running
> from reporting services?
> Our environment -- SQL 2005 Standard x64, SP2 (9.00.3054.00 / Build
> 3790). Running on Windows Server 2003 Enterprise x64 SP2.
> There are some things I'd like to clean up after seeing it, but
> nonetheless it still runs pretty quick in SSMS.
> SELECT
> e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
> ,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2
> WHEN 3 THEN b.desc_3
> WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN
> b.desc_6
> WHEN 7 THEN b.desc_7 ELSE b.desc_8 END AS Plan_Option
> , e.SHORT_NAME, e.SSN
> , SUM(bck.COST)
> , e.STATUS
> ,case when e.terminated ='1753-01-01 00:00:00.000' then ' '
> else LEFT( CONVERT(varchar,e.terminated, 120), 10) end as term_date
> FROM
> ahr_custom.sls.nocorp_ckreg ck
> inner join ahr_custom.sls.nocorp_prckreg p ON p.ck_no => ck.ck_no AND p.ck_style = ck.ck_style AND p.company = ck.company
> inner join ahr_custom.sls.nocorp_beckreg bck ON p.ck_no => bck.ck_no AND p.ck_style = bck.ck_style AND p.company = bck.company
> inner join ahr_custom.sls.nocorp_beneplan b on b.company => bck.company and b.plan_no = bck.plan_no
> inner join ahr_custom.sls.nocorp_employee e on e.company => ck.company and e.emp_no = p.emp_no
> inner join ahr_custom.sls.nocorp_empbene eb on bck.company => eb.company and e.emp_no = eb.emp_no and eb.plan_no = bck.plan_no
> inner join ahr_custom.sls.nocorp_clients c on ck.company => c.company and c.client_no = e.client_no1
> WHERE
> bck.PLAN_NO IN (20676)
> AND p.COMPANY IN ('OK','CA','C2','CO','TX')
> and Left(CONVERT(varchar,ck.ck_date,120),10)
> between cast(year(getdate()-20) as varchar(4)) +'-'+ (right( '0'
> +cast(month(getdate()-20) as varchar(2)),2))+ '-01'
> and LEFT( CONVERT(varchar,
> ahr_custom.dbo.lastdayofmonth(getdate()-20) , 120), 10)
> GROUP BY
> e.COMPANY, b.PLAN_NO, b.DESC_, c.CLIENT, c.CLIENT_NO
> ,CASE eb.option_ WHEN 1 THEN b.desc_1 WHEN 2 THEN b.desc_2 WHEN 3
> THEN b.desc_3
> WHEN 4 THEN b.desc_4 WHEN 5 THEN b.desc_5 WHEN 6 THEN b.desc_6
> WHEN 7 THEN b.desc_7 ELSE b.desc_8 END
> , e.SHORT_NAME, e.SSN
> ,e.STATUS
> ,case when e.terminated ='1753-01-01 00:00:00.000' then ' ' else
> LEFT( CONVERT(varchar,e.terminated, 120), 10) end|||On Dec 4, 11:07 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> How many rows of data is returned?
502 rows|||OK, number of rows is not a problem. My guess is that you are having an
issue with the query plan being different.
First, can you put this in a stored procedure and then call that from both
places and see if that makes a difference?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<stephen.lee.moore@.gmail.com> wrote in message
news:90230c5c-f7c7-4592-8b44-83ce3a381729@.s12g2000prg.googlegroups.com...
> On Dec 4, 11:07 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> How many rows of data is returned?
> 502 rows|||> First, can you put this in a stored procedure and then call that from both
> places and see if that makes a difference?
Wow -- good suggestion! That seemed to fix it.
Any ideas why in the world would a different query plan be generated
from Reporting Services than from SSMS? It seems like either A)
Profiler isn't giving me the right query that's being executed via
Reporting Services or B) different query plans are being generated for
the same SQL statement depending on the calling application. Neither
of those make any sense to me.
Thanks again for your help.|||I have seen this with other people but with stored procedures not SQL. If a
stored procedure acts differently then you can add a With Recompile to fix
the problem. I really don't understand how the same SQL can act different
but that is what I thought was happening to you.
Bruce
<stephen.lee.moore@.gmail.com> wrote in message
news:2cd5adad-6a86-414b-9840-2b3b05e58c31@.j44g2000hsj.googlegroups.com...
>> First, can you put this in a stored procedure and then call that from
>> both
>> places and see if that makes a difference?
> Wow -- good suggestion! That seemed to fix it.
> Any ideas why in the world would a different query plan be generated
> from Reporting Services than from SSMS? It seems like either A)
> Profiler isn't giving me the right query that's being executed via
> Reporting Services or B) different query plans are being generated for
> the same SQL statement depending on the calling application. Neither
> of those make any sense to me.
> Thanks again for your help.

query

Is it possible to design a reporting services report so that you can choose
the parameters that you are after (i.e. selecting from drop downs, etc... to
pass parameters to the underlying sql query)?
ThanksYes it is.
Behold:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_interactive_v1_50fn.asp
"farshad" wrote:
> Is it possible to design a reporting services report so that you can choose
> the parameters that you are after (i.e. selecting from drop downs, etc... to
> pass parameters to the underlying sql query)?
> Thankssql

querstring problem

hi all,
i have a report that i call like this:
http://servername/ReportServer/Pages/ReportViewer.aspx?/Reports/ApplicationsOverviewByTheme&rs:Command=Render&rc:Parameters=false&organ_pkey=2
this works fine.
as soon as i add another parameter to the end, like so:
http://servername/ReportServer/Pages/ReportViewer.aspx?/Reports/ApplicationsOverviewByTheme&rs:Command=Render&rc:Parameters=false&organ_pkey=2&wuser_uid=IHJ8907X1A
it blows up and gives me errors:
Reporting Services Erro
----
For more information about this error navigate to the report server on the
local server machine, or enable remote error
----
SQL Server Reporting Services
the organ_pkey parameter IS used as a report parameter, the wuser_uid is NOT
used currently in the report at all - but we want to keep it for
futureproofability though.
furthermore, how actually do i "enable remote errors" ?
thanks.
t.Seems like you can't just add a parameter name that doesn't exist in the
report. You could create a parameter in the report, called wuser, make it
not prompt the user and allow it to be null and blank. You make it not
prompt the user by just leaving the "Prompt" field blank.
Kaisa M. Lindahl Lervik
"taz" <taz@.discussions.microsoft.com> wrote in message
news:14BA863F-331C-42A3-8260-8C061E268AC8@.microsoft.com...
> hi all,
> i have a report that i call like this:
> http://servername/ReportServer/Pages/ReportViewer.aspx?/Reports/ApplicationsOverviewByTheme&rs:Command=Render&rc:Parameters=false&organ_pkey=2
> this works fine.
> as soon as i add another parameter to the end, like so:
> http://servername/ReportServer/Pages/ReportViewer.aspx?/Reports/ApplicationsOverviewByTheme&rs:Command=Render&rc:Parameters=false&organ_pkey=2&wuser_uid=IHJ8907X1A
> it blows up and gives me errors:
> Reporting Services Error
> ----
> For more information about this error navigate to the report server on the
> local server machine, or enable remote errors
> ----
> SQL Server Reporting Services
>
> the organ_pkey parameter IS used as a report parameter, the wuser_uid is
> NOT
> used currently in the report at all - but we want to keep it for
> futureproofability though.
> furthermore, how actually do i "enable remote errors" ?
> thanks.
> t.
>sql

Queries in mulitiple places

I have many reports in one project and I am using the same query in a few of
the reports. How can I set the query in one place and have my report call
that query? Is that possible? If so, does anyone have an example?Yes, make the query a stored procedure.
Rodney
"David" <dilworth@.newsgroups.nospam> wrote in message
news:AB449D8E-A300-48A8-A3F7-4F8E275BD1DF@.microsoft.com...
>I have many reports in one project and I am using the same query in a few
>of
> the reports. How can I set the query in one place and have my report call
> that query? Is that possible? If so, does anyone have an example?
>|||Unfortunately the answer is no. I too have queries I use multiple places,
especially for parameter lists. The best you can do is create a stored
procedure and use that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:AB449D8E-A300-48A8-A3F7-4F8E275BD1DF@.microsoft.com...
>I have many reports in one project and I am using the same query in a few
>of
> the reports. How can I set the query in one place and have my report call
> that query? Is that possible? If so, does anyone have an example?
>|||Hi David,
As other members have suggested, we may consider encapsulate the query in a
store procedure to reuse it. As RS report layer, we can only reuse a
certain DataSource/DataSet rather than an individual query.
Regards,
Steven Cheng
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Queries against Analysis Server executed several times in SSRS

Using Reporting Services 2005 with SSAS 2005 I have a report working with
some parameters. In queries for the parameters some default values were
calculated. E.g. the current date. Then these values were used as input to
create mdx statements. Parameters!kdjfaj.value
When watching what is happening on the SSAS Server with SQL Profiler I
watched the queries executing SEVERAL times ("query begin" as event class).
Is this a normal behaviour of Reporting Services?
Or is it just a gag of the Profiler Tool to repeat the queries in time?
Or is this depending on the order of the datasets for the report? If this
would be the case - how could I change the order of execution of the dataset
queries?
Best regards,
StefoonI have a similar problem. I have a report created in Visual Studio
based on a querry that retrieves data.
Today however we found a need to count how many times rhis report was
printed. Piece of cake I thought just put an UPDATE query at the botom
of the querry that retrieves data.
tested my simple UPDATE Invoice.ReminderNo = Invoice.ReminderNo + 1 in
managment studio and it worked as i shoud.
But when i tried running the report it suddenly added 10. so I put in
another UPDATE that added one letter/execution to a text field. sure
anough 10 pretty A:s.
The query contains 5 separate datasets and is run 10 times when i
render my report. I find that to striking to be a coincidence. I
believe that the querry is run twice/dataset.
How many datasets do you have, how many times is the querry run?
On 1 Mar, 14:25, Stefoon23 <Stefoo...@.discussions.microsoft.com>
wrote:
> Using Reporting Services 2005 with SSAS 2005 I have a report working with
> some parameters. In queries for the parameters some default values were
> calculated. E.g. the current date. Then these values were used as input to
> create mdx statements. Parameters!kdjfaj.value
> When watching what is happening on the SSAS Server with SQL Profiler I
> watched the queries executingSEVERALtimes("querybegin" as event class).
> Is this a normal behaviour of Reporting Services?
> Or is it just a gag of the Profiler Tool to repeat the queries in time?
> Or is this depending on the order of the datasets for the report? If this
> would be the case - how could I change the order of execution of the dataset
> queries?
> Best regards,
> Stefoon|||Hi Markus,
the proportion is about the same. It seems that any query is executed 2
times.
I understand, that the parameter queries could run several times if you have
cascading picklists or something, but the query for the report's data?
Very mysterious.
Stefoon
"markus.rohsto@.gmail.com" wrote:
> I have a similar problem. I have a report created in Visual Studio
> based on a querry that retrieves data.
> Today however we found a need to count how many times rhis report was
> printed. Piece of cake I thought just put an UPDATE query at the botom
> of the querry that retrieves data.
> tested my simple UPDATE Invoice.ReminderNo = Invoice.ReminderNo + 1 in
> managment studio and it worked as i shoud.
> But when i tried running the report it suddenly added 10. so I put in
> another UPDATE that added one letter/execution to a text field. sure
> anough 10 pretty A:s.
> The query contains 5 separate datasets and is run 10 times when i
> render my report. I find that to striking to be a coincidence. I
> believe that the querry is run twice/dataset.
> How many datasets do you have, how many times is the querry run?
> On 1 Mar, 14:25, Stefoon23 <Stefoo...@.discussions.microsoft.com>
> wrote:
> > Using Reporting Services 2005 with SSAS 2005 I have a report working with
> > some parameters. In queries for the parameters some default values were
> > calculated. E.g. the current date. Then these values were used as input to
> > create mdx statements. Parameters!kdjfaj.value
> > When watching what is happening on the SSAS Server with SQL Profiler I
> > watched the queries executingSEVERALtimes("querybegin" as event class).
> > Is this a normal behaviour of Reporting Services?
> > Or is it just a gag of the Profiler Tool to repeat the queries in time?
> >
> > Or is this depending on the order of the datasets for the report? If this
> > would be the case - how could I change the order of execution of the dataset
> > queries?
> >
> > Best regards,
> > Stefoon
>
>

Queried parameters

Hello,

I need to be able to set the date parameters of a report dynamically when it is run based on system time. The problem I am having is being able to compare the dates (StartDate & EndDate) against [Service Date 1]. Essentially this report will only pull the current month's data.

The date fields being created with the GETDATE, DATEADD & DATEDIFF functions are working correctly. Do I need to create a separate dataset to be able to run the parameters automatically in the actual report?

Any help would be greatly appreciated!

SELECT TodaysDate =GetDate()-2,dbo.[Billing Detail].[Service Date 1], DATEADD(mm, DATEDIFF(mm, 0, DATEADD(yy, 0, GETDATE())), 0) AS StartDate, DATEADD(dd, - 1, DATEADD(mm, DATEDIFF(mm, -1, GETDATE()), 0)) AS EndDate, dbo.[Billing Detail].Billing, dbo.[Billing Detail].Chart, dbo.[Billing Detail].Item,
dbo.[Billing Detail].[Sub Item], dbo.Patient.[Patient Code], dbo.Patient.[Patient Type], dbo.[Billing Header].Charges, dbo.Practice.Name
FROM dbo.[Billing Detail] INNER JOIN
dbo.Patient ON dbo.[Billing Detail].Chart = dbo.Patient.[Chart Number] INNER JOIN
dbo.[Billing Header] ON dbo.[Billing Detail].Billing = dbo.[Billing Header].Billing CROSS JOIN
dbo.Practice
WHERE (dbo.[Billing Detail].Item = 0) AND (dbo.[Billing Detail].[Sub Item] = 0) AND (dbo.[Billing Detail].[Service Date 1] Between StartDate AND EndDate

Phorest,

You should be able to add the parameters to your query. If you are going against SQL Server, you can replace your parameters with @.StartDate AND @.EndDate. Then in the properies of the dataset, you can assign those parameters to Parameters!StartDate.Value and Parameters!EndDate.Value, respectively.

Jessica

|||

Thanks for your reply!

OK,

I think what I need to do is write the expression as a non-queried default value. However when I paste in what I know works in SQL Management Studio it returns an error "Name 'mm' is not declared"

<@.StartDate> =DATEADD(mm, DATEDIFF(mm, 0, DATEADD(yy, 0, GETDATE())), 0)

<@.EndDate> =DATEADD(dd, - 1, DATEADD(mm, DATEDIFF(mm, -1, GETDATE()), 0))

I tried putting an integer after DATEADD(mm, X , 102 DATEDIFF... but i can't get beyond intellisense. How can I fix my expression to work with Reporting Services?

What I need is to have expressions to choose the first day of the month to the last day of the same month compared to NOW()

|||

Apparently that is the trick to use non-queried default values as an expression, However what I posted yesterday will not work as an expression due to the expressions limitations in SSRS:

<@.StartDate> =DATEADD(mm, DATEDIFF(mm, 0, DATEADD(yy, 0, GETDATE())), 0)

<@.EndDate> =DATEADD(dd, - 1, DATEADD(mm, DATEDIFF(mm, -1, GETDATE()), 0))

Now I am using:

<@.StartDate> =DATEADD("D", -30, NOW())

<@.EndDate> =DATEADD("D", 1, NOW())

After much searching and experimentation I can get this to work well, but it isn't exactly what I want. Does any one have any tips as to being able to write the expression to select the first day of the current month and last day of the month?

It seems to be just beyond my grasp at this time...

Thanks!

|||

Phorest,

I'm afraid I misunderstood what you're trying to do. If you want a query that returns rows where the [Billing Detail].[Service Date 1] is between the start and the end of the current month, you can do that all in SQL.

It would look something similar to:

WHERE dbo.[Billing Detail].[Service Date 1]

BETWEEN dateadd(mm, datediff(mm,0,getdate()), 0)

AND dateadd(ms,-3,dateadd(mm, datediff(m,0,getdate() ) + 1, 0))

Does that work for you?

Jessica

|||

I'll have to try that in the SQL, though I was more after an expression more as a datetime datatype so it picks all the dates in the current month only and the user can then adjust the parameter manually after the initial running of the report if they so choose.

Thanks!

|||

I found what I was looking for here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1581230&SiteID=1

In the Report Parameters properties I set the DataType to DateTime and using the Default Values, Non-Queried radio button set the expressions like the following:

@.StartDate =DateSerial(Year(NOW()), Month(NOW)) +0,1) gives me the first date of the current month.

@.EndDate =DateSerial(Year(NOW()), Month(NOW)) +1,0) gives me the last date of the current month.

All is wellnow!

Quarterly Schedule Fails

My data driven report has been scheduled to send last quarters data on the
fifth day of a new quarter.
I set the schedule to send:
Monthly for: Jan, April, July, Oct and on
Calendar Day: 5 at 2am.
For some reason I received the report today, which happens to be May 5.
What am I doing wrong?I also check the system date on the Reporting Services Server, so that's not
the problem. Is there another way to schedule Quarterly report delivery?
"John Broomfield" wrote:
> My data driven report has been scheduled to send last quarters data on the
> fifth day of a new quarter.
> I set the schedule to send:
> Monthly for: Jan, April, July, Oct and on
> Calendar Day: 5 at 2am.
> For some reason I received the report today, which happens to be May 5.
> What am I doing wrong?
>

Quarterly Chart

Hi, i have a table with column for quarter and year (just like the sample Report - Company Sales).
now, i'm trying to create a chart which shows the quarter as the series group /x-axis... how can i show the label of the quarter and the year. currently, it can only use either year or quarter.
so, what i want the x-axis label to be like this:
e.g. Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
2003 2004If you want the quarter to show up on the x-axis, then it has to be a
category group, not a series group. Just use two category groupings (one for
quarter, one for year) and you should get the desired labels.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel" <Daniel@.discussions.microsoft.com> wrote in message
news:9E9728F2-00BA-4ABB-9B38-9C5ECEBC3A10@.microsoft.com...
> Hi, i have a table with column for quarter and year (just like the sample
Report - Company Sales).
> now, i'm trying to create a chart which shows the quarter as the series
group /x-axis... how can i show the label of the quarter and the year.
currently, it can only use either year or quarter.
> so, what i want the x-axis label to be like this:
> e.g. Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
> 2003 2004|||ah yes, i meant the category. however, the label can only show either quarter or year. not both.
i need to differentiate between the first q1 and the second q1. I can only put on field for the 'label'. if i leave it blank, it will only show it by the quarter.
"Robert Bruckner [MSFT]" wrote:
> If you want the quarter to show up on the x-axis, then it has to be a
> category group, not a series group. Just use two category groupings (one for
> quarter, one for year) and you should get the desired labels.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Daniel" <Daniel@.discussions.microsoft.com> wrote in message
> news:9E9728F2-00BA-4ABB-9B38-9C5ECEBC3A10@.microsoft.com...
> > Hi, i have a table with column for quarter and year (just like the sample
> Report - Company Sales).
> > now, i'm trying to create a chart which shows the quarter as the series
> group /x-axis... how can i show the label of the quarter and the year.
> currently, it can only use either year or quarter.
> >
> > so, what i want the x-axis label to be like this:
> > e.g. Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
> > 2003 2004
>
>|||Please try and investigate the attached example which gives you two levels
of groupings on the category axis (inner level: month, outer level: year).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="TotalSalesByYear">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style />
<Legend>
<Visible>true</Visible>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<Color>Brown</Color>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UnitPrice.Value *
Fields!Quantity.Value)</Value>
</DataValue>
</DataValues>
<DataLabel />
<Marker>
<Type>Circle</Type>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=(Sum(Fields!UnitPrice.Value *
Fields!Quantity.Value)+8000)*1.15</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style />
<Visible>true</Visible>
</DataLabel>
<Marker>
<Type>Diamond</Type>
<Size>10pt</Size>
</Marker>
</DataPoint>
</DataPoints>
<PlotType>Line</PlotType>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title>
<Style />
</Title>
<Style />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Margin>true</Margin>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>Northwind</DataSetName>
<PointWidth>100</PointWidth>
<Type>Line</Type>
<Title>
<Caption>Sales / Cost</Caption>
<Style>
<FontSize>14pt</FontSize>
<FontWeight>700</FontWeight>
</Style>
</Title>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="YearGroup">
<GroupExpressions>
<GroupExpression>=Year(Fields!OrderDate.Value)</GroupExpression>
</GroupExpressions>
</Grouping>
<Label />
</DynamicCategories>
</CategoryGrouping>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="MonthGroup">
<GroupExpressions>
<GroupExpression>=Month(Fields!OrderDate.Value)</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!OrderDate.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=MonthName(Month(Fields!OrderDate.Value))</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Height>6.125in</Height>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Cost</Label>
</StaticMember>
<StaticMember>
<Label>Sales</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundGradientEndColor>White</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title>
<Style />
</Title>
<Style />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<MinorTickMarks>Outside</MinorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>6.5in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>da5964d0-11a7-4e51-9b22-cc4fa55fdd7a</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=(local);initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>7.625in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="Quantity">
<DataField>Quantity</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="OrderDate">
<DataField>OrderDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="OrderID">
<DataField>OrderID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT dbo.[Order Details].UnitPrice, dbo.[Order
Details].Quantity, dbo.Orders.OrderDate, dbo.Orders.OrderID
FROM dbo.Orders INNER JOIN
dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order
Details].OrderID</CommandText>
<Timeout>30</Timeout>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>bc811835-2302-4f9e-9c89-a99d4d3f5fd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
</Report>|||got it... i didn't pay attention to the category groups, instead i put it in the group on inside the category group.
"Robert Bruckner [MSFT]" wrote:
> Please try and investigate the attached example which gives you two levels
> of groupings on the category axis (inner level: month, outer level: year).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Chart Name="TotalSalesByYear">
> <ThreeDProperties>
> <Rotation>30</Rotation>
> <Inclination>30</Inclination>
> <Shading>Simple</Shading>
> <WallThickness>50</WallThickness>
> </ThreeDProperties>
> <Style />
> <Legend>
> <Visible>true</Visible>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> <Color>Brown</Color>
> </Style>
> <Position>RightCenter</Position>
> </Legend>
> <Palette>Default</Palette>
> <ChartData>
> <ChartSeries>
> <DataPoints>
> <DataPoint>
> <DataValues>
> <DataValue>
> <Value>=Sum(Fields!UnitPrice.Value *
> Fields!Quantity.Value)</Value>
> </DataValue>
> </DataValues>
> <DataLabel />
> <Marker>
> <Type>Circle</Type>
> <Size>6pt</Size>
> </Marker>
> </DataPoint>
> </DataPoints>
> </ChartSeries>
> <ChartSeries>
> <DataPoints>
> <DataPoint>
> <DataValues>
> <DataValue>
> <Value>=(Sum(Fields!UnitPrice.Value *
> Fields!Quantity.Value)+8000)*1.15</Value>
> </DataValue>
> </DataValues>
> <DataLabel>
> <Style />
> <Visible>true</Visible>
> </DataLabel>
> <Marker>
> <Type>Diamond</Type>
> <Size>10pt</Size>
> </Marker>
> </DataPoint>
> </DataPoints>
> <PlotType>Line</PlotType>
> </ChartSeries>
> </ChartData>
> <CategoryAxis>
> <Axis>
> <Title>
> <Style />
> </Title>
> <Style />
> <MajorGridLines>
> <ShowGridLines>true</ShowGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MajorGridLines>
> <MinorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MinorGridLines>
> <MajorTickMarks>Outside</MajorTickMarks>
> <Margin>true</Margin>
> <Visible>true</Visible>
> </Axis>
> </CategoryAxis>
> <DataSetName>Northwind</DataSetName>
> <PointWidth>100</PointWidth>
> <Type>Line</Type>
> <Title>
> <Caption>Sales / Cost</Caption>
> <Style>
> <FontSize>14pt</FontSize>
> <FontWeight>700</FontWeight>
> </Style>
> </Title>
> <CategoryGroupings>
> <CategoryGrouping>
> <DynamicCategories>
> <Grouping Name="YearGroup">
> <GroupExpressions>
> <GroupExpression>=Year(Fields!OrderDate.Value)</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Label />
> </DynamicCategories>
> </CategoryGrouping>
> <CategoryGrouping>
> <DynamicCategories>
> <Grouping Name="MonthGroup">
> <GroupExpressions>
> <GroupExpression>=Month(Fields!OrderDate.Value)</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Sorting>
> <SortBy>
> <SortExpression>=Fields!OrderDate.Value</SortExpression>
> <Direction>Ascending</Direction>
> </SortBy>
> </Sorting>
> <Label>=MonthName(Month(Fields!OrderDate.Value))</Label>
> </DynamicCategories>
> </CategoryGrouping>
> </CategoryGroupings>
> <Height>6.125in</Height>
> <SeriesGroupings>
> <SeriesGrouping>
> <StaticSeries>
> <StaticMember>
> <Label>Cost</Label>
> </StaticMember>
> <StaticMember>
> <Label>Sales</Label>
> </StaticMember>
> </StaticSeries>
> </SeriesGrouping>
> </SeriesGroupings>
> <Subtype>Plain</Subtype>
> <PlotArea>
> <Style>
> <BackgroundGradientEndColor>White</BackgroundGradientEndColor>
> <BackgroundGradientType>TopBottom</BackgroundGradientType>
> <BackgroundColor>LightGrey</BackgroundColor>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </PlotArea>
> <ValueAxis>
> <Axis>
> <Title>
> <Style />
> </Title>
> <Style />
> <MajorGridLines>
> <ShowGridLines>true</ShowGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MajorGridLines>
> <MinorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MinorGridLines>
> <MajorTickMarks>Outside</MajorTickMarks>
> <MinorTickMarks>Outside</MinorTickMarks>
> <Min>0</Min>
> <Visible>true</Visible>
> <Scalar>true</Scalar>
> </Axis>
> </ValueAxis>
> </Chart>
> </ReportItems>
> <Style />
> <Height>6.5in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="Northwind">
> <rd:DataSourceID>da5964d0-11a7-4e51-9b22-cc4fa55fdd7a</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>data source=(local);initial
> catalog=Northwind</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>7.625in</Width>
> <DataSets>
> <DataSet Name="Northwind">
> <Fields>
> <Field Name="UnitPrice">
> <DataField>UnitPrice</DataField>
> <rd:TypeName>System.Decimal</rd:TypeName>
> </Field>
> <Field Name="Quantity">
> <DataField>Quantity</DataField>
> <rd:TypeName>System.Int16</rd:TypeName>
> </Field>
> <Field Name="OrderDate">
> <DataField>OrderDate</DataField>
> <rd:TypeName>System.DateTime</rd:TypeName>
> </Field>
> <Field Name="OrderID">
> <DataField>OrderID</DataField>
> <rd:TypeName>System.Int32</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>Northwind</DataSourceName>
> <CommandText>SELECT dbo.[Order Details].UnitPrice, dbo.[Order
> Details].Quantity, dbo.Orders.OrderDate, dbo.Orders.OrderID
> FROM dbo.Orders INNER JOIN
> dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order
> Details].OrderID</CommandText>
> <Timeout>30</Timeout>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>bc811835-2302-4f9e-9c89-a99d4d3f5fd2</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> </Report>
>
>

Quarter() function in SSRS

I am uisng VS 2005 to build reports for SQL 2005. The problem is with getting the Quarter() function, mentioned in the BOL, to work in the report builder. When I build an expression and try to use the function as noted in the BOL I receive an error stating that the name "Quarter" is not declaired. When I use the expression builder to build the expression the function is not available in the builder, which is probably why I get the error.

I am assuming there is some sort of service pack of hot fix I need to apply to my VS but have not been able to locate which one. I have verified that I have all of the recent service packs applied for VS and SQL server 2005 but I am still unable to see/use this function.

Any help would be greatly appreciated. I need this function for my financial reports.

Using the QUARTER(datetime) function does not seem to be available in SQL 2005 SSRS;

=Quarter(today())

Results in an error.

After playing with the date part function I was able to resolve my problem. If you are having a similar problem use the following function to extract the quarter from a date

=DatePart(DateInterval.Quarter,today())

Replace Today() with the date you want to get the value for. You can test this by creating a report and placing a textbox anywhere on the report and setting the above code as the expression for the value of the textbox.

Quality Control

Does RS2005 have any quality control mechanisms. Can a report be edited once
its rendered and posted to the report server? For example, my report could
have a paragraph describing some aspect of the report. Could this paragraph
be manually edited?
Thank You - mcOnce the report is published it will continue to be rendered with regards to
the published RDL. However, you can always update the rdl and republish it
on top of the old RDL changing what users see.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> Does RS2005 have any quality control mechanisms. Can a report be edited
> once
> its rendered and posted to the report server? For example, my report
> could
> have a paragraph describing some aspect of the report. Could this
> paragraph
> be manually edited?
> Thank You - mc|||Hi Daniel, thank you for the response. Could you also answer the following?
What if the user was responsible for editing the report? For example, a
user logs in to review the report and wants to make a change? Can the rdl
be updated while viewing the report or would this require a custom
application to make changes?
This leads to another question. Does "re-publishing" track versions or
would it simply be like running another report?
Thanks - mc
"Daniel Reib [MSFT]" wrote:
> Once the report is published it will continue to be rendered with regards to
> the published RDL. However, you can always update the rdl and republish it
> on top of the old RDL changing what users see.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> > Does RS2005 have any quality control mechanisms. Can a report be edited
> > once
> > its rendered and posted to the report server? For example, my report
> > could
> > have a paragraph describing some aspect of the report. Could this
> > paragraph
> > be manually edited?
> >
> > Thank You - mc
>
>|||No the user would not be able to edit the reports while viewing them. If
the user has the correct permission they could download the rdl from Report
Manager and edit the report in Report Designer, but I don't imagine this is
what you want.
Republishing does not track versions. You can create history snapshots of
the report which can be saved and viewed later. You can't trigger them on
publish but can on some other events.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> Hi Daniel, thank you for the response. Could you also answer the
> following?
> What if the user was responsible for editing the report? For example, a
> user logs in to review the report and wants to make a change? Can the
> rdl
> be updated while viewing the report or would this require a custom
> application to make changes?
> This leads to another question. Does "re-publishing" track versions or
> would it simply be like running another report?
> Thanks - mc
>
>
> "Daniel Reib [MSFT]" wrote:
>> Once the report is published it will continue to be rendered with regards
>> to
>> the published RDL. However, you can always update the rdl and republish
>> it
>> on top of the old RDL changing what users see.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> > Does RS2005 have any quality control mechanisms. Can a report be
>> > edited
>> > once
>> > its rendered and posted to the report server? For example, my report
>> > could
>> > have a paragraph describing some aspect of the report. Could this
>> > paragraph
>> > be manually edited?
>> >
>> > Thank You - mc
>>|||No, it would not be feasible for the user to edit the rdl. I would have to
come up with a way to allow the users to make changes or flag the report for
a custom system to allow changes. Any suggestions?
"Daniel Reib [MSFT]" wrote:
> No the user would not be able to edit the reports while viewing them. If
> the user has the correct permission they could download the rdl from Report
> Manager and edit the report in Report Designer, but I don't imagine this is
> what you want.
> Republishing does not track versions. You can create history snapshots of
> the report which can be saved and viewed later. You can't trigger them on
> publish but can on some other events.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> > Hi Daniel, thank you for the response. Could you also answer the
> > following?
> >
> > What if the user was responsible for editing the report? For example, a
> > user logs in to review the report and wants to make a change? Can the
> > rdl
> > be updated while viewing the report or would this require a custom
> > application to make changes?
> >
> > This leads to another question. Does "re-publishing" track versions or
> > would it simply be like running another report?
> >
> > Thanks - mc
> >
> >
> >
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Once the report is published it will continue to be rendered with regards
> >> to
> >> the published RDL. However, you can always update the rdl and republish
> >> it
> >> on top of the old RDL changing what users see.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> > edited
> >> > once
> >> > its rendered and posted to the report server? For example, my report
> >> > could
> >> > have a paragraph describing some aspect of the report. Could this
> >> > paragraph
> >> > be manually edited?
> >> >
> >> > Thank You - mc
> >>
> >>
> >>
>
>|||It really depends on how complex the changes are that users can make. If
they are trivial text changes you could write an app using the ReportViewer
control to display the report. You could then have an edit button and build
a simple designer that allows them to change only elements you wish.
If you just want to flag the report then all RS catalog items have a generic
property bag associated with them. You could have the users set some
property to flag that the report needs updating.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> No, it would not be feasible for the user to edit the rdl. I would have
> to
> come up with a way to allow the users to make changes or flag the report
> for
> a custom system to allow changes. Any suggestions?
>
> "Daniel Reib [MSFT]" wrote:
>> No the user would not be able to edit the reports while viewing them. If
>> the user has the correct permission they could download the rdl from
>> Report
>> Manager and edit the report in Report Designer, but I don't imagine this
>> is
>> what you want.
>> Republishing does not track versions. You can create history snapshots
>> of
>> the report which can be saved and viewed later. You can't trigger them
>> on
>> publish but can on some other events.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
>> > Hi Daniel, thank you for the response. Could you also answer the
>> > following?
>> >
>> > What if the user was responsible for editing the report? For example,
>> > a
>> > user logs in to review the report and wants to make a change? Can the
>> > rdl
>> > be updated while viewing the report or would this require a custom
>> > application to make changes?
>> >
>> > This leads to another question. Does "re-publishing" track versions or
>> > would it simply be like running another report?
>> >
>> > Thanks - mc
>> >
>> >
>> >
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Once the report is published it will continue to be rendered with
>> >> regards
>> >> to
>> >> the published RDL. However, you can always update the rdl and
>> >> republish
>> >> it
>> >> on top of the old RDL changing what users see.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> >> > Does RS2005 have any quality control mechanisms. Can a report be
>> >> > edited
>> >> > once
>> >> > its rendered and posted to the report server? For example, my
>> >> > report
>> >> > could
>> >> > have a paragraph describing some aspect of the report. Could this
>> >> > paragraph
>> >> > be manually edited?
>> >> >
>> >> > Thank You - mc
>> >>
>> >>
>> >>
>>|||Yes your explanation helped, Thank You!
On a side note, would you have any input into the following
1) Is it possible to create a report template containing text that would
be evaluated at runtime by a sql query? For example, the text in my
reports need to cater to various languages. Can I configure a textbox to
look up a value when the report is run?
2) How flexible are the graphing capabilities? Can you a third party
package be used to create graphs as long as the rdl file is constructed
properly?
3) Does RS provide a good audit mechanism for logging and tracking reports?
Thanks again - mc
"Daniel Reib [MSFT]" wrote:
> It really depends on how complex the changes are that users can make. If
> they are trivial text changes you could write an app using the ReportViewer
> control to display the report. You could then have an edit button and build
> a simple designer that allows them to change only elements you wish.
> If you just want to flag the report then all RS catalog items have a generic
> property bag associated with them. You could have the users set some
> property to flag that the report needs updating.
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> > No, it would not be feasible for the user to edit the rdl. I would have
> > to
> > come up with a way to allow the users to make changes or flag the report
> > for
> > a custom system to allow changes. Any suggestions?
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> No the user would not be able to edit the reports while viewing them. If
> >> the user has the correct permission they could download the rdl from
> >> Report
> >> Manager and edit the report in Report Designer, but I don't imagine this
> >> is
> >> what you want.
> >>
> >> Republishing does not track versions. You can create history snapshots
> >> of
> >> the report which can be saved and viewed later. You can't trigger them
> >> on
> >> publish but can on some other events.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> >> > Hi Daniel, thank you for the response. Could you also answer the
> >> > following?
> >> >
> >> > What if the user was responsible for editing the report? For example,
> >> > a
> >> > user logs in to review the report and wants to make a change? Can the
> >> > rdl
> >> > be updated while viewing the report or would this require a custom
> >> > application to make changes?
> >> >
> >> > This leads to another question. Does "re-publishing" track versions or
> >> > would it simply be like running another report?
> >> >
> >> > Thanks - mc
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Once the report is published it will continue to be rendered with
> >> >> regards
> >> >> to
> >> >> the published RDL. However, you can always update the rdl and
> >> >> republish
> >> >> it
> >> >> on top of the old RDL changing what users see.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> >> > edited
> >> >> > once
> >> >> > its rendered and posted to the report server? For example, my
> >> >> > report
> >> >> > could
> >> >> > have a paragraph describing some aspect of the report. Could this
> >> >> > paragraph
> >> >> > be manually edited?
> >> >> >
> >> >> > Thank You - mc
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I can answer the question 3 for you. RS writes every report execution in
the ExecutionLog Table. This table is purged every 30 days. We have
provided some DTS packages for extracting the data to another DB for long
term storage that you would want to take advantage of.
Here is a link describing the process:
http://msdn2.microsoft.com/library/ms159110.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:C1756736-E8F2-469C-B524-4C934AF8F9CE@.microsoft.com...
> Yes your explanation helped, Thank You!
> On a side note, would you have any input into the following
> 1) Is it possible to create a report template containing text that would
> be evaluated at runtime by a sql query? For example, the text in my
> reports need to cater to various languages. Can I configure a textbox to
> look up a value when the report is run?
> 2) How flexible are the graphing capabilities? Can you a third party
> package be used to create graphs as long as the rdl file is constructed
> properly?
>
> 3) Does RS provide a good audit mechanism for logging and tracking
> reports?
>
> Thanks again - mc
> "Daniel Reib [MSFT]" wrote:
>> It really depends on how complex the changes are that users can make. If
>> they are trivial text changes you could write an app using the
>> ReportViewer
>> control to display the report. You could then have an edit button and
>> build
>> a simple designer that allows them to change only elements you wish.
>> If you just want to flag the report then all RS catalog items have a
>> generic
>> property bag associated with them. You could have the users set some
>> property to flag that the report needs updating.
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
>> > No, it would not be feasible for the user to edit the rdl. I would
>> > have
>> > to
>> > come up with a way to allow the users to make changes or flag the
>> > report
>> > for
>> > a custom system to allow changes. Any suggestions?
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> No the user would not be able to edit the reports while viewing them.
>> >> If
>> >> the user has the correct permission they could download the rdl from
>> >> Report
>> >> Manager and edit the report in Report Designer, but I don't imagine
>> >> this
>> >> is
>> >> what you want.
>> >>
>> >> Republishing does not track versions. You can create history
>> >> snapshots
>> >> of
>> >> the report which can be saved and viewed later. You can't trigger
>> >> them
>> >> on
>> >> publish but can on some other events.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
>> >> > Hi Daniel, thank you for the response. Could you also answer the
>> >> > following?
>> >> >
>> >> > What if the user was responsible for editing the report? For
>> >> > example,
>> >> > a
>> >> > user logs in to review the report and wants to make a change? Can
>> >> > the
>> >> > rdl
>> >> > be updated while viewing the report or would this require a custom
>> >> > application to make changes?
>> >> >
>> >> > This leads to another question. Does "re-publishing" track versions
>> >> > or
>> >> > would it simply be like running another report?
>> >> >
>> >> > Thanks - mc
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Once the report is published it will continue to be rendered with
>> >> >> regards
>> >> >> to
>> >> >> the published RDL. However, you can always update the rdl and
>> >> >> republish
>> >> >> it
>> >> >> on top of the old RDL changing what users see.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
>> >> >> > edited
>> >> >> > once
>> >> >> > its rendered and posted to the report server? For example, my
>> >> >> > report
>> >> >> > could
>> >> >> > have a paragraph describing some aspect of the report. Could
>> >> >> > this
>> >> >> > paragraph
>> >> >> > be manually edited?
>> >> >> >
>> >> >> > Thank You - mc
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks again for your help!!
"Daniel Reib [MSFT]" wrote:
> I can answer the question 3 for you. RS writes every report execution in
> the ExecutionLog Table. This table is purged every 30 days. We have
> provided some DTS packages for extracting the data to another DB for long
> term storage that you would want to take advantage of.
> Here is a link describing the process:
> http://msdn2.microsoft.com/library/ms159110.aspx
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:C1756736-E8F2-469C-B524-4C934AF8F9CE@.microsoft.com...
> > Yes your explanation helped, Thank You!
> >
> > On a side note, would you have any input into the following
> >
> > 1) Is it possible to create a report template containing text that would
> > be evaluated at runtime by a sql query? For example, the text in my
> > reports need to cater to various languages. Can I configure a textbox to
> > look up a value when the report is run?
> >
> > 2) How flexible are the graphing capabilities? Can you a third party
> > package be used to create graphs as long as the rdl file is constructed
> > properly?
> >
> >
> > 3) Does RS provide a good audit mechanism for logging and tracking
> > reports?
> >
> >
> > Thanks again - mc
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> It really depends on how complex the changes are that users can make. If
> >> they are trivial text changes you could write an app using the
> >> ReportViewer
> >> control to display the report. You could then have an edit button and
> >> build
> >> a simple designer that allows them to change only elements you wish.
> >>
> >> If you just want to flag the report then all RS catalog items have a
> >> generic
> >> property bag associated with them. You could have the users set some
> >> property to flag that the report needs updating.
> >>
> >> I hope that helps.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> >> > No, it would not be feasible for the user to edit the rdl. I would
> >> > have
> >> > to
> >> > come up with a way to allow the users to make changes or flag the
> >> > report
> >> > for
> >> > a custom system to allow changes. Any suggestions?
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> No the user would not be able to edit the reports while viewing them.
> >> >> If
> >> >> the user has the correct permission they could download the rdl from
> >> >> Report
> >> >> Manager and edit the report in Report Designer, but I don't imagine
> >> >> this
> >> >> is
> >> >> what you want.
> >> >>
> >> >> Republishing does not track versions. You can create history
> >> >> snapshots
> >> >> of
> >> >> the report which can be saved and viewed later. You can't trigger
> >> >> them
> >> >> on
> >> >> publish but can on some other events.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> >> >> > Hi Daniel, thank you for the response. Could you also answer the
> >> >> > following?
> >> >> >
> >> >> > What if the user was responsible for editing the report? For
> >> >> > example,
> >> >> > a
> >> >> > user logs in to review the report and wants to make a change? Can
> >> >> > the
> >> >> > rdl
> >> >> > be updated while viewing the report or would this require a custom
> >> >> > application to make changes?
> >> >> >
> >> >> > This leads to another question. Does "re-publishing" track versions
> >> >> > or
> >> >> > would it simply be like running another report?
> >> >> >
> >> >> > Thanks - mc
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Once the report is published it will continue to be rendered with
> >> >> >> regards
> >> >> >> to
> >> >> >> the published RDL. However, you can always update the rdl and
> >> >> >> republish
> >> >> >> it
> >> >> >> on top of the old RDL changing what users see.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> >> >> > edited
> >> >> >> > once
> >> >> >> > its rendered and posted to the report server? For example, my
> >> >> >> > report
> >> >> >> > could
> >> >> >> > have a paragraph describing some aspect of the report. Could
> >> >> >> > this
> >> >> >> > paragraph
> >> >> >> > be manually edited?
> >> >> >> >
> >> >> >> > Thank You - mc
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Qaurterly Report

Hi everyone,

I'm currently using Visual Web Developer 2005 Express Edition, I have a chart that shows everything The Y axis displays the quantity and X axis shows the month.Well, the X axis I grouped it by month, but i want to set jan-march as q1 and so on.How can I format it, or do so it can display that format?

Thanks ahead of time,
Shuy

It would be easy if you could populate the data from the backend. You could group the data for three months and send the database back to the front end.

|||

If you mean to change the output in some text field based on a column result, you can use IIF to make that change:

= IIF(Fields!Column.Value) = "Quarter1", "Jan-Mar",IIF(Fields!Column.Value) = "Quarter2", "Apr-Jun", IIF(Fields!Column.Value) = "Quarter3", "Jul-Sep", "Oct-Dec")

|||

Thanks so much...just what i needed.

q; users in RS2005

How do you set up user as who can access what report in Report Manger. I do
not see security tab in RS2005.Hi,
you have to configure the security in two step. the first one, in the Site
setting to map NT user with your RS group and in a second time, in the
properties of your report . For each report you have à security tab to
configure witch RS role for your user.
"JIM.H." <JIMH@.discussions.microsoft.com> a écrit dans le message de
news:15A95DA7-C2D4-4315-BEC8-142CA8625A53@.microsoft.com...
> How do you set up user as who can access what report in Report Manger. I
> do
> not see security tab in RS2005.
>|||Thanks for the response. How should I do the first one, can you give me the
steps?
"Alexis Molteni" wrote:
> Hi,
> you have to configure the security in two step. the first one, in the Site
> setting to map NT user with your RS group and in a second time, in the
> properties of your report . For each report you have à security tab to
> configure witch RS role for your user.
>
> "JIM.H." <JIMH@.discussions.microsoft.com> a écrit dans le message de
> news:15A95DA7-C2D4-4315-BEC8-142CA8625A53@.microsoft.com...
> > How do you set up user as who can access what report in Report Manger. I
> > do
> > not see security tab in RS2005.
> >
> >
>

Q: un-deploy

Hello,
I deployed a report by mistake to our report server, how can un-deploy it. I
do not want to see it in the report manager.
Thanks,Go to Report Manager, click on 'Show Details'. Put a check mark in the box
in front of that report and click on 'Delete'
=?Utf-8?B?SklNLkgu?= <JIMH@.discussions.microsoft.com> wrote in
news:473D6912-E218-4504-BFA2-7F6C7AEB1646@.microsoft.com:
> Hello,
> I deployed a report by mistake to our report server, how can un-deploy
> it. I do not want to see it in the report manager.
> Thanks,
>

Q: totals in matrix report

Hello,
How can I create a total at the bottom and on the right in a matrix type
report.
Thanks,
Jim.Right click on the column you want to have 'Total' and choose "Sub
total".
Henry
JIM.H. wrote:
> Hello,
> How can I create a total at the bottom and on the right in a matrix
type
> report.
> Thanks,
> Jim.

q: this strange problem

Hello,
I have different sub-reports in my main report. I have rectangles around my
sub-reporta to be able to put page breaks te the start of rectangle. I need
to make some sub-report visible and invisible based on a parameter. However I
am using =iif(Parameters!MyPar.Value = "true",false, true) in the visibility
property and this creates problem in the page break of the visible reports.
Any idea?If the sub-report becomes not visible then the page break is ignored.
To fix this, use a seperate rectangle control (make it tiny and place
it below the subreport on the master report) and set the page break
property on this new rectangle control.
HTH-
Matt A

Q: this strange problem

I am having this strange problem, when I run my query in Query Analyzer, I
see the result is ok. But my report based on the same query shows first filed
repeats itself instead of showing right values. What might the problem be?Is this in development? In development the report data is cached (look for a
file with an extension called .data). If you change the paramter it will
requery. If no parameter then you can manually delete this file if you care.
The designer does this so when previewing you are not waiting for the query
to run.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:9E917150-64CD-43FA-8E80-84E716FC6AFE@.microsoft.com...
>I am having this strange problem, when I run my query in Query Analyzer, I
> see the result is ok. But my report based on the same query shows first
> filed
> repeats itself instead of showing right values. What might the problem be?

Q: subtotal of rows in matrix

Hello,
I have a matrix report, how can I sum rows under a column. It seems add
subtotal works for summing of columns not rows.
Thanks,Nver mind. Found it.
"JIM.H." wrote:
> Hello,
> I have a matrix report, how can I sum rows under a column. It seems add
> subtotal works for summing of columns not rows.
> Thanks,
>|||Hey
I've been having the same problem, only with both rows and columns.
The subtotal for the row only grabs the first column's value and th
column subtotal only grabs the first row's value. Could you pleas
explain how you got the subtotals to work? If you can't at least pos
the solution you figured out
Thanks

Q: Standard or Enterprise

Hello,
Can I use my Standard SQL Server and Reporting services and run report
though our companyâ's internet site for everyone? Or does it have to be an
Enterprise version of SQL Server?
Thanks,
Jim.Are you talking internet or intranet. The licensing as far as RS is the same
as SQL Server. I.e. if everyone in your company can access your SQL Server
then they can access your RS. If you have RS on another machine you need an
additional license. There is no difference between Standard Edition and
Enterprise as far as how many can access RS. There is a difference in
functionality and if you don't need the additional functionality then
Standard Edition will work. Enterprise Edition adds web farm capability,
data driven subscriptions, etc. See this link for the differences in the
versions:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
Here is a licensing FAQ:
http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> Hello,
> Can I use my Standard SQL Server and Reporting services and run report
> though our company's internet site for everyone? Or does it have to be an
> Enterprise version of SQL Server?
> Thanks,
> Jim.
>|||Hello Bruce,
Thanks you very much for all your help. You helped me a lot now and in the
past.
I am using RS on top of Standard SQL Server in the intranet. We have enough
SQL Server licenses for this. Now I need to deploy some reports to internet
for our partners:
1. Can I do this if I meet licensing requirement for SQL Server without any
technical problem? (I assume I need to buy more licenses, correct?, before
doing that I want to make sure I can use Standard SQL Server and RS for our
Internet, please advice.)
2. We already have our web site accessing to our Standard SQL Server to
fetch data (there is no RS functionality on there at this point). Now; here
is more detail: our Standard SQL Server is in our domain, but Web Server is
actually is not in the domain but it is in its own workgroup. Our current
html internet application accesses this Standard SQL Server through ODBC.
Now, in our local network, my asp.net and RS applications work fine, if I put
my asp.net and RS application to this web sever, will it still access
Standard SQL Server without problem? I am suing standard SqlDataAdapter to
connect to database.
Please advice.
Thanks,
Jim.
"Bruce L-C [MVP]" wrote:
> Are you talking internet or intranet. The licensing as far as RS is the same
> as SQL Server. I.e. if everyone in your company can access your SQL Server
> then they can access your RS. If you have RS on another machine you need an
> additional license. There is no difference between Standard Edition and
> Enterprise as far as how many can access RS. There is a difference in
> functionality and if you don't need the additional functionality then
> Standard Edition will work. Enterprise Edition adds web farm capability,
> data driven subscriptions, etc. See this link for the differences in the
> versions:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
> Here is a licensing FAQ:
> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> > Hello,
> > Can I use my Standard SQL Server and Reporting services and run report
> > though our company's internet site for everyone? Or does it have to be an
> > Enterprise version of SQL Server?
> > Thanks,
> > Jim.
> >
>
>|||Let me just clarify a few things. Are you using your own front end or are
you using Report Manager? I.e. do you have your own web front end and then
are using either URL integration or web services to integrate with RS? Also,
what type of security are you using?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
> Hello Bruce,
> Thanks you very much for all your help. You helped me a lot now and in the
> past.
> I am using RS on top of Standard SQL Server in the intranet. We have
> enough
> SQL Server licenses for this. Now I need to deploy some reports to
> internet
> for our partners:
> 1. Can I do this if I meet licensing requirement for SQL Server without
> any
> technical problem? (I assume I need to buy more licenses, correct?, before
> doing that I want to make sure I can use Standard SQL Server and RS for
> our
> Internet, please advice.)
> 2. We already have our web site accessing to our Standard SQL Server to
> fetch data (there is no RS functionality on there at this point). Now;
> here
> is more detail: our Standard SQL Server is in our domain, but Web Server
> is
> actually is not in the domain but it is in its own workgroup. Our current
> html internet application accesses this Standard SQL Server through ODBC.
> Now, in our local network, my asp.net and RS applications work fine, if I
> put
> my asp.net and RS application to this web sever, will it still access
> Standard SQL Server without problem? I am suing standard SqlDataAdapter to
> connect to database.
> Please advice.
> Thanks,
> Jim.
>
> "Bruce L-C [MVP]" wrote:
>> Are you talking internet or intranet. The licensing as far as RS is the
>> same
>> as SQL Server. I.e. if everyone in your company can access your SQL
>> Server
>> then they can access your RS. If you have RS on another machine you need
>> an
>> additional license. There is no difference between Standard Edition and
>> Enterprise as far as how many can access RS. There is a difference in
>> functionality and if you don't need the additional functionality then
>> Standard Edition will work. Enterprise Edition adds web farm capability,
>> data driven subscriptions, etc. See this link for the differences in the
>> versions:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
>> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
>> Here is a licensing FAQ:
>> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
>> > Hello,
>> > Can I use my Standard SQL Server and Reporting services and run report
>> > though our company's internet site for everyone? Or does it have to be
>> > an
>> > Enterprise version of SQL Server?
>> > Thanks,
>> > Jim.
>> >
>>|||Hello Bruce,
I embedded ReportViewer into my ASP.Net application and using it as a
component. I am guessing it calls report manager, fetch data and show it
through the viewer. It works in our intranet. I am using integrated windows
authentication in our intranet. Does this answer your question? Please let me
know.
Thanks,
"Bruce L-C [MVP]" wrote:
> Let me just clarify a few things. Are you using your own front end or are
> you using Report Manager? I.e. do you have your own web front end and then
> are using either URL integration or web services to integrate with RS? Also,
> what type of security are you using?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
> > Hello Bruce,
> >
> > Thanks you very much for all your help. You helped me a lot now and in the
> > past.
> >
> > I am using RS on top of Standard SQL Server in the intranet. We have
> > enough
> > SQL Server licenses for this. Now I need to deploy some reports to
> > internet
> > for our partners:
> >
> > 1. Can I do this if I meet licensing requirement for SQL Server without
> > any
> > technical problem? (I assume I need to buy more licenses, correct?, before
> > doing that I want to make sure I can use Standard SQL Server and RS for
> > our
> > Internet, please advice.)
> >
> > 2. We already have our web site accessing to our Standard SQL Server to
> > fetch data (there is no RS functionality on there at this point). Now;
> > here
> > is more detail: our Standard SQL Server is in our domain, but Web Server
> > is
> > actually is not in the domain but it is in its own workgroup. Our current
> > html internet application accesses this Standard SQL Server through ODBC.
> > Now, in our local network, my asp.net and RS applications work fine, if I
> > put
> > my asp.net and RS application to this web sever, will it still access
> > Standard SQL Server without problem? I am suing standard SqlDataAdapter to
> > connect to database.
> > Please advice.
> > Thanks,
> > Jim.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Are you talking internet or intranet. The licensing as far as RS is the
> >> same
> >> as SQL Server. I.e. if everyone in your company can access your SQL
> >> Server
> >> then they can access your RS. If you have RS on another machine you need
> >> an
> >> additional license. There is no difference between Standard Edition and
> >> Enterprise as far as how many can access RS. There is a difference in
> >> functionality and if you don't need the additional functionality then
> >> Standard Edition will work. Enterprise Edition adds web farm capability,
> >> data driven subscriptions, etc. See this link for the differences in the
> >> versions:
> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> >>
> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
> >>
> >> Here is a licensing FAQ:
> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> >> > Hello,
> >> > Can I use my Standard SQL Server and Reporting services and run report
> >> > though our company's internet site for everyone? Or does it have to be
> >> > an
> >> > Enterprise version of SQL Server?
> >> > Thanks,
> >> > Jim.
> >> >
> >>
> >>
> >>
>
>|||The ReportViewer control uses URL integration. So, whether this is an issue
depends on how your internet access is setup. If you have a DMZ it could be
a problem. URL integration with the report control is really no different
than typing in the URL from the PC over on the internet. What I mean is that
the user has to have access to the RS machine. If your web server is on one
side of the DMZ and the RS is on the other, the user on the Internet will
not have access to it.
Another issue is security. How is the user on the internet going to be
validated. This is from Books On Line:
>>>>>>>>
Securing Reports for Global Access
Report Manager and HTML Viewer are not intended for extranet or Internet
deployment scenarios. To support external users of a report server
effectively, consider building a custom Web application. The application you
provide should be installed on the same computer as report server. You
should also implement Secure Sockets Layer (SSL) to encrypt transmitted
data.
Although custom authentication models are not currently supported, you can
use Windows authentication to support report server access to users that are
external to your organization. The following list provides guidelines about
supporting this scenario:
a.. Create a low-privileged domain user account with read-only
permissions. The account must have access to the computer hosting the report
server.
b.. Create role assignments that map the user account to specific items in
the report server folder hierarchy. You can limit access to read-only
operations by choosing the Browser predefined role for the role assignment.
c.. Configure data source connections to use Windows NT Integrated
Security if you want to access a data source using the security context of
the user. Alternatively, you can use stored credentials that specify a
different account. This approach is useful if you want to query the external
data source using an account that is different from the account that allows
access to the report server. For more information about these options, see
Specifying Credential and Connection Information.
If you have a small number of external users to support, you can consider
using Microsoft Passport. Passport accounts can be mapped to Windows
accounts. Mapping accounts is a manual process that must be performed by a
system administrator, so this approach is not practical if you want to
provide access to a large number of users.
>>>>>>>>>>
The other option (which I have never implemented so I am not an expert on
it) is to provide your own authentication instead of using Windows accounts.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:A832A82A-F212-4696-95F3-7A460C1CF618@.microsoft.com...
> Hello Bruce,
> I embedded ReportViewer into my ASP.Net application and using it as a
> component. I am guessing it calls report manager, fetch data and show it
> through the viewer. It works in our intranet. I am using integrated
> windows
> authentication in our intranet. Does this answer your question? Please let
> me
> know.
> Thanks,
> "Bruce L-C [MVP]" wrote:
>> Let me just clarify a few things. Are you using your own front end or are
>> you using Report Manager? I.e. do you have your own web front end and
>> then
>> are using either URL integration or web services to integrate with RS?
>> Also,
>> what type of security are you using?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
>> > Hello Bruce,
>> >
>> > Thanks you very much for all your help. You helped me a lot now and in
>> > the
>> > past.
>> >
>> > I am using RS on top of Standard SQL Server in the intranet. We have
>> > enough
>> > SQL Server licenses for this. Now I need to deploy some reports to
>> > internet
>> > for our partners:
>> >
>> > 1. Can I do this if I meet licensing requirement for SQL Server without
>> > any
>> > technical problem? (I assume I need to buy more licenses, correct?,
>> > before
>> > doing that I want to make sure I can use Standard SQL Server and RS for
>> > our
>> > Internet, please advice.)
>> >
>> > 2. We already have our web site accessing to our Standard SQL Server to
>> > fetch data (there is no RS functionality on there at this point). Now;
>> > here
>> > is more detail: our Standard SQL Server is in our domain, but Web
>> > Server
>> > is
>> > actually is not in the domain but it is in its own workgroup. Our
>> > current
>> > html internet application accesses this Standard SQL Server through
>> > ODBC.
>> > Now, in our local network, my asp.net and RS applications work fine, if
>> > I
>> > put
>> > my asp.net and RS application to this web sever, will it still access
>> > Standard SQL Server without problem? I am suing standard SqlDataAdapter
>> > to
>> > connect to database.
>> > Please advice.
>> > Thanks,
>> > Jim.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Are you talking internet or intranet. The licensing as far as RS is
>> >> the
>> >> same
>> >> as SQL Server. I.e. if everyone in your company can access your SQL
>> >> Server
>> >> then they can access your RS. If you have RS on another machine you
>> >> need
>> >> an
>> >> additional license. There is no difference between Standard Edition
>> >> and
>> >> Enterprise as far as how many can access RS. There is a difference in
>> >> functionality and if you don't need the additional functionality then
>> >> Standard Edition will work. Enterprise Edition adds web farm
>> >> capability,
>> >> data driven subscriptions, etc. See this link for the differences in
>> >> the
>> >> versions:
>> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
>> >>
>> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
>> >>
>> >> Here is a licensing FAQ:
>> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
>> >> > Hello,
>> >> > Can I use my Standard SQL Server and Reporting services and run
>> >> > report
>> >> > though our company's internet site for everyone? Or does it have to
>> >> > be
>> >> > an
>> >> > Enterprise version of SQL Server?
>> >> > Thanks,
>> >> > Jim.
>> >> >
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thanks for your responses. I will be implementing your security steps, if I
install RS to DMZ machine, and point it to the database in our domain (so DB
is in the network and application and RS is in the DMZ), will that work?
Thanks,
"Bruce L-C [MVP]" wrote:
> The ReportViewer control uses URL integration. So, whether this is an issue
> depends on how your internet access is setup. If you have a DMZ it could be
> a problem. URL integration with the report control is really no different
> than typing in the URL from the PC over on the internet. What I mean is that
> the user has to have access to the RS machine. If your web server is on one
> side of the DMZ and the RS is on the other, the user on the Internet will
> not have access to it.
> Another issue is security. How is the user on the internet going to be
> validated. This is from Books On Line:
> >>>>>>>>
> Securing Reports for Global Access
> Report Manager and HTML Viewer are not intended for extranet or Internet
> deployment scenarios. To support external users of a report server
> effectively, consider building a custom Web application. The application you
> provide should be installed on the same computer as report server. You
> should also implement Secure Sockets Layer (SSL) to encrypt transmitted
> data.
> Although custom authentication models are not currently supported, you can
> use Windows authentication to support report server access to users that are
> external to your organization. The following list provides guidelines about
> supporting this scenario:
> a.. Create a low-privileged domain user account with read-only
> permissions. The account must have access to the computer hosting the report
> server.
> b.. Create role assignments that map the user account to specific items in
> the report server folder hierarchy. You can limit access to read-only
> operations by choosing the Browser predefined role for the role assignment.
> c.. Configure data source connections to use Windows NT Integrated
> Security if you want to access a data source using the security context of
> the user. Alternatively, you can use stored credentials that specify a
> different account. This approach is useful if you want to query the external
> data source using an account that is different from the account that allows
> access to the report server. For more information about these options, see
> Specifying Credential and Connection Information.
> If you have a small number of external users to support, you can consider
> using Microsoft Passport. Passport accounts can be mapped to Windows
> accounts. Mapping accounts is a manual process that must be performed by a
> system administrator, so this approach is not practical if you want to
> provide access to a large number of users.
> >>>>>>>>>>
> The other option (which I have never implemented so I am not an expert on
> it) is to provide your own authentication instead of using Windows accounts.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:A832A82A-F212-4696-95F3-7A460C1CF618@.microsoft.com...
> > Hello Bruce,
> > I embedded ReportViewer into my ASP.Net application and using it as a
> > component. I am guessing it calls report manager, fetch data and show it
> > through the viewer. It works in our intranet. I am using integrated
> > windows
> > authentication in our intranet. Does this answer your question? Please let
> > me
> > know.
> > Thanks,
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Let me just clarify a few things. Are you using your own front end or are
> >> you using Report Manager? I.e. do you have your own web front end and
> >> then
> >> are using either URL integration or web services to integrate with RS?
> >> Also,
> >> what type of security are you using?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
> >> > Hello Bruce,
> >> >
> >> > Thanks you very much for all your help. You helped me a lot now and in
> >> > the
> >> > past.
> >> >
> >> > I am using RS on top of Standard SQL Server in the intranet. We have
> >> > enough
> >> > SQL Server licenses for this. Now I need to deploy some reports to
> >> > internet
> >> > for our partners:
> >> >
> >> > 1. Can I do this if I meet licensing requirement for SQL Server without
> >> > any
> >> > technical problem? (I assume I need to buy more licenses, correct?,
> >> > before
> >> > doing that I want to make sure I can use Standard SQL Server and RS for
> >> > our
> >> > Internet, please advice.)
> >> >
> >> > 2. We already have our web site accessing to our Standard SQL Server to
> >> > fetch data (there is no RS functionality on there at this point). Now;
> >> > here
> >> > is more detail: our Standard SQL Server is in our domain, but Web
> >> > Server
> >> > is
> >> > actually is not in the domain but it is in its own workgroup. Our
> >> > current
> >> > html internet application accesses this Standard SQL Server through
> >> > ODBC.
> >> > Now, in our local network, my asp.net and RS applications work fine, if
> >> > I
> >> > put
> >> > my asp.net and RS application to this web sever, will it still access
> >> > Standard SQL Server without problem? I am suing standard SqlDataAdapter
> >> > to
> >> > connect to database.
> >> > Please advice.
> >> > Thanks,
> >> > Jim.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Are you talking internet or intranet. The licensing as far as RS is
> >> >> the
> >> >> same
> >> >> as SQL Server. I.e. if everyone in your company can access your SQL
> >> >> Server
> >> >> then they can access your RS. If you have RS on another machine you
> >> >> need
> >> >> an
> >> >> additional license. There is no difference between Standard Edition
> >> >> and
> >> >> Enterprise as far as how many can access RS. There is a difference in
> >> >> functionality and if you don't need the additional functionality then
> >> >> Standard Edition will work. Enterprise Edition adds web farm
> >> >> capability,
> >> >> data driven subscriptions, etc. See this link for the differences in
> >> >> the
> >> >> versions:
> >> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> >> >>
> >> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
> >> >>
> >> >> Here is a licensing FAQ:
> >> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> >> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
> >> >> > Hello,
> >> >> > Can I use my Standard SQL Server and Reporting services and run
> >> >> > report
> >> >> > though our company's internet site for everyone? Or does it have to
> >> >> > be
> >> >> > an
> >> >> > Enterprise version of SQL Server?
> >> >> > Thanks,
> >> >> > Jim.
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||That will take care of the issue with URL integration. It does not deal with
the issue of accounts. If you can give your business users a domain account
then you will be in good shape. I do not operate this way so take it with a
grain of salt. What I have done is log into the intranet via VPN. When this
occurs and you connect to RS it does not know who you are (with my VPN
connection from home, I am not logged onto a domain). When I do this I then
get prompted for a username and password. I haven't done this for awhile so
I don't know if it prompts for the domain or if I have to put in the
username like this: MyDomainName\MyUsername
Note that putting your RS in the DMZ (which means you have split RS and the
Database) requires another license. Plus, when SQL Server is being used on
the internet that affects licensing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:D961D195-A824-44C8-9BC7-88126739FFCF@.microsoft.com...
> Hi Bruce,
> Thanks for your responses. I will be implementing your security steps, if
> I
> install RS to DMZ machine, and point it to the database in our domain (so
> DB
> is in the network and application and RS is in the DMZ), will that work?
> Thanks,
>
> "Bruce L-C [MVP]" wrote:
>> The ReportViewer control uses URL integration. So, whether this is an
>> issue
>> depends on how your internet access is setup. If you have a DMZ it could
>> be
>> a problem. URL integration with the report control is really no different
>> than typing in the URL from the PC over on the internet. What I mean is
>> that
>> the user has to have access to the RS machine. If your web server is on
>> one
>> side of the DMZ and the RS is on the other, the user on the Internet will
>> not have access to it.
>> Another issue is security. How is the user on the internet going to be
>> validated. This is from Books On Line:
>> >>>>>>>>
>> Securing Reports for Global Access
>> Report Manager and HTML Viewer are not intended for extranet or Internet
>> deployment scenarios. To support external users of a report server
>> effectively, consider building a custom Web application. The application
>> you
>> provide should be installed on the same computer as report server. You
>> should also implement Secure Sockets Layer (SSL) to encrypt transmitted
>> data.
>> Although custom authentication models are not currently supported, you
>> can
>> use Windows authentication to support report server access to users that
>> are
>> external to your organization. The following list provides guidelines
>> about
>> supporting this scenario:
>> a.. Create a low-privileged domain user account with read-only
>> permissions. The account must have access to the computer hosting the
>> report
>> server.
>> b.. Create role assignments that map the user account to specific items
>> in
>> the report server folder hierarchy. You can limit access to read-only
>> operations by choosing the Browser predefined role for the role
>> assignment.
>> c.. Configure data source connections to use Windows NT Integrated
>> Security if you want to access a data source using the security context
>> of
>> the user. Alternatively, you can use stored credentials that specify a
>> different account. This approach is useful if you want to query the
>> external
>> data source using an account that is different from the account that
>> allows
>> access to the report server. For more information about these options,
>> see
>> Specifying Credential and Connection Information.
>> If you have a small number of external users to support, you can consider
>> using Microsoft Passport. Passport accounts can be mapped to Windows
>> accounts. Mapping accounts is a manual process that must be performed by
>> a
>> system administrator, so this approach is not practical if you want to
>> provide access to a large number of users.
>> >>>>>>>>>>
>> The other option (which I have never implemented so I am not an expert on
>> it) is to provide your own authentication instead of using Windows
>> accounts.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> news:A832A82A-F212-4696-95F3-7A460C1CF618@.microsoft.com...
>> > Hello Bruce,
>> > I embedded ReportViewer into my ASP.Net application and using it as a
>> > component. I am guessing it calls report manager, fetch data and show
>> > it
>> > through the viewer. It works in our intranet. I am using integrated
>> > windows
>> > authentication in our intranet. Does this answer your question? Please
>> > let
>> > me
>> > know.
>> > Thanks,
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Let me just clarify a few things. Are you using your own front end or
>> >> are
>> >> you using Report Manager? I.e. do you have your own web front end and
>> >> then
>> >> are using either URL integration or web services to integrate with RS?
>> >> Also,
>> >> what type of security are you using?
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> >> news:C558B489-11AE-45E4-84C8-218A49C5D1B8@.microsoft.com...
>> >> > Hello Bruce,
>> >> >
>> >> > Thanks you very much for all your help. You helped me a lot now and
>> >> > in
>> >> > the
>> >> > past.
>> >> >
>> >> > I am using RS on top of Standard SQL Server in the intranet. We have
>> >> > enough
>> >> > SQL Server licenses for this. Now I need to deploy some reports to
>> >> > internet
>> >> > for our partners:
>> >> >
>> >> > 1. Can I do this if I meet licensing requirement for SQL Server
>> >> > without
>> >> > any
>> >> > technical problem? (I assume I need to buy more licenses, correct?,
>> >> > before
>> >> > doing that I want to make sure I can use Standard SQL Server and RS
>> >> > for
>> >> > our
>> >> > Internet, please advice.)
>> >> >
>> >> > 2. We already have our web site accessing to our Standard SQL Server
>> >> > to
>> >> > fetch data (there is no RS functionality on there at this point).
>> >> > Now;
>> >> > here
>> >> > is more detail: our Standard SQL Server is in our domain, but Web
>> >> > Server
>> >> > is
>> >> > actually is not in the domain but it is in its own workgroup. Our
>> >> > current
>> >> > html internet application accesses this Standard SQL Server through
>> >> > ODBC.
>> >> > Now, in our local network, my asp.net and RS applications work fine,
>> >> > if
>> >> > I
>> >> > put
>> >> > my asp.net and RS application to this web sever, will it still
>> >> > access
>> >> > Standard SQL Server without problem? I am suing standard
>> >> > SqlDataAdapter
>> >> > to
>> >> > connect to database.
>> >> > Please advice.
>> >> > Thanks,
>> >> > Jim.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Are you talking internet or intranet. The licensing as far as RS is
>> >> >> the
>> >> >> same
>> >> >> as SQL Server. I.e. if everyone in your company can access your SQL
>> >> >> Server
>> >> >> then they can access your RS. If you have RS on another machine you
>> >> >> need
>> >> >> an
>> >> >> additional license. There is no difference between Standard Edition
>> >> >> and
>> >> >> Enterprise as far as how many can access RS. There is a difference
>> >> >> in
>> >> >> functionality and if you don't need the additional functionality
>> >> >> then
>> >> >> Standard Edition will work. Enterprise Edition adds web farm
>> >> >> capability,
>> >> >> data driven subscriptions, etc. See this link for the differences
>> >> >> in
>> >> >> the
>> >> >> versions:
>> >> >> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
>> >> >>
>> >> >> http://www.microsoft.com/sql/reporting/techinfo/techoverview.mspx
>> >> >>
>> >> >> Here is a licensing FAQ:
>> >> >> http://www.microsoft.com/sql/reporting/howtobuy/faq.mspx
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
>> >> >> news:17707232-9B95-443C-B342-95244D1045A3@.microsoft.com...
>> >> >> > Hello,
>> >> >> > Can I use my Standard SQL Server and Reporting services and run
>> >> >> > report
>> >> >> > though our company's internet site for everyone? Or does it have
>> >> >> > to
>> >> >> > be
>> >> >> > an
>> >> >> > Enterprise version of SQL Server?
>> >> >> > Thanks,
>> >> >> > Jim.
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>