How to add a subtotal row after dgv tabel in print document (invoice) ?

Question

1.00/5 (2 votes)

See more:

" i can't give subtotal label fixed value like
new point (100,100)
because dgv rows changeable size depends in number of rows
how to add subtotal label after dgv rows ?

e.Graphics.DrawString(label51.Text.ToString(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, new Point(100, 100), format);

Here is my code:

C#

  e.Graphics.FillRectangle(Brushes.Yellow, new Rectangle(30, height, 60, dataGridView5.Rows[0].Height));
                e.Graphics.DrawRectangle(p, new Rectangle(30, height, 60, dataGridView5.Rows[0].Height));
                e.Graphics.DrawString(dataGridView5.Columns[9].HeaderText.ToString(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, new Rectangle(30, height, 60, dataGridView5.Rows[0].Height), stringFormat);
int Height1 = 0;
                Height1 = 150;



                while (i &lt; dataGridView5.Rows.Count)
                {
                 

                    if (Height1 &gt; e.MarginBounds.Height)
                    {

                        Height1 = 150;
                        e.HasMorePages = true;
                        return;
                    }
                  

                    Height1 += dataGridView5.Rows[i].Height;

                    e.Graphics.DrawRectangle(p, new Rectangle(30, Height1, 60, dataGridView5.Rows[0].Height));
                    e.Graphics.DrawString(dataGridView5.Rows[i].Cells[9].FormattedValue.ToString(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, new Rectangle(30, Height1, 60, dataGridView5.Rows[0].Height), stringFormat);

                    i++;

                }
                i = 0;
            }

Here is what i want to get:

product_name || amount || price || total 
----------------------------------------
   clothes        1        45       45
   shoes          2        12       24
----------------------------------------
                         total      69
                         discount    9
                         subtotal   60

Posted 4-Jan-16 1:45am

Peter M. Adeeb

Updated 4-Jan-16 9:34am

Maciej Los

v4

Add a Solution

Comments

ZurdoDev 4-Jan-16 8:06am

Use labels. Where are you stuck?

Peter M. Adeeb 4-Jan-16 9:43am

i want to add total row to print page after dgv tabels
in winforms applications

ZurdoDev 4-Jan-16 9:45am

OK. So, add it. Where are you stuck?

Peter M. Adeeb 4-Jan-16 9:49am

i'm using code like that
e.Graphics.DrawString(label51.Text.ToString(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, new Point(100, 100), format);

now i want to add sub_total after dgv rows @ last print page only

ZurdoDev 4-Jan-16 9:52am

1. Please click Improve question and show the relevant code. There are a million ways to do this so you need to show us where you are stuck.
2. If you are using DrawString to print the values why can't you print a subtotal row?

Peter M. Adeeb 4-Jan-16 10:01am

please review the improve
thanks

ZurdoDev 4-Jan-16 10:02am

You still haven't explained why you are having a problem. I don't know how to help you.

Peter M. Adeeb 4-Jan-16 10:07am

the problem is here
i can't give label fixed location in print document like that(( new Point(100, 100) ))
because dgv hasn't fixed number of rows
i want to add subtotal label after last row of dgv in print document

ZurdoDev 4-Jan-16 10:07am

How are you printing the rest of the document?

Peter M. Adeeb 4-Jan-16 10:13am

e.Graphics.FillRectangle(Brushes.Yellow, new Rectangle(30, height, 60, dataGridView5.Rows[0].Height));
e.Graphics.DrawRectangle(p, new Rectangle(30, height, 60, dataGridView5.Rows[0].Height));
e.Graphics.DrawString(dataGridView5.Columns[9].HeaderText.ToString(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, new Rectangle(30, height, 60, dataGridView5.Rows[0].Height), stringFormat);
int Height1 = 0;
Height1 = 150;

while (i < dataGridView5.Rows.Count)
{

if (Height1 > e.MarginBounds.Height)
{

Height1 = 150;
e.HasMorePages = true;
return;
}

Height1 += dataGridView5.Rows[i].Height;

e.Graphics.DrawRectangle(p, new Rectangle(30, Height1, 60, dataGridView5.Rows[0].Height));
e.Graphics.DrawString(dataGridView5.Rows[i].Cells[9].FormattedValue.ToString(), new Font("Arial", 10, FontStyle.Bold), Brushes.Black, new Rectangle(30, Height1, 60, dataGridView5.Rows[0].Height), stringFormat);

i++;

}
i = 0;
}

ZurdoDev 4-Jan-16 10:21am

So what happens when you then try to draw the subtotal below this?

Peter M. Adeeb 4-Jan-16 10:27am

i'm asking how ???

ZurdoDev 4-Jan-16 10:36am

Yes, I understand that. But here's what you have shown us.

1. You have code that prints out what you want.
2. Below #1 you want to print something else and you have code that will print it.

Why doesn't it work? None of us can tell you because we can't run your code. We can't see your screen. We can't see what happens when you try to do what you have done. You need to be more clear.

Peter M. Adeeb 4-Jan-16 10:45am

thanks @ryandev for respond
i want to draw subtotal label in print document after drawing dgv rows
the problem i can't give subtotal label fixed value like
new point (100,100)
because dgv rows changeable size dependes in number of rows
i hope you understood me
i'm sorry for my bad english

ZurdoDev 4-Jan-16 10:50am

" i can't give subtotal label fixed value like
new point (100,100)
because dgv rows changeable size depends in number of rows" - OK. now it makes sense. I would suggest editing your original question and posting that information there.

I'm not sure of the right answer but since you are looping through the rows to print them I would think you could keep track of where the last row was printed to.

Peter M. Adeeb 4-Jan-16 10:53am

that's it
now you got me
can you give me sample code to trace last row and then draw subtotal label ??

Pravin.Bhosale01 4-Jan-16 8:27am

Confusion: you want subtotal only in print? you don't want to display on normal view? Please add more details.
More Details: are you working on desktop application? or web application? Any specific issue using labels as per RyanDev's comment?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)