Crystal Reports problem

here’s the coding for my crystal report display The above code is written in the report viewer form’s load event method. ‘this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue, ListItem.ItemID, Item.ItemName, ListItem.SaleQuantity, ListItem.SalePrice, ItemSale.SaleItemListID FROM Income INNER JOIN ItemSale ON Income.IncomeID = ItemSale.IncomeID INNER JOIN SaleItemList ON…



Answer Question   |  June 28, 2012  6:17 PM
Crystal Reports 8, SQL Server 2005 Express Edition, VB.NET 2005
asked by:
95 pts.

ECM – Production BOM and Profit Plan BOM

How do you control changes to production BOM vs planning BOM using the same alternate BOM? In other words, if the production BOM was approved using ECM module how can I add future planning changes only for planning purposes without impacting the current production BOM?



Answer Question   |  June 28, 2012  5:55 PM
BOM, BOM components, ECC 6.0, ECM
asked by:
5 pts.

Will you be at Interop Las Vegas next week?

Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you’re thinking of the show and the direction of networking in general! Let him know if you’ll be…



Answer Question   |  June 28, 2012  5:41 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Interop, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
asked by:
16,755 pts.

SAP data structures reference?

Could anyone steer me to a good reference on how SAP stores their data? Seems complex and confusing. Help!



Answer Question   |  June 28, 2012  5:06 PM
Data, SAP, SAP and data management
asked by:
5 pts.

SAP BW

How can i see the programmes associated to a ODS?



Answer Question   |  June 28, 2012  4:15 PM
ODS (Operational Data Store), SAP BW
asked by:
MSG
5 pts.

Morphing

I would like to morph aerial ortho rectified photos. How can i get information on this process.



Answer Question   |  June 28, 2012  3:47 PM
AutoCAD 2009, autocad 2010, AutoCAD Civil 3D, morphing
asked by:
5 pts.

Can I access job info directly from the CA-View

What I would like to do is to display a list of jobs that are defined to CA-View then retrieve those jobs using SARBCH. I have a list, but it has to be manually maintined and I am trying to remove that aspect of the process.



Answer Question   |  June 28, 2012  3:44 PM
CA View, MVS, MVS system, REXX
asked by:
10 pts.

How to use button created by Crystal Button in VB 6.0 forms

How to use button created by Crystal Button in VB 6.0 forms



Answer Question   |  June 28, 2012  3:14 PM
Crystal Reports, Crystal Reports Buttons, VB 6.0
asked by:
5 pts.

How to execute Crystal Reports subreports on priority base

Hi I’d created two sub reports(x,y) which uses different queries. In main report i have to call ‘x’ report first because i have to pass the grand tot from ‘x’ report to ‘y’.  How ever my two reports are calling at a time so that ‘y’ report getting wrong result because it is calling before…



Answer Question   |  June 28, 2012  3:14 PM
Crystal Reports, Crystal Reports Subreports, Crystal XI, Oracle
asked by:
10 pts.

How to use button created by Crystal Button in VB 6.0 forms

How to use button created by Crystal Button in VB 6.0 forms



Answer Question   |  June 28, 2012  3:14 PM
Crystal Reports, Crystal Reports Buttons, VB 6.0
asked by:
5 pts.

Data Compression with Remote Journal

Is there a way to apply some sort of data compression (remove repetitive blanks) with a remote journal. These journal entries are for records added to a databse file containing a single 32K long field.



Answer Question   |  June 28, 2012  3:05 PM
Data compression, Remote journaling, V5R4
asked by:
40 pts.

Application transfering

Do you know how a system (a Veritas Cluster System to be exect) automatically transfers an application from the primary server to the standby server in the case of a failure in primary server? Does the target need to pay a license for both servers in this case?



Answer Question   |  June 28, 2012  2:56 PM
Cluster, License, License software, Primary Server, Standby Server, Transfer, Veritas
asked by:
5 pts.

Refresh/Run SQL

We upgraded to Crystal Reports 2008. Our older version queries appear to work… In the Older Verion all we did is click the lightening blot. Now… we have to go through Database, SQL to run/refresh the query. Isn’t there a one click key for to run these queries?



Answer Question   |  June 28, 2012  2:46 PM
Crystal Reports, Crystal Reports 2008, SQL, SQL Database
asked by:
5 pts.

Data model used by SAP

Does SAP retail moduels support the ARTS IXRetail data model or does it use its own proprietary format. Thank you



Answer Question   |  June 28, 2012  2:29 PM
Data models, Schema
asked by:
5 pts.

auto fit of object in crystal report after supression

i have three formula fields containing some data.Based on some condition middle object is supressed.After suppression i just want fit the place for the remaining 2 object.Is that possble that instead of 3 object place , i fit 2 object after supression of middle object.So in earlier situation same place share by 3 object and…



Answer Question   |  June 28, 2012  2:19 PM
Crystal Reports
asked by:
25 pts.

Dynamic list of values in Crystal 10

Hi, I am using Crystal 10 client. Is there any option to get the list of values for a parameter dynamically ? If any one of you knows, kindly get answer me. When i explored, this feature is addressed in Crystal 11, which would retrieve the list of values dynamically. Thanks in Advance Viswa



Answer Question   |  June 28, 2012  2:17 PM
Crystal Reports, Crystal Reports 10
10 pts.

Crystal to IDocs

Can BOBJ Crystal Reports access SAP data via IDocs?



Answer Question   |  June 28, 2012  2:10 PM
Crystal Reports, iDoc, SAP export dump
asked by:
5 pts.

i want to send sap idoc to sql server 2005

I have one application in sap which takes sap data into idoc and want to send in sql server 2005



Answer Question   |  June 28, 2012  2:10 PM
iDoc, SAP IDocs, SQL Server 2005
asked by:
5 pts.

i want to send sap idoc to sql server 2005

I have one application in sap which takes sap data into idoc and want to send in sql server 2005



Answer Question   |  June 28, 2012  2:10 PM
iDoc, SAP IDocs, SQL Server 2005
asked by:
5 pts.

Reprocess a Change pointer

Is there an standard R3 way to reprocess a change pointer and recreate/resend the IDOC?



Answer Question   |  June 28, 2012  2:07 PM
iDoc, R/3
asked by:
5 pts.