Data Display

Question

I am getting data in the following way Sr no TRANSACTION TYPE dptd_slip_no NO OF SLIP PROCESSED 2 ACCOUNT TRANSFER COM09000000025 1 3 ACCOUNT TRANSFER COM09000000067 1 5 ACCOUNT TRANSFER POA09000000621 1 1 INTER DP TRANSFER 10129 1 4 INTER DP TRANSFER ID 000000209

Suthish Nair · Answer

i think this ca easily done on SQL level. anyways you got the required output.

Mayur Gujrathi · Answer

Thanks Body I have solved in this way Dim strtbl As New StringBuilder dtParam.Columns.Add(New DataColumn("@PA_EXCH_CD", GetType(String))) dtParam.Columns.Add(New DataColumn("@pa_audit_report_no", GetType(String))) dtParam.Columns.Add(New DataColumn("@pa_from_dt", GetType(String))) dtParam.Columns.Add(New DataColumn("@pa_to_dt", GetType(String))) drParam = dtParam.NewRow() drParam("@PA_EXCH_CD") = ddldp.SelectedItem.Value drParam("@pa_audit_report_no") = 6 drParam("@pa_from_dt") = Request("txtfrmdt").ToString drParam("@pa_to_dt") = Request("txttodt").ToString dtParam.Rows.Add(drParam) clsdb.Objdatareader = clsdb.ExecuteNonQueryWithReturnCursor("pr_auditreport", dtParam, "pkg_mak_chk") strtbl.Append(" ") strtbl.Append(" ") strtbl.Append(" ") strtbl.Append("   ") strtbl1.Append(" ACCOUNT TRANSFER ") strtbl2.Append(" DELIVARY OUT TRANSFER ") strtbl3.Append(" EARLY PAYIN TRANSFER ") strtbl4.Append(" INTER DP TRANSFER ") strtbl5.Append(" INTER SETTLEMENT TRANSFER ") strtbl6.Append(" POOL TO POOL TRANSFER ") If clsdb.Objdatareader.HasRows Then While clsdb.Objdatareader.Read() j = j + 1 count = count + clsdb.Objdatareader("NO OF SLIP PROCESSED") PrevEntm = clsdb.Objdatareader("TRANSACTION TYPE") If (clsdb.Objdatareader("TRANSACTION TYPE") = "ACCOUNT TRANSFER") Then flag1 = True strtbl1.Append(" ") strtbl1.Append(" " & j & " ") strtbl1.Append("  " & clsdb.Objdatareader("dptd_slip_no") & " ") strtbl1.Append("  " & clsdb.Objdatareader("NO OF SLIP PROCESSED") & " ") strtbl1.Append(" ") ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "DELIVARY OUT TRANSFER") Then flag2 = True strtbl2.Append(" ") strtbl2.Append(" " & j & " ") strtbl2.Append("  " & clsdb.Objdatareader("dptd_slip_no") & " ") strtbl2.Append("  " & clsdb.Objdatareader("NO OF SLIP PROCESSED") & " ") strtbl2.Append(" ") ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "EARLY PAYIN TRANSFER") Then flag3 = True strtbl3.Append(" ") strtbl3.Append(" " & j & " ") strtbl3.Append("  " & clsdb.Objdatareader("dptd_slip_no") & " ") strtbl3.Append("  " & clsdb.Objdatareader("NO OF SLIP PROCESSED") & " ") strtbl3.Append(" ") ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "INTER DP TRANSFER") Then flag4 = True strtbl4.Append(" ") strtbl4.Append(" " & j & " ") strtbl4.Append("  " & clsdb.Objdatareader("dptd_slip_no") & " ") strtbl4.Append("  " & clsdb.Objdatareader("NO OF SLIP PROCESSED") & " ") strtbl4.Append(" ") ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "INTER SETTLEMENT TRANSFER") Then flag5 = True strtbl5.Append(" ") strtbl5.Append(" " & j & " ") strtbl5.Append("  " & clsdb.Objdatareader("dptd_slip_no") & " ") strtbl5.Append("  " & clsdb.Objdatareader("NO OF SLIP PROCESSED") & " ") strtbl5.Append(" ") ElseIf (clsdb.Objdatareader("TRANSACTION TYPE") = "POOL TO POOL TRANSFER") Then flag6 = True strtbl6.Append(" ") strtbl6.Append(" " & j & " ") strtbl6.Append("  " & clsdb.Objdatareader("dptd_slip_no") & " ") strtbl6.Append("  " & clsdb.Objdatareader("NO OF SLIP PROCESSED") & " ") strtbl6.Append(" ") End If End While If (flag1) Then strtbl.Append(strtbl1) End If If (flag2) Then strtbl.Append(strtbl2) End If If (flag3) Then strtbl.Append(strtbl3) End If If (flag4) Then strtbl.Append(strtbl4) End If If (flag5) Then strtbl.Append(strtbl5) End If If (flag6) Then strtbl.Append(strtbl6) End If strtbl.Append(" GRAND TOTAL OF SLIPS " & count & " ") strtbl.Append(" ") strtbl.Append(" ") Response.Write(strtbl.ToString())

Suthish Nair · Answer

You need two different queries. 1. using group by. 2. for taking counts. later combine both and do a sorting.

Mayur Gujrathi · Answer

ACCOUNT TRANSFER COM09000000025 COM09000000025 POA09000000621 NO OF SLIP ISSUED 3 INTER DP TRANSFER 10129 NO OF SLIP ISSUED 1 Ok consider in this way

Sam Hobbs · Answer

I think that no one can understand what you need to do since in the first version there is only one COM09000000025 but in the second version you show 3 of them.

Mayur Gujrathi · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} BUT I want to display inthis way previously i am showing in gridview ACCOUNT TRANSFER COM09000000025 COM09000000025 COM09000000025 NO OF SLIP ISSUED 3 Please help Also not getting in which control i should display

Sr no	TRANSACTION TYPE	dptd_slip_no	NO OF SLIP PROCESSED
2	ACCOUNT TRANSFER	COM09000000025	1
3	ACCOUNT TRANSFER	COM09000000067	1
5	ACCOUNT TRANSFER	POA09000000621	1
1	INTER DP TRANSFER	10129	1
4	INTER DP TRANSFER	ID 000000209

Data Display

Answers (6)