Search results for query: *

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

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

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

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

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

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

hello, i want to add a group with the customer,s second letter of last name? can anyone help

i am dealing with a report which have three field room no price comments 101 120 non smoking 102 140 <null> 103 80 repaired i want to change the null value to "unknown" and be sorted in accending order,so the new table should look like room no price comments...

cr 10/sql derver need some help with the sub report 1.when i click on the customer name on the main report i get all the details of that customer. i i tried to do it by checking the option of make sub report as a hyperlink than in the subreport it gives the detail of all the customer instead...

hi all, I want to print one record per page .i have a group of customer homecountry usa has 2 customer so my first page will be like this like.. customer name first name usa usa motors abhishek next page customer name first name allen motors allen and...

i have a data which required to print per page i.e i have a group of countries on the report. i want to preview one country name per page that include the list of customers in that country.and the page number is set according to the country. if a country have 5 customer than it shows the total...

MY TABLE IS LIKE THIS. ROOM PRICE COMMENTS 101 $34.50 CLEANED 102 $50.00 NULL 103 $60.90 NOT CLEANED I WNT MY REPORT LIKW ROOM PRICE COMMENTS 101 $34.50 CLEANED 102 $50.00 REPAIR 103 $60.90 NOT CLEANED CAN ANYONE HELP

i have just started working with crstal report and i have been struggling with sql querries and store procedures. Are store procedure are sql queries?