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

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

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

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

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

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

All I had a hard coded date format DTS which I updated ( with help from TT colleagues) to include a where clause that would bring back the start and end of the previous month in order to bring back 'last months' transactions. The hard coded version worked of course, but when I use the following...

All I have the following piece of code that sets the desired date ranges for a query. dp_history.effective_dt>=dateadd(mm,-1,dateadd(dd,((datepart(dd,getdate())*-1)+1),getdate())) AND dp_history.effective_dt<= dateadd(dd,((datepart(dd,getdate())*-1)),getdate()) It seems that when the query is...

Hi again all Still learning, still making mistakes. Can anyone please tell me where I am going wrong with this coding. Its the WHERE clause that's causing me grief. Thanks Gez CREATE TABLE [AccountLoanTEST] ( [AccountID] char (12) NOT NULL, [LoanStatus] char (20) NULL, [UndisbursedAmount]...

Hi All Been working on this one for a while now on and off. The DTS works ok, but I note that the TranNarration field in the Database is all Nulls - even though all looks well when I use the preview tab. Any suggestions would be gratefully accepted. Cheers GV CREATE TABLE...

Hi All Can someone help me with the following code - I keep getting errors, but can't work out why CREATE TABLE [AccountInvestment] ( [AccountID] char (12) NOT NULL PRIMARY KEY, [DepositNo] char (12) NULL, [StartDate] smalldatetime NOT NULL, [MatureDate] smalldatetime NULL, [Term] smallint...

Hi All Hoping someone can help. Please find below a DTS package I have created, and am having difficulty running (seperated into two parts). ______________________ CREATE TABLE [TESTNEWTRAN] ( [DPTranNumber] decimal (12,0) NOT NULL, [AccountID] char (12) NOT NULL, [TranCode] smallint NOT...

Hi All Hoping someone can help. Please find below a DTS package I have created, and am having difficulty running (seperated into two parts). ______________________ CREATE TABLE [TESTNEWTRAN] ( [DPTranNumber] decimal (12,0) NOT NULL, [AccountID] char (12) NOT NULL, [TranCode] smallint NOT...

All I know this one has probably been discussed to death before now, however if only once more... I am trying to get this coding right, so it will enable me to retrieve all transactions of the previous month. It is the combination of DatePart and DateAdd that has me confused. The following is...

Hi all Progressing along nicely, however I have come accross a syntax error around the insert command of the following code. Any help you can give will be appreciated... Thanks GV CREATE VIEW CombinedAssets AS SELECT "PropertyAsset"."id" AS AssetID, "PartyFinancialItem"."partyId" AS...

Hi Progressing my coding from Crystal Reports into SQL, and running into some problems with NULL and ISNULL calculations. The following is some basic coding I have done, and am getting errors around the ISNULL statement. I would be gratfeul for any help. Thanks GV SELECT...