You searched for the word(s): userid:838465

More Search Options

RSS Available

• Pivot

  Hi I have gone through examples on pivot and unpivot online which are very good. However I have some questions which may or may not have to use this. Please suggest with your experience which is suitable for me. I have a TABLE in oracle as Australia Entry1 Apple $ 2 Japan Entry2 Guava $2 Australia Entry2 Guava $2 Hungary Entry3 Guava $2 Australia Entry2 Apple $2 Japan Entry1 Guava $2 Australia Entry4 Orange $2 Japan Entry2 Orange $2 My Output should be as follows where Amount is added w.r.t Entries

  Posted to Oracle (Forum) by silver_line on 4/14/2009

• Re: simple query but make row a column

  Hi, I have now come back to the same problem again. This works great for me. Except that I am limited to only Entry1/2/3/4. If I have to do this for many entries automatically, without having to painfully write them in the decode statement. How is this possible. Any pointers to some references is very helpful. Thanks,

  Posted to Oracle (Forum) by silver_line on 4/1/2009

• using math.round

  I have a table in my gridview and I need to compute percentage for one of the column. The equation is pretty basic, i am unable to use the correct type conversion. Please help. I have myDataTable_imgtype.Columns.Add( "Percentage" , typeof ( decimal ), "(Total*100)/(Sum(A)+Sum(B))" ); THis works and gives me in decimal and I want to convert to Math.Round using only 2 digits after the decimal. I tried using double .parse as well as follows. myDataTable_ora_fin.Columns.Add( "Percentage"

  Posted to Data Presentation Controls (Forum) by silver_line on 3/15/2009

• Re: simple query but make row a column

  Actually I got % to be like so and its working myDataTable_ora_fin.Columns.Add( "Percentage" , typeof ( decimal ), "(Total*100)/(Sum(Apple)+ Sum(Orange)+SUM(Guava))" ); I am unable to get Ctotal using the footer row. Please help

  Posted to Oracle (Forum) by silver_line on 3/11/2009

• Re: simple query but make row a column

  Sorry forgot to add one more thing. So I should get total in each column as I had mentioned above also I should get percentage for each of GHO next to each row as last colum The percentage will be ( Total in each row) / (Total of all columns put together) In other words as example COUNTRY Apple ORange Guava TOTAL % Japan 3 2 1 6 6/15 America 4 3 2 9 9/15 CTotal 7 5 3 15 I got Total , still need to get % and Ctotal. Thanks,

  Posted to Oracle (Forum) by silver_line on 3/11/2009

• Re: simple query but make row a column

  THanks I foiund the answer. i had an extra bracket, but error mssg was wierd. I had one more thing to add. To the colum of Apple, Guava and ORange I need to add total in each of its column and show at the footer. I tried like this in .cs file and did not work. Please help. GridViewf.FooterRow.Cells[8].Text = string .Format( "{0:C}" , myDataTable_ora_fin.Compute( "sum(Apple)" , "" ));

  Posted to Oracle (Forum) by silver_line on 3/11/2009

• Re: simple query but make row a column

  I get an error saying Not found The requested URL /apex/wwv_flow.show was not found on this server I dont know what this means. Thanks

  Posted to Oracle (Forum) by silver_line on 3/11/2009

• Re: simple query but make row a column

  Hi Suthish, THanks very much for the answer. Could you please check the syntax. It gives me errors. Also please add another column for doing percentage. The sum for each row is sum of Entry1+Entry2+Entry3+Entry4, so I can delete the entries above with Apple, Guava and Orange. But its not working for me. Sum of Apple in an entire column, put in the end. Same with Orange and Guava. Finally the percentage is calculated to be Total Apple sum/ (sum of Total Apple+ Total Orange+ Total Guava). Similarly

  Posted to Oracle (Forum) by silver_line on 3/10/2009

• Gridview (text-wrap) for header in dynamic gridview (autogenerate=true)

  Hi, I am doing a dynamic gridview and assigning a datasource to it. Problem is I am unable to format the header text to wrap=true. This is possible, I think only to a bound field. How I can do a text wrap to dynamically generating columns comin from datasoure. I am missing here..Please help. COUNTRYNAME ENTRYFORMS STORAGEDEVICE DeviceCore IMAGESHOLD ALLINCLUSIVE HARDWARE DESKTOPSOLUTIONSORGANIZATION IMG RDL GQI PWS Australia 0 0 0 0 0 0 0 1 3 0 0 America Thanks,

  Posted to Data Presentation Controls (Forum) by silver_line on 3/8/2009

• Re: Urgent!!! For loop adding data(html code) to datatable and Gridview

  HI Mudassarkhan, I am doing a dynamic gridview and assigning a datasource to it. Problem is I am unable to format the header text to wrap=true. This is possible, I think only to a bound field. How I can do a text wrap to dynamically generating columns comin from datasoure. I am missing here..Please help. COUNTRYNAME ENTRYFORMS STORAGEDEVICE DeviceCore IMAGESHOLD ALLINCLUSIVE HARDWARE DESKTOPSOLUTIONSORGANIZATION IMG RDL GQI PWS Australia 0 0 0 0 0 0 0 1 3 0 0 America Thanks,

  Posted to Free For All (Forum) by silver_line on 3/8/2009