Search results for query: *

I have a SQL Server 2005 DB (8.0.2055) and need to connect to another DB on a SQL 2008 (9.0.4207) server to pull some data. I've tried creating a new Linked Server entry selecting SQL Server as the server type and tried querying the data by using something like SELECT * FROM...

I created a report with the page size set to "Letter 8 1/2 x 11 in". I then needed more space and changed it to "Legal 8 1/2 x 14 in" page size. When I did this the white portion of the page increased as it should and I was able to add my new columns without any problem. When I save the report...

Oracle 9i -> ODBC -> Crystal Reports XI I'm receiving the following error when running my reports: Database Connector Error: 'HY000:[Oracle][ODBC][Ora]ORA-01406: fetched column value was truncated [Database Vendor Code: 1406 ]' I can run the query being used by Crystal (Database->Show SQL...

Hi all.. I'm using MS SQL 2005 and am trying to take data that is in multiple rows and display it in a single row. I think my question can best be understood with an example. Here is what I have Name Type Count ------- --------- ------- Host1 A 53 Host1...

I'm using MSSQL 2005 and am trying to create a view that does the following. If the dataset looks like this: Column A Column B --------------------- host1 ABC host2 AAA host1 CDE host3 FFF host2 BDE host1 ZZZ The output of the view would be...

I'm using CR10 and have a simple report with 1 grouping. Overall there are about 112k records in the report but the grouping cuts this down to about 2k. When I export the report in xls format only the 2k records are included but when I export to CSV which is what I need, all 112k records are...

Hey All, I am pretty new to using Crystal Enterprise (ver 10) and have a question. I have a link on a website I created pointing to the URL of a report and I got this URL by doing a preview of the report object and copying the address. I'm now experimenting with larger reports that are...

Hey All, I am pretty new to using Crystal Enterprise (ver 10) and have a question. I have a link on a website I created pointing to the URL of a report and I got this URL by doing a preview of the report object and copying the address. I'm now experimenting with larger reports that are...

I'm trying to work only with those rows of data that are the most recently updated each day (maximum timestamp for each day) but I'm running into some problems. I've tried creating a formula field with the following: Maximum({DEVICE_ALLOCATION.TIMESTAMP},{DEVICE_ALLOCATION.TIMESTAMP},"daily")...