Search results for query: *

I want to convert an Htm file to Html. I want to view the html file in Mobile device and I have 30 htm files which have to be converted to html every day. The Mobile device is not accepting the *.htm but accepting *.html. I tried using the following codes but none of them helped .... Ren...

Hello Gurus, Following Code is part of UNION QUERY ... after the UNION i would like to have the SUM of Value of the Columns ABSMG (quantity) VVBUM (Gross Sales) VVNUM (Net Sales) I am getting an error when I directly use a SUM FUNCTION at the following line of CODE as shown below...

Hi gurus, How do I create totals for specific columns in a Union Query? Some code would be of Great appreciated

Hi gurus I have an Existing Query which joins couple of table and generates a Table VIEW. I need to write another query which should generate the SUMMARY 2 colums of that table (Quantities and Revenue)of that in the next row of the TABLE... Any inputs are highly appreciated. Cheers Pr

Hi Guru's SELECT convert(numeric(10),a.partner(isnull(a.partner,'0'))) as Partnernr from smokna1 as a I am getting the following Error message - Invalid Object name a.partner PR

I would like to convert Varchar to Numeric and the following code am using in SQL but still am getting problems... cast(Cast(a.partner as char)as numeric(10)) as Partnernr regards.. PR

I have an interface in which I write SQL (Select statements) and generates an access table... The data is being filled properly in the table but after writing around 550 records then I get an Alert ": ERROR CODE 3001 INVALID ARGUMENT. " By going on clicking the alert box the DATA is getting...

Dear Gurus I have a subreport which retrieves the Summary of the main report. The heading of the MAINREPORT is repeated in the SUMMARY section if the Summary is more than 1 page I see the heading of the MAINREPORT how do I omit the HEADING in the SUMMARY REPORT. Thanq BVK

Hello Guru's I have subreport which generates Summary of the Main report. I have defined the Heading for the Summary in the SUBREPORT which is generated. When the Summary is more than 1 page the Heading is not shown in the Second page. Moving the heading from Report to PAGE Area was possibile...

Hello Gurus I am using CR9 and in the report displaying every page which has its Heading.. like Name Place Contact Type john FFM 01254 Doc but I would not like to see this Heading in the last page because I get the SUMMARY (which is a SUBREPORT) and this...

Hello Guru's ... Could anyone please help me with the formula where I can retrieve only the last 5 five Entries which is based on DATE.. For example a customer has 50 entries in 6 months but when I enter his Customer ID .. I want only the last 5 entries which he made may be in the last month...

Hello Guru's Is their a possibility to have Multiple Groups in a REPORT. I have seen it is possible but I see that it forms as a SUBGROUP to the Existing Group but I would like to have TWO PARALLEL Groups (NOT A HIERARCHY kind) If their is any possibility please let me know::: cheers bvk ...

Hello Guru's When I execute a report its retrieving around 3000+ Pages but for my other report their is an option of choosing Distinct which I checked in the Query analyzer while executing the report. Can anyone of you please tell me where can I select this option of Distinct in Crystal...

Hello Gurus! I need to add the values of the column DOC PHAR AND CLINIC and put the value in TOTAL ... Can anyone give a formula for this please? Date Doc phar Clinic Total ------------------------------------ ------- 13.02.2006 2 0 1 3...

Hello Guru's I have some values in my MAIN REPORT and I would like to pass these values from the main report to a subreport could anyone please tell me the STEPS am using CR9. Thanking in advance.. Cheers BVK

Hello Experts ! I am very new to CRYSTAL REPORTS and I currently have a main report which looks as follows and need a Summary report for the same as a Subreport. Date of Activity : 13.02.2006 -------------------------------- S.No Name Type ------ ------ ------ 1...