My 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 RepliesIs it possible to rename a report section in a crystal reports using the version of crystal that is built into Visual Studio 2008?
View 2 RepliesCrystal Report is repeating values like this:
1 rar
1 rar
1 rar
1 rar
1 rar
I want the output to be like this:
1 rar
I wrote code like this:
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldDefinition As ParameterFieldDefinition
Dim crParameterValues As New ParameterValues()
Dim crParameterDiscreteValue As New ParameterDiscreteValue()
crParameterDiscreteValue.Value = Label1.Text
[Code] ......
Suppress Column in Crystal report Group Section
View 5 RepliesI want to hide or show Drill down Details section in crystal report while runtime. Maybe a checkbox from a from a form or soemthing like that. How can i do that.
View 1 RepliesThis 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]...
I 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.
I 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 Repliesi 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?
I 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]......
I 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 RepliesI 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 RepliesHow 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
may i use shortcut key like Ctrl+P to print the report in Crystal Report Viewer?
View 2 RepliesUsing 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 RepliesI 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]...
This 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
I 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)
These things look about the same to me. Is there any reason I should use one over the other?
View 5 Repliesi 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?.
trying 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 RepliesTrying 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?
I 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]...
I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 RepliesIam 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 RepliesI 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 Repliesi 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 RepliesI 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 RepliesWhen 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 RepliesI 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 Replies