I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is the field i need to display ...
When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software's database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type "A" to data type "O". Our case tool is recognizing...
I am long-winded, so please bare with me! We are having trouble opening pdfs on certain websites. Currently PDPworks as well as one of our vendors who uses twelvehorses.com as a pdf server. We are unable to open a pdf from pdpworks at all and are hit and miss with opening pdfs from...
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
I have a report where certain records are set by a binary switch to print a bold text. I want to prevent these records from printing as the last record on a page. I have tried to do a record count and forcing a page shift if my true false criteria for the binary is met but the record count per page...
We are Using Crystal Reports 2008 I create a report. My end users use Crystal Reports Viewer how can I enable the refresh button on the report to allow the user to up date the report viewer
Hi, I have some reports that automatically run through the Crystal Management Console. I need to turn off or remove recipients from some of these reports. I have gone into the Schedule tab for each report and changes the recurrance and recipients then updated the parameters. The problem is that my...
Hi Everyone, I have a Crystal Report with the usual group headers/footers & detail section. On my detail section I have a 'running total' it is a count function and it counts the number of lines based on a Unique Reference Number But my problem is that I want to get the Maximum of this count....
I am looking for a sample source code / algorithm which can convert NSF (National Standard Format) to 837 ANSI format?
Why "FIND and REPLACE" function does not work in subreport?
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?
How Can Protect For password My Crystal Report's rpt File?
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 but...
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.
Does any one have any idea how a connectin of Spatial Data Bases of ArcGis Server can be achieved?
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, but...
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
As usual, I often use: select top 1 * from table But in DB2, I can't. I use Toad tool to input SQL statement. Who have any solution? Please share with me. Tks a lot!


