Can anyone help me in undersatnding difference between tasks and activities?

Hi,

Email to case is not working properly. What would be the resons? When I get an email, it doesnot create any case in salesforce. Can you please help me in this?

Thnak you so much in advance!

Hi,

One of our users have access to report folder but when he tries to open a report it throws an error: "insufficient privileges.You do not have the level of access necessary to perform the operation you requested. Please contact the owner of the record or your administrator if access is necessary"

what could be the reason?

Report: pulls all the active users information( name, email etc).

How I can pull all contacts that donot have an opportunity record?

There is alook up relation between contact and opportunity.

Hi,

I would like to extract the records that are created in this week . Can we do this without hardcoding the dates? 

We have an option in Reports, but other than reports can we extract weekly data?

Select Id from Contact where created date = this week???

Thanks

Hi,

Can someone help me in understanding this report type.

A

---with atleast one record in B

     ----with atleast one record in C.

Which join happens first? A join B or B join C?

Please help!

Hi,

I would like to extract the records that are created in this week . Can we do this without hardcoding the dates? 

We have an option in Reports, but other than reports can we extract weekly data?

Select Id from Contact where created date = this week???

Thanks

Hi,

I have created a formula field. I want  this field to be visible only in the reports but not on the page layout.

What do I need to do for this?

formula field= field1-field2.

if Field 1 is less than field 2--> it returns me negative number. I need only the difference but not negative symbol. what can i do for this?( ex: -11 but i need only 11)

Thanks

Hi,

we want one field completly hidden from all profiles.

Do I need to remove this field from page layout or is that ok if i hide this field at field level security?

Any recommendations? 

Hi,

We have two PROD instances.( you can treat as 2 diff orgs A and B) we would like to shut down A one completely and only use one PROD B.

We will no longer use any customizations from one PROD A. but we would like to save all the development work at some place. so we can refer to it if needed. we were able to export all the data and place it on different server. I am wondering if we can replicate the PROD A instance into PROD B sandbox.

Any information would be greatly helpful.

Thanks.

Hi,

Do we have Chatter  to case functionality in salesforce?

Any insight will be greatly helpful.

Thank you.

Hi,

We have DB Amp connection with our salesforce production. when i write a soql query in sql server, am not able to pull in one field information. I do have access on that field.

Query:

Select *
From openquery(SALESFORCE,
'SELECT
Id,

..

..

..

.
Credit_Account__c

FROM Opportunity 
WHERE (CreatedDate=YESTERDAY)')

Error : 

OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 2033 : Field Credit_Account__c is not valid for object Opportunity.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

I am pretty sure that this field belongs to opportunity object.

Please help me in figuring out this. Its urgent.

many thanks!!

Hi,

We have 3 recordtypes on Account object. we would like to restrict to view one record type records for all the users except system admin.

If a user have a "View all" permission even though they should not be able to view these records.

can we do this?

Thanks