Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Office
125 results found
Build your apps for
Office
2013 and SharePoint 2013 with the help of NAPA.
It’s really interesting and exciting to see these kinds of new technology and tools by the Microsoft. It’s my great opportunity that I had a change to attend one of the first Asian Dev-Camps related to ‘Build apps for office and SharePoi
Author:
Anil
Date: 3/29/2013 Section:
Blog
tags :
NAPA
,
Office 2013
,
SharePoint 2013
,
Visual studio 2012
,
Windows Azure
Probelm with Aggregated data not appearing on parent Group in SSRS reports
Hi All, I am creating Drill Down report having heirarchy Region->Country->Office->State->City->EmplId and having parameter for all levels the name of parametes are P_REGION,P_COUNTRY,P_OFFICE,P_STATE,P-CITY and using this parameter in where
Author:
faiz_bidn
Date: 9/25/2012 Section:
Forum
tags :
Drill down
,
Grouping
,
Groups
,
no data probelm. aggragation not brging data
,
ssrs 2008
An open letter to Microsoft - BI needs to be a single message across your products
An open letter to Microsoft – BI challenges. To preface this letter, let me just say that I have drunk the kool-aid, just like the Merry Pranksters drank Ken Kesey’s koolaid ( http://en.wikipedia.org/wiki/The_Electric_Kool-Aid_Acid_Test ), and
Author:
MarkGStacey
Date: 4/28/2012 Section:
Blog
tags :
Office
,
PerformancePoint
,
PPS
,
Report Builder
,
Reporting Services
,
sharepoint2010
,
SQL Server
,
SQL2012
,
SSRS
,
Visio
Show/Hide
Office
Ribbons
Yesterday I was in a presentation and because we wanted to see most of the screen, there was a requirement to hide the top ribbon see the image below. I suggested to double click on the menu item to hide the ribbon. That is, double click either on Home, I
Author:
indupriya
Date: 11/24/2010 Section:
Blog
tags :
Access 2007
,
Excel 2007
,
Outlook 2007
,
Powerpoint 2007
,
Word 2007
,
Office ribbon
Office
2013 Preview – Enabling PowerPivot in Excel
With the Office 2013 announcements today I was excited to download and get my hands on the tools. Because this is still a customer preview we’re bound to find things here and there that aren’t functioning as expected when experimenting with th
Author:
DevinKnight
Date: 7/17/2012 Section:
Blog
tags :
Office2013
,
PowerPivot
SSRS Action to Open
Office
Communicator
On a recent reporting project I was assigned to create a Project Management Dashboard. Part of the specs for the report was to be able to click on the Project Managers name in the dashboard that would launch Office Communicator (OCS). In order to achieve
Author:
ChrisAlbrektson
Date: 4/22/2011 Section:
Blog
tags :
SIP
,
SIP fo
,
SSRS
,
SSRS action for Communicator
,
SSRS action for OCS
,
Open MS Communicator from SSRS
BI Components of
Office
2007 -- Part 1
BI Components of Office 2007 We have built a datawarehouse in our sql server 2005 database and built some cubes in Sql server analysis services using sqlser server integration services. Now I wanted to utilise the BI capabilities of office 2007 to provide
Author:
indupriya
Date: 5/18/2010 Section:
Blog
tags :
Excel 2007
,
SSAS
PowerPivot for Excel 2013
The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview . Naturally I am eager to see all the BI features in both Office and SharePoint. If you have ev
Author:
BradSchacht
Date: 7/17/2012 Section:
Blog
Create Access 2010 File
With which version of SQL are you trying to build this? Are you going the 32-bit or 64-bit route? Which version of Office do you have installed and are you trying to use the ACE drivers? I have about an hour later in the day - I'll try to set up a test an
Author:
KeithHyer
Date: 1/26/2012 Section:
Forum
tags :
accdb
,
Access2010
,
ACE
How can i write this selected cell value into another predefined cell in Excel using script component or other tools
How can i write this selected cell value into another predefined cell in Excel using script component or other tools? I have installed Office 2003Primary Interop Assemblies and Add Reference Microsoft Office 11 Object Library but Imports Microsoft.Office.
Author:
bsingha
Date: 1/16/2012 Section:
Forum
Notes from PowerPivot Example
We had a bit of an impromptu session today during today's webinar. You can find the recording for that session at http://www.PragmaticWorks.com and click Webinars. Here's my scripted demo which shows DAX, PowerPivot and more from the AdventureWorksDW2008(
Author:
BrianKnight
Date: 5/25/2010 Section:
Blog
tags :
PowerPivot
,
SQL Server 2008 R2
,
Power Pivot
Free Business Intelligence Workshop
If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are below: Unlock your Data with the Microsoft Business Intelligence Platform Event Details: November 8, 2011 Registration at 8:00am Microsoft O
Author:
PatrickLeBlanc
Date: 11/1/2011 Section:
Blog
tags :
Project Crescent
Microsoft
Office
12.0 Access Database OLE DBO Connection Manager Error
If you have ever tried to use a Microsoft Office 12.0 Access Database Engine OLE DB Provider Connection Manager to pull data from a .xlsx file, you may have received the following error message when you try to test your connection... If this is the case,
Author:
kylewalker
Date: 12/9/2010 Section:
Blog
tags :
Unrecognized database format Error
,
xlsx Source
,
SSIS
Enable Macros in Access 2007
We have a couple of access programs that we use for data conversions. These programs convert the csv files that are generated from our CRM to a fixed file format that is then uploaded to interface with other government institutions. With the introduction
Author:
indupriya
Date: 11/30/2010 Section:
Blog
tags :
Enable macros
,
Macros
,
Access 2007
SQL 2011 Denali New SSIS Parameters
Normal 0 false false false false EN-US X-NONE X-NONE SQL 2011 Denali New SSIS Parameters SQL 2011, code name Denali, has some great new features for SSIS. One of the most powerful features is parameters. These are a lot like variables in the package. But
Author:
MikeDavis
Date: 2/22/2011 Section:
Blog
tags :
denali
,
sql 2011
,
ssis
Analysis Services Webinar Recording and Q&A
I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013. If you weren’t you can now download the recording here . Because I covered new material all the way to the end of the webinar i thought I'd also an
Author:
DevinKnight
Date: 4/2/2013 Section:
Blog
tags :
Analysis Services
,
Multidimensional
,
PowerPivot
,
Tabular
Adding expression to Derived Column Transformation
Try setting this up ( I'm assuming SQL 2005 - with VB.Net being your scripting language ). 1) 3 string variables: PathToExcel maybe set it to C:\Temp\ -- copy 3 or 4 xls files to this folder. ExcelFileMark This might be *.xls for office 2003 or *.xlsx for
Author:
KeithHyer
Date: 4/12/2011 Section:
Forum
tags :
directory
,
file list
,
file system
,
script task
,
latest file
Upgrade SQL/SSRS 2008R2 to 2012 SP1 SSRS Excel Rendering Issue
I'm testing upgrading SQL/SSRS from SQL 2008 R2 SP2 to SQL 2012 SP1 (11.0.3349). Most of my reports' data source is a Dynamics NAV 2009R2 SQL DB where most of the number fields are decimal(38,20). I'm finding that when I have a zero value in a column on a
Author:
tkruse
Date: 3/20/2013 Section:
Forum
tags :
excel 2010
,
render
,
SSRS 2012
,
upgrade
,
xml errors
Create filter that displays the last 3 years based on value in TIME dimension
Hey KT, I'm guessing this is in PerformancePoint? If so there are two ways you may do this: You could create time intelligence filter using and an expression that looks like this - (Year -6) http://office.microsoft.com/en-us/performancepoint-server/about-
Author:
DevinKnight
Date: 2/14/2012 Section:
Forum
tags :
PerformancePoint
,
Scorecards
Loading Excel
There is but Excel has a row limitation, unless you're planning on smashing all those rows across multiple tabs (worksheets). Here's link to limits: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx . If you're
Author:
sqlchicken
Date: 9/21/2012 Section:
Forum
tags :
PowerPivot
Imports Microsoft.
Office
.Interop.Excel does not work in Script Component in SSIS 2008
Dear All, I am writing code in the Script component in VB.NET (Business Intelligence Development Studio) I typed Imports Microsoft.Office.Interop.Excel But Intellisense does not recognize anything after Microsoft. A green squiggly appears under the statem
Author:
bsingha
Date: 1/16/2012 Section:
Forum
Read a specific cell from Excell and write in a specific cell in another defined excell cell in SSIS
Dear Marco Francisco, Thanks a lot. Your reference working very well. Imports Microsoft.Office.Interop.Excel is now working. But when run the SSIS package (VB.NET 2008 Office 2003) there is an error occured- System.IO.FileNotFoundException: Could not load
Author:
bsingha
Date: 1/17/2012 Section:
Forum
tags :
Could not load file
Could not load file or assembly Interop.Microsoft.
Office
.Interop.Excel -Script Task for reading a cell from Excel 2003
Dear All, I am using Windows Server 2003, Office 2003, SSIS 2008, VB.net and Primary Interop Assemblies (PIA) is already installed. Imports Microsoft.Office.Interop.Excel is working. But when run the SSIS package ( Script Task for reading a cell from Exce
Author:
bsingha
Date: 1/17/2012 Section:
Forum
tags :
script task
SSIS Clarification: Loading Data from db to Excel
It looks like column widths are limited to 255 characters in Excel: Correction, looks like you can have 32,767 characters in an Excel cell http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx Take a look at this fo
Author:
sqlchicken
Date: 7/15/2011 Section:
Forum
tags :
SSIS
,
excel
Table of contents
Normal 0 false false false EN-US X-NONE X-NONE Hi, I am struggling with creating Table of contents for ssrs Report. Am using Sql Server 2008 R2. Could you please help me on this. Thanks & Regards Ravi kumar
Author:
ravimani
Date: 5/13/2011 Section:
Forum
tags :
ssrs
,
TOC
Page 1 of 5 (125 items)
<< Prev
1
2
3
4
5
Next >>
Go to page:
[Go]