Search results for query: *

How do you run a Javascript script from Crystal Reports XI R2? I want to put a text object the has a hyperlink containing a javascript script on the report. When the user clicks the text object the javascript in the hyperlink will execute.

I have a stored procedure that is resides in SQL Server 2005. **Bring back all results for multiple firms EXEC dbo.USP_RPT_BOB_CONTRACT @Firm_ID_MULTI = '2888, 18458, 21505, 2842, 13254' Now I used the CR XI to link the reprot to Stored procedure (using command box). Now I need to let user...

I am passing a date parameter to display three months rolling data. I have the following formula: For 3 Months Forward rolling (Assuming I am running for August 2008 parameter) Left (MonthName (month({?Eff_Date})+1),3) Left (MonthName (month({?Eff_Date})+2),3) Left (MonthName...

I would like to be able to query my industry table and see the ist of the top 10 (not first 10 records)industries that are enrolled with my company

I have two tables. Both tables have same field names FirstName, LastName I would like to compare values in both tables based on the first 3 charaters of FirstName or LastName

I have two tables Table1: ---------- EmployeeID Employee Name Contract 1 Jim 1 1 Jim 2 2 Tom 3 3 George 4 4 Frank 5 5 Oscar 6 Table2: ----------- Contract Contract...

Hi, I have a main report that has 5 subreports. Is there a way to schedule this report so after it returns a result, e-mail each subreport to different individual? (We have CR10 Enterprise) Subreport1 to Employee1 Subreport2 to Employee2 Subreport3 to Employee3 Subreport4 to Employee4...

I created a master report that has two subrports. Each subreport is grouped by job code. I have two tables in subreport1 - (North Data and master table that I compare the north region data to and filter only the datas that are in master table and North table) and subreport 2 that has the master...

I have a report that has 9 pages. I just ran the report and wheb I am trying to browse the pages the pages that I see if 1,2,5,6,7,8,9 Missing Pages 3 and 4. I do not get any error, Just the pages are not there even though I can see them in my design section of the report

Hello, I created a calculated field using insert summary feature (distinct count) that counts the distinctcount of a customerID. Then I took the distinct count (Calculated by insert summary) and created a formula which takes the distinct count and times it by 10. Now I would like to bring the...

I am using MS Access 2003 and Crystal Reports 10. I created a database with 6 tables in MS Access 2003. Then, I opened the Crystal Reports 10 and created a new connection to my Access 2003 database. Now, when I am trying to select my tables from "Available datasource" and move it to "Selected...

I have 5 reports that I wrote. I have an intorduction page. One report starts from page 1 to 25 another starts from page 1 to 30. I am going to put all of them into a PDF format (I am creating a handout) I would like to be able to start the page from whatever number I like and continue to the...

Hi, I have the following sample Data Set JobCode Region HourlyRate ------- ------ ---------- 11 North $30 21 North $30 31 South $34 44 South $35 44 South <Null> 44 South $28 I am grouping by Region and then JobCode Here...

Hello, I am writing a report using a simple query: Select ComapnyID, ComapnyName, Average(Salary), NbrOfEmployees from Company table. I would like to replace Average(salary) with "*" if NbrOfEmployees is less than 5. Here is my formula: if Sum ({@NbrOfEmployees)<5 then '*' else...

Hi, Please Help - Thanks Problem # 1 I am using access 2003 as my database. I have a currency field with numeric values including 0 I created one extra column in access and set the data type to (YES/NO). I replaced the values in YES/NO column to "YES" if the value in currency field is equal to...

Hi, I am trying to create a expression for the following condition: I am using the regulart drag and drop future of creating the query in Access. I have two fields: Number of Employee and Number of Minimum Salary reported I would like to count the number of employees where there is a minimum...

Hi, I am using running total feature in crystal reports to do my calculations. I would like to replace a value in my report with a "*" if the value is "0" or "Null" thank you

Hi, I have 5 reports that I created using the "Running total fields" utility in crystal reports. I wrote a function for every single field so I can calculate the ranege of data that I would like in my report. Reports are working fine and I am getting the results that I am expecting. Now I have a...

Hi, I am trying to use runningTotal field feature in crystal reports to calculate "Weighted Average" for a set of datas. The RunningTotal wizard tool lets me only to select the following fields: (1) Field to Summerize - AverageHourlyPay (2) Type of Summary - Weighted Average (3) with -...

Hi, Here is how my report looks like: Description: Number of Employee: '1-300 Employees' 5 '301-500 Employees' 2 '501-800 Employees' 10 '801-1500 Employees' 1 'Over 1500 Employees 5 Now: I wrote the following function in Crytal Reports in order to...