That will not be the case at all throughtout the table but if thats the case than we should show all the prices for that product...i.e all different prices
Thanks
ABhishek
Table A
PRODUCTID PRICEDATE PRICE SOURCE
1 20080102 10.12 A
1 20080102 10.13 B
1 20080102 10.12 C
1 20080102 10.12 D
2 20080102 43.23 A
2 20080102 43.26 B
2 20080102...
All
I have two table A and B.
I need to find out the records in table A which are not present in table B
The both the table have secutity ID.
So basically i need to find out that the list of securityId which are present in table A and not in table B.
Can someone help??
Thanks
Abhi
Hi All
I am using XML and CR 10
All the data is in XML Files is not numeric
I want to convert String into Number and insert summary(count) to that field.
can any one help
Thanks
Abhi
...This is the result when did what you told.
Actually i have five groups(column)i.e MCS ,OTHERS,WCS,ASR,ASE
Tier 1 does not have any data in ACS and ASE but i want to show this in result.
2.By %age i mean I need to add another another summary
formula is:
total*100/grand total
how do i do this?
Hi all,
i am using access 2000/cr10 for generating report.
I have a cross tab
row :tier
:Client name
column:group
sum:amount
I have five tier
Can i have the page break with the change of tier.
expected result:
group
tier1 amount
client name
group...
...chase chase bankone
i have to combine these three table and get one new table
expected result
client name
citibank
citibank
chase
* when associate name is different from member name then it should read the member name(in the data member name is same as company name)
thanks for the tips for submitting a post
Access/cr 10
Data on the table.
Member Associate tier type
Chase bankone 1 G
Citibank Sears 2 P
Citibank baramax 2 p
Xyz (blank) 3 (blank)
I the type...
I am using acess and crystal report 10
I have few question……
1.I have some of these table in a query
Member Associate tier type
Chase bankone 1 G
Citibank Sears 2 P
Xyz no value assign 3 no value assign
And so on…...
I am using cr 10 with sql server on my laptop.I am working anywhere just trying to get hold of this softare for future use and i am having a problem with connection to CE. when i try to connect to enterprise it give this messase: "Unable to retrive cluster member. CMS host 'ABHISHEK' can be...
in a report i have to use two database.initially when i start the crystal report i connect to one database and when i tried to connect to different database it shows connectio failed..with database2
abhishek
i am facing problem while connecting to database. Can anyone tell me if one can connect to more than one database at time in a report in run time.
can anyone help
hi paul,
I was also looking forthe similar thing but when i select new page page after box in the selection expert it give i extra page in the last.So if we have ten customer then it shows 11 pages instead of 10 anf the last page oly include the name of the field.
may be "ONEBIGSCOT" find his...
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.