Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

crystal reports - Sub total each cross tab group with grand total in end? -


i have result of query in form

empid     profit   orderid      companyname ------    ------   -------     --------------   1       500 $      1         acme company   1       200 $      1          evolve corp.    2       400 $      1         acme company      2       100 $      1          evolve corp.   3       500 $      1         acme company     3       500 $      1          evolve corp.  

now desired report format is

     empid  orderid  acme's profit     evolve's profit      -----  ------   -------------     ---------------        1      1         700 $               700 $         total  ----       -----               ------                           700$                700$        2      1         500 $               500 $        total  ----       -----               ------                           500$                500$        3      3         1000 $              1000 $        total  ----       -----               ------                           1000$               1000$      -----   ----     ----------           ----------     grandtotal           2200 $               2200 $ 

i tried hard @ crosstab i'm unable figure out how group records. tried moving companyname in crosstab columns , moved empid in rows & tried cross tab group results not expected.

my questions 1) format achievable cross tab ? 2) how group record's empid's in crosstab in such way companies moved horizontally ?

edit: need sub totals & grand total field.

put company in columns section , you're go.

sample image


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -