Hi David

I have 2000 for reporting services and VB.net 2003

Regards

Vandy

Sorry for not explaning

Actually i have Sales team like Commercial ,Retail and wholesale

Every team has some salesperson and every sales person has customers.

I am running a report which shows ordernumber,...

Many Thanks Vladan

Thanks a Lot Stuart

It make sense...............

Once again thanks

CREATE PROCEDURE Customerspend

    @Year As nvarchar,@Customer As nvarchar (8), @Major as nvarchar (3)

AS

SELECT     Billing.Customer, Billing.ItemCode,Item.ItemGroupMajor, BillingF.QuantityInvoiced, Billing.InvoicedValueBase, TimeDates.Month

FROM         Billing INNER JOIN

                      TimeDates ON Billing.DateInvoiced = TimeDates.S21Date INNER...

Sorry for explaining this .........

Actually i am using IIS FTP server

on AS400 routeone and on sql server routeone client routeone from AS400 is connected with FTP server and it...

I was also doing same thing check this link

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=297690

Hi

I also have this type of error but when i deploy report it's working fine on report manager.

Thanks a lot

It's working .............

Kind Regards

Thanks a Lot Carolyn & Neil

I have made different dataset for all three parameters it's working fine but showing full list and i need same thing which Neil said.

i want that when...

Hi Colin

You need to check first your server because DTS will create excel file on local host.

So just search your excel file on local server.

I am running a DTS package...

Many Thanks Vladan & John

After reading your post i made one view which was having data upto friday and again by changing system date to monday i tried it and it's working.

You...

Thanks Vladan

I changed system date from 11th to 7th and double checked that which date getdate is giving me and it was monday means 7th and after that i posted...

It look like it's not adding only friday and saturday data because total sum is bigger then original sum what i have for friday to sunday

Yah done the same thing but out put is not correct