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]...
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).
code CrystalReport by two DateTimePicker but get error "Mismatched data types in criteria expression"
This is the code
Private Sub btfechascrystal_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btfechascrystal.Click
[code].....
CrystalReport happens I have a filter and code, as follows. which works very well
[Code]...
the problem is that I want to filter by date range start and end with two DateTimePicker and a button. the syntax CrystalReport filter by date range OLDB
I'm using VB.NET 2003 windows application.i'm trying to display Crystal Reports using CrystalReportViewer.
Code i'm using to display "ZTab.rpt" in CrystalReportViewer when Form_Load
Code: Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
for example: if we are using datasource "work.mdb" for "ZTab.rpt" when form_load. when i hit a button, how come i change the datasource to "Employee.mdb" for "ZTab.rpt" during run time using codes. so when form_load it will display ZTab.rpt with datasource "work.mdb" and when i hit a button, it will display ZTab.rpt with datasource "Employee.mdb".
I'm using VB.NET 2003 windows application.
i'm trying to display Crystal Reports using CrystalReportViewer.
Code i'm using to display "ZTab.rpt" in CrystalReportViewer when Form_Load
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
CrystalReportViewer1.ReportSource = "ZTab.rpt"
[Code].....
so when Form_load, it displays "ZTab.rpt" and when i select one crystal report in combobox and hit button "Run", it displays corresponding crystal report. that works fine.
how can i change the datasource of a report during run time using codes (programming).
for example: if we are using datasource "work.mdb" for "ZTab.rpt" when form_load. when i hit a button, how come i change the datasource to "Employee.mdb" for "ZTab.rpt" during run time using codes. so when form_load it will display ZTab.rpt with datasource "work.mdb" and when i hit a button, it will display ZTab.rpt with datasource "Employee.mdb".
I want to set default printer in crystalreport.Because, every i print , i have to choose printer before printing.
View 3 Repliesmy crystal report displays group tree. though it is important for navigation, i want to get rid of it whenever the report loads-just plain report.
View 1 RepliesFor some reasons that I don't understand all my design changes won't show up when I hit F5 and run the application. I can put how many new fields and labels with som "hello" text that I wont but they are not displayed at runtime. But all database changes the report i connected to will be displayed.
How can that be? What is wrong with my report when all datachanges runs thru but not my design changes?
I am using VS 2008 and the built in crystal report and viewer.
[Code]...
I have a main Report which consist of (Detail Report)
Transaction #
Amount Due
PaymentType
[code].....
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]...
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 RepliesI 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]....
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]....
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 RepliesI 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.
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?
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?
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 RepliesI'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?
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 RepliesI have a textbox1 and button1 and panel1 (which is used as a popup control)i want if textbox1.text="show" then modalpopup control whose id is panel1 will be visible on buttonclick event other wise .... modal popup control panel1 will not be shown ...how to do this ? using vb.net ?
View 2 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
[code] I can't show the form 2 when i use TAB.tabindex already set into 1.
View 6 RepliesThis is a simple one, but I haven't seen a way to do it. I have a DataGridView that is bound to a Sql-Server database, and it works fine. The only thing I'd like to add is the row # at the beginning of every row. Yes, I COULD set the first column as "RowNUm" and maintain it that way, but it seems that having the row # on each row should be a feature already provided to us. So, is there a way to have the DataGridView display a row number for each row?
View 1 RepliesI'm application to change some icons, and I'd like to have a window to show different dll icons.
View 11 Replieshow to always have the mouseLocation x & y so every time i move my mouse it say's it ? i serched on here and found some code but it only show's me the mouseLocation when i grab the form and move it
View 13 RepliesI would like to be able to show all the websites visited on a machine.
View 1 Repliesi'm using a menustrip. the menuitems click events won't show a messagebox properly. i think it does load, but i've no idea where, because it disables the form + i can't see it anywhere. it might be behind the form. i have to push the enter key to free the form. [Code]
Why i can't use method dot show in my visual studio 2008 and Why i must declaration object for using method dot show, example[code]...
View 14 Replies