My report has a large text block, this is causing problems because it keep jumping to the second page rather than starting from page one spilling over to page two naturally.

The tabs (at the bottom of my screen) for my detail drawings have suddenly disappeared. How do I restore them?

Hi Guys, I was wondering if any of you knows how to grab data after a specific character. Right now, I have a comment field that has various information in it. the field is called {misc_comment} here is the way the data is laid out: 00VISA 2 /IN: 20120125 00DENTALCENTER /IN: 2012APRIL 00AMAZON/IN: 557878 I…

i have table inn my crystal report at the testing phase an cell contained very long paragraph and that caused the report to skip half of the page and add the long record to new page . how can i let the report behave in the right way like Excel for example. thanks in advance 

I came a cross a wired scenario the other day. Although we could see all tables of a database in Crystal, we could not establish manual links. When right clicking on a field only ‘Browse’ option was available. The ‘Start link’ option was not visible. any ideas?

What selection criteria would limit the display to only the most recent entry per account?

Hi, I’m working on ale idocs right now… while transferring data from one client to another client  I got a  problem in inbound. It gave me an error 51. How can I get rid of this problem. Give me clear information on basic type on what it’s meant for exactly.

What is the need for business intelligence in varying organizations and its future opportunities

Hello, I’m thinking about to buy two barebones servers but I don’t know a lot about hardware. http://www.newegg.com/Product/Product.aspx?Item=N82E16816101319 Can I use four SAS HD’s? I need just to buy the HD’s and put on the server or do I need to buy a SAS card first? Because I saw the description here: http://www.supermicro.com/Aplus/system/1U/1022/AS-1022G-URF.cfm and look…

How many logical views of a report can be created and applied by CA-View

LogiXML recently conducted a survey of 757 IT pros on how they view users of business intelligence and some of the more highly entertaining results included:76% say users make BI needs known by “screaming like banshees” or assuming IT had “telepathy”38% think users spend most of their time “checking Facebook comments on photos from recent…

Sign up for the Teradata live webcast on September 19 at 1 p.m ET as industry analyst Lyndsay Wise will discuss the challenges companies are facing today by relying on traditional BI tools and systems alone and will highlight the benefits of adopting an integrated BI and data warehousing architecture.

Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

I’m looking for a formula that will adjust a timestamp if the current timestamp is not within business hours. If the current timestamp is after 5:00PM the timestamp should increment the date portion by the correct number of days (Depending on Day of Week) and the time portion should be set to 8:00AM. Similarly if…

Is there any way to track “User Account” information on a DB2 server specifically when a users account is locked?

Can I connect Pressure Transducers(Eg:UNIK5000) (0-600bar) and Vacuum guages(Pirani & Penning Guages-upto 10^-8 Vacuum) to Yokogawa MW100 DAQ Module for realtime data acquisition? If it is possible to connect,then is there any necessary interfacing device/unit required?

Data that is provided by a vendor is to be scanned and processed, however instead of a fixed format, this data is “group separator” (ASCII Code 029) delimited. In the 5250 session screen field that the scanner writes to, the data is being loaded but the group separators are being stripped out. So it is…

I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12.…

I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12.…

I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using “Text to Columns” but the delimiter characters are missing and the text is garbled. Several of the…