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
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
Jun 27, 2012
I have a php web service that I can call from a php client. I need to call this web service from a vb.net application. When I try to add a reference to this web service I get this error:The root element of a W3C XML Schema should be <schema>here is the top of my wsdl file:
<?xml version="1.0"?>
<!-- partie 1 : Definitions -->
<definitions name="raidService"
[code].....
View 1 Replies
Jan 26, 2010
Can I reference a dll programatically in VB.net? Or change the Local Copy path for a dll reference?
View 1 Replies
Jan 23, 2012
I have a main Report which consist of (Detail Report)
Transaction #
Amount Due
PaymentType
[code].....
View 1 Replies
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
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
Dec 27, 2010
I want to change my web reference URL at run time depending on if i'm connected to my live site or my "test site"
View 4 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
Feb 15, 2010
I'm writing an application for a device running Windows XP. There are 2 versions of the device and each version has its own API to communicate with the device's software. The application I'm writing needs to pull the same data from the API. My question is how to write a application that will detect at runtime which version of the device it is on and use the appropriate API.
I've created an interface containing all of the common methods and also classes for each device that implement the interface. Now I need to know how to activate the correct one at runtime.
Public Interface IAPI
Sub InitializeMachine()
Function GetActiveProgram() As String
[Code]....
View 2 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
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
Mar 11, 2011
I'm trying to use the microsoft browser in my .net program. When I add the "Microsoft WebBrowser" control, it is referencing ieframe.dll. How to I make it reference shdocvw.dll? I'm using vs2003.
View 1 Replies
Nov 26, 2011
Is there a way to change reference at runtime ? I am automating Word from VB.Net. I think what I have coded will be same for both Word2003 and Word2007. I used Word 12 Object Library reference(which is of Word2007). So, I want to know how to make it compatible with a machine installed with Office2003. That is, it will check the whether the machine has 2003 installed. If so, use that reference. Otherwise use 2007.
[Code]...
View 8 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
Mar 14, 2009
In vb.net 2005 how would one referance a control as variable and change it"s properties. Such as in control X visible = True. Tryed string manipulations that did't work.
View 1 Replies
May 15, 2012
In my code I use two classes. One contains the UI form, the other containsa method to write to a file. During coding I found out some behaviourwhich I don't understand. The code below shows (what I believe to be)the relevant part. The file writing part is substituted by a MsgBox for simplicity.I have the following controls in one form:
NumericUpDown
Button
With the following classes and methods:
[code].....
View 2 Replies
Sep 25, 2009
I'm having some trouble with breakpoints. I'm trying to debug a null reference exception. However if I set a breakpoint right before the null exception normally occurs, the null exception stops occuring. Here is a (very) simplified code snippet to give an example of my code.
[Code]....
In my real project, the line that calls DoSomething will throw a null reference trying to access MyChild. However if I put a breakpoint at that line, MyChild exists, and the call goes through without a problem. In the past, this was usually sign of a race condition in my code. In this scenario however, there are no other threads that modify MyList or any MyParent objects. What could possibly occur when visual studio breaks into code that preserves MyChild object that does not occur when no breakpoint exist? In my real project, the line that calls DoSomething will throw a null reference trying to access MyChild. However if I put a breakpoint at that line, MyChild exists, and the call goes through without a problem.
In the past, this was usually sign of a race condition in my code. In this scenario however, there are no other threads that modify MyList or any MyParent objects. What could possibly occur when visual studio breaks into code that preserves MyChild object that does not occur when no breakpoint exist?
View 2 Replies
Jun 4, 2011
I'm wondering what will actually change a class, in the sense that serialized objects of this class will no longer be recognized. If the class has reference to shared methods of another class. Will changing such shared methods also change the classes that reference them?
View 3 Replies
Jul 20, 2010
We have upgraded our project from Visual Studio 2008 to Visual Studio 2010 without any issues until now. Our project contains a folder call Libraries which contains different versions of Oracle ODP.NET DLL's as well as different versions of Telerik DLL's. Our project contains references to one of the versions of each. The problem is once we remove the reference and re-add it by browsing to the new version, again inside the Libraries folder inside the project, it adds the reference, but to the same version we just removed. We can even copy the DLL to our desktop, remove the reference and add to the new one on our desktop and it still will point to the Libraries folder version???. The only we we can actual change the reference to the new DLL is by manually changing the path in the .vbproj file, which is obviously not going to work for us. The same behaviour worked perfectly in VS 2008. We switch our references quite often, when new versions come out, but also far more often to QA different versions of ODP.NET and Telerik Control DLL's, so manually editing the .vbproj file is becoming quickly cumbersome. If I browse to a specific version at a specific path, Visual Studio should ALWAYS do what I'm telling it to do..
I did some seaching and came across a few other people with the same issue. This better not be as designed and if it's a bug, which I believe it to be, when will it be fixed?[URL]..
View 14 Replies
Aug 27, 2010
I have a simple vb.net project that outputs a dll. In order to build this project, I have to reference some 3 3rd party dlls by manually adding them to the project and then building.
What I want to do now is auto build this using a app called CruiseControl. . . I have been told that in order to use the 3 3rd party dlls, I have to modify the .proj file to include the .dlls. The thing is, where in the proj file do I include this
and how do I do this? I think I may know where the section is and I have included it here:
[code...]
When I run the auto build program it fails (it runs through but fails at compile time); when I build this manually it works when i refer the dlls. What am I missing to make this work?
View 4 Replies
Oct 20, 2009
the schema is created using VS, but when I try creating the schema using XSD.exe, the validation works, am I missing something here, like namespace or anything?
SCHEMA:
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="EmployeeXML" targetNamespace="http://tempuri.org/EmployeeXML.xsd"
elementFormDefault="qualified" xmlns="http://tempuri.org/EmployeeXML.xsd"
xmlns:mstns="http://tempuri.org/EmployeeXML.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:simpleType name="NameType">
[Code]...
View 7 Replies
Jul 23, 2010
I have an imported sql database using pa as the schema instead of the default dboThe problem is when I go into vs 2008 and create a gridview control, it won't recognize the from table object. I get "invalid object name" unless I go directly into the code and put the database name and schema name in front of it.
View 5 Replies
Apr 21, 2010
I have written a small XML validator, that takes in an XML file and an XML schema and validates the XML files against that schema. It works well, except for an XML file, with this content:
[Code]...
View 1 Replies
Nov 18, 2010
I would like to take data, from a dataset, and parse it out in XML. but, i would want the XML to be based on a particular XSD schema. The dataset is being filled from a database (wich i have no problems doing).
View 1 Replies