Search results for query: *

Is it possible for me to group data multiple times in one report without going to the sub-report option? Example: I have data on the locations and cities of property around the world. Management would like groupings of country, then another for city, but they want them independent and not...

Hey everyone, So we've run into a problem that we can't find an answer to. Here's where we're at: BOE XIR2. Report has been written based on stored procedures. It also contains 5 sub reports all pointing to the same stored procedure. When we run this report locally it takes our programmer 2...

I'm also getting this error: There was an error while writing data back to the server: A server running on a machine different from the CMS machine may not register to the CMS with your current set of license keys. The product must be upgraded. The install was only done on one machine. Any...

I keep getting these errors in my event logs, having to do with my Crystal Reports Server XI R2. Failed to register with the name server. Reason: The server name being registered is invalid. There might be another server registered using the same name. Choose another name or delete the...

Hi Turk, I'm stalled at the start really. I've got the backup .sql file sitting there, and trying to run a restore. thats where I'm getting stopped. I can't seem to be able to run a restore properly. to be honest, I'm the shits with MySql stuff so this could be part of it. haha. Could you step...

Hey guys, I'm stuck. Our servers all went down and I now am re-installing Crystal Server XI R2. I have backups of the filestore and the CMS database, but I'm having a hell of a time restoring the MySql database. Any help in the process would really ber appreciated. Thanks

Thanks lbass, that works great. Can I throw one more at you. Now I need to find out the total dollar volume of those exceeding the yield. Can I do a running total? exp: mortgage 1 - $ 75000 mortgage 2 - $ 80000 mortgage 3 - $ 50000 result: $205000 hopefully i...

K, I'll list the content of the formulas below Overall Yield : {@annualized earnings}/{Mortgages.Principal} * 100 Portfolio Yield : Sum ({@annualized earnings})/Sum ({Mortgages.Principal})*100 Nested formulas are: Annualized Earnings : {@interest per year} + {@net fee annualized} Interest Per...

Hi guys, I'm working with Crystal Reports XIR2, and a SQL Server database. What I'm having isssues with, is summerizing a formula. I've done it in the past with no problems but I'm having a hell of a time doing it now. What I have is 2 formulas {@yield1} & {@yeild2}. What I need to find out...

Its a local server. This actually happens while I'm sitting on the server machine. Yea I've been trying to think of what might have changed, but nothing pops up. Thanks for help.

Anybody have any ideas as to why I might not be able to use/view my Java Admin Launch or Java Infoview pages? I keep getting a 502 error. I'm trying to figure out whether its my machine, javav version installed or Crystal. Any help would be awesome.

lbass, you're good. Thanks a ton.

Need some help on this one too. Here's what I've got. I need to find out what the next quarter date is after {maturitydate.field}. Example. my maturity date is Oct 26/07 what I need to find out is the next quarter ending date, which in my case would be Dec 31/07. And then calculate the...

Thanks lbass, I'll look into those functions again.

Hi Guys, I'm needing a calculation formula for compound interest on an investment. I need the future value of a 10,000 investment with an interest rate of 10% compounded quarterly. So here are my fields: rate investment compounded (this will...

Thanks lbass ill give this a try. ss

Hi guys, I need a little help if possible. I'm working on CR Server R2, on a sql database. Heres my problem. I need to capture a mortgage balance at a certain date, (actually a date that has a specific code associated) and then sum all transactions after that date. I need to be able to...

Wow you're good. Thanks a lot for the help lbass. Made my life easier. SS

Hi guys, I'm needing a little help. CRXI R2 user, on a sql database. I have a table with a number of transactions and transaction codes. I need to just display the lastest record with the certain transction code. I'll show an example. Row Trans date Code Amount 5...

Thats great thanks, ill give it a try.