I am using reportview to set up my report pages. I used the existing datasets(configure -->add table -->save) but every time I clicked save, I got a few errors. So I decided to create new datasets for the tables that I want to have reports. Is that the right thing to do?
View 1 Replies
ok, I've finally got my test database issues sorted out, however now I need to actually modify my existing report to add the two new fields from my test database. I have made a copy of the report so that I am not modifying the original. I have deleted the two old fields and now want to add my two new fields in there. In the Field explorer window, I see an object called "dataset1" and when I expand it, it is using a view that includes fields from the table that I added my two new fields to.
The problem I see here is that I have gone in and modified the view to include these two new fields in my test database - but again, they are not showing up as selectable fields here. I am just assuming that "dataset1" is somehow pointing to the live database again and that I need to change the datasource location.In my solution explorer, I see an object called "dataset1.xsd" but the properties of that do not tell me much about where it is actually pointing to...
[Code]...
I am using Visual Studio .net 2008, which has a Crystal Reports builder. I have gotten to the point of building the report from a view I have setup on my SQL server. Instead of using a table on the server, can I use a table from my DataSet? I want to be able to select specific records, and report only results of that select statement.
View 1 RepliesI was given a task of rewriting some Crystal Reports. I found the original reports circa 1999, opened them up in VS 2008 made the changes and saved them.Now, they reference a database that is no longer around. So, I deleted this data source and added a .NET OBJECT datasource. I changed everything around so that the fields now look at this new datasource.
My intent was to create the report and during run time, pass it a datatable. This table is created by running a sproc created.When I run it, I get the first page of the report. But when I try to change pages or print, I get an error: Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File C:...MR01 {8E5164A9-4B01-4019-81E6-87AED65A02DF}.rpt: Unable to connect: incorrect log on parameters
[Code]...
I am trying to use a DataSet to retrieve the data necessary to display a Crystal Report. Just before the report is set to load, I have a message box to show the number of rows in the table. As of right now, when the message box comes up it says "3" which is right. I have 3 records currently in the table I am trying to read from. But the report is always blank with the column headings. [code]....
View 1 RepliesIm generating a report for a billing system, user makes a payment and have to print it.I Created a dataset with a custom query, something like select ID,Detail,value,client from. that gives me all transactions.With that I fill a report.Now I need a way to filter so the report only show the current transaction (I have the ID but don't know how to change the dataset query).How can I do this? or there is a better way to resolve this?
View 10 RepliesI have an iSeries query in VB.NET/VS 2008 that I need to run with 2 separate values of a same parameter and present in a report for A/B comparison. In other words - I want to see a report where the result of a run with parameter = value1 is on the left, same query with parameter = value2 on the right.My initial idea was to use 2 tables on a report where each table would be based on result of each run from a DataSet (xsd), but I seem to be only able to specify the parameters on the ReportViewer level, which means I have 2 identical tables instead of A/B cases.
Obvious second way was to create 2 separate reports, each with its own parameter value and get them as subreports onto a main one. However, both subreports show up with "Error: Subreport cannot be shown". Is there a way to catch an error to see why?What is the best way (a.k.a. best practices, industry standard, whatever you want to call it) to create this kind of A/B report? I was well sure that there is a well-known method to make this work, but to my surprise I haven't found anything except multiple copies of MSDN articles.
How can I generate a Crystal Report without dataset?I want to use Storedprocedure from SQL Server 2005.
View 1 Replieshow to populate my Dataset into Crystal Reports and exporting to PDF File?
View 2 RepliesImports System.Data
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Interop.Word
Imports System.IO
i have been using the above references to print a report in word document but my problem is that i am failing to put headers and footers on my reports. i want to include report title on the header and page number on the footer. how do i do it?
For some reasons I'm getting no data populating in my crystal report. I have set the datasourse of my crystal report to the dataset. I filled my dataset with data straight from the database. My dataset is not empty, I always check it first before populating data to the my report. I built my crystal report off the wzard and I did add
View 3 RepliesWe are getting correct output for crystal report using dataset which does not have a sub report.But it does not work for subreports?
View 3 RepliesImports System.Data
Imports System.Data.SqlClient
Imports System.Text
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports CrystalDecisions.ReportSource
[Code] .....
When I run this code my form with crystalreportviewer not show dataset
Unfortunately the data that i needed to post on the first page of crystal report can NO longer occupy the needed information that my system require in my report page... i would like to know how can i add page 02 on crystal report please
View 3 RepliesSo I had a report I needed to create and needed to get the total users per job for a system that I was not (and still am not) very familiar with. I asked the developer for that system for the code and was told it was no easy task. He sent me a query that didn't look anything like a user count. I told him I needed something to get all the users for each and every job in order to put it in the report I was building for one of the clients. I was told that wouldn't really work. I looked at his code as it worked on a per job basis.
The following is an example of the "logic" used to get the user count per job in asp.net:
TRUNCATE TABLE1
INSERT username INTO TABLE1 FROM QUERY1 WHERE CRITERIA MET AND job = *passedinjob
INSERT username INTO TABLE1 FROM QUERY2 WHERE CRITERIA MET AND job = *passedinjob AND username NOT IN TABLE1
SELECT username FROM TABLE1 and put in a dataset
[Code] .....
There were no UNION statements in the query1 or query2, there was no select count(*) from table, there was no recordset.count..
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.
View 3 RepliesQ:how can i add columns dynamically to rdlc report from dataset in windows based.
View 1 RepliesBasically this will be all I need to survive this flatform.
Public Function NoWork(DateDue As Date) As Boolean
Dim strSQL As String, rsHoliday As Recordset
Dim dHoliday As Date, nDay As Long, x As Date
Dim DDate As Date, dNewDue As Date, dOrigDueDate As Date
[code]....
I'm having a problem connecting my DB to a crystal report. I have tried to databinding my DB in MySql but it seems that it cannot produce the data needed but the fields are there..
here is what i have done to my crystal report. i think i have missed something
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 have a printing to do and there are several ways to print.i know how to print using the printdocument or creating a crystal report and print or transfer the data into an excel sheet and then print(but it needs the excel to be installed in the host computer)but i cant understand which one is the best and mostly preferred.
View 8 RepliesIs there any tool I can use to create a report from a pipe-delimited file? This report will need to have multiple fonts on the same line and be "programmable". I need to be able to loop through a section to output detail data to the report, keeping track of how many records are output.
View 3 RepliesI'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
I'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
[Code]...
I create the form, click on 'Add New Data Source', etc, and am fine till I select the database object and hit 'Finish'. At this point i get the error: "An error occurred while creating the new data source: Could not get type information for ... " and my dataset names.
View 1 RepliesI have a XSD file and I must create an XML file with data,I read schema but dataset doesnt have any table(I debug code ),how do I get XSD file into dataset,I use this code :
vb.code
Dim wds As New DataSet
wds.ReadXmlSchema("C:myXMLschema.xsd")
I am creating a multipage excel report in a single worksheet using VB.Net. I need to display group header information at the top of every page. check whether a cell is the first cell of a page or not.
View 3 RepliesI am using vb 2005 and word 2000. I use word to create a report that the user can print. When I click on the print button, I get the error "Library not registered." I am using clickonce to publish the app. This error only happens on 2 vista machines and xp works fine.
vb.net
Public oWord As New Word.Application
Public oDoc As Word.Document
Public oTable1 As Word.Table
Public oTable2 As Word.Table
Public oTable3 As Word.Table
[Code] .....
I have created an application in VB.net 2010, I have an SQL database that I want to gram some data from: Then Create a word document with that data and save it to a given location, this is what I got so far.
Process.Start("Outlook.exe")
Dim oApp As Outlook.Application
Dim oEmail As Outlook.MailItem
[Code].....
This gets the file and attaches it to an email. I have created another button that is called CreateReport_btn when this is clicked I want to get the last data from the sql database and insert it into a word document.
i am using a local database i.e,the sql server express that comes with the vs2005,dont have any sql server additonally installed in my pc.
whice creating a crystal report,first this comes:
on clicking next,this comes:
then i selected and click next,then this comes:
but it did not show the database(Database1.mdf) which i created in my local database.
then how to create the crystal report when i am using a local sql server express database?
which options to select from the images that i showed above?
