Attachment & files [pdf, zip] are not prompting to Open in SharePoint 2010, only saved, not opening OR [file does not show open]

one of my customer raised a issue regarding file does not prompt to open the files in SharePoint site, mostly pdf and zip files

yes it is a issue, if files does not opens why to maintain database. !!

The Solution

It is a simple web application setting ,The setting is called Browser File Handling and can be found in the General Settings of the web application.

CA> webapplication> general settings> Browser file handling > make it to Permissive

problem solved !! if you read a blog don’t forget to comment plzz

Technorati Tags: not open,only save,not prompting to open,attchement does not open,pdf zip dont open

Showing different values in SharePoint all item views in only in view based on configuration list [currency, Exchange date] defined

 

Create two list,

Requirement:

I have 1 list with key | Exchange Rate  two columns

List 1:

key	Exchange Rate
A	0.5
B	2
C	2
D	3

>>>>>>>>>

List 2: another list Amount List Key Amount

key	Amount
A 1000	1000
A 2000	2000
B 3000	3000

whenever users open any particular view (example test.apsx) of second list ( customized in SPD)

I have to get below results depending upon the exchange rate defined in configuration list 1

I,e exchange rate * Amount

key	Amount
A	500
A	1000
B	6000

 

Report has been implemented in my test site, follow the process to do it. Make you’re your configuration list currency will be look up with

multiplied value

1) Select your column to multiple in any newly created new, select formula on the top

2)

3) Multiply the value with the current node as per the snap shot

4)

Technorati Tags: SharePoint,SPD,Designer,customizing Views,OOTB,Exchange Rate

Technorati Tags: SharePoint,SPD,Designer,customizing Views,OOTB,Exchange Rate

Showing different values in SharePoint all item views in only in view based on configuration list [currency, Exchange date] defined

 

Create two list,

Technorati Tags: SharePoint,SPD,Designer,customizing Views,OOTB,Exchange Rate

Requirement:

I have 1 list with key | Exchange Rate  two columns

Technorati Tags: SharePoint,SPD,Designer,customizing Views,OOTB,Exchange Rate

List 1:

key	Exchange Rate
A	0.5
B	2
C	2
D	3

>>>>>>>>>

List 2: another list Amount List Key Amount

key	Amount
A 1000	1000
A 2000	2000
B 3000	3000

whenever users open any particular view (example test.apsx) of second list ( customized in SPD)

I have to get below results depending upon the exchange rate defined in configuration list 1

I,e exchange rate * Amount

key	Amount
A	500
A	1000
B	6000

 

Report has been implemented in my test site, follow the process to do it. Make you’re your configuration list currency will be look up with

multiplied value

1) Select your column to multiple in any newly created new, select formula on the top

2)

3) Multiply the value with the current node as per the snap shot

4)

What I miss about you [Katie Melua], version 2 by me

 

Its a try !! don’t know how you all feel another version of this song, suggestion and corrections are always welcome.

Missing the talk every night at 8.52

Forgetting myself in our talks as you do

The sharing of feelings that no one else knew

That’s what I miss about you

 

The every smile of yours made me mad

Your starring eyes, melting in my smile told everything

How every day you used to care me

That’s what I miss about you

 

Your presence in my boring life, exciting me

Driving in your dream every day, that was free

Gearing up the imagination, laughing for nothing free zed me

You made me feel you’re mine, like fruits for tree

 

The way you tried to separate the parasite

Your habit of stubborn ever never stopped

The way you said, I am not your bite

Pushing me like thorn of life which you chewed

That's what I don't miss about you

 

I bet you're lying wearing the hating mask

Spoiling the life with your own rules

Expecting me to forget our entire task

Knowing we are in a two different poles

 

The way I doubted believing others was wrong

This is one way of loving for few

The moment you are here, hearts beat prolong

Your skill of putting me down in a flash of flew

That’s what I don't miss about you

Populating the data to drop down list from another list without creating lookup column

Populating the data to drop down list from another list without creating lookup column

WHY??

few scenarios, when you have a look up column, if you delete the item from the look up, users cannot see the that item’s value where they have used in while creating

this leads to retain the column values, also if you delete or add any items in Country (source list) the reflect in the target list where we are looking up

OUR testers tested this scenario to solve this issue I proceeded with below approach

Technorati Tags: SharePoint,Lookup,dropdown,populating,formfields

1) Create a list

2) add a choice or single line text column to the list, in my case country

3) Open the list in SharePoint designer

4) create a new form for your list

5) you will get a web part having all the columns in the page

6) your created  choice column will look like below

 

<SharePoint:FormField runat="server" id="ff25{$Pos}" ControlMode="New" FieldName="Country" __designer:bind="{ddwrt:DataBind('i',concat('ff25',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Country')}"/>

7) create a another row through designer.

8) Insert data source from the ribbon. select your source list

<td class="ms-formlabel">
<SharePoint:SPDataSource runat="server" DataSourceMode="List" UseInternalName="true" UseServerDataFormat="true" selectcommand="&lt;View&gt;&lt;/View&gt;" id="spdatasource1">
<SelectParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></SelectParameters>
<DeleteParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></DeleteParameters>
<UpdateParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></UpdateParameters>
<InsertParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></InsertParameters>
</SharePoint:SPDataSource>
</td>

<SharePoint:DVDropDownList Width="175px" runat="server" id="ff25{$Pos}" __designer:bind="{ddwrt:DataBind('i',concat('ff25',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@ResourceName')}" Width="76px" selectedvalue="{@ResourceName}" datasourceid="spdatasource1" datatextfield="Title" datavaluefield="Title" />

9) change your FORMFIELD to above control,

10) Done

Populating the data to drop down list from another list without creating lookup column

Populating the data to drop down list from another list without creating lookup column

WHY??

few scenarios, when you have a look up column, if you delete the item from the look up, users cannot see the that item’s value where they have used in while creating

this leads to retain the column values, also if you delete or add any items in Country (source list) the reflect in the target list where we are looking up

OUR testers tested this scenario to solve this issue I proceeded with below approach

1) Create a list

2) add a choice or single line text column to the list, in my case country

3) Open the list in SharePoint designer

4) create a new form for your list

5) you will get a web part having all the columns in the page

6) your created  choice column will look like below

 

<SharePoint:FormField runat="server" id="ff25{$Pos}" ControlMode="New" FieldName="Country" __designer:bind="{ddwrt:DataBind('i',concat('ff25',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Country')}"/>

7) create a another row through designer.

8) Insert data source from the ribbon. select your source list

<td class="ms-formlabel">
<SharePoint:SPDataSource runat="server" DataSourceMode="List" UseInternalName="true" UseServerDataFormat="true" selectcommand="&lt;View&gt;&lt;/View&gt;" id="spdatasource1">
<SelectParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></SelectParameters>
<DeleteParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></DeleteParameters>
<UpdateParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></UpdateParameters>
<InsertParameters><asp:parameter Name="ListID" DefaultValue="7587B054-1CB0-4AF3-B419-1023C67EA93F" /></InsertParameters>
</SharePoint:SPDataSource>
</td>

<SharePoint:DVDropDownList Width="175px" runat="server" id="ff25{$Pos}" __designer:bind="{ddwrt:DataBind('i',concat('ff25',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@ResourceName')}" Width="76px" selectedvalue="{@ResourceName}" datasourceid="spdatasource1" datatextfield="Title" datavaluefield="Title" />

9) change your FORMFIELD to above control,

10) Done

retaining the values of lookup column after deleting the item from the look up list in SharePoint 2010

Hi Friends,

there is interesting requirement came when people started testing on some of the OOTB application, we usually develop rapid OOTB application in SharePoint 2010. One of our tester is started testing the application, he was deleting the items from the look up column and customer wanted to retain those values it the list so that they can identify what was the value previously

this can be achieved in two way

one InfoPath

1) if you are designing the form in in InfoPath, instead of look up column, create a single line text,

2) make that as drop down

3) then bring the data from the other list and on the form load bind the data.

4) so item stored the date in a single value but user can select the data from the looked up list

through SPD

1) removed the form field from where you are looking the data from the newform.aspx

2) create SPDROPDOWN control rename the IDs and all the data as per the FORM FIELDS

3) create a connection for the look up table ( you can filter also in connection like active lookup values)

4) add this connection data to SPDROPDOWN

5) save the file. it works as expected

 

Sorry I am not putting any snapshot. if anybody wants i can put those things.

thank you. happy coding OOTB