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 RepliesI have 6 to 7 tables with state information in them. They all have the same field names. I have a Crystal Report that is based on one of them. I want the user to be able to select a state and change the Crystal Report to use that table instead of the one it was based on.I mean when user select text in combo box and then click on "OK" then report show (using only one rpt for all the tables of same fields).i have the database name"Rajab" in which the all the tables have same fields and structures now the problem is that i have designed an rpt now i want that if user select any table from the list of combo box then through this rpt the data of every table shows. how can i use that rpt for every table because i don't want to use seperate rpt for every table i want to use only single designed rpt for 6 to 7 tables.
View 2 RepliesI have to change my sql server and need to point all my crystal reports to that new server at runtime, some reports has StoredProcedures embeded inside and those are the problems.[code]....
View 2 RepliesI have a report and is working with .netnow i needload images in runtime by passing the values in .net or load the image by dbthe control that i using isthe crystal report viewer, i have found codes in the web that refer this:
"crxReport.Sections(3)""CrReport.Sections("Details").ReportObjects("Picture1")=? "
but with the control what i using i dont have that option :(what is the control that i need load to the project that have that options?or is some especial version of crystal report?
how can I change the report orientation from portrait to landscape in runtime? (using Reporting Services report viewer control)
View 5 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 RepliesMy 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 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 would like to add an image to a crystal report at runtime.
I am currently doing this using a second data table containing only a byte field and then a blob field on the report. However this feels like a hack and if there is no data in the first primary table then for some reason the image does not show.
Is it possible to add an image with code or another method?
I'm using crystal reports for visual studio 2010. Winforms project. Either C# or VB.
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 RepliesI am using Microsoft Visual Studio 2008 and want to design my Dynamic crystal reports. In vb6 i normally did this via bounding each control of the section1 ,2 or 3 via run time code by giving the name of that control something like
.section3.controls("txtName").text=some value
can I did the same with crystal reports as well in VB.Net if yes than how.?
Can any one provide me with the Crsytal report runtime installer for Visual Studio 2010.I have the installer of Visual Studio 2008 but its of no use.I need the installer that is the .msi file.
View 3 Replieson first form one textbox and one button present and in second form crystal report viewer is present in first form textbox i write query and when i click on button i want report in second for with data returned by query
[Code]...
I have a simple application with a crystal report in there. So, the crystal report runtime must be installed on the clients which use the app. Now i have create a setup.exe and under "Required Components", Crystal Reports Basic... is marked. I choose the second option below that Crystal Report should come from the identic folder. When i call the setup.exe or the *.msi file the app is installed under programs but without crystal reports.
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 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 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 RepliesI 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]...
How do I view an rdlc report by pressing a button in runtime?The report is called summaryReport but I can't seem to find the code to actually run it.I was trying to do something like summaryReport.Show(), but by typing summaryReport doesn't even show any related events or methods, like the control didn't even exist.
View 2 Replies