Search results for query: *

CR 9 / SQL Server 2K / Mailing Label Wizard. Do any one know all the dimensions including W/L/margins - inner & outer etc. of the Avery Labels in Europe and more especially for L 7163. I couldn't find it any where on Avery or other sites. If you know any site please point me to it. This is not...

CR 9/10/11 SQL Server 2K/2K5 (I use them all) I have 4 subreports in a report. One of the sub reports has a different datasource (ODBC/server/database) depending on the Company. Therefore, I have to change this one subreport for each company. Rest of the main & other sub reports are all the...

CR 9 SQL2K I have a memo field like this: <<value1>><<value2>><<value3>><<Value4>><<Value5>><<Valeu6>><<Value7>><<Value8>> and so on. I want to extract every third value looping through from the beginning to the end of the string (like Value1, 4, 7, 10 etc) and display each one on a line with a...

CR 9 DB - SQL2K Hi all, I need some help. Formula @CMY1 = val(totext(dateserial(year(DateAdd ("M",0 , CurrentDate)), month(DateAdd ("M",0 , CurrentDate)),1),"yyyyMM")) (the value will be incremented through separate formulas for other months). The result of the following formula displays as...

CR 9. SQL Server 2K. I have a calculated fields with same values (with decimal) displayed in the same row on a matrix (like a manual cross tab). I need to round up one and round down the next (alternate) and so on. Example: ID = 101 Table.FieldLoan value = 10 Number of Installments = 4...

CR version 8.5, 9 & 10 DB SQL2k Do any one know the settings for Avery 4019,4020, and 4065? These are "Pin fed labels". I checked in Avery & Crystal sites of no avail. Neither one of them is a big help in other forms of contact either. I need the page margins and Gap between the labels...

How do you build a report using a Report Definition File (RDF)? I could not see a RDF as a data source any where in CR. I could not see any reference in BO's site either. All they talk about is Field Definition file (TTX). Can some one please give me a brief steps or point me to a link that...

Crystal 8.5 or 9 Database: SQL Server 2K I want to change the Font size dynamically in Crystal depending on the length of the string because I want to print the name bigger or smaller depending on the length of the string with in the allotted space. I can not grow the field (no space to wrap)...

SQl Server 2K Crystal 8.5. Situation: I need to print tickets for order with multiple sections depending on the quantity ordered. Example: Order 1 (Group 1) Section (Group 2) Section 1 - Qty 3 Section 2 - Qty 1 Section 3 - Qty 2 so on...

Unlike CR 8.x or earlier versions we can not make the Data source path universal (removing the hard coded DB server, owner path) in Crystal 9. Crystal Decisions come up with explanation that universalization of path is not needed any more etc. Do any one know or remember where this document...

Is there any way to suppress an empty space in a text field or a database string (varchar) field that contains some blank spaces in the middle ? Database: SQL Server 2000. Crystal Decisions: 8.5 / 9 Ex: The database text field will look like this. The above one or two line spaces...

Is it possible to use more than one ODBC connection in one report? If so how? Example 1: I have to create a report where 4 tables are from Oracle 8i and 1 table is from SQL Server 2000. Both have their ODBC setup and working separately. Example 2: I have to create a report where 4 tables are...

I am creating reports for a company that has number of branches. The company don't want one branch to see another branch's data on the report. Is there any way to filter the data through the users' windows-login-id or mail-box-id so that if Branch 1 runs the report it can see data (records)...

DB = SQL Server 7 / 2000 CR = 8.5 The DB table is storing everything in arrays for all datatypes. I have to report a multiple column report using different instances from each array. This could be from one table or another. Each selection is conditional. The layout would look like this...

Is there any way we can create a foot note like notation in crystal report 8? I need to put 1 or 2 or 3 etc. in the report and give an explanation text (a field value) at the end of the report(like an end note you see at the end of a term paper or a company annual report). Ex: 1...

Can we create an Index at the end of the report for the values/words in the report. EX: 123 John Doe Company Page No 3 456 Smith And Smith Page No 57 ..................etc. I have created the formula giving the info exactly as I need. I have assigned it to a...

I have a need to consolidate my cash for each calendar month. My payout bills are spreaded over two calendar months. Ex: January 10th to February 09th. This trend continues for the entire year. My need: For January I need to take the number of days and cash amount from 10th to the end of the...