Initializing/resetting subreport and shared values

In CR 8.5, I am passing a subreport value to the main report, then using the subreport field value in the main report.  (I have the calculation in the step [em]below[/em] the step that is returing the sub-report value.)   My issue is that once the subreport value gets populated with a non-zero value, it populates…



Answer Question   |  June 27, 2012  5:54 AM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Subreports, Initlialize Shared Fields, Subreports
asked by:
5 pts.

How to stop GF1 info from disappearing

I am using Crystal Reports 2004, version 11.0.0.895. I am writing a report that groups by two fields Customer Name and Invoice Number. Customer Number is Group 1 and Invoice Number is Group 2. I am trying to just show the summary information from Group 1, which sums the information in Group 2. I hide…



Answer Question   |  June 27, 2012  5:52 AM
Crystal Reports, Crystal Reports 2004, Crystal Reports XI, Grouping
asked by:
5 pts.

Lotus Approach and File Maker Advance Pro 10.0.3

Can anyone help me on how to migrate or import/export or open Ms Excel using these softwares Lotus Approach 2000 and File Maker Advance Pro 10.0.3 please thanks



Answer Question   |  June 27, 2012  5:51 AM
FileMaker Advance Pro 10.0.3, Filemaker Pro, Lotus Approach, Lotus Approach 2000, Lotus Approach and File Maker Advance Pro 10.0.3 softwares
asked by:
15 pts.

How to pass Stored procedure to Crystal reports

I have created a report in Crystal report using stored procedure and i have to call that report in delphi by passing parameters to stored procedure..?



Answer Question   |  June 27, 2012  5:45 AM
Crystal Reports, Delphi
asked by:
5 pts.

Printing a Crystal report – paper size

I have an application that uses Crystal reports 10 on a Citrix environment. Suddenly, when trying to print the report from the screen the printer defaults to a strange size of paper (12′ x 18′) when the printer settings are correctly setup for Letter. ANy ideas?



Answer Question   |  June 27, 2012  5:43 AM
Crystal Reports, Crystal Reports printing
asked by:
5 pts.

Macro to Open Crystal Reports

I have an excel spreadsheet that I’ve used to create a crystal report. The excel file has multiple employee id’s on it. The crystal report has a parameter that uses the employee id to only show that employee’s information. I’m trying to set up a macro to loop through the employee ID column, pass one…



Answer Question   |  June 27, 2012  5:41 AM
Crystal Reports, Excel macros, Microsoft Excel
asked by:
5 pts.

Crystal Reports 2008 Version 12 Viewer, whats the class name field and what to put there?

In Crystal Reports 2008 version 12.  Im using the viewer to try and pull up the reports I created and designed to view outside of SAP Business 1, but im not sure what to put in the “class name” field. Can anyone help to what I should put there and the function of this field?



Answer Question   |  June 27, 2012  5:38 AM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Crystal Reports Projects, Crystal Reports Viewer, Crystal Reports XI, SAP Business One, SAP Reports
asked by:
145 pts.

Crystal Reports 2008 Version 12 Viewer, whats the class name field and what to put there?

In Crystal Reports 2008 version 12.  Im using the viewer to try and pull up the reports I created and designed to view outside of SAP Business 1, but im not sure what to put in the “class name” field. Can anyone help to what I should put there and the function of this field?



Answer Question   |  June 27, 2012  5:38 AM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Crystal Reports Projects, Crystal Reports Viewer, Crystal Reports XI, SAP Business One, SAP Reports
asked by:
145 pts.

generating a custom database from an existing database

from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.



Answer Question   |  June 27, 2012  5:27 AM
Database Management Systems, Excel Database
asked by:
15 pts.

smartform printing

I have tested, in QAT, and the changed TDG does not printI changed it in the sales order (VA01) and then created the delivery (VL02N) and double checked that it was still changed in the delivery and then printed the bill of lading and the TDG definitely does print what I changed it to….only the…



Answer Question   |  June 27, 2012  5:27 AM
aarav, core it
asked by:
0 pts.

Data Access Layer in RPG

Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a…



Answer Question   |  June 27, 2012  5:26 AM
DB2, RPG, RPGILE
asked by:
5 pts.

Modifying a Stored Procedure

The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don’t want it showing up on the…



Answer Question   |  June 27, 2012  5:26 AM
Crystal Reports, SELECT statement, SQL, SQL Database, SQL stored procedures, Stored Procedures
asked by:
130 pts.

User Defined Field Setup Crystal Reports 8.5

How does one create a user defined field in Crystal Reports 8.5. I needed a field in IQMS to enter employee information so I created a user defined setup with a pull down menu, but I have to now add the field to the table that is being used in Crystal Reports but I don’t…



Answer Question   |  June 27, 2012  5:22 AM
Crystal Report 8.5, Crystal Reports, User report
asked by:
5 pts.

Data Access Layer in RPG

Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a…



Answer Question   |  June 27, 2012  5:22 AM
DB2, RPG, RPGILE
asked by:
5 pts.

using mrsid format in autocad 2000(i)

can you use mrsid format in autocad 2000(i)?



Answer Question   |  June 27, 2012  5:22 AM
AutoCAD, AutoCAD 2000, MRSID Format
asked by:
10 pts.

crystal 11

How many data passes are allowed with crystal 11.



Answer Question   |  June 27, 2012  5:21 AM
Crystal Reports, Crystal Reports Data Passes, Crystal Reports XI
asked by:
5 pts.

Exporting Lotus Notes Email for content management

Hi, There is a need to export the emails with the attachments to upload the same in a content management solution. What is the best possible way to do this ? Regards Vivek



Answer Question   |  June 27, 2012  5:15 AM
Content management, Lotus Notes, Lotus Notes 4.x, Lotus Notes administration, Lotus Notes Exporting
asked by:
5 pts.

Exporting Lotus Notes Email for content management

Hi, There is a need to export the emails with the attachments to upload the same in a content management solution. What is the best possible way to do this ? Regards Vivek



Answer Question   |  June 27, 2012  5:15 AM
Content management, Lotus Notes, Lotus Notes 4.x, Lotus Notes administration, Lotus Notes Exporting
asked by:
5 pts.

Crystal Report 2008

We recently moved our report portal from Crystal Xi to Crystal 2008. Now the embedded images on the reports only display a text of “Image”. When I send the report to the printer the Image will then display. Does anyone have any idea how to get the image to display on the screen?



Answer Question   |  June 27, 2012  5:14 AM
Crystal Reports 2008, Crystal Reports XI
asked by:
5 pts.

Crystal 8.5 export trouble

My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant…



Answer Question   |  June 27, 2012  5:06 AM
Crystal Reports 8.5, SQL Server 2003
asked by:
5 pts.