DR for Crystal Enterprise and Business Objects

Have to build DR solution and subj is a part of it.

Maybe some one has done it already… share the experience please.

Dr in my case will between 2 different data centers, replication is san 2 san so on other side I have a warm standby that does not see san disks and will become active if and only if the primary data center is down, windows domain is the same, ip addresses, names of the servers are different. How a cluster will behave is interesting as well (I mean CE is on cluster, not geo distributed cluster).

I have CE90. I’m talking to their tech support that seems to be outsourced, they didn’t really produce in 5 days anything more then a part of their own documentation in pdf format for CE version I do not use J…

So I’m wondering maybe somebody had to walk similar path already…

I see you were already involved on the previous thread that discussed some of the general considerations for such SAN replication (it was titled SAN Replication and is at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=465113&SiteID=1). Unfortunately I'm not aware of any specific considerations for CE.

doubt in crystal report(help needed Urgently)

hai

I have one doubt in crystal report.I am using crystal report 7 version.I added a databse to report and i connected that report with visual basic and my report is working.Except that i cant refresh my report at runtime and so it displays the same values repeatedly.

I cant use crystal report 8 or 9 or 10.

Help needed urgently

Bye
Ramyafrom file menu of crystal report , uncheck the option of 'Save Data with Report', then save the file and try .|||hai

i have one doubt i am using crystal report from visual basic and not directly from crstal report.

That is i added report at project itself and so where to change that option

Bye
Ramya

Dont know how to stop the duplication

Hi, Im still quite new to Crystal, and cant quite get my head around this one.. I'm using CR9

Ive attached a sample report to help demonstrate the problem.

I have three tables using the following fields:

Customers Tbl: DOB, Address 1, Address 2, Address 3, City + Postcode.

Folder Items Tbl: Voucher No, Tvl Date, Code, Client Name, Client Paid, Redeem Date.

Credit Card Tbl: Card Type, Card No.

Im trying to establish how many vouchers this client has ordered. On the example shown hes actually ordered 3 vouchers, but because he has two different credit cards listed in his profile, each item is duplicated, so it looks like hes made 6 orders.

If the card type equals DC, then we need to show what the card number is. If its any other card type, then we just show the two letter card code, and no other info. Which works fine when theres only one card in the profile.

I need to somehow say if there are two cards present only show the first one, and always select card type DC if there are two or more different types

Does anyone have any ideas? At the moment, I'm exporting the data into excell so I can delete the duplicates before submitting them, but the reports is getting bigger each week, and it's going to get out of hand very soon.

Thanks
LisaIn your Crystal query, use Distinct Keyword

Select Distinct columns from yourTable