Current Position:Home > Problem when exporting Query from Web template to Excel Sheet.

Problem when exporting Query from Web template to Excel Sheet.

Update:11-30Source: network consolidation
Advertisement
Hello,
Im encoutering a problem when im trying to export query output from web template to excel sheet.
A popup windown appears when excel sheet opens which reads.."problem cameup in the following areas during  load : Cell Value".The report layout appears to be fine but the totals shows unwanted values starting with * followed by number.
Any valuable inputs, what could be the problem. where can i rectify the same.
Regards
Ellora

The Best Answer

Advertisement
Hello A K,
Thanks for ur time and response but the option u mentioned did not serve my purpose.
The problem seems to be only with pirticular cells.As mentioned earlier the layout appears properly..all the values are seen..but the end result..totals are disturbed.
eg: If the report shows in template the total value :20,668,554...when exported the values is shown as **668553.88000000600000.
So what could be the problem ? any template setting ? global setting to look at ?
Regards
Ellora
  • Problem when exporting Query from Web template to Excel Sheet. Update:11-30

    Hello, Im encoutering a problem when im trying to export query output from web template to excel sheet. A popup windown appears when excel sheet opens which reads.."problem cameup in the following areas during  load : Cell Value".The report layo

  • Problem while exporting the text written on web-template to excel. Update:11-30

    Hi Experts, I created a report at WAD ,while exporting it to excel all the web items got exported except for the text written on the web-template. Is it possible to export the text written on web-template to excel??? Also i dont want to add the text-

  • Long Query Runtime/Web-template Loading time Update:11-30

    Hi, We are having a very critical performance issue, i.e. long query runtime, which is certainly not acceptable by client as well. <b>Background Information</b> We are using web application designer (WAD) 2004s release to design front end of o

  • Variance Scaling in Query and Web Template Showing Different Results Update:11-30

    Hi experts, I have the following problem - variance scaling in my query and web template are showing different results. My variance in column is set as follows: Formula: NODIM(A % B) Scaling Factor: 1 I have a structure in row that uses Scaling Facto

  • Authorization to query and web template in BI 3.5 Update:11-30

    Hello I need to grant users athorizatio to the WEB template and its query. Query is based on Multiprovider. Should I save query and WEB template to existing role and grant authorizaion to tis role or I also need to grant authorization to multicube an

  • Filters Query and Web Template Update:11-30

    Dear All, Many reports use filters in both the query and the web template. What is the difference? Regards, KSthe filter used in query and web templates are same there is no difference between filters used. as webtemplate uses the same query as its d

  • IE error of query and web template Update:11-30

    Hello experts, We had completed the configuration of " Integration into Portal" successfully. Query and web template can execute successfully via "Execute" button. After click "Execute" button, query or web template display t

  • How to export the data from table to excel sheet Update:10-11

    hi experts i have some problem am trying to export the data fro table to Excel sheet  in the view controller i have created one button wit public void onActionCLEAR(com.sap.tc.webdynpro.progmodel.api.IWDCustomEvent wdEvent )     //@@begin onActionCLE

  • Export Multiple tables into a single Excel Sheet Update:11-30

    We have a use case where we need to export multiple tables into an excel sheet. The exportCollectionActionListener only allows one table (which is provided in the exportedId attribute) to be exported into Excel. So is there a method provided by adf t

  • How to use a query in Web template Update:10-11

    Hello i have really a very silly question. How can i use a Query that is already defined by BEX into a Web template so that i can set up simple properties like changing colours of Row as well as avoid Tab pages. I logged into a Web template. Can any