how to display amount monthly,annually in the reports

Question

0.00/5 (No votes)

See more:

Hi,
i want to display Premium amount in the Reports basis on the PolicystartDate
how to show Monthly and Annually.I have(Policydate,PaymentMode,Premium amount)
how to make view in the sql2008.
so it will help in the reports.

Policystatedate clientName Premium amount Premiummode PolicyNo
23/03/2011 sa 1000 monthly 14
23/04/2012 ba 2000 Anunally 15

i want to make this type of calendar view.

PolicyNo clientName jan feb march april may june july aug sep oct nov dec
14 sa 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000

15 ba 2000 amount will be April

how to make this crosstab Reports???
plz tell me.

thanks for advance

Posted 10-Jul-12 3:19am

sadhana4

Updated 10-Jul-12 4:03am

v4

Add a Solution

Comments

Sandeep Mewara 10-Jul-12 10:04am

What have you tried so far? Do you know how to make crosstab report?

sadhana4 12-Jul-12 10:28am

no i dont kw how to make the crosstab reports

3 solutions

Add a Solution

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)

sahabiswarup · Answer 1 · 2012-07-10T08:20:00

Solution 1

sadhana you must read PIVOT function which will help you to modify your table as per your requirement.
check this below link; hope it helps
Converting two column as row from a table[^]

Posted 10-Jul-12 8:20am

sahabiswarup

vivek.bagdai · Answer 2 · 2012-07-10T08:49:00

Solution 2

In this case you need to do is

Make table
Fields are Date, Name, Amount, PremiumMode, Jan, Fab, .... ,Dec

Now check condition

if(premiumMode = Monthly) THEN
 insert into Jan...Dec equal to Amount
else
 put that empty

In report you will get you required output

All The Best.

Posted 10-Jul-12 8:49am

vivek.bagdai

Updated 11-Jul-12 8:50am

v4

Sandeep Mewara · Answer 3 · 2012-07-12T20:08:00

Solution 3

Since you are not even aware of how to create cross tab reports, start from here:
MSDN: Cross-Tab Reports[^]
Video: Crystal Reports Tutorial Creating Cross-Tab Reports[^]
Cross Tab Reports[^]

Go through them, try out!

Posted 12-Jul-12 20:08pm

Sandeep Mewara