Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created for a client a Reporting Services report that includes images.
When I export the report from Reporting Services into Excel 2003 and then sort, the images sort along with the data. However, in Excel 2007, the images do not sort. I have created some instructions for the client on what to do in order to get the images to sort, but the client is not happy. What is different from 2007 to 2003? Does anyone have any suggestions that can allow the exported Reporting Services report to sort images in Excel 2007 right out of the box? Here is what I have to do now to get them to sort. 9 steps is a bit daunting to the client: 1. Click on any one of the images. 2. Hit Ctrl-Shift-Spacebar on your keyboard. This will select all of the images. 3. Right-click on one of the images and choose €śSize and Properties€ť 4. Click on the Properties Tab 5. Choose €śMove but Dont Size With Cells€ť 6. Click on the Size Tab 7. Under €śSize and Rotate€ť, change Height from 0.7€ť to 0.6€ť. You can do this by clicking once on the down arrow next to the size. 8. Click the close button 9. Click into the Mark Column 10. On the toolbar, choose Data 11. You can now sort and the images will sort with the data. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 and inserted images | Excel Programming | |||
Creating Images in Excel 2007 | Excel Discussion (Misc queries) | |||
imported images in Excel 2007 | Excel Discussion (Misc queries) | |||
How do you print images in excel 2007 | Excel Discussion (Misc queries) | |||
print images in excel 2007 | Excel Discussion (Misc queries) |