Recent content by Bisquite

Thanks for the quick response. My preference would be not to edit the registry, I am working for a client that has strict policies on such things. If we were to try it though, would we need to change the BO Enterprise server's registry or the client pcs, or both?

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

You're right Eric, I've just tried it and it works fine. Thanks for replying.

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

You replied whilst I was typing... Thanks for the code, I'll take a look at it tomorrow.

I think the logic behind the amount calculations will have to be based on a standard 30 day month, but I am yet to decide this. So I think for simplicity it's probably best to ignore the amounts for now and concentrate on just splitting the dates. So for your examples we would get the...

We have tables that store all the months and all the days. Is that what you mean?

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

Thanks Scott, I will give this a go. I am still undecided as to whether partial months should be treated as fractions of the month they live in or fractions of a standard 30 day month. Any thoughts?

But that wouldn't work if the start and end dates didn't fall at the start and end of the month.

Thanks Madawc but this wouldn't work well enough as it's too big an assumption. If the start and end dates were 01-Feb-05 and 28-Feb-05 then this formula would give you 0.93 months but you want 1.0 months. I know you could put lots of conditional if statements to check the month but there must...

Thanks Synapse but that would only round to the nearest whole month, I am also interested in part months, hence the .5 in example 2. David, we use SQL Server but I don't want to start writing stored procedures or views to write reports on, I would rather keep it just to Crystal. The current...

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