Yeah could you send the exact format as you indicated. I am trying to visualize what you are saying. Are you saying put the Name in the row section and the group in the column section and use a formula to differentiate the groups or something else?
I am using CR8 and here is my situation. I have on the detail line a column of information. Name and Group. I want to show the name and the group they belong to on the same detail line. However if a name belongs to another group, crystal repeats the name and put them on a different detail...
Problem 1
I am using the sqldataadapter wizard to use Query builder. I connected 2 tables, customer(cust_id(pk), acct_id(fk)) and accounts(acct_id(pk)). As I progress through the wizard I get a multiple table error message. The wizard does not handle multiple tables and tells me I need to...
Chrissie you responded to my 7/11/04 concern about datagrid not updating using a update button. You sent me some code. Here is my finding when I used the code.
Here is the original code I was using
Private Sub cmdCustUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)...
I am okay until I enter this code
con.connectionstring= ... it has a problem with the ...
Also, the names of my tables are cutomer and account. Account ID is a fk in customer. In my sqldatadapter1, I used query bulder to link the 2 tables together. So when I get to the code: com.commandtext...
My Update Button is:
Private Sub cmdCustUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCustUpdate.Click
If Not Customer1.GetChanges Is Nothing Then
Try
SqlDataAdapter1.Update(Customer1)
Me.Dispose()...
I have a button on a dataform that when pushed is designed to load some data from an sql database. Here is the code:
Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
objcustomer.Clear()
Try...
I built a datagrid on an asp page. I used an oleDbAdapter and a dataset to bind the data. In page load I put in OleDbDataAdapter1.Fill(Dataset21)
DataGrid1.Databind
When I run the application to a localhost I get the following error on the line that has OleDbDataAdapter1.Fill(Dataset21)...
Here is some code I am using to connect to an oleDbConnection database. I am writing a routine to force the user to enter a user id and password. Both must match what is in a .mdb table. The database is in a folder with my project. I am okay until I get to Cnxn(open) I get an unhandled...
I'm using CR8.5. I have a report with mutiple subreports. I am noticing that if the subreport lists a large amount of data, it will force a new page thus leaving blank space on the previous page. If the subreport will list a small amount of data (say no more than 10 lines) it does not force a...
In Studio.net. I choose an asp workspace application. I get an error message that my machine is not running asp.net version 1.1. I installed the redistributable and .net framework version 1.1 from microsofts web site. I checked the add/remove prorgrams and confirmed that both are installed...
I created a coldfusion page using drmx. Everything works perfectly when viewed on a localhost. When I publish to the web I get the code instead of the database. Why is this and how is this solved?
When I sign into ColdFusion Administrator I receive a message stating that it is a trial period and I would need to purchase a license. Does anyone know the cost and is there a way around this cost? Obviously I need the administrator to register all data and web services.
Using crystal 8.5. I have a GroupHeader1:SORTNAME. I want the report show a set number of SORTNAMES (ie 6) then move to the next page. What is happening is that despite using the Format Section keep together feature, on some pages a GroupHeader will show but the supporting data shows on the...
Are there any major limitation of the enterprise edition of microsoft xp enterprise vs professional. I am specifically talking about IIS for web applications and using crystal reporting. I set up a crystal report, delcared it globally and assigned it to open via a command button. When...
Using CR8.5. There is probably a simple answer to this question but here goes. I have four columns of totals:
@pledge(if gifttype='p' then giftamount)
@payment(if gifttype='y' then pledgepayment)
@writeoff(if gifttype='w' then writeoff)
@Due(@pledge-@payment+writeoff) Each transaction is...
I am using crystal 8.5.
In the format crosstab section I have the following: Rows= SchoolNames Columns = @living(if deceasedID ='000' then "Living") @Mailable(if deceasedID = '000' and addrlocator = 'good' then "Mailable"). The summrized field = DistinctCount of the StudentID, which helps...
I am using crystal 8.5. I have a report with several sureports, each in their own detail section. If data from a subreport over flows to another page I want a page header before the data appears. Is there a way to force a page header in a subreport. In the main report it is automatic.
I have a report consisting of 4 detail areas housing 4 subreports. I used the suppress if blank and keep together checkboxes in the format section. Doing this seems not to work. One page will have a lot of blank space before the next subreport print (wont suppress). In other cases, I have...
I am using crystal 8.5. I have a mainreport and a subreport which displays membership types. Here is an example: Single Installment(in main report) Single installment(subreport). If there is an entry in the subreport, I want to count it and add it to a total in the main report. For example...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.