Member Avatar

Hi all.. How i can make a report without using database. Data can directly from the active form. Thank you in advance

Member Avatar
0
35
Member Avatar

Hello Everyone, A few months Ago I was introduced to Linux operating system...Ubuntu...Some of you are probably wondering where the hell have I been...Let's just say I was stuck in a Window....Needless to say I love The change....Unfortunately for me I didn't know what I was up against....After updating Ubuntu 12.04 And restarting my system ...I am greeted with an error That says the system is running in low graphics mode :your screen , graphics card and input device settings could not Be detected Correctly.You will need to configure these yourself..Nothing I try works...Needless to say I am lost as …

Member Avatar
0
47
Member Avatar

I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have tried viewing tutorials. I have also restarted the SQL Service from the configuration manager.:sad:

Member Avatar
0
10
Member Avatar

[CODE]Hi Friends, I have written a code with some example script for generating report in PDF with PHP and MYSQL. But i am unable to fetch the data from my table. So Please help me to solve this issue. Thanks <?php $today=date('Y-m-d'); $hostname = "localhost"; $database = "bdname"; $username = "root"; $password = ""; $conn = mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($database, $conn); date_default_timezone_set('UTC'); require('fpdf/fpdf.php'); class PDF_result extends FPDF { function __construct ($orientation = 'P', $unit = 'pt', $format = 'Letter', $margin = 40) { $this->FPDF($orientation, $unit, $format); $this->SetTopMargin($margin); $this->SetLeftMargin($margin); $this->SetRightMargin($margin); $this->SetAutoPageBreak(true, $margin); } function Header () { $this->Image('images/logo.png',100,15,200); // …

Member Avatar
0
51
Member Avatar

Please help me why do I get this error. Thank you!

Member Avatar
0
15
Member Avatar

hi I'm having problems in my crystal report where all the selected rows in my datagrid will show up in my crystal report but instead it showing me an exception selectcommand.connection has not been initialized here's my code in my form where the datagrid is: Dim cmd As OleDbCommand = New OleDbCommand("SELECT Data1.ID, Data1.DateFile as [Date File] , Data1.Plate as [Plate #], Data1.Driver as Driver, Data1.EmpID as EmpID, Data1.OdometerBefore As [Odometer Before], Data1.OdometerAfter As [Odometer After], Data1.Gas as Gas, Data1.CostofGas as [Cost of Gas] FROM Data1", con) con.Open() adpt = New OleDbDataAdapter(cmd) 'Here one CommandBuilder object is required. 'It will …

Member Avatar
0
10
Member Avatar

Hi all, I have installed SAP Crystal report for Visual Studio 2010 successfully on PC(.NET4.0, Windows Vista, Visual Studio Ultimate 2010). Now When I am going to add rpt file in my existing project, It automatically create .mht file and not .rpt file, that .mht file containing instructions and link to install SAP crystal report which I have installed already. Anyone can tell me, what I have to do to create an .rpt file to generate Crystal Report?

Member Avatar
0
6
Member Avatar

Friends .. how my code working fine with two buttons (PDF and RTF) but the last portion for HTML converting its not working .. please help Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Diagnostics Imports System.IO Public Class Form1 Dim myReportDocument As New ReportDocument Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load myReportDocument.Load("d:\test\S111.rpt") CrystalReportViewer1.ReportSource = myReportDocument CrystalReportViewer1.Refresh() End Sub Private Sub BtnText_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnText.Click Try Dim CrExportOptions As ExportOptions Dim CrDiskFileDestinationOptions As New DiskFileDestinationOptions() Dim CrFormatTypeOptions As New PdfRtfWordFormatOptions CrDiskFileDestinationOptions.DiskFileName = "d:\test\check.pdf" CrExportOptions = myReportDocument.ExportOptions With CrExportOptions .ExportDestinationType = ExportDestinationType.DiskFile .ExportFormatType …

Member Avatar
0
15
Member Avatar

Hello people, I am new to crystal report. Normally, I would insert columns in the crystal report viewer and then look at the records at the Main Report Viewer. All the rows/records in that particular columns of that table will be shown. And then I found out about this SQL Command Query which can be used in the Database Expert of VS 2008. Now I can have a table that selects rows in my own choosing. Example, I can select records of people who have inactive accounts on the system. SELECT * FROM PeopleTBL WHERE Status = 'Inactive' All the …

Member Avatar
0
7
Member Avatar

Hi All, I would like to thank this community for the enormous help to develop my skills. Thanks. I have 2 databases and a single report form and a crystal reportviewer. The User can select the database which he want to work (Each of them belongs to different warehouse) So he can select and make dc, invoice, and associated work for the particular database. I have a dataclass it difines which database selected and which data should be retrieved using a login screen which contains a database selection combo. All goes well. I am also created a report format in …

Member Avatar
0
13
Member Avatar

Hello everyone. I have build a simple MS Access database to keep track of volunteer info (contact, address, phone etc). I have a report that displays each record in a list: record1. Last Name, First Name, phone, email record2. Last Name, First Name, phone, email etc... What I want to accomplish is to have either the Volunteer's name in this record be a Link or add a link itself to the recod that when you click it it takes you to an individual detailed report that will display more accurate information about the volunteer. I know I can create a …

Member Avatar
0
4
Member Avatar

i want to create a text report and i have use this coding:- <?php $f=fopen("c:\amit.txt", "wb"); // adding header $text="\n Your text to write \n ".date('d')."-".date('m')."-".date('Y')."\n\n"; fputs($f, $text); fclose($f); ?> which results me some thing like when i open it in windows [i.e my computer->c drive->mit.txt] :- > []Your text to write[]09-09-2012[][] but i want it like this Your text to write 09-09-2012 and in fanfold paper size 14" * 12" as i have a huge data to create a report for ex payslip of all employee in my company plz help me

Member Avatar
0
8
Member Avatar

my report show this way: surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 2 firstname2 middlename2 surname 2 firstname2 middlename2 i want to display my those records this way surname 1 firstname1 middlename1 surname 2 firstname2 middlename2 since the 5 surname 1 firstname1 middlename1 have different values in other columns (and so as the surname 2 firstname2 middlename2)... in my crystal report I want to display only the surname, firstname, and middlename... how can I display the records the way I want? any help is appreciated... thanks …

Member Avatar
0
10
Member Avatar

Hi guys, Have been trying this out for sometime with no success. I want to be able to use pdf printing application like pdfprinter to print my vb reports to and then save the reports to a particular location on my computer. Anyone with an idea how i'd achieve that? Regards.

Member Avatar
0
5
Member Avatar

When I run my program following is my program: public class JasperReportsDemoApp { String reportSource = "c://report1.jrxml"; String reportDest = "c://HelloReportWorld.html"; public JasperReportsDemoApp() { Map<String, Object> params = new HashMap<String, Object>(); params.put("reportTitle", "Hello Report World"); // params.put("author", "Craig Conover"); // params.put("startDate", (new java.util.Date()).toString()); // params.put("reportTitle", "Hello Report World"); // params.put("author", "Craig Conover"); // params.put("startDate", (new java.util.Date()).toString()); try { JasperReport jasperReport1 = JasperCompileManager.compileReport(reportSource); // Make the driver class available. Class.forName("com.mysql.jdbc.Driver"); // Create a connection to pass into the report. java.sql.Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/shyamadb", "root", "root"); // Replace the empty JR datasource parameter with // the connection parameter named conn. JasperPrint …

0
1
Member Avatar

My application get crashed as soon as I attempt to see Crystal Report. Environment: Windows 7 CRRuntime_64bit_13_0_1.msi (SAP Crystal report installed) .NET 4.0 WPF Application Can anybody tell me whats should be the reason of crash and what to do?

Member Avatar
0
4
Member Avatar

How to create report in core java

Member Avatar
0
4
Member Avatar

Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my database).

Member Avatar
0
2
Member Avatar

I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=)

Member Avatar
0
3
Member Avatar

I need to know how can I get specific record there in report by passing string parameter from vb.net to crystal reports? For example - I have text box, button & crystalreportviewer there in my form. When user will use it he will write specific word there in the text box & click on view report button then it will automaticlly find out the specific record & show it there in report. Please help me.

Member Avatar
0
11
Member Avatar

I have a very complex multi-page form I am developing in the Crystal Reports which is included in VS2008. There is always 1 Page A. There may be 1 or more page B. There may be 1 or more Page C. Page A has 7 subreports and a header from the main table. Pages B and C hold overflow records that won't fit on Page A. Page(s) B holds 1 subreport and a header from the main table. Page(s) C holds 3 subreports and a header from the main table. My problem is the page header on pages B and …

Member Avatar
0
2

The End.