.net - Subreport With Query Inserted Into Main Report?

Feb 4, 2010

I have a crystal report with a bunch of parameterized fields that are being filled by code and displayed through CRViewer. I need to add a few sections in here to execute a query to return a dataset and display this in the same report. I am not sure if the best way to do this with a subreport. I am trying to add a subreport and then set the datasource of the subreport to my dataset, but I cannot get it to work.

Lets say there is a customers table. I have FirstName LastName as parametirized fields displayed on the form along with address and basic customer information.

I want to place a subreport showing all orders this customer has made on the SAME report. The is an association table with multiple orders possible.

The report is being placed in a class that can be called by a VB.NET app. Therefore I cannot create the dataconnection for the subreport in the UI (or maybe I can and pass params later).

I am successfully populating the parameterized field by doing the following:

Dim myRpt As New RunReport.RunReport
myRpt.Load("myReport.rpt")
'Set Labels

[Code]....

This will be one report I just need to display the subreport section to handle all possible orders.

View 3 Replies


ADVERTISEMENT

Link A Subreport To A Main Report Correctly?

Nov 15, 2011

I created a report [RptContacts] to show the data of all the contact persons in my SQL server database.

The report has a row group on the column [PK_Contact] in the datasource (IQueryable).

An other report [RptCommunications], which will serve as subreport in the main report, shows all the communications we had with each contact person. The datasource (IQueryable) for this report contains the column [FK_Contact] referring to the contact person with whom we had the communication.

I added [RptCommunications] as subreport to [RptContacts]. In de Subreport Properties/General, I indicated both under "Name:" and "Use this report as a subreport:"RptCommunications.

How can I make sure that for every value of [PK_Contact] in the main report [RptContacts], I see the correct records in the subreport [RptCommunications] corresponding with the right contact person. In other words, how can I make sure that for every communication in the subreport, [FK_Contact] = [PK_Contact] in the main report?

View 3 Replies

Crystal Reports: Main Page Break If Subreport Grow?

Jun 21, 2010

I've been working on a report and it has 2 subreports, one of them can outgrow the region destinated for it (on a preprinted paper), and I want to break the subreport on a new page of the main report (with page header and page footer).

View 2 Replies

Crystal Reports : Get Effectively A Subreport Within A Subreport?

Jan 30, 2010

I'm using Crystal Reports within VB.NET and Visual Studio 2005.I have a report with several subreports. I'm setting List(Of MainStuff) as the data sources for the main report. I'm setting List(Of SubreportStuff) as the data source for the subreport. Each SubreportStuff has a key which links back to a particular MainStuff, so the report groups each MainStuff item with its related SubreportStuff items. (Or, at the DB level, SubreportStuff items have a foreign key, which is the primary key in MainStuff.)

Below shows the Load function for the dialog, which contains a CrystalReportsViewer. In the Crystal Reports report editor (within VS 2005) I set the subreport link to pull only the related items into that part of the report.

Imports System.Windows.Forms
Public Class dlgMyReport
Private rpt As New MyReport
Public theMainList As New List(Of MainStuff)

[code]....

This works fine.Now, though, what I'm needing to do is in essence the same thing, but pull items based on the keys in the subreport items. This would mean having a subreport within a subreport. However, it doesn't appear that I can do this (the option for inserting a subreport is grayed out when I try to insert in something that is already a subreport).

View 1 Replies

DB/Reporting :: .rdlc Report With A Dynamic Image Inserted Question?

Jul 6, 2009

directly here is the issue:a "OpenFileDialog" on a windows form is made to choose a picture and then insert it into a rdlc report under VB.net 2008 so i need the exact command to access any picturebox in the rdlc report.

i used to do the job under VB6 as the following:Set ReportName.Sections("SectionName").Controls("Image2").Picture = LoadPicture(fileName)

View 1 Replies

Sql - Get Last Inserted Record In Msaccess Query?

Dec 16, 2011

I am inserting data from my vb.net application to msaccess db.I am confused in way of getting the last inserted record added to a table. IN MS-SQL we get @@IDENTITY for that but it didn't worked for me in MSAccess.

so what should be do for getting the last inserted record added to a table?

View 4 Replies

Crystal Report With Joined Query Not Showing On Report

Jun 5, 2011

im trying to fetch rows in 3 TABLES using JOined Queries.im tried the query first in MS ACCESS and it worked but when i tried to show it in Crystal report it wont show its data. [code]

View 7 Replies

After Running Insert Or Update Query, Need The Last Inserted Record And Compare In .net Sql Server?

Mar 11, 2010

i have 2 queries in vb.net with an if clause -

if x=0 then
insert into table1
else
update table1

both queries have 5 fields. now what i want to do is after this insert or update takes place, i need to look at this inserted/updated record and compare it with another table (table2). Especially for update, i have 5 fields in both tables. if any of the 5 fields dont match with table2, then i insert a new record in table 2 which is the updated record in table 1.

View 1 Replies

Sql Server - How To Get Last Inserted Identity In Formview Inserted Event Using .net

Sep 21, 2009

I am using VB.net (FormView and ObjectDataSource) and Sql Server 2005.

I want to get last inserted @@identity in table on FormView1_ItemInserted

Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) Handles FormView1.ItemInserted

End Sub My issue is that I want to redirect my FormView to readonly mode after FormView1_ItemInserted but for that I need to show the inserted record in readonly mode and that is only possible if I get my last inserted @@identity.

View 1 Replies

Background Worker / Progress (Report To Default Instance Of Main Form)

May 23, 2012

I am using background worker to report progress on the screen. In the Main.vb I have the following

Public Sub report(ByVal sender As System.Object, ByVal e As System.ComponentModel.ProgressChangedEventArgs) Handles bwlistener.ProgressChanged
Dim message As String = e.UserState
logRTB.AppendText(message & vbCrLf)
End Sub

When I call this from Main.vb I use:
bwlistener.ReportProgress(0, "Some status text goes here")
It works great. The problem is when I try to call it from any other module in my project.

When I call it OtherFile.vb:
Main.bwlistener.ReportProgress(0, "Some status text goes here")
It doesn't work... The program doesn't crash. Debug goes through everything but no output is actually shown to the end user.

View 16 Replies

How To Add Query To Crystal Report

Aug 6, 2011

I couldn't add a query to crystal report from ms access d-base. explain me the way how to add it through form wizard.

View 1 Replies

Edit SQL Query In Crystal Report?

Oct 8, 2010

how to edit the sql query in crystal report..

View 2 Replies

Pass Sql Query To Crystal Report?

Apr 20, 2011

im using 3 tier architecture..

Public Function SelectVoucher() As DataSet
Try
Squery = "select a.VoucherNo,convert(char(10),a.VoucherDate,120) as VoucherDate,
a.TotDebit,b.CustomerName as PartyName,c.Particulars

[Code].....

how to i pass the query to crystal report.

View 1 Replies

Create A Report From A Query Using Multiple Forms?

Apr 21, 2010

which contains a combobox with two Gender options, Male and Female. When the form runs the user can select either male or female to perform a query. I made the ComboBox public and shared so that it can be viewed by other forms. On another form i added a ReportViewer and a dataset based on my database (MS Access 2007 database with 1 table named tblStudents). I don't have any problems when i try to run a simple query without parameters, but there is a problem with my

View 13 Replies

Generating Crystal Report Runtime With Sql Query

Jan 29, 2012

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

View 4 Replies

Pass Query Result Into Report Parameter

Oct 24, 2011

I have an rdlc report with a TextBox that contains
=Parameters!ReportParameter1.Value

View 1 Replies

Running Same Report Multiple Times With Same Query?

Sep 5, 2011

I have a report that displays some sales info. I have a query that takes the data from an SQL Server database and I store it in a dataset. Up to there everything is ok. The problem is that I need to print the same report using Crystal Reports for each row in my query. Is there any way this can be done? I call a form with a ReportViewer tool to display the reports, wich are basic .rdlc reports.

View 1 Replies

Changing Query To Load Specific Data In Report?

Jun 18, 2012

Synopsis: I have a report generated from the report wizard in VB that works, but I only want to load data from the same department as the current user.

Details: The application connects to MySQL using the MySQL Connector/Net. I have a users table in the database, one of the fields is "Dept_ID." The report I currently have works loads data and everything fine, but I only want to load some of the data from the table, specifically where Dept_ID matches the current user's Dept_ID, basically adding the "WHERE" clause to the select statement.

I used the report wizard to generate the report and data table, etc, just followed from step one. I've looked around and have found something about using parameters, but can't seem to figure out how to pass a variable to the parameter, or if that is even the best option. Using the wizard, I don't have any code to show for it and the report works like it should, I just need to figure out how to configure it further.

View 1 Replies

SQL - Select Query Result In Tabular Format Like Summary Report

Nov 30, 2011

For example
month1 month2 month3 total
district1 5 2 9 16
district2 1 0 11 12
total 260 150 140 550

Here final total is not much important. But at least I need to show count per district per month.
SELECT Districts_mst.district_name,COUNT(Payments.PaymentId)users ,DATEPART(M,payments.saveon)Month
FROM Payments
JOIN Subsciber ON Payments.SubId =Subsciber.SubId
JOIN districts_mst ON districts_mst.district_id = Subsciber.District
where lang_id=1
group by district_name, DATEPART(M,payments.saveon)

Which give me list like.....
district_name users Month
dist0 1 1
dist1 1 11
dist2 3 11
dist3 1 11
dist4 3 11
dist5 1 12
dist6 1 12

View 1 Replies

How To Use SubReport In XtraReport?

Jan 23, 2012

I have a main Report which consist of (Detail Report)

Transaction #
Amount Due
PaymentType

[code].....

View 1 Replies

Adding A Subreport To Active Reports?

Oct 8, 2010

I'm writing a report in VB .NET (using Active Reports) that displays details about a location, and then displays a bunch of images, which are stored in a database. The images are displayed in my main report via a subreport. However, I can't get the images to load. I have two files, the main report (rptMain) and the image subreport (rptSubImages). The sub Detail1_Format in the rptSubImages never gets ran, which is why the images are not appearing, and I can't figure out why! I've included the code below... can anyone pinpoint why my subreport detail section isn't getting called? The rptSubImages report gets initialized, but if I put a stop point inside the detail sub, it never gets caught during debug.

[code]...

View 2 Replies

Change The Schema Reference For Subreport

Apr 8, 2010

fy0910 and fy1011.so when i see the report in schema fy0910 or in fy1011 i have to change every time the schema reference for the subreport,but when i see the report in the specific schema after setting the schema reference then there is no problem in subreport but when i go to another schema then again i have to change the schema reference for sub report.For your kind information there is absolutely no problem in main report.

View 1 Replies

Data Retrieval Failed For The Subreport?

Feb 16, 2011

I have created a working report, included a sub-report that is linked to another RDLC file in the same project.The sub report fails to load with : Data retrieval failed for the subreport, 'Subreport1', located at: WML_WS.MediaCur.rdlc. Please check the log files for more information.My question is, where are the 'log files'.I have the following code:

ublic Class frmProofSheet
Public Property Caption() As String
Public Property BookingNo() As String[code]....

View 3 Replies

Remove Duplication Of Data In Subreport?

Aug 6, 2010

Am developing a resume data retrieving software where data is stored in one parent table and 4 child tables as such:

Resume_table ----> Parent table
holds ----> Res_ID, Emp_ID, Lang_ID, Task_ID & some other static data

Employee_Table--->which is referenced directly to Resume_Table.Emp_ID similarly ol other 3 tables are referenced to the main parent table Storing and retrieving data is all working fine as long as I am retrieving 1 record for each child tables But some times there might be couple of languages and only single records for other child tables.In dat case as the four child tables are ol in separate subreports whch are called onto the main report whch prints as cv gives redundancy in data i.e by giving duplication of ol records twice which were single records during entry, which i think follows the language table if it consist of 2 records.am using a join query to call these records onto crystal report...

[code]....

View 3 Replies

VS 2008 CrystalReport Subreport Won't Show

Jul 2, 2010

Ok a fellow employee created a CrystalReport that has several sub reports on it. They needed some kind of interface to pass the parameters to the report so I'm doing that in vb.net. This seemed very simple at first, here is the code for setting the parameters and showing the report.

[Code]...

View 2 Replies

VS 2010 Error On RDLC Subreport?

Apr 2, 2012

I've been googling around to find a way of inserting a subreport by using the designer. So i created a new RDLC report and inserted a subreport on the existing RDLC report. Then i changed the Name property of the subreport to the name of the second RDLC, without the rdlc extension. At execution time it fails with the message:"The ReportName for the subreport Unicre_Report_Comm_SR is not valid. A ReportName can not be an empty string or just white space."

View 1 Replies

Subreport Page Header On Pages B And C Does Not Print

Mar 11, 2010

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 C does not print except on the first page B or C and I need it to print at the top of each one. (There could be many) Pages B and C are currently subreports but evidently that doesn't work. I have to format the report this way, it's a gov't form. Does anyone know how to get a subreport (which is actually a working report) and which can grow past a single page, to display a page header at the top of each new page?

View 1 Replies

Reference A Report Variable In The Report Properties Code Window Of A Local Report?

Apr 19, 2011

how I can reference a report variable in the Report Properties Code Window of a local report? I have tried Variables!Claimant.Value (for a variable called Claimant) but I get an error "Reference to a non-shared member requires an object reference." I have tried qualifying it with Report. and also with the report name in front of it but I get errors with this also.I have the variable CLaimant defined in the Variables section of the Report Properties.

View 3 Replies

Is SubReport's Implicit KeepTogether Feature Fixed In VB 2010

Sep 22, 2010

This behavior occurs because the Subreport control has an implicit KeepTogether property. By design, the KeepTogether property tries to keep content of a subreport on one page. Because of this behavior, the report engine creates blank space on the main report if the subreport does not fit on the same page as the main report. Then, the report engine creates the subreport on a new page.

View 13 Replies

Split A Crystal Reports Subreport Across A Page Break?

Nov 16, 2009

I'm using Visual Studio 2005 and writing in VB.NET.I have a subreport in a Crystal Reports report consisting of a list of log entries. Sometimes the list of log entries is long enough that it would extend onto the next page. What I see happening is that the list appears on the next page, leaving a big blank space at the bottom of the first page.

I've tried unchecking the "Keep Together" boxes in the "Experts" in a number of different places (sections, groups, etc.) but see no change in the output.I'm guessing that this isn't the right way to go, but do you know what is?

View 1 Replies







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