Excel PivotTable from Cube: How to get a flat table? -

-

i'm importing data sql cube , have several row labels i'd show. there way not have hierarchical view? (aka no plus signs first row values, , instead show second row label's value next first row labels, etc.) i'd see data without being hidden or aggregated together.

figured out...

it's under pivottable tools > design > report layout > show in tabular form


Comments

Post a Comment

Popular posts from this blog

SAP Web Service from .NET via WCF -

-
i'm trying consume sap web service .net via wcf. i've generated proxy , have configured app.config file. here test code: webservicesap.ztest_rfcclient mywcfservice = new webservicesap.ztest_rfcclient("myendpoint"); mywcfservice.clientcredentials.username.username = "<username>"; mywcfservice.clientcredentials.username.password = "<password>"; webservicesap.ztestrfc parameter = new webservicesap.ztestrfc(); parameter.testinput = "this simple test"; webservicesap.ztestrfcresponse response = mywcfservice.ztestrfc(parameter); console.writeline(reponse.testoutput); console.readline(); the ztestrfc sap method simple function accepts input string, , outputs: "result: <the input string>" when call ztestrfc method, got null value in variable response. soap messages seem fine. soap request <messagelogtracerecord> <httprequest xmlns="http://schemas.microsoft.com/2004/06/servic...
Read more

email - PHP Mail Error "The Page at X Says: E-Mail can not be sent!" -

-
i have simple contact page set form , sending details via email using php mail() function. when submit page works fine , email sends data no problems. however once has done popup in browser says: "the page @ (address) says: e-mail can not sent!" even though message not true , email sends fine need stop appearing halts page's execution , no more code ran after this. can't seem find error on google. here mail code anyway in case me causing it. $headers = "from: ".$email."\r\n"; $headers .= "content-type: text/html; charset=iso-8859-1\r\n"; $msg = ' <html> <body> <strong>enquiry www.mysite.com website</strong><br /><br /> <strong>name:</strong> '.$fullname.' <br /> <strong>email:</strong> '.$email.' <br /> <strong>phone:</strong> '.$phone.' <br /> <strong>message:</strong> '.$message....
Read more

Optimized Line drawing in QT -

-
i new qt. working on graphics. i using qwidget drawing graphics(for drawing graphics in qwidget paint event). need draw background , foreground graphics. background fixed graphics. foregrounds drawing lines. each 100 millisecond need draw 20points. drawing time 8 sec. total need draw 1600 points (total points represents contentious line). i using qtimer invoke drawing in each 100ms. first few drawing drawn fast. in middle of drawing it's become slow. the problem need draw foreground , background in each 100ms. please me fix problem. if 1 have sample code please provide. in advance. is there way draw partial area ie. particular modified region of graphics? qpainter-drawing can slow without hardware support. using qgraphicsview won't if lines visible, since internally uses qpainter anyway. if have draw 20 new points (or lines) per update , per update background gets cleared have render again, there few things try: 1) disable background autofill. see...
Read more