Gathering requirements for SQL Reporting Services

Hello,
I am assigned the task of gathering requirements from business users
for implementing reports using SQL Server Reporting Services. Some of
the questions I have in mind are:
1. What is the purpose of the report?
2. How many users would be using it?
3. Where is the data coming from?
4. What delivery method is required?
5. What is the layout of the report?
What other information would I need before jumping into setting up the
framework and developing the reports?In addition to your list. you can find out.
1. Complexity (like calculated fileds, charts etc) of the reports
2. Whether the reports are to be shown seperate or should be a part of the
program (This question is for Report viewer)
3. The setup of the hardware servers ( this question is for checking the
performance)
4. Licensing issue should be in your checklist as well.
Amarnath
"sandeshmeda@.gmail.com" wrote:
> Hello,
> I am assigned the task of gathering requirements from business users
> for implementing reports using SQL Server Reporting Services. Some of
> the questions I have in mind are:
> 1. What is the purpose of the report?
> 2. How many users would be using it?
> 3. Where is the data coming from?
> 4. What delivery method is required?
> 5. What is the layout of the report?
> What other information would I need before jumping into setting up the
> framework and developing the reports?
>sql

gateway dropping SQL Connection

Hi guys,
I need some serious help from any of you geniuses here. I have a
problem with an Access 2000 adp connection. I have users on that site
going through a gateway to communicate to our server and we are having
major connection problems. It seems that something on the network or
the gateway keeps dropping our connection to the sql 2000 server.
Is there any setting or even anything on the gateway hardware itself
that would be responsible for doing this? I would need to be able to
instruct the Network tech on what to do since I don't have any admin
rights to do it myself and the network tech might not know what to do.
Thanks in advance
bump
Marvinq wrote:
> Hi guys,
> I need some serious help from any of you geniuses here. I have a
> problem with an Access 2000 adp connection. I have users on that site
> going through a gateway to communicate to our server and we are having
> major connection problems. It seems that something on the network or
> the gateway keeps dropping our connection to the sql 2000 server.
> Is there any setting or even anything on the gateway hardware itself
> that would be responsible for doing this? I would need to be able to
> instruct the Network tech on what to do since I don't have any admin
> rights to do it myself and the network tech might not know what to do.
> Thanks in advance
sql

gateway dropping SQL Connection

Hi guys,
I need some serious help from any of you geniuses here. I have a
problem with an Access 2000 adp connection. I have users on that site
going through a gateway to communicate to our server and we are having
major connection problems. It seems that something on the network or
the gateway keeps dropping our connection to the sql 2000 server.
Is there any setting or even anything on the gateway hardware itself
that would be responsible for doing this? I would need to be able to
instruct the Network tech on what to do since I don't have any admin
rights to do it myself and the network tech might not know what to do.
Thanks in advancebump
Marvinq wrote:
> Hi guys,
> I need some serious help from any of you geniuses here. I have a
> problem with an Access 2000 adp connection. I have users on that site
> going through a gateway to communicate to our server and we are having
> major connection problems. It seems that something on the network or
> the gateway keeps dropping our connection to the sql 2000 server.
> Is there any setting or even anything on the gateway hardware itself
> that would be responsible for doing this? I would need to be able to
> instruct the Network tech on what to do since I don't have any admin
> rights to do it myself and the network tech might not know what to do.
> Thanks in advance

gateway dropping SQL Connection

Hi guys,
I need some serious help from any of you geniuses here. I have a
problem with an Access 2000 adp connection. I have users on that site
going through a gateway to communicate to our server and we are having
major connection problems. It seems that something on the network or
the gateway keeps dropping our connection to the sql 2000 server.
Is there any setting or even anything on the gateway hardware itself
that would be responsible for doing this? I would need to be able to
instruct the Network tech on what to do since I don't have any admin
rights to do it myself and the network tech might not know what to do.
Thanks in advancebump
Marvinq wrote:
> Hi guys,
> I need some serious help from any of you geniuses here. I have a
> problem with an Access 2000 adp connection. I have users on that site
> going through a gateway to communicate to our server and we are having
> major connection problems. It seems that something on the network or
> the gateway keeps dropping our connection to the sql 2000 server.
> Is there any setting or even anything on the gateway hardware itself
> that would be responsible for doing this? I would need to be able to
> instruct the Network tech on what to do since I don't have any admin
> rights to do it myself and the network tech might not know what to do.
> Thanks in advance

Future of Report builder

Hi,
I am looking into letting users build their own reports. So far, it
looks good for most scenarios. However, some of the 'reports' I'd
like users to create are forms for our quotes, orders and invoices.
I can create these kinds of reports in VS 2005, but I can't in report
builder because of its lack of the List control. I use the list
control to display fields from the Document header data source, which
will only ever have one item in the list such as sold to information,
the document number, etc.
Will report builder gain the ability to use the List control so that i
can place item details arbitrary on the form? I'd like to see this
feature added, as it would allow my users to create any kind of
reports / forms they need so long as I provide them an appropriate
model.
For now, are there any workarounds?
Thanks
AndyBasically RB is for top management, who can create report on their own, for
forms you can try using "Infopath" for forms creation. Since it is a very
very earlier version, we expect MS will improve on it.
Amarnath
"Andy" wrote:
> Hi,
> I am looking into letting users build their own reports. So far, it
> looks good for most scenarios. However, some of the 'reports' I'd
> like users to create are forms for our quotes, orders and invoices.
> I can create these kinds of reports in VS 2005, but I can't in report
> builder because of its lack of the List control. I use the list
> control to display fields from the Document header data source, which
> will only ever have one item in the list such as sold to information,
> the document number, etc.
> Will report builder gain the ability to use the List control so that i
> can place item details arbitrary on the form? I'd like to see this
> feature added, as it would allow my users to create any kind of
> reports / forms they need so long as I provide them an appropriate
> model.
> For now, are there any workarounds?
> Thanks
> Andy
>

future enhancement

I would like to see bread crumbs in report manager for linked reports and drill through to make it easier for users to navigate back to the parent and intermediary reports. The browser back button can be a little flakey. It would be REALLY nice if this could be put into the new report viewer control in VS 2005 also.

I would also like to see a "My Reports" feature that would allow a user to create a list of reports they most frequently access. I have created a custom solution to do this and only told a few users about it; now there are 276 entries in it. We have about 80 users total. I looked at the subscription option but it requires to many settings. Most of our reports have parameters, a date range being the most common, that are not static and therefore subscriptions would be a little tedious to use.

By the way, I am not sure if there is a better forum for this.

Fundamental Functions MS SQL Server 7 or 2000 users VALUE MOST

Hi all,

What are the fundamentals (fundamental functions) that most small to
medium sized organizations that use MS SQL Server 7 or 2000 value
most?
What's your insight?

OK, here's my biased definition of small to medium sized organization,
annual revenue from 20m to 300m.

Thanks.

DLdaaa@.rock.com (DaaaDaaa) wrote in message news:<2193afb.0406011507.37ee4f6d@.posting.google.com>...
> Hi all,
> What are the fundamentals (fundamental functions) that most small to
> medium sized organizations that use MS SQL Server 7 or 2000 value
> most?
> What's your insight?
> OK, here's my biased definition of small to medium sized organization,
> annual revenue from 20m to 300m.
> Thanks.
> DL

http://www.microsoft.com/sql/evalua...ies/default.asp

Apart from that, I would guess that MSSQL is like most software -
people are using it to do more or less anything and everything you can
do with it.

Simon|||> http://www.microsoft.com/sql/evalua...ies/default.asp
> Apart from that, I would guess that MSSQL is like most software -
> people are using it to do more or less anything and everything you can
> do with it.
> Simon

Thanks, Simon.

Don

Function to return all days in a month

Hi,

What I need to do is to join a table with all days in a range that the users inform with another table that has the values so I can have a montly report separated day by day...I don't want to create the table manually cause the range is different...

I tried to do with cursor but it's to slow..

Any better solution?

Thanks

You don't say what version of SQL Server you are using. If you are using SQL Server 2005 then you can use a recursive common table expression to do what you want. Here is a sample:

Code Snippet

DECLARE @.RepMonth as datetime

SET @.RepMonth = '2007-04-01'

-- Use a common table expression to loop over a set of years

;WITH DayList (DayDate) AS

(

SELECT @.RepMonth

UNION ALL

SELECT DATEADD(d, 1, DayDate)

FROM DayList

WHERE (DayDate < DATEADD(d, -1, DATEADD(m, 1, @.RepMonth)))

)

SELECT *

FROM DayList

|||

OK thanks. It solves for my other program....But I still need it to sql2000... =)

Thanks

|||

Been thinking about it since posting previously and I came up with the following code which works if you don't have SQL Server 2005. It depends upon having a table which simply contains the values from 0 to at least 30 (giving 31 records for 31 days). I put up to 32 in to show check the logic worked for any month - and that it can have any number of records in it. In the sample this is a table variable - but in a real system this would probably just be a little standard table.

Code Snippet

DECLARE @.ValueList table

(

ValueID int

)

SET NOCOUNT ON

INSERT INTO @.ValueList Values ( 0)

INSERT INTO @.ValueList Values ( 1)

INSERT INTO @.ValueList Values ( 2)

INSERT INTO @.ValueList Values ( 3)

INSERT INTO @.ValueList Values ( 4)

INSERT INTO @.ValueList Values ( 5)

INSERT INTO @.ValueList Values ( 6)

INSERT INTO @.ValueList Values ( 7)

INSERT INTO @.ValueList Values ( 8)

INSERT INTO @.ValueList Values ( 9)

INSERT INTO @.ValueList Values (10)

INSERT INTO @.ValueList Values (11)

INSERT INTO @.ValueList Values (12)

INSERT INTO @.ValueList Values (13)

INSERT INTO @.ValueList Values (14)

INSERT INTO @.ValueList Values (15)

INSERT INTO @.ValueList Values (16)

INSERT INTO @.ValueList Values (17)

INSERT INTO @.ValueList Values (18)

INSERT INTO @.ValueList Values (19)

INSERT INTO @.ValueList Values (20)

INSERT INTO @.ValueList Values (21)

INSERT INTO @.ValueList Values (22)

INSERT INTO @.ValueList Values (23)

INSERT INTO @.ValueList Values (24)

INSERT INTO @.ValueList Values (25)

INSERT INTO @.ValueList Values (26)

INSERT INTO @.ValueList Values (27)

INSERT INTO @.ValueList Values (28)

INSERT INTO @.ValueList Values (29)

INSERT INTO @.ValueList Values (30)

INSERT INTO @.ValueList Values (31)

INSERT INTO @.ValueList Values (32)

DECLARE @.RepMonth as datetime

SET @.RepMonth = '2007-04-01'

SELECT DATEADD(d, ValueID, @.RepMonth)

FROM @.ValueList

WHERE (DATEADD(d, ValueID, @.RepMonth) < DATEADD(m, 1, @.RepMonth))

Put an order by on the selects if you need the records in a particular order.

|||

You might want to give consideration to using a calendar table; you can find an article that describes this type of table here:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

|||

GREAT !!! Thanks..you're the master....

Do you have msn....I'll add you to never forget !(or add me...it's my nickname @.hot....

|||

You may find having a 'Calendar' table to be constantly useful.

Datetime -Calendar Table
http://www.aspfaq.com/show.asp?id=2519

|||

create function udf_MakeDatesTable(

@.dtInput smalldatetime

,@.Months tinyint = 1

)

/*

this function will allow you get a table of dates

for any range of months you like,

starting at the input date.

See below for the usage

*/

returns @.TableOfDates table(dtTemp smalldatetime)

as

begin

declare @.dtEnd smalldatetime

--declare @.dtInput smalldatetime

--set @.dtInput = '1/5/2005 05:12'

--This line will strip out the Time component

set @.dtinput = convert(varchar,@.dtInput,106)

--Find our end date. Always @.Months after @.dtInput

set @.dtEnd = dateadd(m, @.Months, @.dtInput)

--declare @.TableOfDates table(dtTemp smalldatetime)

while @.dtInput < @.dtend

begin

insert into @.TableOfDates select @.dtInput

set @.dtInput = @.dtInput + 1

end

return

end

go

select * from dbo.udf_MakeDatesTable('1/15/2005',1)

Full-Text Search stopped for confict in service accounts

Hi:
In me organizattion are one sql 2000 server with the dbs.
When remote users connect to this server can't see the Full-Text Search
running.
The Microsoft Search service in windows are running.
I was read that the problem concern to change the user of microsoft sql
services after install the server. This is the poit. This server have this
problem. I change the user of sql services after install the sql.
Have any form of resolve this confinct without reinstall the sql server?
Thanks a lot
cyber
MSSearch must run under the local system account. One of the reasons SQL FTS
might not work is because you change the account that MSSQLServer runs under
using control panel. If so you should locate your server in Enterprise
Manager, right click on it, and select properties, then click the security
tab, and change it back to system, SQL Server will prompt you to stop and
start it. Then change it back to the local admin account.
I suspect you are actually running into this problem -
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"cyb165er" <cyb165er@.discussions.microsoft.com> wrote in message
news:CBD24B8D-9D09-4EC0-84C0-84D48F7344CC@.microsoft.com...
> Hi:
> In me organizattion are one sql 2000 server with the dbs.
> When remote users connect to this server can't see the Full-Text Search
> running.
> The Microsoft Search service in windows are running.
> I was read that the problem concern to change the user of microsoft sql
> services after install the server. This is the poit. This server have this
> problem. I change the user of sql services after install the sql.
> Have any form of resolve this confinct without reinstall the sql server?
> Thanks a lot
> cyber

Full-Text Search stopped for confict in service accounts

Hi:
In me organizattion are one sql 2000 server with the dbs.
When remote users connect to this server can't see the Full-Text Search
running.
The Microsoft Search service in windows are running.
I was read that the problem concern to change the user of microsoft sql
services after install the server. This is the poit. This server have this
problem. I change the user of sql services after install the sql.
Have any form of resolve this confinct without reinstall the sql server?
Thanks a lot
cyberMSSearch must run under the local system account. One of the reasons SQL FTS
might not work is because you change the account that MSSQLServer runs under
using control panel. If so you should locate your server in Enterprise
Manager, right click on it, and select properties, then click the security
tab, and change it back to system, SQL Server will prompt you to stop and
start it. Then change it back to the local admin account.
I suspect you are actually running into this problem -
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"cyb165er" <cyb165er@.discussions.microsoft.com> wrote in message
news:CBD24B8D-9D09-4EC0-84C0-84D48F7344CC@.microsoft.com...
> Hi:
> In me organizattion are one sql 2000 server with the dbs.
> When remote users connect to this server can't see the Full-Text Search
> running.
> The Microsoft Search service in windows are running.
> I was read that the problem concern to change the user of microsoft sql
> services after install the server. This is the poit. This server have this
> problem. I change the user of sql services after install the sql.
> Have any form of resolve this confinct without reinstall the sql server?
> Thanks a lot
> cyber

Full-Text Search stopped for confict in service accounts

Hi:
In me organizattion are one sql 2000 server with the dbs.
When remote users connect to this server can't see the Full-Text Search
running.
The Microsoft Search service in windows are running.
I was read that the problem concern to change the user of microsoft sql
services after install the server. This is the poit. This server have this
problem. I change the user of sql services after install the sql.
Have any form of resolve this confinct without reinstall the sql server?
Thanks a lot
cyberMSSearch must run under the local system account. One of the reasons SQL FTS
might not work is because you change the account that MSSQLServer runs under
using control panel. If so you should locate your server in Enterprise
Manager, right click on it, and select properties, then click the security
tab, and change it back to system, SQL Server will prompt you to stop and
start it. Then change it back to the local admin account.
I suspect you are actually running into this problem -
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"cyb165er" <cyb165er@.discussions.microsoft.com> wrote in message
news:CBD24B8D-9D09-4EC0-84C0-84D48F7344CC@.microsoft.com...
> Hi:
> In me organizattion are one sql 2000 server with the dbs.
> When remote users connect to this server can't see the Full-Text Search
> running.
> The Microsoft Search service in windows are running.
> I was read that the problem concern to change the user of microsoft sql
> services after install the server. This is the poit. This server have this
> problem. I change the user of sql services after install the sql.
> Have any form of resolve this confinct without reinstall the sql server?
> Thanks a lot
> cyber