Or you can do this also

=((SUM(Iif(Fields!Quality.Value="Good", Fields!Length.Value, CDec(0))))/SUM(Fields!Length.Value))

take this exp and select your filed col and click properties in format Property put P2 it will give you % sign upto...

Thanks a lot for reply

Malcolm could you explain this more how i can store this vale to database?

Thanks

May be  Parameter can help you

Thanks

Hi David

You can break your report by grouping. With grouping you can export single group in a single sheet. eg if you have 10 groups you will have ten...

Thanks a lot Sergiy

I hadn't thought about it. I am agree with you. My every table has same format for date so in other table i am using this with...

Here is my query

SELECT     COUNT(OrderLineNumber) AS [Total Number Of Orders], COUNT(CASE WHEN DateInvoiced <= SystemOrderDate + 1 THEN OrderLineNumber ELSE NULL

                       END) AS [24 Hour Receipt], COUNT(CASE WHEN DateInvoiced >...

Hi  George

It's Done. Thanks a lot for your help.

Kind Regards

Hi George Carley

Thanks a lot for reply

My report has groups but don't know from where i can put a check to insert new page after and the other question is...

Thanks a lot Sergiy

I WILL TRY THIS ..........

Kind Regards

Vandy

Thanks Ninja's RGR'us

Sorry for again asking

Is this mean 2 days and 7 hours...?

I want to show my client output in one table like this

Total number of orders      8289   

24 hour...

Thanks for reply

Sorry Sergiy, i am a new user of sql.Could you explain me this statement please

 @Delivered = GETDATE() + 2.7

Regards

Hi Guys

Thanks for reply

I tried this with cursor but will going to try with wrapper package also

Thanks a lot

Hi Geogre

Could you tell where you want to export your text file like i am exporting my file to other server with FTP ....

Hi

I am doing same thing mine is working & i am exporting this file every morning to client computer try this:-

globalVal = DTSGlobalVariables("global").Value

 set dtsCurrentDate =...

Actually my table has only backorder because during extraction i applied all conditions. So from my table i need to select only vendor.

Thanks