on 04-27-2010 8:58 AM
Hi,
I have WEB I report in which I have two Reports. One report is in Tabular format while other is in Graph format.The grap report is created by using the feature of "Inserting New report" of WEBI. But whenever I am trying to save it to my computer as EXCEL then I am not gettting it saved into multiple tabs like Sheet1 and Sheet2 in Excel.
Please tell me what should be done.?
Thanks & Regards
Ani
To export reports in tabbed excel
-- Make sure you have report tab in Web Intelligence Report
-- Name of the table should not more than 30 char ( though its not restriction) otherwise tab names will trim in excel
-- Don not use special characters in tab names in WEBI.
Reply if still facing issue.
--Kuldeep
Edited by: Kuldeep Chitrakar on Apr 27, 2010 2:22 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
When I try, there is no problem.
try this
File > Save As > Excell. the save as box will seem. right side of box, you can chose which reports tab do you want to export.
chose from this " Select All" and than click Save.
best regards
bulgur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi anushree
After creating the webi document which containing two or more reports,
save it first and then save it as an excel file,
Now you got the options like select reports.
check all the reports and then click the radio button "Prioritize easy data processing in excel document".
now you will get all the reports that you created in the webi will be reflected in your excel file.
Thanks & regards
Sreekanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ani,
Are you using two report tabs in webi or creating tabular and grap report in one report only.
Also which kind of graph you are creating?
Try to create a fresh report with graph only and no tables and see after exporting how it behaves?
Regards,
GS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.