DB/Reporting :: Creating Reports Without Crystal Report?

Mar 2, 2010

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?

ADVERTISEMENT

DB/Reporting :: Creating Crystal Report From Two Tables?

Dec 20, 2011

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]......

Creating Reports In Crystal Reports That Is Integrated Within Visual Studio 2008?

Aug 26, 2011

I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?

Generating Report Using Crystal Reports On ASP.NET?

Jun 1, 2010

After reserving a ticket for an travel agency, I want generate a printable report using Crystal Report.

Using Crystal Report To Generate Reports?

Jun 12, 2011

My program is using Crystal Report to generat reports. Fine. Everything worked in VB.net 2005 and Crystal report XI. But know, when I have build the project in VB.net 2010 I cant open the reports any longer from the program.

DB/Reporting :: Crystal Reports With Vista X64?

Dec 21, 2009

Recently, I unfortunately installed Windows Vista x64 on my computer! Now, besides all other problems, I realized that Crystal Reports which has been installed with .Net 2005, isn't compatible with Vista x64. I searched internet & realized that I need a redistribution kit named "CRRedist2005_X64.msi" but I can't find the file itself!

Generating A Very Simple Report In Crystal Reports IDE?

Apr 8, 2011

I have a simple application with one datatable in a dataset, I wanted to generate a simple report based on the values in that datatable. I have not used crystal repots IDE ever and I was wodnering can we create a report in crystal reports 2008 based on my application dataset? HOW? If it is not possible to do it in the crystal reports itself, can you send me a link of something that I get on well?

.net - Rename A Report Section In Crystal Reports?

Aug 25, 2009

Is it possible to rename a report section in a crystal reports using the version of crystal that is built into Visual Studio 2008?

Create Multiple Reports In One Crystal Report?

Jan 6, 2009

I have 2 or more reports and I want to be able to open them in a single report. Let's call it the master report. In this report I want to open several reports, that are independent one to another. I'm using this code to generate the raports:

Dim crDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Dim cmd As New OleDb.OleDbCommand
Dim da As New OleDb.OleDbDataAdapter
Dim dt As New DataTable

[code]....

With this code I rewrite the datasource of the raport, and I can filter the query by the 'param' variable in the query.After setting the datasource of the report i can save the raport:

crDocument.ExportToDisk(CrystalDecisions.[Shared].ExportFormatType.RichText, "C: emp.rtf")

into rtf, pdf, etc. I want to append more of these reports into a master empty report. Or load these reports as subreports into a master empty report.

Generating A Report Without A Dataset In Crystal Reports?

Feb 19, 2012

How can I generate a Crystal Report without dataset?I want to use Storedprocedure from SQL Server 2005.

Sql - Maintain A Stock Report Using Crystal Reports?

Mar 12, 2011

I want to take the following result with the help of query in Crystal Reports:I have a stock table where three column's "type", "product", and "quantity" now I want that to drag two sql expressions in my report 1st is "INN" and 2nd is "Out" and it comes like if the "type" is purchase so it check the "product" field and ADD the quantity and if the type is Sale it less the quantity according to "product" So what query should I write to get the result?

DB/Reporting :: Crystal Reports Using A Stored Procedure

Mar 19, 2009

We connecting a stored procedure in a crystal report.

In the query analyzer we can call the SP with: execute test 'example'

If we run the crystal report we get the possibillity to fill in the parameter for this SP. The report looks fine but how can we send this parameter in the crystal report script??

DB/Reporting :: Deploying .Net Application With Crystal Reports?

Oct 8, 2008

I have a project that uses a crystal report and I'm planning of deploying it.The problem is, is there a common setup for the components that was used in my project so I don't need it to manually register on the client pc?

DB/Reporting :: Labels On Crystal Reports..Read Only Or Writable?

Dec 13, 2008

I have one working and displaying my data and can change it using my ListView when an item in the list is picked.Now I need to change some of the labels on the report at runtime and cant seem to do it?If i have textbox on th report I can change its text at runtime I just cant seem to do it with the label controls that show in the report as IFieldObjects

Code:
Dim myReport
myReport = New CrystalReport1

[code]....

Can I do this with the label controls or should I try and change all the bound IFieldObjects to TextBox controls?

C# - Crystal Reports 2011 .Net 4.0 OS Installed On E: Gives Error When Running Report

May 4, 2012

I have one PC whereby the OS has been installed on E: and it has no C: drive. Onto this I have installed my .Net 4.0 WPF Application which runs fine.

However, when I try to access a crystal report it gives the exception below. This user is able to access the report from its network location in windows explorer so I assume the act of asking Crystal to copy it locally is causing a problem?

Therefore, can anyone advise where the local copy will be created and/or how I can control this.

[Code]....

Crystal Reports - Show / Hide A Sub Report Based On Condition

Jun 2, 2009

I've a VB.net 2005 desktop application, and i'm using crystal reports. In one report i've abt 6-7 sub reports. is it possible to show/hide a sub report based on some condition. i'm new to crystal reports , please suggest what is the best possible way to achieve this.

DB/Reporting :: Crystal Reports & Entity Framework 4 With Nullable Types

Jul 6, 2011

I have written an application which manages some bookings, and want to use Crystal Reports to provide the reporting engine. I have used it before with datasets with no problems.

I am using EF4, and have a LINQ query and report datasource assignment as below:

Code:

Dim ActiveCustomers = From Customer In FMEntities.Customers
Where Customer.Status = 1
Select Customer

[Code].....

I have read up that I may need to convert the incoming data, but I am confused as to what it needs to be converted to. Should it be a datatable?

DB/Reporting :: Set Number Of Groups Per Page Programmatically In Crystal Reports?

Jul 8, 2009

I'm designing a program using VS.NET 2008 and Crystal Reports 2008, and I want to give the user the option to set how many groups per page is viewed. I know I can do it using the Group Expert, but is it possible to set it programmatically in VS.NET?

Creating Bootstrapper For Crystal Reports Runtime?

Mar 15, 2012

I need help creating bootstapper for crystal reports runtime..I want crystal reports runtime to be installed automatically with the application if its not installed on the target machine.I am using vs2010?

Creating Reports Without Crystals Report?

Mar 17, 2009

In vb 6.0 I can create I data report by using data environment of the project properties.I woul like to ask if how can I create something like that in vb.net. The reports that will be viewed will be printed if the user want to.

DB/Reporting :: Crystal Report And MySQL

Jan 22, 2009

This 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, 2011

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.

DB/Reporting :: Seagate Crystal Report?

Nov 27, 2008

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.

DB/Reporting :: Sub Section In The Crystal Report?

Dec 6, 2010

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?

DB/Reporting :: Use SQL Statement In Crystal Report?

Feb 11, 2008

i 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?

Creating Crystal Reports For VS 2005 For A Client Server Application

Jun 5, 2011

how to create Crystal Reports for Visual Studio 2005 for a Client Server application? The problem I faced is that when I created Crystal Reports for Visual Studio 2005 where the Crystal Report is displayed in the client application it does not get refreshed with data entered. It only displays data that was entered during the time of development. I think this is probably because the database path changes when deployed in a new environment while the Crystal report keeps referring to the database location at development time.

Deploying Crystal Reports - Adding Crystal Reports To The Setup And Deployment

Jun 21, 2010

I am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.

DB/Reporting :: Crystal Report Shows NO Data?

May 20, 2008

I 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 Replies

DB/Reporting :: Listing SQL Statement In Crystal Report

Feb 20, 2008

How 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, 2004

may i use shortcut key like Ctrl+P to print the report in Crystal Report Viewer?

Copyrights 2005-15 www.BigResource.com, All rights reserved