[sqr-users] Re: Export data into Excel....... (Srinivas Amaragani)

[edwin.hommes@bluewin.ch]

Srini, I am not sure I completely understand your problem, but if you define
your output within the SQR, just name it something.xls
However, if you want to do it through the PS process scheduler, you will
have to amend the process defenition.
In the process defenition, find the "destination" tab (4th tab). There you
will see several options, the most important being: destinationsource. Set
that to Process defined and the large box becomes available. There you can
enter the name of your output file (e.g. something.xls). 

Hope this helps


3. Re: Export data into Excel....... (Srinivas Amaragani)

You are right we can rename to .xls when we open CSV file in Excel, but here
my requirement is different..let me explain you what we are doing exactly.

We are scheduling sqr reports on one scheduler and keeping pdf,csv outputs
in brio repositories. For users access we created a EIS Bqy, this bqy is
allows access users to pre- runned pdf and csv files from repository. So
why i need .xls file ??? Brio EIS section i can format .xls file, but i can't
format .csv file.

Here we are generating 100's of csv files , there is no chance to change
.csv to .xls because everything is automated.

Schedule SQR Reports --> After run (Sits out put in Brio Repository) -->
Browser(User access reports via EIS Interface or DashBoard).

I hope you understand when we export data into .CSV file

1) When file open -- its open in Notepad until we setup path to excel(select
file open with Excel, atleast one time) 

2) Column length not fit into cell width and can't format bold etc., things.

 

Brio Designer we can format .XLS file using JOOLE Script. 

I hope now you understand my problem.....thanks for your reply.

Srini




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users