Search results for query: *

Hello all I found the solution the correct syntax to convert the files in Batch is following ren M:\files\*.htm *.html Thank you people... Regards Pr

Sorry but it doesnt work ... Yes the files under the M drive and under the folder Files ... Should I try any other way ...??

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

I am trying to do the same thing .. but could not succeed so far could you please tell me the step how I can do that ..?

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

I still have the problem in my Select it says it cannot convert the VARCHAR to NUMERIC where as when I try directly on the SQL Server it works... PR

convert(numeric(10),a.partner(isnull(a.partner,'empty'))) as 'Partnernr', First of all the part (isnull(a.partner,'empty')) is checking if a.partner has any null values then isnull function is filling it with text called empty ... Then the Convert function is converting the Text to Numeric...

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

Hi thanks for the replies I dont need DECEMALS...when I use INT its saying ILLEGAL EXPRESSION. 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...

Solved it .. Thanx

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

Solved it.. Thanx anyways.. Cheers Preetham

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

SOLVED IT ...

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