Create a Sequential Line Count for Group...

I have a report that groups by item number but then is filtered by a
parameter to only show the top # the user has entered. Does anyone
know if it is possible to number the results I return so that the user
can see how that particular record ranks with other records? Basically
I want to be able to have the user see 1 for the top item sold, 2 for
the second most items sold, etc...Try using
=Rownumber(Groupname)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Brent" <Brent.Raymond@.gmail.com> wrote in message
news:1126532242.793502.287600@.o13g2000cwo.googlegroups.com...
>I have a report that groups by item number but then is filtered by a
> parameter to only show the top # the user has entered. Does anyone
> know if it is possible to number the results I return so that the user
> can see how that particular record ranks with other records? Basically
> I want to be able to have the user see 1 for the top item sold, 2 for
> the second most items sold, etc...
>

Create a new SQL Server database

I have Visual Studio 2003 Developer edition installed. The "Create a new SQL Server database" item is not enabled in the server explorer when I right click on connection. Do I have to instal a different version...or is there a common solution for this?

Thank you.

CJG

in VS 2003 , you can't .

to create a new database for SqlServer , you have to use Enterprise Manager for your SQL server version ,

if you dont have one , you can install it fromhere:

Create a Letter

hi there,
Anybody know how to create a letter using Sql Reporting. My report
format is given below please advice which tool item i should use and
how to justify the letter body.
where xxx is from database
Dear Mr xxxx
xxxx is pleased to confirm the receipt of the sub amt for the xxx
project. the details of which are as follows
sub for : xxx
all : xxx
two sentence here
please advice how can i do this...
thnxJust drag a list control expand till you get a decent size of the letter and
place various text box's inside, each will be placed as per your letter eg.
some has fixed text and couple of variable textbox eg. Name of the person.
in the properties of the listbox create group and give a page break. in your
case the group will be set on emp name.. so it prints in different page for
each emp.
Amarnath
"Murali" wrote:
> hi there,
> Anybody know how to create a letter using Sql Reporting. My report
> format is given below please advice which tool item i should use and
> how to justify the letter body.
> where xxx is from database
> Dear Mr xxxx
> xxxx is pleased to confirm the receipt of the sub amt for the xxx
> project. the details of which are as follows
> sub for : xxx
> all : xxx
> two sentence here
>
> please advice how can i do this...
> thnx
>

Counting a group of data as one

How do I go about counting a group of data as 1 item? For example, I have a user who worked on 11 work orders, but only 10 were completed and I am trying to get the # of work orders completed. The problem I am having is it is counting each work day for each completed work order, so for example, if one work order was worked on for 5 days, it counts that work order as five and not one. I need it to ignore the number of work days and just give me the one work order in the count.use distinct count instead.|||I tried that, but it does not work in this case. I am getting closer with it, but now I have a different problem. It seems that the total I need is always off by 1. For example, if a person worked on 7 work orders and 5 of them are closed or completed, it is giving me a count of six. I need to figure out how if a work order has a certain status, to take that total and subtract 1 from it, otherwise leave it alone. Any ideas?|||It would be good if you would post an example of your current report and your desired result.|||You might be able to use a running total with a formula to determine which records to count; reset at the appropriate level.