Search results for query: *

I send an Excel workbook to multiple recipients. My workbook contains getpivotdata and vlookups that refer to another workbook that I do not want to email to the recipients. How do I prevent the workbook from refreshing and causing errors to the recipient?

MS Excel 2007 I want to do a distinct count using a pivot table: Date Deal# 2/5/06 2 Result 2/5/06 2 2/1/06 3 Feb 2 3/1/06 4 March 2 3/1/06 4 total deals 4 3/5/06 5 I want to group by month and only count unique deals per month. How...

I have a report grouped by Quarter then Division. I only want to see the division group for the most recent quarter but I want to see the quarter group for all quarters. QTR 3 200,000 GH1 MSD 80,000 GH2 BSD 20,000 GH2 ISD 100,000 GH2 QTR 2 300,000 GH1 QTR 1 150,000 GH1 How...

I created a form for my admin to enter employee information. THe control buttons on her view do not work but when I test the same exact database it works on my view. Using Access 2007 and the database is stored on the server. she accesses via this server. I have it set to default to the form...

I have a union query in Access 2007 that joins three tables into one. Where the fields do not exist in one of the joined tables I created this in the Select statement: "" AS [Product Name], WHen Crystal Reports XI grabbed the query from Access it created a parameter that looks like this: []...

I have a union query in MS Access 07 that unions 3 tables into one. The union query has "" as OpportunityID for the two tables that do not contain an opp ID. The issue is when I perform a distinct count it sums all the blank into 1 distinct count in Crystal REports XI. How do I get the...

I set up my database to load a specific form upon start up and to hide all the options to modify it so that the end user cannot get into the settings. However, I cannot get to teh options now to change it back. Any clues? I am in Office Access 2007 but this is a 2003 database.

I am working with CR XI and Access 2007. I have two dates I want to combine into one graph and one date group. Fields: [registered date],[sold date],[registered revenue],[sold revenue] all in one record. I want a graph to graph this as one graph by week: Week Beginning [registered...

I am using CR XI Pro I have table of sales data I have table of call data I have a table of employee data each employee will have multiple calls and sales. My sales data is coming from Salesforce.com and the other two from MS Access. I would like to group the report by week, month, qtr year...

Using Crystal REports XI and Excel data. I have data where there is a one to many relationship. One lead for many calls. I only want to count the data in my crosstab for the last call made. My pivot table is grouping by calldate (weekly)and doing a distinct count of the lead id. I want it to...

If I uncheck the case-insenstive option in Crystal REports report options (XI version), will this work with salesforce.com data so that it distinguishes between two identical ID's with one having a capital letter and one not?

I am trying to convert ID's into Unique IDs. SFDC give us the 15 character ID, but it could be identical to another ID except one letter may be Capitalized in one and not in the other. I cannto get Crystal reports to distinctcount using capital -v- non capital. So, I was given this...

I have data in one worksheet that I named. WHen I add more rows, I would like my named range to automatically get the additional data with me having to edit the named range each time. how can I do this.

I have data in a cell: MSD AutoCAD Electrical 2007 Trial CD PTD AutoCAD 2007 Download Trial TQ I only want the data up to the TQ. I tried this formula If cell ends with TQ get me len(cell)-3 How do I right this formula I tried =if(right(len(cell)="q",left(cell,len(cell)-3),cell)) but...

I am havig issues with Access and SQL. I am trying to create a form to enter data into a SQL table. When I enter teh new record and move then enter the 2nd record, it changes teh 1st record to the 2nd record. And, if I enter another record it changes record 1 & 2 to the same as record 3. It...

Why does my report keep reprinting the last few lines of data onto the 2nd page (luckily it does not add it into the totals a 2nd time) It doesn't always do this for each group though. I have the data printing int he GH6 section.

I have a sub report that is linked by sales agent to main report. In this sub report I have a formula to calculate the value of each sale. I want to add this value to the group total in the main report. Can I do this?

How can you distribute a report without having to buy the expensive server or Enterprise version with CR Pro 9.0 or with CR Adv Dev 10.0?

I have linked tables to an Access back end and to Sql Server in my database but when I open the linked table manager to change location so I can work locally, no tables show up in my linked table manager. Any ideas on what hte problem is and how to fix it.

I get two differ data files from our source with dates in these two types of format yyyymmdd ddd, mmm dd, yyyy 20050215 Sun, Feb 12, 2005 I get in a *.csv or txt file and then import it into our sql server database as an nvarchar field (cuz it would not import as a date...