Search results for query: *

My main concern is that they created this thing called Business Views to replace the Data Dictionary and when talking with a consultant the consultant said that they were going to probably discontinuing the Business Views in the next version, V11, when they start integrating it in with the other...

I thought that the Crystal Management Console came with ePortfolio. You need that on the backend to manage all of the objects that you are going to be placing in ePortfolio. Do you have the ePortfolio Launchpad? It should be on that page. Cole

I'm using DB2 Connect to connect the DB2 Data Warehouse center to our AS/400. DB2 Data Warehouse ver 8 and V4R5 on our AS/400. When I use the CLI I can connect to any table on the 400 and query it. It just seems to be with the Data Warehouse Center gui that I don't see all my tables. The...

T.Blom Thanks for your response but I'm not sure I'm following you. I'm having trouble viewing the listing of physical files at the moment. For the time being I'm not concerned with logical(views), although I just checked and I can't see any of them, one problem at a time. Cole

What you need to do is to go into the Management Console and go to Manage Objects and select that object. Once that object is selected then go to the Database tab, this is where you can enter the userid and password for the sql server. Cole

I have something I don't understand. I'm running DB2 Data Warehouse from an NT server and I'm connecting to our AS400. I'm trying to create a link to a Source table on the AS400, when I browse the table list I'm not seeing all of my tables, why is this? Also, on some files when I do connect...

I've tried to do both. I've entered a 0 in the "For Empty Cells" box with no effect. Also for that field the box and text for "Show Items with No Data" are greyed out and not available. Cole

I'm not sure how best to describe this but let me try. I have a table that has a range of of columns and rows that are supposed to look like this: .60 .65 .70 .75 .80 .85 .90 R1 1 0 5 4 2 0 0 R2 8 0 3 0 0...

I need some help. I have a pivot table that I'm creating and it has a field for the Columns that I have a Column heading for but for all of the Rows the value is zero. I still want the Column heading to display but the way it works now if there are all zeros in the row it doesn't display...

Hello, I'm trying to retrieve the number of rows that are in a text file via vba. I'm transferring data from one system to another in a series of files and I want to record the number of records I'm transfering in a spreadsheet. Is there an easy way to do this? My first thought is to open...

I found the answer to my problem. I can create the formula for my record selection by going to the "Record" menu selecting "Edit Selection Formula" then selecting "Record". This bring up a formula editor dialog. As long as my parameter is defined I can manually...

Hi Rosemary, Thanks for the information. I'm looking Books Online over right now. My report combines data from multiple databases. Is it better to create a Visual Basic program to extract the data to send to Crystal? From what I'm gathering the stored procedure in SQL Server only can...

Thanks Rosemary, I'm not familar with stored procedures. How do I go about creating one? Cole

Hello, Is it possible to code my sql statement so that depending on a selected parameter. Here's my problem: given a selected business I use different fields to extract data from my system. How do I code this? Thanks, Cole

Hello, Is anyone using DB2 Warehouse Manager? Our company is going to install it this month and I was looking for some additional heads up on the product. Pros and cons and tips. Thanks, Cole

Hello, I have a report that I scheduled in CE 4 days ago and it is still showing as "running" when I view history for the report. How can I cancel this report? In a related vein, I have two large reports that I am trying to run and I keep getting a timeout when I try to run the...

Hello, I am runnin CR 8.5 and every month I need to run the same set of reports. Is it possible to run these reports from a command line and then place them in a batch program so that I just supply the date parameters and then all of the reports will run? Thanks, Cole