Recent content by report2000

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

Here u go. this is the qury stucture. How can I group the industrycode so thwn i can pick up the top 10 industry select company.userid, company.companyName, Industry.industrycode, indusrty.idustryName from company company industry industry where company.indusrtycode = industry.industrycode

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

It asks me for a number value (i.e. 1, 2,). Doesnot like this "Sum ({GAScr.Field9})

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

Sorry I placed them in report footer. I fixed the problem by just creating a new report and copying and pasting all the section into the new report. It works now. CR10 probably has a bug or something. I never seen this problem before so it worked somehow. Thank you

On your top right hand corner you have a arrow that you can click to see next page or jump to the last page of your report. (Lets assume I do not have any page numbers in my report - I checked and I am missing some pages) No when I click on the first arrow, "Go to next page" it does the...

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

Thank you. I tried your solution. The problem I have is that I created a running total. (1) Created a formula that does the following in order to come up with a distinct ID: {CLCHARGE.ACCOUNT}+totext({CLCHARGE.XACDATE2}) (2) Select distinct count of my formula in step (1) (3)I chose evaluate...

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