DB/Reporting :: Seagate Crystal Report?
Nov 27, 2008I have installed Seagate Crystal Report 8 to design reports for a database in Microsoft Access 2003. I have linked that database to Visual Basic 6.0 interfaces through ADODC coding.
View 3 Replies
ADVERTISEMENT
DB/Reporting :: Crystal Report And MySQL
Jan 22, 2009This is my current code.
Code:
Set rs = cn.Execute("SELECT * FROM customer WHERE VsVslNo LIKE 'V16'")
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
[CODE]...
DB/Reporting :: Login For Crystal Report?
Dec 20, 2011I have an applciation in VB.NET but when I try to produce the reports a popup message appears requiring login information.
I have attache the print screen of the popup message.
DB/Reporting :: Sub Section In The Crystal Report?
Dec 6, 2010My stored procedure return 2 set of data.Select * from customersSelect * from productsnow on the report, I can see all the fields of table customers and products in the "Field xplorer".How can I display all the data in the table customers first, then display the products right after?
View 2 RepliesDB/Reporting :: Use SQL Statement In Crystal Report?
Feb 11, 2008i would like to ask if how can i call this SQL statement in my crystal report. im using Crystal Report 10.
Code:SELECT IF(out_balnce < 0, CONCAT(""("", FORMAT(ABS(out_balnce),2) ,"")""), FORMAT(out_balnce,2)) AS OutBalance, IF(acct_side < 1, CONCAT(""("", FORMAT(tran_amnt,2) ,"")""), FORMAT(tran_amnt,2)) AS TransAmount, user_code FROM LedgerHistory WHERE srvc_nmbr = '12345678' ORDER BY srce_date desc how can i place TransAmount and OutBalance in crystal report?
DB/Reporting :: Creating Crystal Report From Two Tables?
Dec 20, 2011I am trying to load a crystal report from two tables but it seems that is not working.Here is the code to load the crystal report:
Code:
Private Sub InvoiceLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]......
DB/Reporting :: Creating Reports Without Crystal Report?
Mar 2, 2010I am using VS 2008 standard edition to develop my first windows form application and it does not come with crystal components. I nedd to design few reports but I can't find any help on the net. In my vba application I create one form which accepts all parameters and based on parameter I build SQL statement and pass it to report data source. I would like to similar in vb.net, but all I see is cryatal. Can I create reports without Crystal?
View 1 RepliesDB/Reporting :: Crystal Report Shows NO Data?
May 20, 2008I made a simple CR using the wizard.I display it with the CR viewer.I can see the report and the labels but no data.
View 14 RepliesDB/Reporting :: Listing SQL Statement In Crystal Report
Feb 20, 2008How do I list the SQL statement in my crystal report. I have the report loaded etc using
Dim DA As New SqlDataAdapter
Dim DS1 As New DataSet
DA.SelectCommand = New SqlCommand(gSQL, SQLConn)
DA.Fill(DS1, "JobID")
Dim CR1 As New ShowFiles
cr1.Load(gActiveReport)
cr1.SetDataSource(DS1.Tables("JobID"))
CRV1.ReportSource = cr1
This shows my report But how do I reference the SQL Statement, I can see in in report design but cant find it in the loaded report
DB/Reporting :: Print In Crystal Report Viewer?
Feb 16, 2004may i use shortcut key like Ctrl+P to print the report in Crystal Report Viewer?
View 2 RepliesDB / Reporting - Duplex Crystal Report, Portrait And Landscape
Feb 22, 2011Using VB2008 Crystal reports. We are busy to create a duplex crystal report, size A4. The front of the CR is a portrait view and the backside must a landscape view. In our project we have made two CRs, one portrait and one landscape. Till now two pieces of paper are printed. Can someone give us more information how to configure CR?
View 5 RepliesDB/Reporting :: Crystal Report That Fails On A Formula Field?
Apr 14, 2008I have a crystal report that fails on a formula field but I cannot see why.
Here is my code:
Code:
Public Function CreateReportPDF(ByVal dsReport As DataSet, ByVal CrystalReportPath As String, _
ByVal reportSize As String, ByVal landScape As Boolean, _
ByVal dsParameters As DataSet, ByVal filePath As String, _
ByVal fileName As String) As Boolean
[Code]...
DB/Reporting :: Dynamic Crystal Report Including Parameter Value
Jan 16, 2009This for a semi-automated application. Basically the user provides a list of parameters (entered as an offline spreadsheet). The application automatically selects the required report and logon information. Each line in the given spreadsheet will be used as parameter values for a certain report.Therefore the requirements for this (vb.net) applicaton include:
- dynamically select a different Crystal reports
- each report may read data from different tables from an Oracle database.
An old application of mine that had done something similar and it works normally. Those Crystal reports retrieve data from a SQL server stored procedure. (The stored procedure reads data from Oracle using linked server concept). I do not have to set the logon information dynamically in the vb.net code because every report uses Trusted Windows logon concept. The application can also pass dynamic values to different Crystal report parameters without problems.Then I modify this old application for the required new set of Crystal reports. Because these reports access Oracle database via ODBC and not every report reads from the same Oracle schema, it appears I have to write codes to pass ODBC Dataset and its logon information (the users do not want enter it everytime). The application does not run after the change. The report printout shows blank. Although I can accomplish what is needed by modifying each report to use Stored procedure. But this is not prefered and not a simple task because of the number of reports.I have tested each report and it does run normally in interactive mode.I am not sure if I need to write codes to set the datasource for these 'new' Crystal reports. In my test codes I set the reportsource for my CrystalReportViewer object to an non-typed report. Is there anyone who can show me sample codes that
1) achieve odbc logon
2) select a report dynamically for preview/printing
3) pass values to parameter
Reporting - Introduce My Bank To Crystal Report As Datasets
Jan 4, 2012I have a problem with Reporting
1)i introduce my bank to Crystal Report as Datasets
Describing :
1)when i introduce my bank to my project then i make a blank Reporting and i choose project data>Ado.nets >datasets then i choose my datasets
2) i design my reporting and but i cant use it in my project...
Attached image(s)
DB/Reporting :: Difference Between Microsoft Report Viewer And Crystal Report Viewer
Dec 28, 2008These things look about the same to me. Is there any reason I should use one over the other?
View 5 RepliesDB/Reporting :: How To Connect 'crystal Report' With Mysql Database Table
Apr 28, 2010i am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
DB/Reporting :: *** Cant Change ServerName Or DatabaseName At Runtime In Crystal Report?
Dec 22, 2008trying to simply change the Server Name for a Crystal Report at runtime and it will not let me. Herthe code below. The database is identical to my development server database. I use SQL Server 2005(SPK 2) and Visual Basic 2008. I use Crystal Reports 2008. When I run the code it accepts changes to the user name and password but igmores any change to the ServerName or DatabaseName
View 5 RepliesDB/Reporting :: Crystal Report 2005 Filling In Static Information?
Mar 19, 2009Trying to fill a crystal report we want to fill in calculated information. Can someone tell us how to put information in a text field in the report?
Or is there an other possibillity to place static information on the report?
DB/Reporting :: Export The Current Record To Crystal Report Which In Turns Converts It To A PDF File?
Aug 19, 2009I have a database app where on a button click, I export the current record to crystal report which in turns converts it to a PDF file. Upon application startup, I export one record into PDF just fine but when I move ahead to the next record and I click the export button, the new PDF file that was exported is now blank. If I restart the app, I can then export the one record again but any subsequent record will export to PDF as a blank PDF file.
To sum up:I can export one record once using the below code snippet but when I try it for a second time on another record, I get a blank PDF file (only the crystal report formatting is in the PDF).
[Code]...
Crystal Report & Temporary Tables - Print The Table Data Through Crystal Report?
Jun 21, 2010I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 RepliesCreate A Crystal Report Dynamically Not By Using Crystal Report Wizard
Jun 23, 2009Iam workin wid crystal reports have a problem i jus want to create a crystal report dynamically not by using crystal report wizard rather by using a blank crystal report and connecting to the database server and generating the report from the database manually....
View 1 RepliesDB/Reporting :: Crystal Report "requires Further Information" On Printing?
Dec 29, 2009I have created a Crystal Report for my Visual Basic Web Application, developing with Visual Studio 2008. I have created a DataSet for my web project, giving it all the field names I need to fill in the report. I wrote code that obtains necessary data from a database and fills in an instance of this DataSet, then I push the dataset into the Crystal Report and display it. It displays fine, and the data is in place as expected. However, when I click on the "print" icon on the report page, and answer "yes" to the dialog box that asks me how many pages I want to print, it displays a page saying "The report you requested requires more information" and displaying four text fields, labelled ServerName, Database Name, UserName, and Password. It also displays the name of my dataset, as though it expects me to "log into" my dataset.
View 1 RepliesVisual Studio 2008 Not Install With Crystal Report (only Crystal Report Install Its?
Jun 12, 2011i am having a Visual Studio 2008 but it not install with crystal report when i open add new item-> its didnot contain Crystal Report how can i add crystal report and make crystal reports in visual studio 2008 how i install crystal report with visual studio 2008 only crystal reports 2008 install and its open with visual studio 2008 when we click Project->Add New Item-> and crystal reports shows in thiis file
View 1 RepliesWill End-user Need A Crystal License In Order To Use Crystal Report Part Of Program?
Jul 16, 2009I plan on designing a Crystal Report, and then calling it through VB.NET code. Will the end-user need a Crystal license in order to use the crystal report part of the program?
View 1 RepliesClose The Crystal Report Viewer And Pass The Parameter Again And Should Be Able To View Report Again?
Aug 15, 2011When i pass the parameter and run the report it works fine as i close the form it closes the form is there any way so that i should be able to close the crystal report viewer and pass the parameter again and should be able to view report again.
View 1 RepliesPrint A Report Which Is Receipt Having Size 3 X 4 Cm But Unable To Resize Crystal Report?
Dec 30, 2010I got a problem I want to print a report which is receipt having size 3 x 4 cm. i am unable to resize crystal report. i am using crystal report coming with visual studio.net 2008.
View 1 RepliesCrystal Report Not Loading - Get The Load Report Failed Notice
Jun 5, 2011I have created an application using vb.net 2008 and for reports Crystal Reports Basic for Visual Studio 2008 but the problem is, when I run the application in another machine away from developing box, I get the Load report failed notice. I don't have any idea on how I should approach this issue. I tried installing the CRRedist2008_x86 and CRRedist2005_x86 but still the problem won't go away.
View 3 RepliesDisplay Data From Table In Report Footer Of Crystal Report?
Dec 2, 2010I'm having a problem with my crystal report with regards to report footer. I want to display the data from the table, column name "Remarks" in report footer but when I try to call the data it doesn't show the remarks. I'm using VB 6 and mdb files as my back end. Is there any command or fundamental that I've missed?
View 1 RepliesCrystal Report - Dosn't Shows Any Report Instead Of It Gives An Error
Jun 21, 2010I had created 5-6 crystal report in my vb.net project with back end sql server 2005 and i had given my path for crystal report. after this i had creted setup and deployed at customer machine but there it dosn't shows any report instead of it gives an error. for viewing report so how to come up with this probelm.
View 7 RepliesCrystal Report With Joined Query Not Showing On Report
Jun 5, 2011im trying to fetch rows in 3 TABLES using JOined Queries.im tried the query first in MS ACCESS and it worked but when i tried to show it in Crystal report it wont show its data. [code]
View 7 Replies