crystal32.ocx was not found(after install cr)

hi to all
my name is giridaran
i have some problem with my crystal report 9
after finishing my crystal report installation i create report successfully but in visual basic crystal report control is missing. i have searched in components and win32 folder also but it was not fond.
i want immediate solution for this
thank youAs far as I know, there is not an ocx control in Crystal Reports 9, You should use RDC|||hi
i new userof crystal reports
i di\ont know about RDC
can you expalain for me
with regards
Giri

Crystal32.ocx - What version of Crystal comes with this?

I have Crystal 8.0, 9.0, 10.0 (Developer Edition). I don't want to use 10.0 as I much prefer the old method using the crystal report control (crystal32.ocx). Which version of Crystal Reports has this? Does it come with 8.0? I am pretty sure by the time 9.0 came out this was phased out. If it doesn't come with 8.0 does anyone know where I can get it or what version prior, it came with?Visit this site
www.businessobjects.com

Crystal XI forumla syntax

I am trying to write a formula for a report that sums up payments received, both positive and negative amounts.

The issue I am running into is that when I drop the appropriate field as a Summary into the report, it displays a blank field in the details section for each entry that would've appeared if I put that transaction amount field into the report.

Further, I cannot just hide the details and do things in a group section (I tried).

I was wondering if someone could help me with this, I am at my wits end. I can display more information about the fields themselves if necessary

On a similiar note, is there anyway to do a Where clause/command in Crystal formula?

ie sum({x}) where transactioncode = "x"On a similiar note, is there anyway to do a Where clause/command in Crystal formula?

ie sum({x}) where transactioncode = "x"

1. You can create a running total.
Select and add your 'Field to summarize', set the 'type of summaries'.
Evaluate it on the 'Use a formula', click x+2 buton and enter your formula:

transactioncode = "x"

Reset summaries as you need.
-------
or
-------
2. create a formula, kind of this one:

if transactioncode = "x" then {x} else 0

then summarize it

About the issue you have, can you post your formula and some example of your desired result, please?

Crystal vs Actuate reporting

Guys,

Could anyone tell me how Crystal is different from Actuate reporting? I am basically an Actuate report developer and wondering how flexible is Cystal reporting. My knowledge of Crystal is very limited (with ver 7) We are planning to move away from Actuate possibly to Crystal provided if it is flexible enough to do everything. How easy/difficult to do the following...

1. DB Connection: Can I Connect to different DBs? Read UserID/Password info from a text file or a table instead of defining in the report?
2. Drop-down parameters: Dynamically populating parameter values from DB into the Drop-down.
3. Can I control whats goes into the drop-down box based on the user role.
4. Generate reports where the data comes from multiple DBs.
5. Page-leve security
6. Drill-down reporting - Tree view
7. Dynamic Cross-Tab reports -
8. LDAP Integrating
9. Single Sign-on
10. Output in PDF/Excel
etc...

Please point out if these feature are available out of the box. I looked at the latest version features and it says we can do it all. I would like to hear from you what you think whats possible and what not with out much effort.

Thanks,
PSGuys,

I am very sure some of you have used not all but at least some of these tasks. I would appreciate it if you could respond to only those tasks and comment how easy/difficult to do for a beginner. Whats available out of the box. We can directly talk to sales guys but we do not think we get the correct picture unless you talk to people who is actually using the product.

Thanks a lot for your time.

PSsql

Crystal Viewer 8.5 with vb6

Any body help me that I want to use Crystal Report viewer 8.5 to explore the conditional report. For Example
Show data from date to date, or show data for particular code(s).
Yours cooperation in this regard is highly appreciable
Thanking yours.http://support.businessobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf

http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_21312684.html

Crystal V9 Range selection

Hi all,

I have installed SP3. whilst in the development environment, I have created a simple report that just lists everything from a single table. This works fine.

I then introduced a range parameter on one of my fields. then go to preview and enter a valid range, but the results still show all records???

Cant believe this is a enuine bug, as it's pretty fundemental. What am I doing wrong?What datatype it is? I tried with date range. It works fine.|||the field type is a character string and the database is an Access 2000 one.

The values are 2 characters like:

LA LB LC LD LE ......and so on.

when I enter a start of LB and and end LD for instane, it returns All|||check ur selection formula.|||I have now removed all parameter fields and will walk you through what I am doing.

I have the field explorer open and have right clicked on the parameter fields and selected new.

this displays a create parameter field dialog box I then enter a value in the name and propting text values leaving value type as string. I change options to range values then press the button set default values. I ensure that the table is correct and then set the browse field with the column from the table that I want to filter on. Then in the left hand pane it displays all values relating to that column. I press the >> button to make all values the default I then set the order to alphabetical ascending i then press ok. it goes back to the previous dialog and I leave allow editing of default values checked and press ok.

My parameter field now exists in the field explorer window under parameters. I drag this to the report header, and press preview I'm them prompted for a start and end of range which I enter, I then press ok, and then I'm returned all values.

???:confused:|||Everythings looks correct.

The last step is, you have to write the record selection formula.

Goto Report menu, select "SelectFourmula" and then "Record..."

This will opens the edit formula window.

Here select your database field and then give in condition which will be suitable for range values and then select ur parameter field.
This looks like

{table.column} in {?parameter}

now save and close this.

Refrsh the report|||Ah....thx the manual doesn't mention the last bit. It works now.

Crystal Using DAO

Hi,
Can Some Body Help ?

I was using Crystal Report 7.0, 8.0, 8.5 using CrystalReport control but when i started using 9.0 first of all my old DAO reports are not working, when i am trying to connect it is giving logon error. If i create new one it is ok but working with CRViewer which i do not need, there is a long code i have to write to make any report run, another problem there is no possibility/option of printer seledction like it was there in earlier versions.

Please Help Me.

Thanks in Advancehi, i m also facing problem with DAO can u help me pls.if got soln of urs query.i am just started to work on crystal report 8.5.

so can you?|||See if you are able to find solution here
www.businessobjects.com

Crystal Syntax Problem

I have created a Crystal Report with a section that needs to be suppressed when there is no data. I used an "if then else" statement using the basic syntax of Crystal on the suppress control option of a textbox.

The code is as follows:

if {GetData;1.Complaint} = "" then
formula = True
else
formula = false
end if

Most of the time it works just fine, however on occasion I get the following error:

Error in formula <Object_Visibility>.
if {GetData;1.Complaint} = "" then

Exception Target Site: []N

I am not sure what causes this error. As a note this Report is used in conjuction with Sql Server and a VB.NET application. Any help given is greatly appreciated.Make sure that the condition does not return null value|||It could return a null value. What can I do in the Crystal Report to account for that? Any help given is greatly appreciated.|||Try this

if {GetData;1.Complaint} = "" or isnull({GetData;1.Complaint}) = True then
formula = True
else
formula = false
end if|||It still gave me the same error. Not sure what to do. Any theories?sql

Crystal Subreports problem

I could use some help very badly with subreports. I am looking up Bill of Materials part numbers. I have a report that shows the Assembly_Part_Numbers, Component_Part_Numbers, and some other fields. Now, assemblies such as pc boards, cable assemblies, frame assemblies, etc., may comtain components, e.g. - (Component_Part_Numbers) which are themselves assemblies as well. They may be cable subassemblies, daughter boards, etc. If a Component_Part_Number also is listed in the Assembly_Part_Numbers then it is a sub-assembly. I need to be able to show the component parts of these separately, as well.

Now, on the main report I group by Assembly_Part_Number then sort the group by Component_Part_Number. This listing is perfect. But I am having a really hard time figuring out how to do the subreport, or drill-down report. I want the user to be able to click or double-click on a Component_Part_Number listed and, if it is a sub-assembly, display a subreport showing all the components of the sub-assembly. Also, I need to be able to print these out, as well.

Can anybody point me in the right direction? I tried it myself and came up with a very ugly report. I've been using Crystal for over eight years, but have never needed to do a subreport before.

Thanks,
Michael FoxHave you tried Hierarchical Grouping Options in Report menu? This will allow you to establish recursive relation by specifying Instance ID and Parent ID, so the entire tree structure of your assemblies will be displayed. I am not sure, however, if it is possible to actually drill-down into the tree. I tend to think it is not possible, and you would need some frontend application to catch user clicks and re-display the report with selected data.

Subreport is not your friend in this case, because subreport is not recursive (can't have one subreport inside another one).

Crystal sql caching?

I have been using Crystal Reports for some timw now, but in the last few weeks I have noticed that when I change the qry driving a report and update this on the server, Crystal Reports Viewer still accesses the previous version of the qry, even though this no longer exists. I have tried everything including rebooting, or running it from a different machine, but CRV still accesses the old qry. However, when I run the report outside of CRV, using the report directly, it runs the updated qry.

Has anyone seen this before?Shot in the dark. Is save data with report on in report options. Other thought is this report using a command ?

Crystal Show SQL Query Question

I had a database named X. I renamed it to Y.

My report is mapped to a view named viewX.

After I changed database names, and I choose Show SQL Query in crystal reports, my query from clause says

FROM X.DBO.VIEWX

I want it to say Y.DBO.VIEWX since i changed database names. Is there any easy way to do this. Or is it possible to just eliminate the DB name from the SQL from clause.

thanks,

deep.Open the Report and Do verify databasesql

Crystal Running Group Total equivilent in Report Services

I'm trying to use Reporting Services Developer edition with SQL Server 2000
and Visual Studio 2003. Net to create a report that already existed in
Crystal Reports 8.5 so that the report can be distributed via email and other
things that Report Services allows.
The Crystal Report uses something called a 'Running Total' field that
summarizes a field and evaluates a value for each chance of the field and
resets the value on the change of a group.
Who would you go about solving this problem in Report Services?
Thanks,
JimCheck out the RunningValue value function in BOL...
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> I'm trying to use Reporting Services Developer edition with SQL Server
> 2000
> and Visual Studio 2003. Net to create a report that already existed in
> Crystal Reports 8.5 so that the report can be distributed via email and
> other
> things that Report Services allows.
> The Crystal Report uses something called a 'Running Total' field that
> summarizes a field and evaluates a value for each chance of the field and
> resets the value on the change of a group.
> Who would you go about solving this problem in Report Services?
> Thanks,
> Jim|||What is BOL and how do you get access to it?
"Jim" wrote:
> Check out the RunningValue value function in BOL...
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> > I'm trying to use Reporting Services Developer edition with SQL Server
> > 2000
> > and Visual Studio 2003. Net to create a report that already existed in
> > Crystal Reports 8.5 so that the report can be distributed via email and
> > other
> > things that Report Services allows.
> >
> > The Crystal Report uses something called a 'Running Total' field that
> > summarizes a field and evaluates a value for each chance of the field and
> > resets the value on the change of a group.
> >
> > Who would you go about solving this problem in Report Services?
> >
> > Thanks,
> > Jim
>
>|||BOL is Reporting Services Books On Line.
You can also find them on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_1l6b.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:74ABD5D6-72D0-43E5-97C7-BD433A7F6876@.microsoft.com...
> What is BOL and how do you get access to it?
> "Jim" wrote:
> > Check out the RunningValue value function in BOL...
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:8DDF9D20-B55F-4DD1-8B69-937AD2ACD859@.microsoft.com...
> > > I'm trying to use Reporting Services Developer edition with SQL Server
> > > 2000
> > > and Visual Studio 2003. Net to create a report that already existed in
> > > Crystal Reports 8.5 so that the report can be distributed via email
and
> > > other
> > > things that Report Services allows.
> > >
> > > The Crystal Report uses something called a 'Running Total' field that
> > > summarizes a field and evaluates a value for each chance of the field
and
> > > resets the value on the change of a group.
> > >
> > > Who would you go about solving this problem in Report Services?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >

Crystal Reports+CPU Performance

Hi all
I am to actually integrate different sub reports into the main report.
I was able to solve the problem of linking the sub report parameter fields to the main report.This particular link of msdn helped me

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crtskinsertingsubreports.asp

I am linking the parameter field value of the main report to that of the sub report using the above method.
But my application's performance is going very slow..The cpu usage of the application is almost 100%.I think its because of the double reference that this happens.Reference I mean,the main reports parameters should link to the subreport and then print the data,I guess its this reason that makes the performance go poor.
Can anyone help mein giving any ideas of improving the CPU performance ?

Thanks in advance.How long does it take to print the data?

Crystal reports: passing DATA to main report

hey everyone:

I have a report with a number of subreports which basically contain ranking data with ranks stores in certain catagories. What I would like to be able to do is at the end of the report, take all of the store_ids that show up on the subreports, and total up their rankings for one aggregate score.

This involves sending data back from the subreports to the main reports, and I would need to pass both the store_id and ranking number.

Is there a way to accomplish this with the current report setup? The one idea I had is to use a shared array for each subreport, and at the end of the report I can handle each array, but that would involve looking for matching store id's, and since i am NOT a programmer, that would take me a long time to accomplish.

so if anyone has any simpler solutions, i would really appreciate it.

edit: Crystal reports 8.5, fwiwWhat is the difficulty you are facing with comparison?
Give more details

Crystal Reports: Displaying percentages of total qty?

I'm creating a .NET crystal report sales report that lists the total # of each item sold and the percentage of total sales that the item contributed towards however, before I can calculate the percentage for each row, I need to know the total qty of the report, which I don't know how to retrieve.

So a sample report of 500 items sold may look like this:
------------------
Category | Qty Sold | Percentage
------------------
Electronics | 200 | 40%
Books | 100 | 20%
Movies | 150 | 30%
Games | 50 | 10%
------------------
Total | 500 | 100%
------------------

How can I calculate a percentage for something like this?
Thanks.

-Goalie35http://forums.belution.com/en/crystal/000/061/54.shtml

Crystal Reports with VS2005

Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
Server even after closing the report and viewer? -On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> Server even after closing the report and viewer? -
I have not experienced that personally; however, if you are using
VS.NET, you may want to make sure that you are closing the database
connection, etc and destroying it in your application. Hope this
helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank you for the reply - we are doing that but it doesn't make any difference.
"EMartinez" wrote:
> On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > Server even after closing the report and viewer? -
>
> I have not experienced that personally; however, if you are using
> VS.NET, you may want to make sure that you are closing the database
> connection, etc and destroying it in your application. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 7, 6:30 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Thank you for the reply - we are doing that but it doesn't make any difference.
> "EMartinez" wrote:
> > On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> > <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > > Server even after closing the report and viewer? -
> > I have not experienced that personally; however, if you are using
> > VS.NET, you may want to make sure that you are closing the database
> > connection, etc and destroying it in your application. Hope this
> > helps.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
The only other thing that I can think of is that Crystal Reports is
holding the connection open. You can try calling 'sp_who' from the
application and searchnig for some Crystal Reports descriptor in the
resulting table and then use 'kill' to kill the appropriate
process(es); ofcourse, this could cause an error in the application,
if there is still a dependency on the process.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Yes - I think you are right - Crystal does appear to be holding the
connections open for some reason - I am running a web app written in VS2005
and the behaviour of crystal/sql server is different on different platforms /
installations of SQL Server.
Our production server seems to be managing the connections as expected
though - not sure if this is good or bad - as it could be something waiting
to catch me out later - Thanks for the reply
"EMartinez" wrote:
> On Mar 7, 6:30 am, David Whitt, MCSD, MCSD.NET
> <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > Thank you for the reply - we are doing that but it doesn't make any difference.
> >
> > "EMartinez" wrote:
> > > On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> > > <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > > > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > > > Server even after closing the report and viewer? -
> >
> > > I have not experienced that personally; however, if you are using
> > > VS.NET, you may want to make sure that you are closing the database
> > > connection, etc and destroying it in your application. Hope this
> > > helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> The only other thing that I can think of is that Crystal Reports is
> holding the connection open. You can try calling 'sp_who' from the
> application and searchnig for some Crystal Reports descriptor in the
> resulting table and then use 'kill' to kill the appropriate
> process(es); ofcourse, this could cause an error in the application,
> if there is still a dependency on the process.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||I've seen this extensively with SQL Server RS 2005 against SQL Server
2000 Relationally.
I reccomend bouncing the SQL Server services once a night; I think
that was a fashionable strategy back in the 90s; and I think that it's
still necessary
On Mar 7, 3:08 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> Server even after closing the report and viewer? -

Crystal reports with java

Hello all,
I am new with Crystal Reports.
I have strange problems.
I created report with parameters and run it from Tomcat.

When i use default parameters window - parameters value which i add don't affect on report result - it uses previous parameters.
If i use custome jsp and add parameters programmatically it's work.

When i try to perform "Search for text" with some text i get:
"ERROR Some parameters are missing values".
If i leave search control empty and perform "Search for text" all work fine - i get parameters window and after this i get report.

Thanks in advance, VitalyWhen assigning value to the parameter make sure you spelled the name correctly and send the proper data that matches to the parameter datatype

Crystal reports v9 parameter problems

I have a V9 Crystal report with 2 parameters. It runs fine when I run the report 'directly', however, when I use the same report as a subreport, I cannot pass the two parameters to the subreport -- it comes up blank wihtout an error. 1 parameter works fine, but 2 is a problem.

Any ideas?Did you link the subreport?
If you did, do the parameters between report and subreport have same
type of data?|||The report is not linked -- its imported. I will double check next week (I'm on vacation this week) but am pretty sure var types are matched.sql

Crystal Reports Syntax

I am not really a programmer but I am writing a report in CR XI and I am having syntax issues. I need some sort of operator after my 'then' statement (See code below) "Else" only works on the first line. I tried "And" or "Or" does not work. Can someone please help!!!!

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} IN 100 TO 199 Then 'Cash' - need function

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} IN 200 TO 299 Then 'Short Term Investments' need fuction

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} in 300 To 399 Then 'Account Receivables'

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} In 500 To 599 Then 'Fixed Assets'

If {REPORT_LINE.SECTION_NUMBER} = 1 and {REPORT_LINE.LINE_NUMBER} In 600 To 699 Then 'Long Term Investment'okay I figured it out, instead of using If.... Then statements there is a command call "switch" that you can use for all true values. My report is now done YEAH!!!!!|||u can also use :
If .... then

elseif ...... then

else

endif

crystal reports row count

bebe lush posted at 20-Sep-06 05:58
How can i add a column in the report to count the rows, and to auto increment.
Like:
1. | line 1
2. | line 2
3. |
to show me the current number.Friend,

Do one thing create one Formula Field named @.SlNo, and insert into detail section. Formula is given below:

//------------------

numberVar numSlno = 0;

IF PREVIOUSISNULL(<Name of Any Field>) THEN
numSlno := 1
ELSE
numSlno := numSlno + 1

//------------------|||why use formula
just include record number itself :wave:|||why use formula
just include record number itself :wave:
Thats correct way|||I tried this one but I got error at the part (<Name of Any Field>). I am a newbie, could you please elaborate on it? Thanks a lot!

Friend,

Do one thing create one Formula Field named @.SlNo, and insert into detail section. Formula is given below:

//------------------

numberVar numSlno = 0;

IF PREVIOUSISNULL(<Name of Any Field>) THEN
numSlno := 1
ELSE
numSlno := numSlno + 1

//------------------|||Well, that code has a bug anyway.
As said before, in the Field Explorer, just use the special field Record Number.|||as one of the repliers said,
the best way to me is to add a special field recordNumber.
OR you can also use a running total field.
In fields Explorer, Create new Running Total Field, Choose any of the fields (Preferably numeric) Summerize.
and select Count .
Allow it to execute for Each Record
One of these things should solve the problem.
The Last Solution i would suggest will be to use shared variables.|||as one of the repliers said,
the best way to me is to add a special field recordNumber.
OR you can also use a running total field.
In fields Explorer, Create new Running Total Field, Choose any of the fields (Preferably numeric) Summerize.
and select Count .
Allow it to execute for Each Record
One of these things should solve the problem.
The Last Solution i would suggest will be to use shared variables.

Why to make things complicated?

Just use Record Number field.