Scheduling WebI report to network drive

scheduling XI Scheduler
1

Hi Guys,

I need to schedule WebI reports every week and send it to some common network drive(for ex. D drive or E drive in our common network)
I can see only 3 different types of destination on CMC under schedule: Default, email(SMTP) and Inbox. I would like to schedule our BO WebI XI R2 report every week and send it to our common network drive. Can anybody please advice me how can i do this.

Thanks,
J WOOD

wood :nepal: (BOB member since 2006-06-05)

2

First you have to change the format of your report to either Excell or PDF. THen you will be able to FTP it or send it to a drive location

Milos :us: (BOB member since 2005-08-06)

3

I have tried to schedule Webi reports from Infoview. I am admin so i have rights to schedule from infoview.
Under Destination option i have seen list of options. Our requirement is to send our webi reports in pdf format to our common shared network drive. Should i choose “Specific file location” for this purpose? i tried with this but my job failed. There are some default location also. how can i configuare my system to use those default location?

Guys please throw some light on my problem.

Thanks,
J WOOD

wood :nepal: (BOB member since 2006-06-05)

4

You need to configure the webi servers to support the Unmanaged Disk destination.

In the CMC go under Servers, choose the WebI Job server, and look under the Destinations tab. You’ll see that Unmanaged Disk has a big red bar through it. Enabale it ad then go make any changes to the default settings that you want to and save. Do the same thing for the Webi Report server.

If you use the Crystal Reports doc type then you’ll need to go configure the ReportJob, ProgramJob, and DestinationJob servers as well. If you use DeskI then those servers will need to be configured, and if you use RAS you have to do that one as well.

Cris E :us: (BOB member since 2005-03-18)

5

I have enabled Unformatted disk setting on destination tab. I have to schedule my BO reports and send it to some folders inside J:. So the path i gave under Destination Directory is J:/Folder1/Folder2/Folder3. But i am getting error: destination directory error.CrystalEnterprise.DiskUnmanaged: No such file or directory

Am i doing something wrong here. Please suggest me.

thanks,
J WOOD

wood :nepal: (BOB member since 2006-06-05)

6

Don’t use drive letters. Use the full universal path ( \servername\volname\directorynames\ ) in case your maps are different from the acct you’re rnuning the server nuder. Also, don;t use the Local Admin account to start the server. Change it to a domain account so it has some rights on the network.

Cris E :us: (BOB member since 2005-03-18)

7

Is it possible to send the report to a different folder within the Webi / BO environment ?
I need to create an archive of monthly snapshots, so once a month I want to copy reports run the report sand send them to a Sub folder with the Month name

Anyone tried this ?

psjkxp :uk: (BOB member since 2005-08-19)

8

When I put \servername\folder name in the unmanaged disk in CMC for deski job server, it changes it to forward slash //servername/folder and I dont see the file in the folder.
Do I have to put the account name at the bottom, the shared location has no security and can be accessed from the server.

venky80 (BOB member since 2006-11-02)

9

We use FTP.

It needs this:
a) Host Name
b) Destination Directory (without Drive Letter, and path must be forward slashes)
c) User Name
d) Password.

Every month our reports are stored by client on this shared drive which is password protected(only business users can access it)

BO_Chief :us: (BOB member since 2004-06-06)

10

Ya but how do you do it to an Unmanaged disk, I know FTP would work.
Thanks

venky80 (BOB member since 2006-11-02)

11

Yes, you have to enter the credentials of a domain user. Even if the network share is open, it will not accept a connection from the Local System account.

You can set the credentials either in the job server or the individual report.

Joe

joepeters :us: (BOB member since 2002-08-29)

12

Thanks Joe it worked.
Thank you others for giving your suggestions.

venky80 (BOB member since 2006-11-02)

13

HI - I’m curious - regarding sending reports to a file location… has anyone ever set up the server (enabled the unmanaged disk), scheduled a job (which worked fine), and then went back oh say the next day to do it again and that option disappeared from list of destinations?

This is happening to me… i enabled the ability to send to a specific file location and set up one scheduled job. I then went back later (like 4 hours later) to schedule another job and the option was gone from the menu… i went to CMC and doubled checked settings… all are still intacted…

I don’t get it… :hb:

Alandwehr :us: (BOB member since 2008-02-20)

14

Did you change the format to Excel or PDF? First you have to change that and then choose the destination.

madhu kothamasu :us: (BOB member since 2007-07-31)

15

Good Lord - I didn’t understand that from prior posts in this string… tried and it worked… i would think you’d put format before destination if that’s what determines which destination types are available…

Alandwehr :us: (BOB member since 2008-02-20)

16

It seems nobody answered your question. How to prevent it from turning back-slashes into front-slashes? :hb:

It turns \servername\folder into //servername/folder

How can I force it to keep my backslashes backslashes?

dorothy (BOB member since 2010-06-17)

17

[Moderator note - moved to XI Scheduler forum]

Nick Daniels :uk: (BOB member since 2002-08-15)

18

What version? XIr2 does this; I don’t think you can change it.

KSG :us: (BOB member since 2002-07-17)

19

Hi all,

we have req like .scheduling .Deski Reports and stores as a pdf in D or C drive of installed machine

pls sme one help

Thanks

bouserbo (BOB member since 2010-10-27)

20

What is the problem that you are having?

joepeters :us: (BOB member since 2002-08-29)