Suppress duplicate subreport data
Using Crystal Reports 11, I have a report with 2 subreports A and B. Sometimes the two subreports will show the same data. Is there a way to suppress data in subreport B if it already exists in subreport A? My report is laid out as such: Group 1 Header Group 2 Header Details Group [...]

Answer Question   |  June 29, 2009  2:00 PM
Crystal Reports, Crystal Reports Subreports, Crystal Reports XI, Subreports

Showing a substiute value in a report if conditions are met – Access
In one of my tables, there is a date field which shows dates of an event happening (called “Issue Date”). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been [...]

Answer Question   |  July 14, 2009  10:54 AM
Access 2003, Microsoft Access, Reports

Hiding fields in business objects
I have a field (country) that I need in my query in order to perform a calculatin but I dont want to show country in the results. How can I hide this field?

Answer Question   |  June 25, 2009  3:37 PM
Business Objects, Business Objects 6.5

Crystal Reports help
I’ve been given a Crystal Report to modify which contains 180+ fields and formulas. Is there a way for me to get a printout of all the formulas? There must a at least 110 calculated fields it would be very nice if I could export them to an editor for viewing and documentation.

Answer Question   |  June 24, 2009  11:29 PM
Crystal Reports

Importing History into Microsoft CRM 4.0
How do I import history in Microsoft CRM 4.0?

Answer Question   |  April 7, 2010  5:39 PM
Microsoft CRM, Microsoft CRM 4.0, Microsoft CRM History Import, Microsoft Dynamics

FTP AS400 RECEIVING EDI FILE
ON MY AS400 VER 4.5 I AM RECEIVING THRU FTP A EDI FILE FROM A PC BASED SYSTEM BUT THE DATA COMES IN AS ONE LONG RECORD. ANY IDEA’S THAT WOULD HELP

Answer Question   |  June 26, 2009  12:44 PM
AS/400 FTP, EDI, EDI Transactions

Disconnecting a Crystal 8.5 report while report is open in VB6
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which require [...]

Answer Question   |  June 24, 2009  1:11 AM
Crystal Reports 8.5, Microsoft Access, VB 6, Visual Basic 6

Crystal Reports exporting issue
Hi, I am using crystal reports XI Release 2 to develop reports and I will deploy the reports in Crystal reports server using Central management console at client location. My requirment - I have developed a report and it consists of 4 ondemand subreports. I have to export the reports( main and subreports) to all [...]

Answer Question   |  June 30, 2009  12:46 PM
Crystal Reports, Crystal Reports On-Demand Reports, Crystal Reports XI

Crystal Report 10 – Can not obtain error message from server
When running a Crystal Report(V10) I get the error message ‘Can not obtain error message from server’ My report is running over a Domino database, connecting two views to together with a single join (Left outer join, not enforced). If I run the report I get a different error message ‘Failed to open a rowset’ [...]

Answer Question   |  June 22, 2009  10:25 AM
Crystal Reports, Crystal Reports 10, Lotus error messages, Lotus Notes Database

Crystal Reports Duplicating Records
Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don’t share a common layout. I have created a basic report to see if the record count for [...]

Answer Question   |  June 22, 2009  10:08 AM
Crystal Reports, SQL, SQL Server

how to identify infrastructure master is down?
how to identify infrastructure master is down? What is the serious inmact if is down?

Answer Question   |  June 22, 2009  6:07 AM
Flexible Single Master Operations, FSMO Roles

Encryption by Law? If so, what strength or type?
Should encryption be explicitly proscribed in Data Security and Privacy legislation like the Massachusetts Data Prvacy Law and the White House cybersecurity initiative? If so, what strength or method? Should there be a minimum strength? What do you think? Troy Tate, thanks, are you recommending the law should explicitly require 1024-bit minimum key length? I’m [...]

Answer Question   |  November 9, 2012  12:23 PM
cybersecurity, Encryption, privacy, Security

IDOC or RFC
Hello everybody, I need some help! I would like to know how is the best way to transfer Data from a webserver (non SAP) to SAP? Scenario : Supplier_Information are in a Database (mySQL) storde in a Webserver they have to be transfer to SAP and shortly after will generate an order. I would like [...]

Answer Question   |  June 22, 2009  10:11 AM
Data transfer from non SAP to SAP, Data Transfer Function, iDoc, RFC, SAP administration, SAP Import/Export

Does the same syntax work in both SAS 9.1 and SAS 9.2?
Hi! I am a new SAS user and just yesterday IT installed SAS 9.2 on my computer at work. The code I was using for SAS 9.1 (which was working perfectly fine) has not been working on SAS 9.2; instead it sits there for a while and then shuts down. If my code were different [...]

Answer Question   |  June 19, 2009  7:00 PM
Coding, Error Report, SAS 9.1, SAS 9.2, syntax

pasting a database query into crystal
I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

Answer Question   |  June 19, 2009  4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries

ArcGIS, .NET, Urgent! Please help
I’m trying to save a unicode utf8 string –> “سلام” in a feature of a featureclass, but it is saved like “????”.as ArcMap support different encodin and also Farsi that I’m working with, It should be possible through my program.but I didn’t find any way yet.anybody knows about this? feature = fc.CreateFeature(); feature.Shape = point; [...]

Answer Question   |  June 18, 2009  2:28 PM
.NET, ArcGIS, Unicode, UTF-8

Difference between ODBC and JDBC?
I’m writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to [...]

Answer Question   |  April 19, 2013  1:49 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL

UC solutions: Show and tell
As Tony Bradley frequently emphasizes on his blog Unified Communications: Click to Talk, there are many benefits, cost and otherwise, to implementing UC solutions within your organization. I want to know — are you using UC? What product(s)? How has your experience been, and why did you make the switch? Was it mainly cost-driven, or [...]

Answer Question   |  June 25, 2009  9:43 PM
Unified Communications, Unified Communications Hardware, VoIP, VoIP hardware, VoIP hardware selection

What backend works best with Cognos frontend?
Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren’t sure if that is the best option. Any suggestions?

Answer Question   |  June 18, 2009  8:19 PM
Cognos, Microsoft Access, SQL Server

Crystal Reports file error: data may have been lost
using CR7 xp sp 3 office sp 3 when I do a export from CR7 to excel I receive the following message file error data may have been lost

Answer Question   |  May 19, 2011  12:20 PM
Crystal Reports, Crystal Reports 7, Crystal Reports error messages, Crystal Reports Export, Crystal Reports Export to Excel, Microsoft Excel, Microsoft Office, Windows XP