Search results for query: *

lbass, I have gotten my report to output the information accurately and now I am proceeding with cosmetic fix ups...One of my problems is figuring out how to make the report flow correctly. I have a total of 7 subreports that are now making up the single larger report and due to the way the...

lbass, the partners at my firm want it laid out exactly like above because they feel it is easier to look at (rolls eyes). Anyway, I thought of doing the subreport thing but like I said above I will already have 9 subreports at this point and from what you tell me it is not possible to have...

I have never ever even thought about using DTS but I think I need to now and really have no idea about the specifics. Here is my problem: We are using ADP for our payroll system (SQLBase 7.5) and I need to import the payroll information into one of our SQL Servers (SQL 2000) so that I can write...

Awesome, thanks for that information. Now that I have completed a large portion of my report I am looking at it and can't help but think that there has to be a better way of doing it. As it stands right now I will have 9 subreports that make up the sought after report. The one that I am...

thanks for your response, unfortunately the subreport is about 10 pages in length so that won't work. On the main report that will house all 7 of my subreports, does it matter where the subreports go?? Should I just create PHa, PHb, PHc,...PHg?? The only thing I want to pass from the main...

Hello all I've got a few questions Using: CR 9 Standard with SQL Server 2000 using Stored Procedures I work for a CPA firm and have been given the task to build a very large and complex hours analysis report. I am building it in sections, obviously, so what I have so far is the following...

Thanks again for pointing me in the right direction on this...I have come across something new; in two of my SELECT statements I want all departments returned along with a current and past employee count regardless if they have employees in them...naturally I use a LEFT JOIN to create this...

I meant to say Woman...sorry :-(

Wooohoooo!!!!!!!! You are the freakin man!!!! Thanks you so much, your function worked like a charm....Don't go too far though I may need to enlist your help down the road again....You have to be a millionaire

Could you maybe post some code on how I might do that...I would really like to learn from it. Also, when using an IN clause with a variable, how do I get the SELECT statement to see all of the values? Ex. since my variables contain character datatypes I obviously need to use single quotes...

Thanks so much...have a wonderful star for all of your help :-)

Ahh, I see, thanks...One more question; since I will be using a few IN statements, do I need to pad my variables with single quotes for it to work?? As it is now, when I print out the contents of my variables they look like this: CurrenYrToDate: 0603, 0703, 0803, 0903, 1003, 1103, 1203, 0104...

Thanks a lot for the responses...I'm not sure if either of you have heard of Elite; it is an ERP system that, to put bluntly, sucks. The documentation is horrible, the table naming convenstions seem like they were made up by someone having a seizure...Nothing about this system is logical, and...

Do you need to add a column to indicate which of these types of summary it is? Yes I do need to do that, would you be willing to help me out?? Also, do you know how to pad text?? I would like to check to make sure that @CurrentYr, @PriorYr, @TwoPriorYr, and @DefaultMonth are always 2...

SQLSister - Thanks for the help on that, works like a charm. Donutman - Unfortunately I have no control over the DB design, this thing is absolutely huge (over 1000 tables) and is extremely difficult to work with. I can only come to the conclusion that the DB designer(s) wanted job security...

Platform: SQL Server 2000 I work for a CPA firm and the managers and Partners want to know that their staff are not only working a desired amount of hours but that the hours they are working are considered billable time. The following Stored Procedure tries to perform an hours analysis for...

CR Version: 9 Developer Platform: Win XP Pro Datasources: SQL Server 2000 & SQLBase 7 I am wondering if it is possible to share individual values from a subreport to a main report as opposed to summary values Sample Data From Time & Billing System (SQL Server 2000) --Tkinit is timekeeper...

I would like to thank both of you for helping me out on this...it seems that the query was working after all it's just that since I am trying to run Aged Accounts Receivable over a 1 month period that I would have a lot more outstanding than just the 3 records that were returned...I went and...

shouldn't this statement return only records in the 9/30/2004 period that have balances outstanding for greater than 90 days?? (I don't mean to ask it like a question since I am the one who wrote it, I mean it as an 'are you sure?' kind of thing) The really wierd thing about this is that when I...

I have a SQL statement as follows 'dw_xaraged = Data Warehouse table 'clients = Clients table 'matter = Services for each client 'relationships: client 1..N matter | matter 1..N dw_xaraged 'mmatter = Specific service for each client (ie Tax Return, Financial Statement, etc.) 'arage1, arage2...