Recent content by mirage10

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