Search results for query: *

I have the following code but I can't get it to give me individual sums for debits and credits for each journal. I just want a list of journals names with their debit and credit values as one summed value which should match to each other in theory but our journals can be 20000 lines long. Code...

I Open Section expert and then press the formula button, it goes to open the pop up formula box but I just cant see it. I have tried everything. Its obviously open as I can not do anything else on screen until pressing escape and I am then back in section expert. I used this last week but...

use RC001 declare @line_amount integer set @line_amount = null select top 10 * from rec_items where (ABS(line_amount) like convert(int,isnull(@line_amount,'%'))) and rec_id = 'HWK1004' The column itself only contains numbers and is always populated however im using the code to build a report...

I have the following code but I can not get the reults to populate Excel even though they return results in query editor. Its a slow query but should't cause a problem declare @dbs table (db varchar(20)) insert into @dbs select upper(wdname) from csmaster.scheme.workdirm where dgroup = 'sys'...

I want to sum journalamt but using the part field in the group by satement but it will only let me use the posting_code field I know its probably simple but I don't write SQL SELECT journal_number, Left(posting_code,2) as part, SUM(journal_amount) as journalamt FROM...

I have two fields in a Universe.I need to show the value of these value field as a Debit or credit. These are running against oracle databases My field indicator is either DR or CR. I would imagine the select statment in the universe to be SUM(amount) * -1 where DRCR indicator like 'CR' else...

I am getting the above error when writing some code(Not a single-group group function) select '01 Arrears' as arrears,a.agreement_type as Agreement_type,a.agreement_status as agreement_status ,count(*) as count,a.prb_number as prb_number,a.prb_fund_type as fund_type, sum(a.wkprem *...

I have some users who use a VFP routine. We had a power cut and when they try to access their routines they get the message file access denied. How can I unlock these tables. I do not use vfp but I can usually get by Thanks

I have been tasked with migrating data from a Great Plains Database to a Sage Database. I am only moving general ledger data. I was wondering if anyone had a copy or knew where I could find a diagram of how the data is linked within the GL tables. I seem to get so far then it all goes pear...

I have created a Universe based on a single excel worksheet with 70 columns, nothing fantastic. I created the universe and inserted table,all 70 column headings are shown. to check it was reading this correctly I did a count of Rows and got the following error 'Syntax error in From Clause' If...

I am trying to run the following bcp union query. I have two queries on two tables that I am trying to join the output for. Individually they work but it doesn't like the UNION command. Any Ideas would be helpful @bcp "select 'SL613'...

I have some users who run various MS QUERY's. I have written some and some they write themselves. Some of these queries run when you open the excel spreadsheet. You can refresh them once but then the ability to refresh dissapears and you can not edit the query. On some spreadsheets this happens...

I have a VB script that I did not write and I confess to know very little about VB. I am trying to amend the following script with the one below but Ikeep getting a 1004 run time error If PensionRowNum <> 0 Then Range("J" & PensionRowNum).Select...

I have a Chart which is fine, however when I create the chart it take my group name before it was formatted. My report shows groups as Feb 2007 but the chart reverts to the pre formatted version as 02/2007. Any Ideas Pete

I have some users who want some extra info for a one off report.Basically they want to report on a field from the universe which is ytdspend. They want this column 7 times but the YTD amount is dependant on an account code. How do I set each column up to report differently for the same field in...

I was wondering if with Dynamic Parameters you can make them work up or down. My example of levels is Division,,SubDiv,BudgetCentre,Cost Code Can I select say Sub Div or Budget Centre and then just report on that. Do I have to work down from the top level or can it be left blank. Thanks Pete

I have a table in MSACCESS which I use as a lookup, this runs fine on MY PC. However when I run it against Business Objects via the intranet I get asked for a user name and password when it tries to acces the MDB. Has any one got any ideas. I have tried my username for the network but to no...

I have 68 fields with a different formula in each. I want the result to show a different colour for a positive or negative result. Is there a way of writing a formula to say IF {Multiple fields} < 0 then crRed else crBlack. Seems pretty simple but either you cant do it or I am simple...

If have an IF statement which generally returns a value however on occasions there will be no value to return to my formula field. How do I pre populate my formula field with the value of zero before the IF statement is run or can I put a zero in at the end. Sample code below IF {?Period...

I have managed to confuse my self all ends up and just need a helping hand. I have the following selection {nlforcm.budget_code} = {?Budget Code} and not ({@YTDActual} <> 0) and {@YTDBudg} <> 0. What I require is to do an inull at the end of this selection, when the results of the selection...