Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: abhishekpant
  • Order by date
  1. abhishekpant

    Decimal calculation problem

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

    Decimal calculation problem

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

    Joining two tables

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

    Joining two tables

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

    Joining two tables

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

    how to convert string into number

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

    Showing just 4 digit of the number

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

    page break in cross tab

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

    page break in cross tab

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

    combining two tables

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

    combining two tables

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

    if then else staement?

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

    if then else staement?

    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…...
  14. abhishekpant

    connectivity with crystal enterprise?

    i am not able to find out cms is running on my machine or not please help
  15. abhishekpant

    connectivity with crystal enterprise?

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

    connection with database..

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

    connection with database..

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

    Printing records on separate pages...

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

    group by second letter of last name

    hi jaspaul, Which version of crystal report yuo sre working on.. IN crystal report 10, go to insert,group and add group by name cheers abhishek
  20. abhishekpant

    how to call a subreport in a cross tab?

    Can anyone tell me if we can call a subreport in across tab. If yes then how thanks Abhishek

Part and Inventory Search

Back
Top