Recent content by abhishekpant

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...

Goerge I am new to this.. yeah it works.\ Thanks ABhi

Thanks Goerge But I need to find out the Ids which are present in table A but not In table B Does this query do the same thing?? Thanks Abhi

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

Hi I am trying to show last 4 digit of the number. example 0000012345353211344 I want to show 1344 can any one help thanks Abhi

Hi MCS OTHER WCS Grand Total tier1 ABN AMRO 695,080 306,000 70,000 1,071,080 ING 234,000 234,000 Total 929,080 306,000 70,000 1,305,080 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...

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...

i am very sorry . i am so confused atb this time .i have to add to column not two tables.. abhishek

Hello Access/cr10 Data company name member name associate name citibank citibank sears citibank citibank baramex chase chase bankone i have to combine these three table and get one new table expected result client 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 not able to find out cms is running on my machine or not please help

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...