Search results for query: *

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

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

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

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

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

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

SQL SERVER 2000 pervasive sql v8 I created a DTS package to get import data from pervasive sql 8 into sql server 2000. this package is scheduled to run every minute. and every minute the data is fetched.. it appends to already existing data.. that is making the table double each minute.. can...

pervasive sql 8 crystal v 8. Hi, I have never accessed a stored procedure from crystal.. so pl. advise. I have stored procedure like below which returns data on the db.. but when I tried to "add" the stored procedure to the report, it gave me the err msg: no data returned. Pl. advise on what...

Hi, I am using visio 2003 program. I was trying to create a UML class diagram. and when I drag drop the class on to the main page, by default the shape is protected for "rotation" and "height". I see this when I go to "format"-"protection". I cleared all the check boxes and saved.After that I...

excel 2000 Hi I have a report which has formulae in it. Previously it had linking from other work books too and i tried to remove them, but i think they were not removed completely and every time i open the work book i get the error message "u have linked information from other workbooks" is...

Crystal version XI oracle 9i. I installed oracle 9.2.0.1 recently.I was trying to connect to Oracle database through Cystal reports Version X1. When I click on "Create New Connection"- "Oracle Server" I get the dialog Oracle server Connection: Service- User Id Password. In the oracle database...

crystal reports 11 accessing Stored procedures in sql server 2000 Pl. bear with me as this is the first time I am dealing with SPs. I created a very basic stored procedure in sql server: CREATE PROCEDURE proc1 @ITEMID varchar(40) AS SELECT MIITEM.ID,MIITEM.DESCR FROM MIITEM WHERE ID =...

Hi, TO understand this concept "Stored Procedures in Crystal reports" where do I start?? I want to look at some examples of the stored procedures, how they are written and how they are used in crystal. thanks, I have versions 8 and 11 on my computer. ------------------------------------------ A...

Hi, In a particular excel sheet, I typed the whole document and later realised that the rows should have been columns and vice versa. I donot want to type the whole thing again.Is there a way to interchange these row and column positions? ------------------------------------------ A Man can be...

Hi, I have multiple work books in one folder, All these work books have the same format, they will have same column names A,B but each work book will have different values. I want to get all this data into a new work book called "abc" I want to present data in one of the following 2 ways 1...