How can I make a report that contains for every record key 3 different layouts for the detail lines
e.g. title activity
Local organization
Loc. Budget Overhead
Accepted Date
Date req.
Date act.
[Code]...
If a have a lable called: lblWarning. I'd like to display it (Visible = True) when the detail band does not have any records. The label is in the group footer.
View 2 RepliesCrystal Report is repeating values like this:
1 rar
1 rar
1 rar
1 rar
1 rar
I want the output to be like this:
1 rar
I wrote code like this:
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldDefinition As ParameterFieldDefinition
Dim crParameterValues As New ParameterValues()
Dim crParameterDiscreteValue As New ParameterDiscreteValue()
crParameterDiscreteValue.Value = Label1.Text
[Code] ......
I have a problem with vbc, which is located at C:WindowsMicrosoft.NETFrameworkv4.0.30319vbc.exe If I run it, I get the error"The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail"But when I run it on my laptop, it works fine.The error also comes up where I originally experienced it, doing a asp.net project with vb.
View 2 RepliesI'd like to add Auto Number per group box in crystal report. Here I use Record Number but it increases by group box.
Report View
The AutoNumber will be at the front of Barcode Column. How to set it per group box?
I'd like to show new page per a group in crystal report. Please check my images below
report design
report review
How to set to show one group box per page?
I use a simple master-detail form using Visual basic 2005 express edition and ms sql server 2005 express edition, as well.
The master table is dept (deptno int, dname nvarchar(50)) .
The deail table is emp (empno int, deptno int, ename nvarchar(50)).
The primary key for the dept table is deptno and for the emp table is empno.
There is also a foreign key (deptno on emp table).
I created a new project, connected to a db (called test.mdf) and created a data source consisting the two of the above reffered tables.
I dragged and dropped these tables on the form and i noticed the following:
1)When the form opens... the system queries the database and displays the data on each block on the form.
2)I insert and/or update a record on the master table (dept) and everything goes well...
3)I try to insert and/or update a record on the detail table (emp) and nothing is changed on the detail table - without any error.
4)When i try to insert and/or update a record on the detail table (emp) which violates the primary key constraint or foreign key the system complaints...(as expected).
I have made several posts on here lately regarding master/detail or parent/child data setups but no one has been able to help. It seems like a subject people don't like to tackle BUT I really need help.
I'm having a real hard with the DataView.RowFilter functionality and it is driving me insane.
For the most part, I have the basic master/detail functionality working. When you select a record in the first grid, it shows the correct data in the second grid. When you enter a record in the first grid, you can enter related data in the second grid. I accomplish this by using a dataview and row filter bound to the 2nd grid. When you change the record in the first grid, the rowfilter for the 2nd grid is restated and reapplied.
The problem arises when I overwrite the primary field value in the first grid and the detail records become orphaned. You would think all I have to do is change the ID in the 2nd grid to match the new ID in the 1st grid but this is where I am having problems. I wrote a loop to change the ID of each record currently loaded in the 2nd grid to match the newly changed ID in the first grid. The code is here:
Code:
Dim I As Integer
For I = AuthorizationGroupsDGV.Rows.Count - 2 To 0 Step -1
AuthorizationGroupsDGV.Rows(I).Cells(0).Value = StrEmployeeID
Next
I have used this code before and it works great. It has to step backwards through the grid because when the ID's are changed, they no longer match the RowFilter criteria and they disappear from the grid. They still exist in the dataset. The problem is, while the code "works" the intended effect does not. Some of the records completely disappear from the dataset and do not reload when I restate the row filter against the new ID number.
I have an inventory system I am making for my business. I have a form that has a listbox control that lists all the orders that have been submitted. I also have a datagrid that lists the items in the order based on what is clicked in the listbox.
View 6 RepliesI want to get the detail of all the applications running in windows like
Application name : Status : User : Resources Usage : etc....
also I want to get the detail of all the users logged in at a time
There are a lot of master/detail databinding examples with detail form on the same window than the master, I can't find any example where detail is in a new window.
View 1 RepliesI have one SQL Server database with two tables:
CREATE TABLE [dbo].[Invoice]
(
[IdInvoice] [int] IDENTITY(1,1) PRIMARY KEY,
[code].....
Suppress Column in Crystal report Group Section
View 5 RepliesI want to design RDLC report via visual studio 2010, it is big different with visual studio 2008. Please guide me create RDLC report in visual studio 2010. I have a Class table combine with table Student with 1...* relationship in database. I will fill this data into report which one each row of Class table is row group and multiple students below. Example: [URL]
View 1 RepliesI am looking to produce an Excel report from an Access database table. The data contains numerous records with fields for Site, Country, Region, Type and a Resolution Time. My problem is that each month the Sites change so I need to be able to write VB code within Access to read the database table and output 'Site' records for that month, grouped together along with the incident details for that site, e.g. The report would have the following headings:
'SITE' 'COUNTRY' 'REGION' 'TYPE' 'TOTAL' 'RESOLVED<3DAYS' 'RESOLVED>3DAYS' 'NOT RESOLVED'
MEL AUS APAC TECHNICAL 78 40 31 7
MEL AUS APAC HARDWARE 49 40 8 1
LON GBR EURO HARDWARE 90 40 40 10
As I will have over 30 different sites and these may change each month how do I loop through the data identifying each site and its associated field values? I have used the following code to open the data and loop through records printing to excel, but am stuck at grouping by site:
Set rst = db.OpenRecordset(sqlStat)
row=10.......
..... Do While Not rst.EOF
.cells(row, 1).Value = rst.Fields(0)
.cells(row, 1).Value = rst.Fields(1)
.cells(row, 1).Value = rst.Fields(2)...
On my form I have an Group Box that I use to visually segment various controls on the form. how can I add a horizontal line that looks the same as the border lines of the Group Box?
View 3 RepliesI'm fiddling around with trying to make a sort of map/world. I'm using 16 x 16 pictureboxes named PictureBox1, PictureBox2, etcThe issue is that when I put the images into all the pictureboxes, I have to have a line for each picturebox (so say I have 100 boxes, I have 100 lines).The only difference in each line is the picturebox number, the rest is identical. I'm basically telling it to set that picturebox's image based on the number that a variable I've created has stored.I've got a game idea, and I'm just trying to figure out how to do the map. I want it to work like the old school RPG games like Dragon Warrior, or the more recent Dwarf Fortress. I'm still not sure if I want to use graphics or letters. At this point, I'm just trying to figure out how I can create the main screen where the user moves around. This is what I've come up with, as it works with what I know. I'm pretty new to this, although I've messed around with VB6 a lot.
Dim tile(30) As Integer
Dim tilelocation(3) As String
Dim x As Integer
[code]....
I have a dataset containing 2 tables,Customers and Contacts. Just showing the master-detail is not a problem. Problem occurs when I try to search the master table to bring in the detail table. Searching the master table shows only the master record, but not the related detail records. Adding a 'findby' query on the detail table only shows the records.url.. Normally when the master table is filled, the detail record shows in a form.
View 1 RepliesI have a large form that is set up from master-detail datasets in Visual Studio 2008.I havene master table with a large amount of detail tables. Several of the detail tables also have detail tables linked.Now I need to add a master table that sits on top of my existing master table making it a detail table.
View 7 Replieshow to build something like the following:I have an application that will reside on Kiosk style PCs that are out there in public settings. While the application is running on the Kiosk I'll need to restrict the access to certain PC features (reboot, command prompt, download files, etc.) so they don't mess with the PC. I need to build a Windows Installer that deploys the application and does all the set up needed to lock down the PC. The installer needs to do all the work; there can't be any manual steps besides running the installer. The installer will install the application, this part is standard. In addition it will create a local user and use Local Group Policy Objects to restrict the user's access to the machine. Then the machine administrator will log in as that local user and run the Kiosk application under this account. The hope is that the account is locked down and people playing with the application won't be able to stop the application or do anything malicious to the PC.I have been looking for a way to create GPOs in C# code. This way I can implement the GPOs as a CustomAction in my installer. So far I am not finding the right API for GPO management so I'm starting to wonder if I'm even on the right track.If you know of a nice solution for how to accomplish the Kiosk lockdown via a Windows Installer or you know something about managing Group Policy in a C# application
View 7 RepliesMay I know how can I collapse panel or group box in a windows form? I just want to put my datagridview in the panel or group box and collapse the panel..
View 2 Repliesi have a problem in crystal report when i am getting a data from database field that field has 30 words i want that in my report that field should be broke in 10 words each line
View 4 RepliesAs i need to export my report to PDF. In Crystal Report Viewer the Alignment are perfect.. But when i export into PDF the Alignment changed entirely.. In the Report im using all the Controls ( Text,Line,Box).
View 3 Replieshow 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 RepliesI'm trying to match up a specific group name and see if it exists for the currently logged in user using Active Directory roles. If the Group Name exists for the Current User, I want that group name to be displayed in a drop down list. Example: If current user is in BIG Group, display BIG in drop down list.Problem: All I am getting is SIDs and I'm not able to get anything to match up to the group name and nothing will show up in the drop down list.I also get the following Error:Error: Object variable or WIth block variable not set.How do I fix this?? here is the code I am using:
Private Sub GetMarketingCompanies()
' code to populate marketing company drop down list based on the current logged in users active directory group that
[code].....
Enumerate if an Active Directory group's member is user or another group
View 1 RepliesI barely use windows form but now I have a windows form application, there is a Listbox control, which will populate Active Directory search result, not like other regular database.I am thinking it would be nice if user can print off the search result in the listbox?
I was thinking using a Crystal Report viewer, but how to define the data source, it is not like regular data source that I can set up a connection, the search result is a dynamically generated data table, not from database.
I am working on a Windows Application,Having trouble crating a RDLC Local report.
There are just 2 text boxes in the report, One is Employee Name & another one is address.
Everything is alright but I couldn't figure out how to pass RDLC Report variable & show its value in the Report text boxes or in the report .
I am writing an application and I do not know how to reference a group of controls inside a group box. I will include the code I have written so far and a picture with a detailed explanation as to what I am trying to do. Feel free to comment on any discrepancies that you may notice in my code.
Code:
Public Class Form1
' The following class-level constants are used
' to calculate the price of the model
Const decCOUPE As Decimal = 18000
[code].....
I want to remove a group (include all items in this group) in ListView, but unsuccessful, the code is below, why?
ListView1.Groups("GroupName").Items.Clear()
ListView1.Groups.Remove(ListView1.Groups("GroupName"))