Search results for query: *

I have a table of data in Access 2003 with columns "Company" and "Tag" as follows: Company Tag ABC media ABC showbiz ABC TV ABC entertainment DEF media DEF entertainment DEF radio GHI software GHI enterprise...

I have a list of data "Company" and "Tag" as follows: Company Tag ABC media ABC showbiz ABC TV ABC entertainment DEF media DEF entertainment DEF radio GHI software GHI enterprise GHI programming What...

I am using Excel 2003 SP2 and I have a pivot table in which I have placed some conditional formatting for the subtotals. In short the data looks like this: Company Position Qty Cost/Sh Cost ABC Company PFD C 500 $1.00 500.00 PFD D 250...

I am using Excel 2003. I need to find an item in an array. Basically I have a two dimensional array with 2 "columns" and 10 "rows". "Column" 1 contains ranks as integers and "Column" 2 contains company names. What I want to do is lookup the company name in "column" 2 and return the...

I have a listbox that is populated by a dataset and I am looking for a way to store the selectedindices so that I can compare then to see what has changed. Based on the changes I want to delete a record (from other data not the list)if it is no longer checked and add a record (to other data) if...

Hi I am using VB.Net and CR XI Thanks to some slick advice from some VERY smart people on this site, I have set up a Windows application that exports a Crystal Report to a pdf and then emails it to users automatically. What I am having trouble doing is checking if the crystal report returned...

I am using CR XI. I have a report that I am grouping on User Name as the 1st level grouping. I would like to include a parameter for user name and include an option to select ALL Users. I would also like the option that IF ALL users are selected that the grouping should be either shown (so...

Visual Studio .Net 2003 I have a windows app with a form and 2 textboxes. I have coded a "Lost_Focus" event on textbox1 to perform some tasks however I don't want those tasks to be performed if the FORM has "Lost Focus". Can anyone direct me? Thanks and best regards, -Lloyd

I am using CR XI. My data is as follows: Company Activity Date A Left Voicemail 08/22/05 A Email Sent 08/23/05 A Email Received 08/24/05 A Email Sent 08/25/05 B Left Voicemail 08/22/05 B Email Sent 08/23/05 B Email Sent 08/25/05 C Email Sent...

I have a form with a textbox and a button. The form is NOT modal. I have the following code: Private Sub textbox1_LostFocus(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles textbox1.LostFocus If Not textbox1.Text = "" Then LookupCompany() Else...

I posted this in the Business Objects forum, but thought perhaps there was some VB way around the fence so I'm posting it here too. I am using CR XI and VB.Net with the viewer embedded in a form and the report object loaded based on the user's selection of a menu item. 98% of the time the...

I am using CR XI and VB.Net with the viewer embedded in a form and the report object loaded based on the user's selection of a menu item. 98% of the time the users want the default values when they run the report. Is it possible to upon opening a report to have the default values accepted...

Hi, I have a rich text box that I would like to store URL's in and have set Detect URL's to true. All seems ok, however I would likd to be able to click the text in the rich text box and be taken to the website. IS this possible? Thanks Thanks and best regards, -Lloyd

I have a listbox that is populated with a dataset. How can I make the listbox default to NO SELECTION? Currently the listbox appears with the first item selected. Thanks and best regards, -Lloyd

I have a simple selection formula as follows: {Prospects.Owner}<>"Joe" The problem is that when I use this selection formula any records that have a NULL value in owner are filtered out as well. Am I doing something wrong? Thanks and best regards, -Lloyd

We are viewing crystal reports with the viewer in Access and while the reports run perfectly we get a major screen flicker every 30 seconds or so as if there were some refresh going on behind the scenes. We are connecting to an SQL database via a file dsn. There are macros in the Access...

I am using CR XI. Does anyone know of a way to skip the "Refresh Report Data" dialog box when refreshing a report? Thanks and best regards, -Lloyd

CR 11 I have a manual running total that I created using the 3 formula method that I want to use in the body of the report to calculate a % of a total (the ending value of the manual running total). I have used Evaluateafter(manual running total display) however this doesn't give me the % of...

I am using CR 11. I have a parameter set as a number to ask the user for the year of the report (ie. 2005, 2006 etc). I pass this parameter as a number to a few on demand sub reports and all works like a charm. The problem? The users don't like the format of the parameter value (which...

CR 11 I have created a cross tab report that queries a table (actually a stored procedure to which I pass a date) and summarizes (counts) activities (rows) based on the activity type and beneath that the activity person (person who entered the activity. Both activity type and person are...