how to block update command when using STRSQL ( db2/400)?
Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?
Answer Question
| July 24, 2009 4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL
Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?
Answer Question
| July 24, 2009 4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL
Crystal Report How Can Protect For password My Crystal Report’s rpt File?
How Can Protect For password My Crystal Report’s rpt File?
Answer Question
| July 20, 2009 6:39 AM
Crystal Reports 8.5
How Can Protect For password My Crystal Report’s rpt File?
Answer Question
| July 20, 2009 6:39 AM
Crystal Reports 8.5
Crystal report xi parameters
I have created a paramteter for the user to select a date from a list of dates. I have also created two parameters for the user to select a begin and end date. For each date, i setup each date value as a formula using the DATEVALUE ({query.datefield}). I inserted the parameters on the report [...]
Answer Question
| July 20, 2009 11:43 PM
Crystal Report XI, Crystal Reports
I have created a paramteter for the user to select a date from a list of dates. I have also created two parameters for the user to select a begin and end date. For each date, i setup each date value as a formula using the DATEVALUE ({query.datefield}). I inserted the parameters on the report [...]
Answer Question
| July 20, 2009 11:43 PM
Crystal Report XI, Crystal Reports
EDI mapping orders
I have to write a EDi orders for Tradanet. The input file is in varable length text fields seperated by ‘+’ & ‘:’ Does anyone have a best method for writting this.
Answer Question
| July 17, 2009 3:49 PM
EDI, EDI Mapping, Tradanet
I have to write a EDi orders for Tradanet. The input file is in varable length text fields seperated by ‘+’ & ‘:’ Does anyone have a best method for writting this.
Answer Question
| July 17, 2009 3:49 PM
EDI, EDI Mapping, Tradanet
ArcGIS Server and AS400/I-Series Connectivity
Does any one have any idea how a connectin of Spatial Data Bases of ArcGis Server can be achieved?
Answer Question
| July 17, 2009 3:08 PM
ArcGIS Desktop, ArcGIS Server, AS/400, Connectivity, iSeries
Does any one have any idea how a connectin of Spatial Data Bases of ArcGis Server can be achieved?
Answer Question
| July 17, 2009 3:08 PM
ArcGIS Desktop, ArcGIS Server, AS/400, Connectivity, iSeries
Issue with Knowledge Base Articles created via MS Word.
When I open an Altris Knowledge Base Article that was created via MS Word, how do I keep MS word from opening? There must be a setting somewhere as I have co-workers that open the same article and word DOESN’T open for them. I’ve searched for a seeting in IE, MS Word and other places, [...]
Answer Question
| July 17, 2009 2:30 PM
Knowledgebase, Microsoft Word
When I open an Altris Knowledge Base Article that was created via MS Word, how do I keep MS word from opening? There must be a setting somewhere as I have co-workers that open the same article and word DOESN’T open for them. I’ve searched for a seeting in IE, MS Word and other places, [...]
Answer Question
| July 17, 2009 2:30 PM
Knowledgebase, Microsoft Word
Crystal Reports in vb.net
iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001
Answer Question
| July 17, 2009 12:23 PM
Crystal Reports, Crystal Reports error messages, SQL Server, SQL Server error messages, VB.NET, VB.NET 2005, VB.NET 2005 Express Edition
iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001
Answer Question
| July 17, 2009 12:23 PM
Crystal Reports, Crystal Reports error messages, SQL Server, SQL Server error messages, VB.NET, VB.NET 2005, VB.NET 2005 Express Edition
change printer
Select A Printer Programatically For Crystal Reports 10
Answer Question
| July 17, 2009 2:42 AM
Crystal Reports 10, Printer, Printer management
Select A Printer Programatically For Crystal Reports 10
Answer Question
| July 17, 2009 2:42 AM
Crystal Reports 10, Printer, Printer management
How to select 1 record in DB2
As usual, I often use: select top 1 * from table but in DB2, I can’t. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!
Answer Question
| April 18, 2013 5:34 PM
DB2, SELECT statement
As usual, I often use: select top 1 * from table but in DB2, I can’t. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!
Answer Question
| April 18, 2013 5:34 PM
DB2, SELECT statement
Crystal Reports to SSRS
There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the reports ? Also [...]
Answer Question
| July 18, 2010 4:44 PM
Crystal Reports, Crystal Reports XI, SQL Server Reporting Services, SSRS
There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the reports ? Also [...]
Answer Question
| July 18, 2010 4:44 PM
Crystal Reports, Crystal Reports XI, SQL Server Reporting Services, SSRS
UTILIZING ECM ADAPTER 607 FOR OUTBOUND EDI 880 VIA BPCS
Currently, I’m running EXTOL Integrator on our AS/400 for our EDI solution, and we are using BPCS 6.0.2 along with the ECM File Adapters to tie in all data throughout the system. Has anyone had any experience with this? I’m looking to figure out how to structure the ECM files properly so that we get [...]
Answer Question
| July 16, 2009 6:56 PM
AS/400, BPCS 6.0.02, EC, ECM, EDI, EXTOL
Currently, I’m running EXTOL Integrator on our AS/400 for our EDI solution, and we are using BPCS 6.0.2 along with the ECM File Adapters to tie in all data throughout the system. Has anyone had any experience with this? I’m looking to figure out how to structure the ECM files properly so that we get [...]
Answer Question
| July 16, 2009 6:56 PM
AS/400, BPCS 6.0.02, EC, ECM, EDI, EXTOL
Crystal New Connection
When trying to create a new connection to a different database receive the following message “Crystal Reports has encountered a problem and needs to close” then cystral closes.
Answer Question
| July 15, 2009 6:56 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports XI
When trying to create a new connection to a different database receive the following message “Crystal Reports has encountered a problem and needs to close” then cystral closes.
Answer Question
| July 15, 2009 6:56 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports XI
Connection of Crystal Report 2008 with VB6.
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..
Answer Question
| July 14, 2009 9:28 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..
Answer Question
| July 14, 2009 9:28 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6
The request could not be submitted for background processing
I am using VS2005 and CR10. After saving the record it should print 3 copies but some time in a day it prints only 1 or 2 copy and printer stops and show the following error message: “Error in File C:DOCUME~1SETCOU~1LOCALS~1TempSalesAdvice {8F644754-8B0F-4028-ABAE-7EA18B46699A}.rpt: The request count not be submitted for background processing. Now I did not [...]
Answer Question
| November 5, 2009 8:53 AM
Crystal Reports 10, Visual Studio 2005
I am using VS2005 and CR10. After saving the record it should print 3 copies but some time in a day it prints only 1 or 2 copy and printer stops and show the following error message: “Error in File C:DOCUME~1SETCOU~1LOCALS~1TempSalesAdvice {8F644754-8B0F-4028-ABAE-7EA18B46699A}.rpt: The request count not be submitted for background processing. Now I did not [...]
Answer Question
| November 5, 2009 8:53 AM
Crystal Reports 10, Visual Studio 2005
CRYSTAL REPORTS QUESTION REQUIRING , GROUPING, SUMMARIZING AND SUPRESSING ?
Hi,I am grouping my report as per the columns.I need to sum values of indivual transactions as per the dates and display these summarised values against the items in the grouped columns. I do not want to display the date fields but I need the dates since I need the items , queried and summaised [...]
Answer Question
| July 13, 2009 12:52 AM
Crystal Reports, Grouping, SUMMARIZING AND SUPRESSING DATA
Hi,I am grouping my report as per the columns.I need to sum values of indivual transactions as per the dates and display these summarised values against the items in the grouped columns. I do not want to display the date fields but I need the dates since I need the items , queried and summaised [...]
Answer Question
| July 13, 2009 12:52 AM
Crystal Reports, Grouping, SUMMARIZING AND SUPRESSING DATA
Graph – SAS Question
I am using GCHART and for each month I am grouping company total sales figures by dept. I defined my patterns for each dept total. However I would like the colors on each chart to be consistent with the dept for each company. For ex. company 1 has dept A – D and is assigned [...]
Answer Question
| July 13, 2009 2:59 AM
GChart, graph, SAS
I am using GCHART and for each month I am grouping company total sales figures by dept. I defined my patterns for each dept total. However I would like the colors on each chart to be consistent with the dept for each company. For ex. company 1 has dept A – D and is assigned [...]
Answer Question
| July 13, 2009 2:59 AM
GChart, graph, SAS
Crystal reports XI formula window not appearing on screen and main CR page losing focus
While running CR, when I try to use the formula editor either in the formula fields or selection areas, the window does not appear and the main CR page looses focus. It seems to me that the editor screen is someplace, but it is not visable. Any ideas?
Answer Question
| August 20, 2009 4:42 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
While running CR, when I try to use the formula editor either in the formula fields or selection areas, the window does not appear and the main CR page looses focus. It seems to me that the editor screen is someplace, but it is not visable. Any ideas?
Answer Question
| August 20, 2009 4:42 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Crystal reports formula – equal or less than 60 days
Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.
Answer Question
| July 17, 2009 8:19 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.
Answer Question
| July 17, 2009 8:19 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
can I use accdb with Crystal report 8.0?
can I use accdb with Crystal report 8.0? Please help.
Answer Question
| August 11, 2009 5:42 AM
ACCDB, Crystal Reports, Crystal Reports 8
can I use accdb with Crystal report 8.0? Please help.
Answer Question
| August 11, 2009 5:42 AM
ACCDB, Crystal Reports, Crystal Reports 8
Error in file links
Using Crystal 8.5 Developer in an app. Connects to two Access databases via ADO connection. Works on multiple machines, but when one user goes to display report gets error: “Error in File Links” Warning: Fields in the report from the file “Dynamic” cannot be linked.
Answer Question
| July 8, 2009 6:32 PM
Crystal Developer, Crystal Reports 8.5, Crystal Reports 8.x, Crystal reports development
Using Crystal 8.5 Developer in an app. Connects to two Access databases via ADO connection. Works on multiple machines, but when one user goes to display report gets error: “Error in File Links” Warning: Fields in the report from the file “Dynamic” cannot be linked.
Answer Question
| July 8, 2009 6:32 PM
Crystal Developer, Crystal Reports 8.5, Crystal Reports 8.x, Crystal reports development
