Search results for query: *

Thanks to all who responded. I was able to get it working correctly. Sue

Turkbear, Yes to both questions.

I'll try that again. It's been a very long day. The 12 digit accounts would be 200012347405 10.00 201036987405 15.00 202043567405 20.00 The fund account in all cases is 27405, and that amount should equal the total of the 12 digit accounts

Sorry, I'm confusing myself. In the example in my last post, the 3rd 12 digit account should end with 7405.

I have tried grouping by 5 digit account then by 12 digit account. For example, you have a 5 digit(fund) account: 27405 45.00 You have several 12 digit accounts: 212347405 10.00 236987405 15.00 243567505. 20.00 I want the total of these 12 digit accounts(i.e...

I am using Crystal Reports 8 on MS sql server 2000. I need to compare the total of accounts such as 2xxxx7801 with the amount of account 27801. The 2 in the example stands for the fund, and there are several different funds. I can't seem to construct the report so that the 5 digit account is...

Thanks, Skip, that worked perfectly. Sue

I'm a newbie to powerpoint. I created next and previous buttons on each slide, but they are different sizes and at different locations. Is there a way I can make all the buttons the same size? Also, is there a way I can make all Previous buttons at the same location on each slide? Thanks...

I am currently using Crystal Reports 8.0 and Sql Server 7.0. We are thinking of upgrading some people to CR 9.0. If I bring a CR 8.0 report into CR 9.0 and modify it, can I save it back to CR 8.0 format to be used by people with CR 8.0? Thanks for your help. Sue

vongrunt, Thanks for getting back to me. I'm still not quite sure about how to get around with the newer form of sql, but since the sql was already in place(from Crystal), I tried to follow that form. I'm more accustomed to putting just the table names in the From section and the joins in the...

I'm using Sql Server 2000 on the client, and Sql Server 7 on the server. I copied sql generated by Crystal reports into a stored procedure and modified it to include 2 new tables--budget_lists, and budget_list_accounts. When I run it in query analyzer, it parses ok, but when I try to execute...

Thanks for the link. I'm going to try the workaround. Apparently the Service Pack is not yet available. Do you have any idea when it will be coming out?

I am just getting started in asp.net. I am running Windows XP and Visual Studio.Net 2003. When I tried to build an ASP.Net Web Application, I got the following message: Could not copy built outputs to the Web. Unable to add folder '../labfiles' to Web project. Server error: '../labfiles'...

Well, I finally got information displaying for last fiscal year. I couldn't get the union to work right. Apparently what did it was Dave's Cast/ReCast syntax, along with changing the Crystal running totals formula to 2004, instead of last fiscal year. Neither one of those worked alone, but...

Thanks Dave. I was on the right track, but couldn't get the syntax quite right. I'll give it a try.

Thanks, Fred. I'll give it a try, and I'll let you know if I have any questions. Sue

I tried the 2 most recent suggestions, and I also tried changing ledger_balances.fiscal_year to budget_lists.fiscal_year, but so far nothing as worked. I had tried to use @last_fiscal_year instead of hard-coding '2004'. When that didn't work I tried '2004', which I will settle for at this...

Thanks, -k, I'll give it a try and let you know if it works. Sue

Thanks to all who responded. I think the 2 data sets may be the problem, but I'm not sure how to determine if that is the case, or how to join the two with a UNION query. I've posted the proc below. If anyone can point me in the right direction, I would very much appreciate it. Thanks, Sue...

I have a Crystal 8.0 report that is running off a stored procedure(SqlServer 7.0). The stored proc is returning the period amount for the current fiscal year, but not for the previous fiscal year. I just get 0's for previous fiscal year amount when I add the condition that fiscal...