Search results for query: *

Hi All Been a long time c=since I have been on here and just as long away from Crystal. Now back into it, but encountered something I never have before - a cross tab calculating incorrectly. It is grouped only once, with one total column. The number for each row (3) of the crosstab seem to be...

Hi All Been searching for awhile to find an answer to this one, hopefully it's a case of shop blindness... My crosstab (CR 2008 nil sp) provides distinct counts that provide a correct total and distinct percentage of 100%, but the groupings making it up are way over the expected total and way...

Hi All I am wanting to create a report catalogue out of our CRS 2008 server. I have tried to connect to CRS using CR via ODBC which does work, but it only sees parameters and custom functions. I have also tried to connect to the database itself, but have found it impossible so far, to locate...

Turk Thanks again for your help. We looked at it again with a fresh set of eyes and realised that the problem was based on the fact we installed a brand new server running 64 bit. It turns out that the ODBC 32 bit connection was bottling up the whole process. We cleared out the 32 bit...

Ok - Updated - sorry for the delay I have been using Crystal Reports as a report writer since version 8.5, so am an advocate for BO. I was asked for a more robust report delivery system than the old RAS I have used in the past and of course found that CRS advertised exactly what we need, so we...

Thanks Turk Yep - seen that one before. Good to set it up, and the IT boys have done that. It's more about very simply (?) loading a pre created crystal report (2008) and getting it to run, without coming up with twenty different error. OK twenty is probably a bit of overkill - but you know...

All I have looked high and low for a guide to CRS 2008. I am in charge of implementing this product, using CR 2008 to write the reports and SQL 2008 as the db back end. I have been playing with the main management page, but am a little lost as to the process required to get an existing report...

Does the machine where CR Server located have access to the database used in the report, and is it named as it is in the report? GV

Dinshak Sounds like the field in the database is not a true boolean. You will need to add the following to the Select Statement of the report (or coding) {INVESTIGATION.X_OOS_8_INVSIG} = "T" Having this in the Selection criterea means you dont have to hide the data within the report - it...

Hoping you may be able to help. Being a newbie, this one has me stumped... Trying to start from cell a1, and copy the range of data from b1 to i1 to position k1. I need this to be loopped so the same is done for all lines of data from a1, a3, a5, a6 etc until cell ax is blank. Having red quote...

Thanks for that CC Tried that already - the system is not too happy with it I am afraid. Back to the drawing board it seems Cheers GV

All Still continuing with my project, and been trying to work this one for most of the day, with many attempts and frustrations. I though this bit would be easy, but alas - no such luck. I have the cursor in Cell B1 (blank). Cell A1 is the result of my previous post's formula, which is url...

Thanks to everyone I will take some time to digest these suggestions - I appreciate your help. Cheers GV

Thanks for that Skip Having only started writing VBA code on Monday, I am a bit confused by the meaning of your post. If you could explain what it is you mean, I can take it from there. Thanks GV

Hi all The following code works except that it defaults every time to the else clause - or seems to. The First part of the if clause should capture any Race Number (using count) that is less than ten and add a zero preceeding the race number in the HTML statement. Currently, evertime I run the...

Hi All Managed to get some answers to this one. Cheers GV

Hello This is my first day using VBA. I have searched the web and tried to come up with a single usable answer for my query. I am running Excel 2007 on an XP machine. I am trying to produce a large data input from a third part website, and am working through it stages - this one has got me. My...

Hi all Having a problem with a Datediff formula, where I am getting a whole number back (which is rounding someone 17.78 yrs old to 18). Currently the formula is (datediff(month,RM_ACCT.birth_dt,getdate())/12) AS Age With birthdate as smalldate and Age as numeric with precision 18 and scale...

All It's amazing what happens when you spend time away from actually trying to solve a problem and look at it a different angle - I now have it working. For those who haven't seen it - I missed out a vital part of the coding, which designates the start point for the substring. Having entered...

All I am having a problem with the line of code below (it is a small portion of a select statement). It will not parse correctly. Basically I would like to return as the PacketNo If the deed_pkt_no is not null, then return the deed_pkt_no. If it is null, then all but the first...