Search results for query: *

Oops I messed up the version of the SQL2008.. I am not able to connect to it from my 2005 Management Studio so I don't know the exact version. The version I wrote down for it was for the wrong db server, please ignore that. Thanks.

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

You could try creating a formula field like so: if isnull({table.field}) then 1 else 0 If you throw that new formula field in your details section you should be able to get the total count of rows where that entry is null by summing this field in your running total.

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

If you want a section to only display on even numbered pages you can use a suppress formula in the section expert like this: if remainder(pagenumber,2)<>0 then true This will suppress the section on odd numbered pages.

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

Exactly what I needed. Thanks!

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

Thanks gmmastros for the link and quick response. I'm really looking for a way to do this in a view though. Any suggestions would be very much appreciated.

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

Admittedly I'm no Crystal expert but here's my crack at this. Looking at your example it makes sense that the 25's are being displayed a row early. Since this is the case you could try creating the amount reached as a global variable, display the current value of the variable first (this will...

I'm not using a group selection formula. I'm still looking to see if I can get around this problem another way but I'm just wondering why exporting to CSV would yield different data than exporting to Excel.

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

Sorry looks like I posted this questions in the wrong forum... didn't see that there was a sep. CE forum.

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

Ahhh thats it, I actually did have the group but it was being printed each second instead of each day... just changed the group to daily and it's not throwing any errors at me anymore. Thanks!

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