Search results for query: *

Tek-Tips community, We curently are using the old version of Cognos Impromptu Version 7.0.702.0 We have other BI tools now but so much is developed in this it is keep the lights on. PROBLEM One of our users is running a report using desktop Impromptu. This report is a formatted report which...

Good afternoon - I have been asked to add a "filtering tab" to an Excel file containing two lists of data and 4 PivotTables (all on different tabs). The goal is to make this file "more presentable" to the audience while providing a better user experience. Here is my summary of the file: 2 tabs...

Please review the below layout for current state and desired state of the data. I am trying to come up with a SAS Script to run to address the need of transposing(creating a cross-tab) a hierarchy dataset. RAW DATA IDNumber Group LetterRating 123 Finance A 123 Sales B 123...

My scenario is as follows: I have a list of users who have access to a site. When a users visits the site, activity is tracked (basically a hit counter). After bring my data into Excel I am trying to do a quick analysis to show total # of users with access to site by group, # of users who...

All - I am not sure that my subject line explains my situation but here is the scenario. I have a list of companies and for each company a list of sales contacts who the company works with. So, one company may have just one sales contact or many sales contacts. I have an Excel sheet which...

Hello All - In Excel I have a list of employees (attached fig.1). This list can have more employees added to it over time. In Another tab in this spreadsheet, a matrix (attached fig.2) to show where those employees fall regarding certain criteria. I want to be able to run a macro and have...

Hello all - I have been given the job of putting together a list of hardware requirements for a "super data analysis/process modeling PC". Any suggestions on what hardware anyone out here is purchasing to run BI tools and modeling tools such as WebSphere? We are not looking into a server -...

The spreadsheet I have contains a number of columns and rows. One column I have contains company names. I would like to add code to an existing macro that will change all text in that specified column to uppercase format. I can not think of how to do it other than adding a column, copying the...

I am importing a .CSV file into an existing table in an Access DB. During the import process, I want to add an additional field and prepopulate all records in that field with the same data element. (Example: Field name is Location and I would want to define the location as Texas and add that...

Hello all - I am currently creating a database which askes the user to enter data in about 10 fields. These fields are related to a call the representative receives from a customer. To speed up the data entry process, I would like my form to have the same functionality as excel does in that...

Hello all - I have a report which has 2 parts. A main list frame and a sub-form list frame. Since I can not pass multiple values to a sub-report from the main report I have come up with an alternate solution. Both the main list frame and sub-form list frame have picklist prompts. main...

Hello all - I have read through a few examples but none seem to quite fit my problem. First a few details about my report: I have a report asking for a Rep, Opened Issues, Closed Issues, and Total Issues. I am having any problems getting the correct results. The Issues are conditional totals...

Hello All! I am currently using Cognos Impromptu. I am creating a cross tab report which sets up like this: ROWS = Product Name (field from table) Columns = Month (field from Time Dimension table showing just month number, example 6 for June basically takes a date and strips off...

I have an Access form with a random button on it. The Rnd function works find and does what I desire. My issue is: When you use the random button a number of times (example 25 times) then close the form and open it again, the next 25 you choose the random button, the results seem to be the...

I have a 2 forms. One form EnterScores, is my main form where a user can enter, update, or view a record and its data(fields). I have created 3 macros to open additional forms for analysis purposes. On the form EnterScores, I have a combo box which allows the user to select one of the 3...

This is my number 1 problem that I can not figure out. We are using access to keep track of training records. I have two tables, one that has the training needed and one that has the training taken. In the training needed table there are about 1,500 records In the training taken there are about...

On my form, I have a duplicate button with the following code: Private Sub btnDuplicate_Click() On Error GoTo Err_btnDuplicate_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ,acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, ,cMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu...

I have 3 different fields in a report with a time value in this format: _d _hr _min Is there any way to sort all 3. Currently my report sorts one field then the next then the 3rd. I want to sort so that the 3 fields are not divided up. Is this clear? field 1 field 2...

Is there any way to get a DCount in a query? I have a parameter in the query. I keep getting the result of #Error Here is my formula: =DCount("[Prospective Documents]","Late",([Prospective Documents]-[Date of Appointment])>1) My query askes for a start date and end date. Or can I somehow...

I have a formula in my report footer which averages the total time between two dates in my query. The only problem with this formula is, is that it does not include the Null values. My report(query) makes any records Null which are less than 24 hours between the two dates. That way the user...