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
ADVERTISEMENT
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
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
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
Jun 1, 2009
Im trying to detect if an active report has been closed to close the "main form". Basically what im doing is populating an active report from parameters passed to the main form then the active report is populated, once the active report is closed i want the form to be closed. However, i have not been able to find an event that will close both. Unless i close the mainfrom which inturn closes the active report, which i want to happen opposite.
View 1 Replies
Apr 1, 2009
I've been doing research on reporting suites for a project my company is about to undertake, and have narrowed the candidates down to Active Reports and Crystal Reports. During the demo yesterday, it was clarified to me that one of the capabilities our client would like is the ability for the end-user to create custom reports integrated into the Web-Based client. I know that both packages have options for integrating an end-user designer to a WinForms based app, but I can't find a definitive straight yes or no answer for either suite as to whether or not it's possible to attach them to an ASP.Net based app.
View 2 Replies
May 2, 2012
I have a active report and I need to group it on my country attribute. I have been looking around on the active reports API and came across grouping. Is this the best way to do this and how do I go about doing this?
View 1 Replies
Feb 26, 2010
64-bit Windows 7 Profesinoal running a project I have done vb2005. Reporting as a tool I'm using active reports 2.0. Normal data base connection is very slow. The first problem this.The second problem, none of my reports does not work. gives the following error:is not a valid Win32 application.
View 2 Replies
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.
View 2 Replies
Feb 29, 2012
i added the COM reference to:Crystal Reports 9 ActiveX Designer Run Time Library 9.0 i have some code that prints a crystal report:
'print report
Dim Appl As New CRAXDRT.Application
Dim CrystalReport As New CRAXDRT.Report
[code]....
Code works fine on my Windows 7 64 bit computer because I have Crystal Reports 9 installed on that computer but i want this to work on other computers that don't have Crystal installed.I have published my app and installed it on another Windows 7 64 bit computer and it doesn't work.I think i need to have the craxdrt.dll install and register on the users computer.
how can i include this in my setup? I already include the Interop.CRAXDRT.dll when i publish (publish status: INCLUDE/Download Group: Required/Hash: Include) but it doesn't make a difference.i am using vb.net 2010 express?
View 3 Replies
Feb 29, 2012
I've got an intranet based reporting tool (VB.Net + ASP.Net Integrated Windows Authentication) that looks up users and managers from a SQL Server 2005 table to roll up the reporting to manager level. This table is currently manually maintained and I've been asked to make it more dynamic as it is going to be up-scaled for far more users. Therefore I'm looking to link in with the Active Directory to create an Org table in the back end which will replace the current manually entered one.I'm comfortable getting user data from the AD, but not so sure as to the best approach to set this up, I was thinking of the following table:
CREATE TABLE dbo.Employees
(
EmpID nvarchar(8) PRIMARY KEY,
EmpName nvarchar(30),
[code]...
EmpID will be the NetworkID (sAMAccountName).Then this will need populating from the AD, I'm guessing through recursive calls to fill in the fields. I'm then not sure how to structure the code so that it will capture every employee under every manager starting at a given level. I'm currently using the below to capture the direct reports for a given manager:
Public Function GetDirectReports(ByVal ADFullName As String) As ArrayList
Dim adItems As ArrayList = New ArrayList
Dim rootEntry As New DirectoryEntry("LDAP://" & ADFullName)
[code]...
View 1 Replies
Dec 22, 2010
I'm using VS 2008 to develop a solution which will report on data mostly contained in SQL Express databases, across two servers. It will be used by up to about 10 XP clients. I am unfamiliar with the Reports Applications. Will I need to buy extra licenses to use a Crystal Reports application? Why are they both included in VS? What is the basic difference between them?
View 3 Replies
Apr 27, 2012
I am trying to add user to a Active Directory group which i already have access to but i am getting an error "Unspecified Error" Ca you guys please take a look at my code and let me know what i am doing worng?
Public Sub adUserToGroup()
Dim Buf As String = ""
Dim sDomainName As String = ("LDAP:servername.cfe.kineeg.com")
[code].....
View 1 Replies
Sep 29, 2010
I want to manually add two items as "Active" and "Inactive" in a ListBox. When the user selects "Active", I want to get the value "A" and when "Inactive" is selected, I want to get "I". How do I do this in VB.NET.
View 3 Replies
Jan 23, 2012
I have a main Report which consist of (Detail Report)
Transaction #
Amount Due
PaymentType
[code].....
View 1 Replies
Sep 22, 2010
I have a function that works perfectly when I attempt to add a user from the same domain into a group of the same domain.
Function AddUserToGroup(ByVal strUserDN As String, ByVal strGroupDN As String, ByVal strGRPDC As String, ByVal strUserDC As String) As Boolean
Dim oUser As DirectoryEntry
[Code]....
The error is actually being thrown on the Invoke line, but as I said earlier, if the user is in the same domain, this works perfectly.
View 1 Replies
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
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
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
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
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
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?
View 1 Replies
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
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
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
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
Dec 9, 2010
Basically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.
View 1 Replies
Apr 28, 2011
i am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder
View 1 Replies
Mar 30, 2009
I want to get the active control (control which has the focus or where the cursor is on) each time the cursor moves to another control or each time a control receives a focus.
View 5 Replies
Dec 1, 2011
How can we create a report in vb.net without using any crystal reports
View 11 Replies
