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

It turned out that I have a formula that initializes the variable in the wrong place. Although this init formula was in the group header, it seems to initialize a variable being evaluated in the detail section. After I removed the init formula, the value is was saved.

'WhilePrintingRecords' didn't make a difference. It didn't preserve the value.

I've determined that it's not a null issue. None of the fields contain nulls.

I totally agree about the handling of nulls. It can cause unpredictable results. In report options, I've set all null values to default with the same result. I'll try a few more codes on handling nulls. Thanks for the post.

I thought that would work too, but didn't. Here's my formula which is basically the same as your sample.... Shared NumberVar VarE; If {TblJoin.FundExp.FiscalYear} = {?Pm-?CurrFiscalYear} - 1 and {TblJoin.FundExp.Object} > "6200" Then VarE := VarE + {TblJoin.Budget19} Else If...

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

Thanks Ian. I suspected that would be the solution but the ways I can redo the join are not available to me in CR8.5. Visual Link join option is greyed out. 'Database > Show SQL Query' is also greyed out. My source database is Access.

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

I formulated and grouped by a RecordID. It worked well. Thanks for the tip.

Yes, the entire row is duplicated. Unfortunately, the 'Select Distinct Records' is grayed out in both Database menu and Report Options. I am looking at grouping now.

Thanks Kray. Creating a query was an attractive solution. I tried it but my query resulted in duplicate records. These tables are laid out differently with a few common fields.

These are MS-Access tables with an equal join. Join type is grayed out so I cannot really experiment with different joins.

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

I created an ODBC/DSN for the SQL SERVER table which seemed to work better. I am now able to link the two tables. Thanks for the reply.

I am linking it via Database Visual Linking Expert. I'm using Crystal 8.5. Field is actually varchar in SQL Server. Crystal is detecting it as a string. Thanks.

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.

It turned out that a file p2BDAO.dll is missing in c:\windows\system32 folder. I copied the file from another PC. The report now works.