DataManagement

conversion from FileMaker Pro to Microsoft Access database

How do you convert filmaker pro 7 database to an access 2007 database file

ignoring line breaks when inputting data

Suppose we have this text on three spearate lines this is a sentence. this is another sentence. and we want to read it as two records - one for each complete sentence this is a sentence. this is another sentence. How can I do that is SAS?

Dates in Crystal reports

Hi, Situation looks like this: i've got table with dates, but some dates are missing (no records) but in CR i need all dates i.e. reports contains data from May 2009 but there only 4 records for May 1st, May 13th, May 20th and May 22th, but i need to show on graph all dates starting from May, 1st...

Delete OLD files from Table not having date or timestamp

Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

Printing the Links in the Standard Report Creation Wizard

I am trying to print the graphical display of the links in the Link box of the Standeard Report Creation Wizard. How can I do this?

security privilege

When report was query error appear as "A request was cancelled. The necessary security privileges could not be verified. This indicate a problem with the security server"

how long should an average EDI (xi) map take to develop

I am working with a new vendor and I would like to know how long it should take to develop, on average, EDI maps in XI. I am experienced with other EDI mapping technologies and ETL mapping tools. However, I have not worked with XI before and I would like to know why it seems to take significantly...

CUT SUBSTRINGS USING SYNCSORT

HPW IS ONE ABLE TO CUT A SUBSTRING FROM THE NAME OF A FILE AND ALSO APPEND IT AS A RECORD IN THE DATABASE??

Career matchmaking - program development

I am interested in making software that allows potential employees to find employers who are offering what they are looking for in a job (be it salary, benefits, location, a specific job, etc). I also would like to have the vice versa of the scenario where the employer can look for a specific type...

Crystal reports

Hi, I need a link to navigate from subreports to main reports. Eg. i have a report and subreport embedded in it. when i click on subreport link it open that report in another tab. I need a link in subreport so that when i clik on it, it should go back to main report. Thanks, Vijay Kanth

Crystal Reports - The special variable 'formula' must be assigned a value within the formula

Any new formula I try to write comes up with this error. I have disabled all report formulas that use a shared variable thinking that it would take care of my problem. I am using version 8.5. If I reinstall it would it clear up the problem?

how wrap marathi word in next Line in crystal report 8.5

hi i m using crystal report 8.5 i have simple data report in marathi for this i m using ISM when i saw a preview of that report in crystal report it is ok but when i saw a report in crystal report viewer (in c# dot net) marathi word is cut at the end of line i.e. marathi word is not wrap. PLz tell...

Field in crystal reports duplicating lines from quote

Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database. This is hard to describe accurately but here goes... I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes. QUOTE_Binary_to_notes is...

Suppress duplicate subreport data

Using Crystal Reports 11, I have a report with 2 subreports A and B. Sometimes the two subreports will show the same data. Is there a way to suppress data in subreport B if it already exists in subreport A? My report is laid out as such: Group 1 Header Group 2 Header Details Group 2 Footer...

Showing a substiute value in a report if conditions are met - Access

In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...

Hiding fields in business objects

I have a field (country) that I need in my query in order to perform a calculatin but I dont want to show country in the results. How can I hide this field?

Crystal Reports help

I've been given a Crystal Report to modify which contains 180+ fields and formulas. Is there a way for me to get a printout of all the formulas? There must a at least 110 calculated fields it would be very nice if I could export them to an editor for viewing and documentation.

Importing History into Microsoft CRM 4.0

How do I import history in Microsoft CRM 4.0?

FTP AS400 RECEIVING EDI FILE

ON MY AS400 VER 4.5 I AM RECEIVING THRU FTP A EDI FILE FROM A PC BASED SYSTEM BUT THE DATA COMES IN AS ONE LONG RECORD. ANY IDEA'S THAT WOULD HELP

Disconnecting a Crystal 8.5 report while report is open in VB6

Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which...