Do we have crystal32.ocx component in crystal 8.5 ? I have installed crystal 8.5, but my VB program complains that "crystal32.ocx" is missing. When i looked for this component on my machine, i found that it is not there.Hi,
Reinstall the crystal reports, In setup select custom option enable the all feature to install.
Thanks & Regards,
K.Babu
Do we have crystal32.ocx component in crystal 8.5 ? I have installed crystal 8.5, but my VB program complains that "crystal32.ocx" is missing. When i looked for this component on my machine, i found that it is not there.sql
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Sunday, March 25, 2012
Crystal With MSDE..>HELP!
I get "Unable to Open Database" when I try to run Crystal Reports with MSDE. Any ideas.
The reports work fine with SQL Server and MS Access.
Thanks in Advance.I'd need more information before I can offer advice.
How is security set up? Integrated, SQL Server?
Using OLEDB or ODBC?
What version of Crystal? MSDE? Are both on the same computer or is access across a network?
etc...|||Thanks for your reply,
I am using MSDE 1.0(SQL Server 7.0) and Crystal Reports Version 8.5. The application that runs the reports is on the same machine as the database for now. I am using ADO (MDAC 2.7) to connect to the database.
The reports are made off a MS Access Database (2000) and I change the driver at run time, as it checks for the database type that the application is running off of. I am using:
Crpe.Tables.ConvertDriver(pssql.dll)
function to convert the driver from Access to SQL Server.
Once I try to run the reports it gives me Crystal Report
[error 533:Unable to Open Database]
But once I run the same reports on MS SQL Server or MS Access Database it works fine or even once I run these reports off of MSDE running on XP Professional it still works fine.
This has become a real chanllenge. Any help would be appreciated.
THANKS IN ADVENCE. :)
The reports work fine with SQL Server and MS Access.
Thanks in Advance.I'd need more information before I can offer advice.
How is security set up? Integrated, SQL Server?
Using OLEDB or ODBC?
What version of Crystal? MSDE? Are both on the same computer or is access across a network?
etc...|||Thanks for your reply,
I am using MSDE 1.0(SQL Server 7.0) and Crystal Reports Version 8.5. The application that runs the reports is on the same machine as the database for now. I am using ADO (MDAC 2.7) to connect to the database.
The reports are made off a MS Access Database (2000) and I change the driver at run time, as it checks for the database type that the application is running off of. I am using:
Crpe.Tables.ConvertDriver(pssql.dll)
function to convert the driver from Access to SQL Server.
Once I try to run the reports it gives me Crystal Report
[error 533:Unable to Open Database]
But once I run the same reports on MS SQL Server or MS Access Database it works fine or even once I run these reports off of MSDE running on XP Professional it still works fine.
This has become a real chanllenge. Any help would be appreciated.
THANKS IN ADVENCE. :)
Crystal SQLQueryString
I am writing some code that analyses the 700+ Crystal reports we have within our business. I am aiming to have this code evalaute the data access code for each report. I have managed to determine whether the report is using a Command, Stored Procedure or Table access to obtain the data. However, when I am retrieving the SQLQueryString property of the Report I seem to be having an adverse affect on the msdb database on our SQL Server. It appears to be causing some locking issues. Is there any other method of obtaining the SQL Command code from the Crystal Objects?In your Front End application, check if there is any property to get query
Something like
CR.GetQuery
Something like
CR.GetQuery
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 ?
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 Server logon error - Urgent.
Hello,
Can anybody please help me or point me in the right direction here.
The ongoing problem is that I have uploaded my reports to the crystal server at work. Everytime I try to view a report, it tells me I have a logon error as follows, "The database logon information for this report is either incomplete or incorrect." I have tried to make a new report with a new sql database connection on the server at work - I still get the same error message.
The ODBC settings are exactly the same as my own server at home. I have the same username and password as well. I can view the reports at home without any problems. But can't view them from the work server.
If I view the reports through a JDBC connection I can view the reports on the server at work. But if I change the connection to ODBC, no report can be viewed. I can view the same reports on my home server regardless of what type of connection it is, ODBC or JDBC.
For the life of me, I just can't seem to figure out the root of the problem? Please help me.
Best regards
SafIf you don't mind my asking, have you figured out your database logon problem?. We occasionally have the same problem, and still don't know why it happens.|||See if you find solution here
www.businessobjects.com
Can anybody please help me or point me in the right direction here.
The ongoing problem is that I have uploaded my reports to the crystal server at work. Everytime I try to view a report, it tells me I have a logon error as follows, "The database logon information for this report is either incomplete or incorrect." I have tried to make a new report with a new sql database connection on the server at work - I still get the same error message.
The ODBC settings are exactly the same as my own server at home. I have the same username and password as well. I can view the reports at home without any problems. But can't view them from the work server.
If I view the reports through a JDBC connection I can view the reports on the server at work. But if I change the connection to ODBC, no report can be viewed. I can view the same reports on my home server regardless of what type of connection it is, ODBC or JDBC.
For the life of me, I just can't seem to figure out the root of the problem? Please help me.
Best regards
SafIf you don't mind my asking, have you figured out your database logon problem?. We occasionally have the same problem, and still don't know why it happens.|||See if you find solution here
www.businessobjects.com
Crystal Rpt 10 - currentdate + 6 months
Hey all I am trying to use Crystal Reports 10 and have a date that I need to use from my table. I want to take that date and if it is greater than the CURRENTDATE + 6 months I need to display a message. I have part of it but not sure how to do the "6 month" thing.
if ({mytable.mydate}) > CurrentDate ("+6 months") then
'Length-Promo-Rate = 0'
I have tried this:
CurrentDate + Month({mytable.mydate},6) but it doesn't like it. Suggestions? Thanks.Hi,
for that you have to insert a formula field like :
dim msg as string
if {Report Date/date from table} >= DateAdd ("m",6 , CurrentDate) then
msg ="6 month old"
else
msg = "new"
end if
formula = msg
-Jayesh Mendpara
if ({mytable.mydate}) > CurrentDate ("+6 months") then
'Length-Promo-Rate = 0'
I have tried this:
CurrentDate + Month({mytable.mydate},6) but it doesn't like it. Suggestions? Thanks.Hi,
for that you have to insert a formula field like :
dim msg as string
if {Report Date/date from table} >= DateAdd ("m",6 , CurrentDate) then
msg ="6 month old"
else
msg = "new"
end if
formula = msg
-Jayesh Mendpara
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?
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_oracle
Can we execute/Run crystal reports with PL/SQL code in Oracle?yes u can use oracle stored procedures ,using ref cursors to report.|||shareem Thnks for reply,
but my question is can we run crystal reports in pl/sql code. instead of schedule to run crystal reports|||Why do you want to run CR from ORACLE?sql
but my question is can we run crystal reports in pl/sql code. instead of schedule to run crystal reports|||Why do you want to run CR from ORACLE?sql
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
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
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 XI with ascii file
hello CR users,
i'am nearly completely new in the CR field, so sorry for my question...
i have a big ascii file about 300mb. how can i use this file within CR?
is there any way to convert this ascii file into a excel file ore wathever so i can use it.
smaller pieces of this file i can convert into a 'comma separately' csv file.
but there is no well formatet column separation...
i would be very happy if there is somebody out there how wuold post a short solution for this...
thanks HagenSo do you want to show the Ascii values in the report?
i'am nearly completely new in the CR field, so sorry for my question...
i have a big ascii file about 300mb. how can i use this file within CR?
is there any way to convert this ascii file into a excel file ore wathever so i can use it.
smaller pieces of this file i can convert into a 'comma separately' csv file.
but there is no well formatet column separation...
i would be very happy if there is somebody out there how wuold post a short solution for this...
thanks HagenSo do you want to show the Ascii values in the report?
crystal reports XI and VBA
Hi folks..
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"
CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub
************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..
Could you any one solve this problem..
i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...
Thanks in advance
salaiTry to reinstall CR X1 and see what happens
I am using crystal reports created in version XI with Excel(VBA).
i have the following code to display the report..
********************
Private Sub CommandButton2_Click()
Dim rep As New CrystalReport
rep.ReportFileName = "c:\apcg\test\report1.rpt"
CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub
************
But i am facing an error
Runtime error:430 - Class does not support Automation or does not support expected interface..
Could you any one solve this problem..
i knew that the problem is with CRViewer.dll
when i tried to register that file, it failed..
also i am getting an error "Error accessing Registry" when i click references in VB project menu...
Thanks in advance
salaiTry to reinstall CR X1 and see what happens
Crystal Reports XI and Sql Server
Hello everyone,
I am new to crystal reports. Ive been through some of the sample reports and have been learning. All of the samples use the Extreme Database that comes with Crystal Reports. Now I want to practice connecting to my SQL Server database but I havnt been able to figure that out. In the database expert there is every possible database type from MS Access to Oracle, DB2, Informix, Sybase.whatever, but there is no way I have found to connect to an SQL Server directly. The only way I have been able to connect is by creating a DSN for my SQL Server Database and connecting via DSN. Even though I have set my DSN to use integrated security, Im still prompted to enter a user name and password when I refresh the report. The report initially opens without prompting for user name and password.
Has SQL Server been completely left out of the loop in Crystal Reports? Can anyone let me know how to connect to SQL Server directly?
Thanks
GEMCreating the DSN is the way to go. I started by adding an ODBC connection, and adding a system connection, CR will prompt you for a password unless you embed it into the report. (If you embed the password, others with CR may be able to see it) I created a ODBC DSN on my computer, and a matching one (Name Case must match) on my SQL box. ivr_report is the DSN name in this case. Then, open CR, add a ODBC (RDO) connection, select your DSN from the list, (In this case ivr_report), once you have the connection, you can select your tables or views. Hope this helps.sql
I am new to crystal reports. Ive been through some of the sample reports and have been learning. All of the samples use the Extreme Database that comes with Crystal Reports. Now I want to practice connecting to my SQL Server database but I havnt been able to figure that out. In the database expert there is every possible database type from MS Access to Oracle, DB2, Informix, Sybase.whatever, but there is no way I have found to connect to an SQL Server directly. The only way I have been able to connect is by creating a DSN for my SQL Server Database and connecting via DSN. Even though I have set my DSN to use integrated security, Im still prompted to enter a user name and password when I refresh the report. The report initially opens without prompting for user name and password.
Has SQL Server been completely left out of the loop in Crystal Reports? Can anyone let me know how to connect to SQL Server directly?
Thanks
GEMCreating the DSN is the way to go. I started by adding an ODBC connection, and adding a system connection, CR will prompt you for a password unless you embed it into the report. (If you embed the password, others with CR may be able to see it) I created a ODBC DSN on my computer, and a matching one (Name Case must match) on my SQL box. ivr_report is the DSN name in this case. Then, open CR, add a ODBC (RDO) connection, select your DSN from the list, (In this case ivr_report), once you have the connection, you can select your tables or views. Hope this helps.sql
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? -
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
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 Viewer [2003]
Hello,
I have a load of crystal reports which have been created previously, and what I'd like to do is print / preview these from my VB.NET application.
Ideally I'd want a form in VB which will list all of the crystal reports in a particular location on my hard drive. Then I'd like to be able to click onto the reports and print / preview them in the Crystal Viewer.
I have found something called Crystal Reports Viewer on the toolbox, but I can only seem to link 1 report to that.
Can anyone help me with this please, or point me in the direction of some documentation which will help me do this?
Thanks,
J.use filedialogbox and set default path to ur local hard drive folder.
whattever file user selects map it to, reportsourse property of crystalreportviewer.
I have a load of crystal reports which have been created previously, and what I'd like to do is print / preview these from my VB.NET application.
Ideally I'd want a form in VB which will list all of the crystal reports in a particular location on my hard drive. Then I'd like to be able to click onto the reports and print / preview them in the Crystal Viewer.
I have found something called Crystal Reports Viewer on the toolbox, but I can only seem to link 1 report to that.
Can anyone help me with this please, or point me in the direction of some documentation which will help me do this?
Thanks,
J.use filedialogbox and set default path to ur local hard drive folder.
whattever file user selects map it to, reportsourse property of crystalreportviewer.
Crystal Reports Version Selection
I have ten users who need to access a single server operating crystal. Currently looking at around 200 reports max being generated (not per day). I was wondering what the latest version available to me would be suitable which can manage atleast 10 concurrently. Also does MSDE come with it and is it sufficient to handle this small solution. Have searched the net but not exactly sure what Im looking for.
CheersSearch here
http://support.businessobjects.com/
CheersSearch here
http://support.businessobjects.com/
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
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 using .net objects
hi
I am using VS 2005 c#.net, in that crystal reports 10.
In my requirements i have to bind the databse with two data base objests.
With using one object i am able to get that data.
CrystalReport2 cryst = new CrystalReport2();
cryst.SetDataSource(cand.GetGeneralInfo());
crystalReportViewer1.ReportSource = cryst;
this GetGeneralInfo() method is of type list.
I am binding that list to my report.
Thanks
Raghudo you want to get data from two different servers?
I am using VS 2005 c#.net, in that crystal reports 10.
In my requirements i have to bind the databse with two data base objests.
With using one object i am able to get that data.
CrystalReport2 cryst = new CrystalReport2();
cryst.SetDataSource(cand.GetGeneralInfo());
crystalReportViewer1.ReportSource = cryst;
this GetGeneralInfo() method is of type list.
I am binding that list to my report.
Thanks
Raghudo you want to get data from two different servers?
Crystal reports to SQL Server Reports
Hi
Present we are using Crystal reports 9.0 in application.
we like to convert crystal reports to SQL server reports.
Do we need to rewrite all crystal reports into SQl reports again
Would you appreciate if any one give suggestion for hot toconverting
crystal reports to SQL Server Reports .
Regards
VenuI do not know of a conversion tool. We just went through same and re-wrote
our reports. It was fun! RS is a powerful reporting tool and out-classes
crystal.
good luck
--
U. Tokklas
"venu gopal" wrote:
> Hi
> Present we are using Crystal reports 9.0 in application.
> we like to convert crystal reports to SQL server reports.
> Do we need to rewrite all crystal reports into SQl reports again
> Would you appreciate if any one give suggestion for hot toconverting
> crystal reports to SQL Server Reports .
> Regards
> Venu
Present we are using Crystal reports 9.0 in application.
we like to convert crystal reports to SQL server reports.
Do we need to rewrite all crystal reports into SQl reports again
Would you appreciate if any one give suggestion for hot toconverting
crystal reports to SQL Server Reports .
Regards
VenuI do not know of a conversion tool. We just went through same and re-wrote
our reports. It was fun! RS is a powerful reporting tool and out-classes
crystal.
good luck
--
U. Tokklas
"venu gopal" wrote:
> Hi
> Present we are using Crystal reports 9.0 in application.
> we like to convert crystal reports to SQL server reports.
> Do we need to rewrite all crystal reports into SQl reports again
> Would you appreciate if any one give suggestion for hot toconverting
> crystal reports to SQL Server Reports .
> Regards
> Venu
Subscribe to:
Posts (Atom)