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

Member Avatar
Member Avatar
+0 forum 6

Hi all expert, Need help here. RS.Open "Select * From TABLE where Box_ID = '" & BOXID & "' Order By CASE_NO ASC", con1, adOpenDynamic, adLockOptimistic Set DataReport.DataSource = RS DataReport.Sections("section1").Controls.Item("Text1").DataField = RS("BOX_ID").Name DataReport.Sections("section1").Controls.Item("Text2").DataField = RS("LOT_ID").Name In my program i am able to printout the data field. But how can i convert RS("LOT_ID).Name to barcode? Eg. BOX1001 100001 BOX1002 100002 I want to printout the LOT_ID as barcode instead of text. i had tried to change the font to barcode 39 font but the barcode printout is not readable by scanner. DataReport.Sections("section1").Controls.Item("Text2").DataField = "*" & RS("LOT_ID").Name & "*" I had …

Member Avatar
Member Avatar
+0 forum 5

According to the latest [Verizon 2015 Data Breach Investigations Report](http://www.verizonenterprise.com/DBIR/) all but four per cent of the security incidents analyzed by researchers could be accounted for by just nine basic attack types. That's pretty useful information for enterprise looking to prioritize their approach to security in terms of establishing a stronger security posture. So, as far as the nearly 80,000 incidents that were analyzed to form the basis of the report, what were these nine basic patterns then? Verizon states that the nine threat patterns are: 1. Miscellaneous errors (such as sending an email to the wrong person for example) …

Member Avatar
+1 forum 0

I have this gigantic query that returns certain data from my MSSQL Database (working perfectly- Courtesy of djjeavons). I want to sort and arrange this data in order. I want if the user selects a range of dates from the form (ex. November 1, 2014 - November 9, 2014), the result should be grouped in order (November 1, 2014, November 2, 2014, November 3, 2014 ..... November 9, 2014). I would like for each of the results to form its own dataset. # November 1, 2014 # Distributor/Importer OpeningPMS Transfer Sales Closing (ADD DATA) # November 2, 2014 # Distributor/Importer …

Member Avatar
Member Avatar
+0 forum 1

It's that time of year again, and the latest [Secunia Vulnerability Review](http://secunia.com/vr2015/) has been published. This analysed anonymous data gathered from scans right across 2014 of millions of computers which have Secunia Personal Software Inspector (PSI) installed and revealed some interesting statistics. On average, the computers used by the people running PSI had 76 programs installed on them and these vary from country to country. Secunia focussed its attention on what it calls "a representative portfolio of the 50 most common applications" which compromised 34 Microsoft and 16 non-Microsoft ones. So what did the analysis discover? You might be surprised …

Member Avatar
+1 forum 0

hello experts, I want to show .jrxml file in html div as a preview of created report. I am using eclipse luna and I was created a report in jasper soft studio 6.0. and i need to show this jrxml file in html <div> </div> So please help me. thank you.

Member Avatar
Member Avatar
+0 forum 4

Hallow everyone! I'm developing an application that features a bunch of reports and I have been using DataGridView as a way of displaying my reports, which come from the database (programmatically). When I want to print, I have been using a function that prints the datagridview like you are taking a screeshot. This is not good as it can only print what is currently seen in the screen, if I have a long list, then only the part that is on the screen will be printed, until I scroll down and print again. So I am looking for a way …

Member Avatar
Member Avatar
+0 forum 1

Hi, I have installed CR 8.5 and VB6. prepared one small prog. Now want to add CR control in VB toolbox so as to drag the same in vb form where I have to write code to print. So how to get the control please.

Member Avatar
+0 forum 0

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
Member Avatar
+0 forum 3

I’m going to use main report and sub report for showing some details. Main report has InvoiceHeader Part and sub report has invoice detail part. Invoice Header and invoice detail has 2 SPs. SP_InvoiceHeader (Use for main report) ALTER PROCEDURE [dbo].[testSP1] @invnoH as varchar(20) AS BEGIN SELECT * FROM INV_HEADER WHERE INVNO=@invnoH END SP_InvoiceDetail (Use for sub Report) ALTER PROCEDURE [dbo].[testSP2] @invno as varchar(20) AS BEGIN SELECT * FROM INV_DETAIL WHERE INVNO=@invno END I create the main report and using Insert --> subreport I just add a sub report. Both reports are used above SPs seperatly. I just can pass …

Member Avatar
+0 forum 0

Hi All, I am using cognos report sudio 8.4. I have got a problem in adding each cell to its next cell data (means running total not addition two cells). I tried with available report studio functions like running_total, Moving_total. I got errors. I am automating excel reports into cognos report studio. Converting sum(previous cell + current cell) function in excel to report studio. please help me to overcome this problem.

Member Avatar
+0 forum 0

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
Member Avatar
+0 forum 2

Hi Guys I have my Asp.net 4.0 application,it has crystal report viewer, that viewer object is not visible at run time on win 8.1 beta version and microsoft windows 2008 server, but it works fine on my persoanl pc which runs windows 8 , any idea on what is the reason ? thanks regards sumith

Member Avatar
+0 forum 0

Hi everyone, Please help me to register the sql query exceutor in netbeans and java. I am using ireport 5.5.1 and netbeans 8.0 with jdk 8. The problem is that when i run the reports within netbeans, they run but when i build the project and run it from a jar file, report give the exception of this sql query executor. How to do it? Documentation asks to change the property but i couldn't do it, and i didn;t find any good tutorial on this anywhere.

Member Avatar
+0 forum 0

how to create a report with data from duatabase on the same server or different servers, using SQL Server 2000, using the **crystal report 8.5** or **data report of VB6 ** For example I have table A and table B with the same table structure, table A is stored in the database with the name DataB1 and stored in a database table B DataB2 Table A =============== code name =============== Jon X1 Jim X2 Table B =============== code name =============== Yana Y1 Y2 yono I want to create a report showing the contents of both tables A and B Dapa …

Member Avatar
Member Avatar
+0 forum 3

I hav two tables sales (sa_no,sa_date,cu_id,total) ladger(ledger_id,cu_id,payment,payment_date) I want to display the transactions of a customer (cu_id) in one crystal report in the order of dates ,such as sa_no sa_date total ledger_id payment payment_date ie one row from sales then one row from ledger for the customer cu_id Please help me , I hav been trying for a week to solve this.

Member Avatar
Member Avatar
+0 forum 1

Sir i want to know what is the complete and correct code of daily report of an inventory control system in vb6

Member Avatar
Member Avatar
-2 forum 1

[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
Member Avatar
+0 forum 2

1. Please how can select Assigned Court so that the Assigned Judge and his Court Location should be auto selected...What I was able to do is just for Assigned court and Assigned Judge..Please I need help to capture the three. This can be found on the Second ICON after login...Add Entry 2. Under Add Control User (4th ICON)...I tried ading user profile picture but its showing error. Please assist 3. On the Report page (6th Icon), Status of cases per court should be included and a Report graph in bar chart should be displayed at the bottom of the page …

Member Avatar
Member Avatar
+0 forum 4

I am creating crystal report in ASP.NET and C#.I am creating a crystal report.All are going fine if I give textbox for search parameter but when I give combobox for search parameter then it does not generate report.Data does not come into DATATABLE.Where I am doing wrong? sql = "select Fund_Allocation.ProjectID,Fund_Allocation.HeadType,Fund_Allocation.GroupName,Fund_Allocation.SubGroupName,Fund_Allocation.Name,Fund_Allocation.FundID,sum(DISTINCT(Fund_Allocation.amt)) as total,sum(DISTINCT(File_Sanction.FundAllocated))as Booked,sum(DISTINCT(File_Purchase.BillAmt))as Expenditure from Fund_Allocation LEFT JOIN File_Sanction on Fund_Allocation.FundID=File_Sanction.FundID left join File_Purchase on Fund_Allocation.FundID=File_Purchase.FundID where Fund_Allocation.ProjectID = '" + ComboBox2.Text + "' AND Fund_Allocation.FinacialYear='" + ComboBox1.Text + "' AND Fund_Allocation.HeadType='" + ComboBox3.Text + "' AND (File_Sanction.SanctionDate>='" + TextBox4.Text + "' AND File_Sanction.SanctionDate<='" + TextBox5.Text + "' or …

Member Avatar
Member Avatar
+0 forum 2

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

Member Avatar
Member Avatar
+0 forum 2

Hello, I have created a report using SAP Crystal Report on Visual Studio 2010. As datasource, a interal dataset is used to populate the report which is included in my project. Everything seems to work fine until during runtime when I load the report onto the report viewer, it keep telling me to end a username and a password when I using a dataset that has no form of security nor authentication. I've found older posts and tried multiple suggestions but no luck. I've have posted my codes and what I've tried so far. I would appreciate your help. my …

Member Avatar
Member Avatar
+0 forum 2

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
Member Avatar
+0 forum 2

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
Member Avatar
+0 forum 2

good day... did any anyone know how to put the filtered items in listview into a data report? TIA

Member Avatar
+0 forum 0

Hi. I have developed project using visual studio 2012 in vb code. Application is running fine in my local machine. But In server it will show the error once excuting report. server is MS Server 2008 R2 with SP2. Here is the error . This is my senario Database: MSSQL 2005 express Sever OS: Microsoft server 2008 R2 SP2 Project development : Visual Studio 2012 Ultimate Error Message An error occurred during local report processing. The definition of the report 'Reports\DailyCollectionBYDATE_PRINT.rdlc' is invalid. The definition of this report is not valid or supported by this version of Reporting Services. The …

Member Avatar
Member Avatar
+0 forum 2

Hello to all. I want to know how i can merge 2 different rows of a dataset when the ID of the 2 different rows are equal. Can you help me? THX

Member Avatar
+0 forum 0

Hi... I'm seeking out some suggestions, ideas, or anything that could help... my .xl report is taking too long to generate... I'm doing this report under php and html but then It takes too long too generate... Is there any suggestion you could give me to fix such kind of problem?.. I don't know if this is about the query I've done or something wrong with my codes... Even generating a report for one employee takes longer than it needs to be...

Member Avatar
Member Avatar
+0 forum 1

hi guys , i am buliding the application using vb.net vs2010 ,mysql server workbench 5.2 . it works fine about the database connection and inserting and all sql operation with the mysql but now the problem is that unable to make the crystal report using that mysql it not supporting the connection of the database (table) to report it .plz help me solution for this problem any one have idel how to report it r connection with the report to mysql database ......

Member Avatar
Member Avatar
+0 forum 1

I want to develop a software program to enter data and to validate the data with respect to some rules. Finally I want to generate a report which showing the entered data. (This looks like online job application submission and final printout generation with input validation) How can I develop a program ? Which software/programming language/database tool should I use? **Additional Details** [platform--windows or linux user interface-vb.net or similar programming expertise-beginning to intermediate usage--networked usage storage--moderate data storage]

Member Avatar
Member Avatar
+0 forum 1

The End.