Configuration Error

Question

Dear All,

i got this error
 
"Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified." when i put the published file on another pc which have vs2008 and iis 7.5. i search on net a lot every body says install crystalreport but i don't know from where can i get. can some body help me to solve this issue and i have attache the image also please look and give the solution.



thanks in addvance

Answer 1

i solved it 

Select Cast(SUM((O_ttotal + P_vatto) * (P_totdis / 100)) As Decimal(9,2)) As TotalDiscount From PRO_BILL

Answer 2

@Abrar that i also know, in this way i get two answers i want the whole total of (A+B+C) not (A+B) and C

Answer 3

HI, when you are using the aggregate sql function then you have to define the group by clause.

like 
cmd = new SqlCommand("Select (SUM(P_ttotal)+SUM(P_vatto)* (P_totdis)/100) as dis  from PRO_BILL group by P_totdis", conn);