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?

they are not dups. It is deals with multiple products. For example Deal 1 bought three products. I get the deal number three times but I still need the detail per product line in addition to the distinct count of deals.

How can I do this using a formula? I am not familiar with this

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 figured it out. Our FY starts on 2/1/2007 not 1/1 so I added a parameter field to ask for the current quarter begin and put in suppression for division group section: Reportdate < CurrentQTRBeginDate and for my monthly selection I added month(Reportdate) <> month(today) - 3 The minus 3...

Actually it did not work it is only showing the top group of the division: QTR 3 MSD QTR 2 QTR 1 It is not showing ISD, BSD, etc.. for QTR 3 I want it to look like this: QTR 3 MSD BSD ISD QTR 2 QTR 1

Awesome, it worked. Now, can you explain to me why it worked. I hate doing something and not knowing why. I really don't understand this one and was expecting that it would not work.

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 get errors if I do not put [] around the field name

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: []...

it worked perfectly! Thank you

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...

You are my hero! Thank you!

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...