I have 3 columns College, Year and programs and the data looks like
College Year Program
2005-2006 1styear Maths
Physics
English
Earth Science
2006-2007 2ndyear AB
CD
EF
GH
IJ
KL
MN
OP
QR
2007-2008...
Thanks lb.
I have the following text field in the application in 4 lines
A
B
CD
EFG
No matter how I format the field in the front end application, in crystal report when I set the field formatting to html text, it shows up as ABCDEFG without the tags and other formatting like line break...
I have a crystal report designed using crsystal reports V11.
A few fields in the database are stored in html tags.
When I show these fields in the report, the html format is showing
up.
When I right click on the fields ----> Format field ----> Paragraph
----> Text interpretation ----> HTML...
I have orderid, customer name and orderamt
1, abc, 950
2, abd, 500
3, abe, 450
4, abf, 1950
5, abg, 1200
6, abx, 2200
7, aby, 2500
8, abz, 2700
9, abxx, 2800
10, abzz, 3100
I want to pass one parameter number, 100 or 500 or 1000 so that the order amt results are grouped based...
I have completely 2 different datasources pcp1 and pcp2 and are not related
The data coming from pcp1 and pcp2 is most of the times same but not always.
I have a cross tab in the main report taht displays data from pcp1 and subreport
that displays data from pcp2
my goal is to find if there is...
I have a Cross tab that has
Rows
Country
Columns
Year
Summarized fields
orderamt
Profit(Y/N)
sample data looks like
2001 2002
Austria Orderamt 4200 6000
Profit(Y/N) Y N
France Orderamt 5500 5000
Profit(Y/N) N N
Germany Orderamt 12000 10000
Profit(Y/N) N Y
Ireland...
Hi Tested again,
USE
create 2 formulas
@Cash
if Cash = 0 then Cash else 0
@NonCash
if NonCash = 0 then NonCash else 0
insert a sum on these 2 formulas in GF4 and u can suppress it.
then go to report ---->selection formulas----> Group and write a condition
sum(@Cash,transdate) = 0
and...
create 2 formulas
@Cash
if Cash <> 0 then Cash else 0
@NonCash
if NonCash <> 0 then NonCash else 0
insert a sum on these 2 formulas in GF4 and u can suppress it.
then go to report ---->selection formulas----> Group and write a condition
sum(@Cash,transdate) = 0
and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.