Search results for query: *

Thanks Hasit, this is good for now- but for long term what we are looking for is -as he clicks on the link the email should go automatically without the user having to click on send button again. ------------------------------------------ A Man can be only as happy.. as he makes up his mind to be

Hello, We have an excel file sitting on a shared drive where the problems are logged by the users. Is there any way that the users can click a button and an email is sent to one particular person with 'check the status' as the subject ? any advise will be appreciated. Thank you...

Hello, We have an excel file sitting on a shared drive where the problems are logged by the users. Is there any way that the users can click a button and an email is sent to one particular person with 'check the status' as the subject ? any advise will be appreciated. Thank you...

No,.. above code doesnt work.. unclerico .. when i say SUM(fields!fld.Value, "datasetname") it gives me the grand total.. but i want the total pertaining to that grp. ------------------------------------------ A Man can be only as happy.. as he makes up his mind to be

Hi, I was able to figure this out - wrote this code - in code section. public Dim calc1 As integer Public Function getCashlogAmt(inpAmt as integer) calc1 =inpAmt return calc1 end function in grp2 i passed the sum - =code.getCashlogAmt( sum(Fields!fld.Value,"grp2")) in grp1 accessed it...

I have grp1,grp2 on the report. i want the following on group footer 1 - grp1 sum(fields!fld.value,"grp2"). meaning i want to access the summary per grp2 on grp1. when i put the above formula i get the following err message "The value expression for the textbox ‘textbox7’ has a scope...

has any one used reporting services with cubes?? i found it really not cube aware.. it does not recognise the dimensions. can some one suggest a better front end tool for printing presentable reports against cubes in analysis services? ------------------------------------------ A Man can be...

Hi, SQL reporting services. SQL server 2000 database. We are using reporting services as the front end for the crystal reports (dont ask me why!!) On click of "Run report" there is a code for Jump to URL. the URL works fine.. but the issue we have here is .. when we have to move the crystal...

I also tried with just one page header - putting both the contents in one page header.. whichever is in the second row only is exporting.. first row doesnot export. ------------------------------------------ A Man can be only as happy.. as he makes up his mind to be

Cyrstal reports 10, sql server 2000. Hi, I have a report with 2 page headers on the report. pageheader -a is a formula. -b is text. both are not suppressed by any condition. when i export to excel 97-2000 data only - only the page header b exports. i have interchanged the contents of the...

Hi, we have sql server 2000 database. while creating the database- the transaction_log file size was set to 8 GB..(some how.. in error) our hard disk space is only 10 GB.. and transaction log filled up the hard disk. i have tried dbcc shrinkfile -with emptyfile, with truncateonly-.. this only...

u can use pwformatdate() function ------------------------------------------ A Man can be only as happy.. as he makes up his mind to be

pervasive sql 8 crystal version 8. I have data like the following: example: under lot# 015072 raw material lot# 27862 has 2 transactions stock to wip and dispense wip. Grouping is done by the lot# I want to show only those lots for which transaction stock to wip is there but not dispense...

sql server 2000 crystal version 8 Hi, I am trying to create a datasource from crystal reports "create new data source" to sql server to get access from the tables in a new database which was created fairly recently. when i am trying to change default database to access this particular db.. it...

the data is entered by the customers in this format.. we cannot do any thing at their end.. we will have to figure out a way at our end.. ------------------------------------------ A Man can be only as happy.. as he makes up his mind to be

Hi , In excel 2000 i have data in a column like 200mg 400 mcg 8000 IU I have to perform calculations on the number part of the cell some times i will have to divide this column by 4 then i want the data as 50mg 100mcg 2000IU. is there a way we can separate the number from this string and...

we have 2003 server.. is it advisable to install iis from 2003 CD? ya i was able to check the version.. but not able to check what edition tbis is like standard,enterprise etc.. (we are trying to get the 2000 server CD from a friend and to Install IIS does it matter which edition it was that we...

Hi, We have windows 2000 server installed on a machine.. and the bad news is 2000 server cd is Misplaced. Now we have to install IIS on the server .. is there any way I can get IIS installed from the internet?? Pl. advise if this is possible without a CD. thanks. also I want to know what is...

yes that is right. *using a dts package i first imported table MIITEM into the present sql server database. (this dts package was not scheduled , just ran once.. to get the table.) .. query is as simple as "SELECT * FROM ADH.MIITEM" i am using dts import wizard to get the data. let me tell...

DNG, thanks for the prompt replies. In my DTS package I have steps 1) truncate table MIITEM 2) will build the data from a query (used query builder to get the data from other database) but now when i query the table MIITEM from sqlserver i see no data... in job history i see job...