Recent content by basquiat

Hi I've created a shared Notebook in a library on Sharepoint Services (Small Business Server 2003)...it works just fine from all XP workstations. Trying to open the shared notebook from Vista returns the following in OneNote 2007: 'OneNote cannot find the file specified' And after clicking...

Thanks Jebenson; Nice links! Thanks you;

Hi I have (I'm sure) a very basic SQL Server 2000 and VB.NET question; To simplify: I've got two tables on SQL "Employees" and "Transactions"; "Employees" has one Field... "EmpNo" and "Transactions" has 3 Fields... 1) "TransNo" (Primary and Identity) 2) "EmpNo" (Foreign Key) 3) "Amount" Now...

Thanks lbass; I changed the way the report was grouped and followed your advice above; Works fine now; Thank you very much for the help;

There's a field "AccNumber" holding the account numbers; Then there are 24 fields with the balance/movement for each month of the current year (BalanceThis01, BalanceThis02 .... BalanceThis12) and previous year (BalanceLast01, BalanceLast02 .... BalanceLast12); The balance field holds only the...

Thank you for the feedback; Both your methods still give me the error…“running total cannot refer to a print time formula” I think it’s because it’s doing the calculation during pass #2 and I need it during pass #1? I am trying to write a Balance Sheet (for Financial Statements); The report is...

I’ve got the following very irritating problem… I’ve got a table with 2 fields, account number and balance; Account Balance A 100 B 200 C 300 D 400 E 500 F 600 On my report I only want account D, E and F (in that order) and the balance next to...

I’ve got the following very irritating problem… I’ve got a table with 2 fields, account number and balance; Account Balance A 100 B 200 C 300 D 400 E 500 F 600 On my report I only want account D, E and F (in that order) and the balance next to...

Thank you very much!

Hi I've got a report with a formula field; Depending on the paramater selected by the user, the field should be displayed either as a number or as a %; Is there an easier way of doing this apart from adding another formula field with a % format and suppressing the fields based on the...

Thank you, worked 100%;

I've got a Income Statement report with a group called 'category' based on a account type code in the table; I gave this group a 'specified order' and with a formula divided it into 4 Named Groups Income, Expenses, Interest, and Tax; Each group has a sub total and there is a grand total, which...

Thanks! It's doing the trick; But since the formula is now group1, it sorts it according to this group/formula; I've got 4 categories "Income,Expense,Interest & Tax"; How can I get the groups in that order since it's not ascending nor descending?? Thanks for your help!

I'm using Crystal Reports 8 I am trying to create an Income Statement based on a Transaction Table; The table has an entry for each and every transaction captured; So there would be more than one entry per account type/code; For example... AccCode: AccDescr: Amount: 1000...

Thanks! You helped alot!