SSRS: Creating a "Shared Reports" folder in Reporting Services

This blog post covers step-by step instructions on how to create a folder that can be shared between multiple users without being publicly findable (i.e. users will have to share a URL with people who they want to be able to access it).The location of this folder is under the "My Reports" folder for the individual user.Start "Internet Explorer" with an account which has administrative permissions for the particular SQL Server Reporting Services (SSRS)...

Read More

Oracle EBS: Linking GL Lines to AP Invoice Distributions in R12

This blog post gives some guidance as to how to link a GL Journal line in Oracle R12 back to its associated AP Invoice Distribution.NOTE: That this applies ONLY to R12 data - you will not be able to link old (pre-migration) data using this method you will need to have one linking rule for old records and one for new. Just another reason to do a reimplementation!As always the easiest way to look at this is with a picture;The image is click-able for...

Read More

SSRS: Sharing Report Builder 3 Reports Between Users

This blog post provides a fairly quick-and-easy guide to simply sharing a single report between two users.NOTE: If you're sharing a report in your "My Reports" directory you will need to do some fiddly changes with the URL in order to get someone else to actually access the report (they won't simply be able to browse to it).Sharing a FolderBy far the easiest way to share reports is actually to set the permissions on folders so that multiple users...

Read More

Noetix: Adding a Flexfield to a View

This blog post covers a step-by-step guide to adding a Flexfield into a NoetixView. As is the case with all Noetix changes if you do now have NCM (Noetix Customisation Mantenance) these changes will not be supported by Noetix.In order to add a flexfield you need to identify the table and columns used to store the data. Flexfield data will typically be stored in the ATTRIBUTE1..x columns of the table you specify, but this isn't always the case! You only need the "general" information, not down the the segment level.Once you have the table/column...

Read More

Oracle PL/SQL: Working with Materialized Views in a 24/7 Reporting Environment

This blog post gives an outline for a process that will provide users with the Last Update, Next Update, and a "nice message" during a materialized view refresh.The purpose of this blog post is to provide your report writers with a way of identifying whether or not the view is currently being refreshed so they can "try again later". Of course for business-critical up-to-the-second reporting you might not want to be using materialized views at all.Setting...

Read More

Oracle PL/SQL: When are Materialized Views refreshing?

This blog post provides a pieces of SQL which will look for Jobs in the SYS.DBA_JOBS view that appear to be Materialized View refreshes and display the timing information as well as the interval.Execute the following SQL; SELECT dj.job,       SUBSTR(SUBSTR(dj.what, 24, 255),              1,              INSTR(SUBSTR(dj.what, 25, 255), '"')) VIEW_OWNER, ...

Read More

Oracle PL/SQL: Removing an Existing Materialized View

This blog post provides a piece of SQL that you can easily customize to check-for and remove a materialized view if it is present.The SQL is;declare  v_MVName varchar2(30) := 'XXX';begin  for v_Row in (select 'x' from all_mviews am where am.owner = user and am.mview_name = v_MVName) loop  execute immediate    'drop materialized view ' || v_MVName;  end loop;end;In order to target a specific view just replace XXX in the second line with the name of your vi...

Read More

SSRS: Problems Linking To SharePoint Lists When Running in Sharepoint-Integrated Mode

This blog post documents a problem linking to List Items in SharePoint from a SSRS Report Running on a SharePoint integrated-mode server.NOTE: There is currently no solution to this problem. However there is a quick and relatively painless work-around (see below)Prerequisites;SQL Server Reporting Services 2008R2 with SP1 server running in Integrated Mode (with SharePoint 2007)A SharePoint website containing at least one list to use as a source for...

Read More

SSRS: Using &ReportName In SharePoint Mode vs Native Mode

This blog highlights the different values (for the same report) returned in the two modes in which SSRS can be run; Integrated into a SharePoint Farm, and in Native (or stand-alone) Mode.For the purposes of testing I am running Report Builder 3 against 2008R2 SP1 reporting servers. The version of SharePoint I'm using to integrate with is 2007 (with SP2). To browse the website I'm using Internet Explorer 9.UPDATE (from Microsoft): The lowercasing...

Read More