DR For Crystal Enterprise And Business Objects
Jun 12, 2006
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€¦
View 1 Replies
ADVERTISEMENT
Feb 28, 2008
Ok, probibly an easy question but I haven't been able to find what I am looking for.
If I have a simple class (see below), how would I make the People List avalible to build a report off of?
Thanks
asdf46
Code Snippetpublic class Person
{
public string FirstName { get; set;}
public string LastName { get; set;}
}
// and put them into a list
List <Person> People = new List<Person>();
People.Add(new Person () { FirstName = "Joe", LastName = "User"});
People.Add(new Person () { FirstName = "Jane", LastName = "Smith"});
View 3 Replies
View Related
Mar 23, 2000
We have a user who uses Business Objects to run queries on the database. They are reporting that the query can lock the database up and that they were told at a conference that there is a setting which can aleviate this problem, but they are not sure if it is in SQL Server or Business Objects.
Anyone got any idea what they are talking about?
Colin.
View 1 Replies
View Related
Apr 3, 2007
We have decided to use business objects in our new application, which seems to be working well, since they can be used as a binding source for grids, etc.
I am trying to evaluate whether SSIS is a practical solution for our ETL requirements. The problem is, I can't find any examples or references, or even the slightest hint that anyone is using them with business objects. Any attempts to search yield a ton of results which are based on a commercial product called "Business Objects" rather than the design pattern.
It is currently a requirement of our development team that all data access must be done via business objects, rather than communicating directly with the database.
Can anyone provide some more information (besides just suggesting I write a custom connection manager)? Is there anyone who has actually made SSIS work with business objects?
Thanks, Richard
View 9 Replies
View Related
Jul 20, 2005
Hi,I am evaluating Microsoft Reporting Services against Business Objectsas a reporting tool against SQL Server. I am primarily a BOBJdeveloper and am finding RS not easy to use. Can anyone provide anyfeedback to the overall comparison between these 2 products as I amfinding RS frustrating and am wondering if it is just a matter ofre-adjusting and spending more time on it or if anyone else is findingRS more trickey to use than BOBJ as wellI would be extremely grateful for any feedback.Many thanks in advanceLA
View 1 Replies
View Related
Apr 2, 2008
I was wondering if it is possible to use a generic list object to use as the datasource/data for a report? Right now we use these business objects to display information on our website and would be great it we could re-use those objects and create reports based on them. We are doing some calculations etc in the business layer to build these objects, so if we could re-use, that would be best.
Thanks!
View 2 Replies
View Related
Oct 27, 2007
Hi,
Is there any one knows how to fix this, please help! This is urgent.
In the configuration checking, there was only one warning message about operation system (this warning should be ignored according to some advice). When coming to the Component checkboxes, there is only one checkboxe checkable at the last item.
Thanks!
View 6 Replies
View Related
Oct 23, 2007
Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?
I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.
Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.
Thank you
View 1 Replies
View Related
Jun 10, 2006
Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?
I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.
Has anyone tried this?
Can someone walk me through the process?
Thanks
Debbie
View 1 Replies
View Related
Dec 27, 2006
please help newbieI need to create a lot of objects the same type (let's say: schemas)I wish to use paramerized block in loop to do so.- how to put names of my objects to such control-flow?belss you for help
View 5 Replies
View Related
Nov 20, 2013
passing serialised objects to a stored procedure for the purpose of data inserts. I see this as being a way to handle multiple row inserts efficiently.
However, in my limited use of XML data I am not so sure how to link the data when I have a dependency on another "object" within the serialised XML.
Below is a code snippet showing what I have so far.
The first insert statement works fine - but how to retrieve the identifier created by the DB - I want to use an SQL statement that finds the record in the table based on the XML representation (of the PluginInfo), allowing me to insert the ConfigurationInfo with the correct reference to the PluginInfo
DECLARE @Config NVARCHAR(MAX)
DECLARE @Handle AS INT
DECLARE @TransactionCount AS INT
SELECT @Config = '
<ConfigurationDirectory >
<ConfigurationInfo groupKey="Notifications" sectionKey="App.Customization.PluginInfo"
[code]....
View 1 Replies
View Related
Jul 11, 2006
This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?
View 3 Replies
View Related
May 3, 2001
A long shot but someone may have experienced same problem. We are using Crystal Info to run reports against a SQL 7 database. Reports that usually take 1 or 2 minutes to run are taking up to 15 minutes to run. The database is fine ie you run the query through the query analyser and it runs in 1 or 2 minutes. Any ideas... I've spoken to Seagate but not making much progress.
Thanks in advance..
View 1 Replies
View Related
Sep 6, 2000
Can any one tell me where can I find good online help for Crystal Reports for learning?
Thanks!
View 1 Replies
View Related
Feb 2, 2007
I just started using Crystal, and I have to say, its a pain in the arse.
Can I just run a simple SQL query and get the results I want, without having to use Crystal Syntax?
Here is the query I want to use:
Code:
select * from esmpvald, esmprmtr
where esmpvald.permit_id = esmprmtr.permit_id and
esmprmtr.issue_date >= ('01/01/06') and
esmprmtr.issue_date <= ('12/31/06') and
esmprmtr.permit_id in (select esmvardd.permit_id
from esmvardd, esmudfvr
where esmvardd.var_fld_id = esmudfvr.var_fld_id and
esmvardd.permit_id in
(select esmvardd.permit_id from esmvardd, esmudfvr where esmvardd.var_fld_id = esmudfvr.var_fld_id and
(esmvardd.var_fld_value = 'a') and
(esmudfvr.var_fld_name = 'Commercial Type')) and 1=1)
I will be looping through the "esmvardd.var_fld_value = 'a'" part, going a through f, but for now, I just want to start with the 'a'.
I could do this manually, and throw it in a Word doc, but I'm trying learn this thing. Ideas?
View 1 Replies
View Related
Apr 19, 2006
I am working on creating Crystal Reports from a SQL database.
In CR you can define a multiple range parameter i.e. 1-10, 100-200, 300-400 and Cr will filer records that satisfy this criteria.
How can I transfer this functionality using a stored procedure?
View 1 Replies
View Related
Mar 6, 2006
Hi,
I am new to crystal reports.
I need to change the database connection in the reports to different sql server database and use the same report layout.
Any help is appreciated.
View 4 Replies
View Related
Mar 20, 2007
I'm new to SQL but have quite happily been using Crystal Reports without it until now.
I am creating a letter template and it has the name at the top then the address
<name>
<address1>
<address2>
<address3>
<address4>
There is always an address 1, but maybe not a 3 or a 4, and aparently we dont want any line gaps to show, so I figured i should use an isnull to eliminate the line and to move the other address line up?
Not sure what to put though, any ideas?
Thanks in advance for any help :o)
View 2 Replies
View Related
Sep 27, 2007
THE TIME PORTION OF THE DATE/TIME IS NOT DISPLAYING IN CRYSTAL 8.5
IT SEES THE DATE...BUT NOT THE TIME
ANY SUGGESTIONS
View 3 Replies
View Related
Jan 24, 2008
ive come from a crystal background and im having difficulty writing reports.
An example of the problem im having is with saved formulas (crystal calls them formulas)
eg
i would create a forumula called Difference
it would be something like this
=DateDiff("d",Field1, Field2) save that and then it was stored
then in a text box i would reference it like so.
=iif( Difference <= 23,"Too New","Just Right")
is this possible in RS??? as i have reports i need to convert from crystal to RS, and the iif statements are becoming huge, especially when you reference the same formula in the expression multiple times.
bit long winded i know, and i hope this makes sense, but i am witts end with this issue
thanks in advance
Jonny
View 3 Replies
View Related
May 17, 2007
Hi,
I have a question. How can i fill a report made in CrystalReports in .net
Thanks in advance
View 1 Replies
View Related
Aug 10, 2007
I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?
Thanks,
Kathy
View 9 Replies
View Related
Mar 14, 2008
what are the good resources for crystal reports.
Also is it something which is difficult to work with ? Suggestion, experiences and notes please.
View 4 Replies
View Related
Apr 26, 2002
Hi,
I am trying to run the crystal report from asp.
its says SQL Server connection failed. But i could connect SQL server using the same DSN. Any idea???
Set crp = Server.CreateObject("Crystal.CRPE.Application")
iReturn = crp.LogOnServer("p2sodbc.dll", "DSNNAME","USERID","PASSWORD")
Set oRep = crp.OpenReport("C:inetpubwwwrootpdftestest.rpt")
oRep.Preview
Set crp = nothing
Thanks
Ilango
View 1 Replies
View Related
May 27, 1999
hey folks...
i am new to store procedures, crystal and sql server... ..one heck of a combination..yikes....neways.... writing a stored procedure in 6.5 to run a crystal report 7.0... want to create an output variable in the procedure that the report will see as a field... can i do this...and if so how....
any and all help muchos gracious.... the higher ups just don't get why i can't do all in 10 days of learning sp's on my own.... egads... management
:-)
take care.....kim
View 2 Replies
View Related
Jan 12, 2004
Does Crystal Report 8.5 work OK with SQL Server 2K ?
Anyone encoutered problems for with this couple of programs ?
View 3 Replies
View Related
Feb 2, 2006
Hi,
I'm very new to SQL Server, I'm coming from an Oracle background.
I've set up a server with windows authentication but I'm having no luck connectiong to it with Crystal Reports XI.
Can anybody go through the basics with me?
Regards
Sean
View 6 Replies
View Related
Sep 27, 2007
How can I convert a crystal report to a pdf format.ASP.net is not loaded in my machine.pls help me...
View 3 Replies
View Related
Jul 23, 2005
Hi,I'm semi-new to crystal reports & sql server and what i want is toextract data from a sql server file. I've been able to connect to sqlserver directly and get the info. i need but is there a way to just openthe data file (in crystal reports) without making a server connection?TIA
View 1 Replies
View Related
Jul 23, 2005
Has anyone had any luck getting Crystal Reports 8.5 to work with theSql Server 2000?I keep getting a "Unable to open Database" error. I've tried openingwith either the .Connect property and the LogOnServer method and getthe same message from either approach.I am using the OCX control.Does this version work with Ms Sql?Any thoughts and suggestions would be most appreciated.Thanks.-Dave
View 4 Replies
View Related
Jul 23, 2005
I exported a column of type float to SQL Server using DTS. In Crystalreports, it 'sees' the column as a string! Is 'float' the best type touse? Must I create a formula field in CR to 'correct' for this?
View 3 Replies
View Related
Jul 23, 2005
I am formating text by adding a hyperlink that looks like this:"https://IQuoteSummary.asp?vid=" & {v_L.VersionId}&"&lid=" &{Locations.LocationId}Both database fields are type numberThe url enters the address:"https://IQuoteSummary.asp?vid=1,521.00&lid=12.00"It works when I run the report in crystal but after publishing it onthe crystal publishing wizard thing, I get those weird numbers.I need these numbers as ints and without a comma. I tried changing theformatting on the database fields on the report but that doesn't work.Any idea how to get the url to print like this:"https://IQuoteSummary.asp?vid=1521&lid=12"Thanks
View 1 Replies
View Related
Aug 9, 2007
Hi James,
I need some help from you on solving a problem in Crystal to SSRS conversion.
I am trying to convert a Crystal Report to an SSRS Report.In the Crystal Report the Data is filtered using a Parameter which can accept Multiple Range Values.In order to achieve the same feature in SSRS I wrote a small Custom Code in VB.
This Function will accept the Field and the Parameter as Strings with multiple ranges separated by commas and will return a Boolean True if the field satisfies any one of the given ranges.Otherwise it will pass a Boolean false.
So only the Rows with True as return value are passed forward.
I used the above condition in the filter clause of the Datasets not in the where clause unlike Crystal.Now I face a new Problem. In the Crystal report there are 3 Groups and the Crystal Query has an Order by clause on these 3 Groups.
So In crystal after the where clause the Sorting is taking place.
Now I tried to do the same in SSRS and implemented the Order By clause in the SSRS Query.But the outputs are not matching.
One reason may be that ,In Crystal the Sorting of data in groups is done after filtering but in SSRS Sorting is done before the filtering.
Is there an alternative or any work around that you can suggest me to get the same as of Crystal.
Please help me.
View 1 Replies
View Related
