There are tools available, such as this[^] however you could also do it yourself, depending on requirements. http://aspalliance.com/1917_Automate_delivery_of_Crystal_Reports_With_a_Windows_Service[^] I know the language. I've read a book. - _Madmatt

Still i get the same error....

I had an issue similar to this awhile ago, i cant remember the exact code but you need to loop (Recursivly) through all the subreports and set the credentials for them aswell. If at first you don't succeed ... post it on The Code Project and Pray.

It shows an error that the virtual path "http://project1" doesnt exist

AFAIK, the default one doesn't have that feature.. You probably need to find the third-party one. I wonder why you want to make one column as pivot.. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

Trying to be a bit more helpful But the solution has to do with CTEs, at least if your using SQL Server as this is not standard SQL: with tmp(parent, son) as ( select tab.parent, tab.son from tab where tab.parent='A' union all select tmp.super, tab.son from tmp join tab on tmp.son=tab.parent Beware of loops! In that case you need to introduce a recursion counter or a condition that restricts son<>'A'.

VB.Net Developer wrote: Thanks a lot Welcome My Website | Ask smart questions

This works perfectly fine...Thanks a lot

VB.Net Developer wrote: i need to download Attachment from Email in Outlook using VB,NET. Could someone help This article was posted a few days ago: http://www.codeproject.com/dotnet/OutlookEmailExtractor.asp[^] Pete Soheil DigiOz Multimedia http://www.digioz.com