Search results for query: *

I have been compiling .EXEs for my user under CR8.5. We have moved to CRXI. Does anyone know how my users may be able to run CRXI .RPT files independently?

Just wanted to share this.... I have this simple formula to add a few variables. VarB := VarC + VarE + VarI + VarJ + VarK;. The formula does not work at times and result comes out zero. What fixed this issue is I deleted the formula and retyped everything. And it worked. My guess is that...

I'm using CR11 on an Access database. My formula uses a shared variable. When a condition is met, a sum is moved into the variable. The problem is that the previous value is not saved. When it gets to the next record and the condition is not met, zero is moved into the variable. The formula...

I have two tables that are 'Equal' joined. I'd like to report on all records in TABLE1 as well as all records in TABLE2. I am finding that records in TABLE2 are not reported when the linking item is not in TABLE1. In other words, if I have records 2010, 2012 and 2013 in TABLE1 and records...

Hi.. In CR8.5, how do you avoid a cartesian product? I have 2 tables. Amounts on tableA are totaled and so are amounts in tableB. Total of TableA is exaggerated. Thanks

Hi...in my .aspx connection file, I have the following codes. <script language="VB" runat="server"> <Dim myConnection as new OleDbConnection connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database\tblPhone.mdb" providerName="System.Data.OleDb"> </script> I am getting...

Hi, I am trying to link an Informix table to a SQL Server table. I know that both keys are string(10). For some reason, I kept getting "The specified links are of different types" error. Any ideas are greatly appreciated.

I have Crystal executables compiled in 8.5. When I run the .exe and clicked the Print button, nothing happens. Any idea is greatly appreciated.

Hi, I am creating an address line by concatenating the address fields. The line does not get printed when one of the fields has a null value. Here's my code: {Street.Number} + " " + {Street.Direction} + " " + {Street.Name} + " " + {Street.Type}. For example, if {Street.Direction} is...

I am running an executable created from CR8.5. After a couple of hours of running, the run aborts with a runtime error referencing CRRUN32.exe. The report is to process about 36,000 records. It contains a subreport. The report is exported to Excel. Has anyone experienced this issue?

I want to print data in rows instead of columns. For example, I have data... Acct1 23 Acct1 34 Acct2 39 Acct2 88 Acct3 75 Acct3 92 I want to print it in rows so it'll look.... Acct1 23 34 Acct2 39 88 Acct3 75 92

Hi, Sample data are INV-7-10-1234 and INV-7-10-12345. I'd like to print just the last digits after the last hyphen. In the example, I want my report to print 1234 and 12345 respectively. Any ideas is greatly appreciated.

Hi, I am about to write a report with summary pages of different layouts. Sums and counts from different field sources are going to be reported. Is the Report Footer section the best place to accomplish this? Thanks

Does anyone know if Crystal has the ability to report on web log files? The logs are flatfiles with an extension of .log. I have Crystal XI.

I am using CR-XI and having difficulty exporting to CSV. All columns but the mailing address exported fine. The line is in Group Footer #1. The mailing address shows fine in preview and exports with no problem in PDF. Does anyone know of a workaround? Thanks.

What would be the best way to print a set of text (a worksheet) to be printed on the back side? That is, I have 5 different worksheets to be printed on the back side of a common front page. The worksheet is determined by a license type. Thanks.

Using the Package and Deployment Wizard, I get an error "Unexpected error number 80004005 has occurred: Automation Error Unspecified Error". I am using VB6.0 for 32-bit. Any ideas is greatly appreciated. Thanks

I am new wih SQL. Does anyone know of a way to drop leading zeros? The field is nvarchar and may contain values such as 00000123. I need to drop the leading zeros so the result would be 123. Some values maybe all zeros in which case might produce a null which is disallowed by the field. Any...

Hi, I have the following data: Sullivan Avenue Santa Ana Drive South Lake Shore Drive I need to parse these into Street Name and Street Type such that output would be: Street Name Street Type ----------------- ------------------ Sullivan Avenue Santa Ana Drive...

Hi, I am having a problem suppressing my group footer. I dont want the group footer to print when the account balance = 0. The condition I inserted in the Section Expert is {#AcctBal}>=0.00. Group footer is to be suppressed when this condition is met. Any help is greatly appreciated. Thanks.