DataManagement

Can 1 get data from 3 different DBs to write a WEBi report

My company stores data in different databases in the same network. These databases have the same schema. Can one write say 1 WEBi reports that would get data from different databases. example DB1 has Customer names (A-J) DB2 has Customer names (I-O) DB3 has Customer names (P-Z) from the above...

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...

Crystal Reports exporting issue

Hi, I am using crystal reports XI Release 2 to develop reports and I will deploy the reports in Crystal reports server using Central management console at client location. My requirment - I have developed a report and it consists of 4 ondemand subreports. I have to export the reports( main and...

Crystal Report 10 - Can not obtain error message from server

When running a Crystal Report(V10) I get the error message 'Can not obtain error message from server' My report is running over a Domino database, connecting two views to together with a single join (Left outer join, not enforced). If I run the report I get a different error message 'Failed to...

Crystal Reports Duplicating Records

Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...