Hi
I have designed a SQL Server Report Serverice project using SQL Server 2005 and VS.NET 2005 for an ASP.NET 2.0 project. In my project, the report data is supplied from a StoredProceduren, which return day to day statistic day of a suppliers raw material like rectified Spirit (RS), Neutral Spirit (NS), Denatured Spirit(DS)......etc.
Something like Opening Balance, Manufactured, Issued, Loss, Closing Balance. With respect to the product and supplier code. The output data consits of three rows for each product, in which the first row represents the particular days statistic data, the second row represents the first of the month data( i.e the opening balance will start from first of the month till the particular date Closeing Balance) and similarly the third row consist of the 1st of the July of the respective year.
| OpenBalance |
RDate |
othersource1 |
othersource2 |
fromsource1 |
othersource3 |
othersource4 |
fromsource2 |
Utilization |
totloss |
Product Code |
SupplierCode |
| 88431.705 |
00:00.0 |
NULL |
NULL |
500 |
NULL |
NULL |
200 |
NULL |
0 |
6 |
PD004 |
| 73019 |
00:00.0 |
NULL |
NULL |
23372 |
NULL |
NULL |
2741 |
NULL |
0.295 |
6 |
PD004 |
| 73019 |
00:00.0 |
NULL |
NULL |
23372 |
NULL |
NULL |
2741 |
NULL |
0.295 |
6 |
PD004 |
| 245986.735 |
00:00.0 |
NULL |
NULL |
7000 |
NULL |
NULL |
500 |
200 |
0 |
4 |
PD004 |
| 240899.88 |
00:00.0 |
NULL |
NULL |
11487 |
NULL |
NULL |
2600 |
2380 |
1500.145 |
4 |
PD004 |
| 240899.88 |
00:00.0 |
NULL |
NULL |
11487 |
NULL |
NULL |
2600 |
2380 |
1500.145 |
4 |
PD004 |
| 100509.715 |
00:00.0 |
0 |
0 |
800 |
0 |
1800 |
700 |
NULL |
0 |
5 |
PD004 |
| 95099.855 |
00:00.0 |
15100 |
15000 |
1500 |
1500 |
2500 |
5410 |
NULL |
0.14 |
5 |
PD004 |
| 95099.855 |
00:00.0 |
15100 |
15000 |
1500 |
1500 |
2500 |
5410 |
NULL |
0.14 |
5 |
PD004 |
I have used a matrix control in SQL Server Report Serverice to display the report. where the rows will be displayed in vertical order, somthing like this
| FORM 1 |
|
|
|
| on the day of report |
From 1st of Month |
From 1st of July |
| Medium Grade Alcohol |
1. Opening Balance |
88431.705 |
73019 |
73019 |
| |
|
|
|
| |
|
|
|
| 2.Production of Distillery From Molasses |
500 |
23372 |
23372 |
| From IS/RD |
200 |
2741 |
2741 |
| |
|
|
|
| |
|
|
|
| 3. Total |
89131.705 |
99132 |
99132 |
| |
|
|
|
| 4. Issues(details given below) |
|
|
|
| 5. Loss |
0 |
0.295 |
0.295 |
| 6. Closing Balance |
89131.705 |
99131.705 |
99131.705 |
| Rectified Spirit |
1. Opening Balance |
245986.735 |
240899.88 |
240899.88 |
| |
|
|
|
| |
|
|
|
| 2.Production from Primary |
7000 |
11487 |
11487 |
| Redistilled |
500 |
2600 |
2600 |
| |
|
|
|
| |
|
|
|
| 3. Total |
253486.735 |
254986.88 |
254986.88 |
| Used for R.D to N.S |
200 |
2380 |
2380 |
| 4. Issues(details given below) |
|
|
|
| 5. Loss |
0 |
1500.145 |
1500.145 |
| 6. Closing Balance |
253486.735 |
253486.735 |
253486.735 |
| Neutral Spirit |
1. Opening Balance |
100509.715 |
95099.855 |
95099.855 |
| 2. Quantity of RS received from Distilleries for distillation |
0 |
15100 |
15100 |
| 3. Quantity of RS received from other Distilleries for distillation |
0 |
15000 |
15000 |
| 4.Quantity of NS Received from own Distillery |
800 |
1500 |
1500 |
| 5. Quantity of NS Manufactured |
700 |
5410 |
5410 |
| 6.Quantity of RS below 65 OP Manufactured |
0 |
1500 |
1500 |
| 7. MGA used for Redistillation |
1800 |
2500 |
2500 |
| 8.Total |
102009.715 |
102009.855 |
102009.855 |
| |
|
|
|
| 9. Issues(details given below) |
|
|
|
| 5. Loss |
0 |
0.14 |
0.14 |
| 11. Closing Balance |
102009.715 |
102009.715 |
102009.715 |
In which certain data which are in one product does not have data for other something like (where you can see the blank spaces after the Opening Balance of RS).
I just want to delete the row, where its value is NULL.
For any help could be appreciated
Thanks.