Search results for query: *

Hi, I am trying to solve a problem caused by Crystal only returning the first 1000 values in a prompt. I cannot edit the registry settings to change this however. I have a report using a stored proc as the data source with a parameter @Case. I have created a list of values from a Business View...

We use windows AD authentication for out CE10 system. When we import users from the AD with user names longer than 20 characters the last bit gets truncated. (eg. "jennifer.llwelyn-bowen" becomes "jennifer.llwelyn-bow"). Has anybody seen this before? It also happens on our new system which we...

We currently have a datamart in SQL Server which pulls information daily from hundreds of standalone booking/billing systems round the world. This datamart is used for reporting. We have just developed a new system to replace the standalone ones. It is our intention to gradually roll out the...

I am developing a website using php, MySQL and Apache on my home pc which uses WinXP. I am pretty sure that I will not be able to find a web host who will support Apache on Windows, so I guess I will have to go for one that uses Linux. If I do this, is there a serious difference between the way...

I need to create a new table based on bookings placed in our system. Currently the booking information contains data like:- BookingID StartDate EndDate Amount 1 01/01/2005 31/03/2005 £100 2 15/02/2005 16/03/2005 £50 I need to split these lines up based on the start...

Anyone ever written a formula to calculate the number of months (including part months) between 2 dates? I have been struggling to come up with something that works for all cases. Example 1: Start Date = 01-Jan-04 End Date = 30-Jun-04 Months = 6 Example 2: Start Date = 01-Jan-04 End Date =...

We are using CE10 and are scheduling reports using packages. When a user views the latest instance of a package it brings up the list of report instances. If there are more than 20 report instances the user has to navigate to the next page to see more reports, this isn't always obvious and has...

Is there any way of telling if you are at the bottom of the page or not? I am using CR10 into SQL Server 2000. I have a report with detail information and group footer summaries and would like to prevent the group footer printing on its own at the top of a page when the last record of the group...

Hi, We are publishing crosstab reports to CE10. When viewing these reports through e-portfolio (in Crystal Report format) a number of fields are bleeding into the adjacent columns. Has anyone else seen this before? Thanks

When viewing the latest instance of a report that was scheduled directly into Excel, the following behaviour occurs:- 1) If Excel is not currently open on the users PC the report opens into Excel but there is a blank IE window behind it. 2) If Excel is already open the report opens in an IE...

I use Robocopy to copy files from a number of servers, some are NT and some are Windows 2000. I have no problem getting to the 2000 boxes but cannot copy from the NT ones. The log files give the error "Login Failure: Error in user name or password". Does anyone know of a workaround for...