+2
Hi,
Anyone out there know how to access K2 OOTB reports without going through SSRS. Based on the new release of K2 4.5, standard OOTB reports will be hosted inside the workspace instead of referencing from SSRS.
http://help.k2.com/en/KB001195.aspx
Thanks in advance.
+10
Hi,
The reports are now hosted inside a DLL (SourceCode.Workspace.OOBReports.Resources.dll).
There is a tool on K2Underground which you can use to extract these so that you can get them into RDL format. Once in RDL format you can rehost these in the ReportViewer control on your web page.
Here is the link to the tool:
http://www.k2underground.com/groups/k2_rdl_export_tool/default.aspx
Hope this helps!
+13
Does this mean if I can only use VS2008 and BI component to create report using SourceCode data provider and retrieve SmartObject data? (to provide custom reporting interface)
From K2 KB
The K2 for Reporting Services component requires SSRS to run in native mode and is not supported in integrated mode.
It provides for the following:
From MS KB
Microsoft Visual Studio 2010 does not support Business Intelligence
Development Studio Integration Services, Report Services and Analysis
Services projects for SQL Server 2008 and SQL Server 2008 R2. To work
around this issue, you can install Visual Studio 2008 alongside Visual
Studio 2010 on the same machine and then open the Business Intelligence
Development Studio projects in Visual Studio 2008.
+2
We also thought of this approach which is to extract these RDL files but it would be best to redirect reports directly to the exact URL K2 workspace is using. We don't have any custom reports that relies on K2 data, even if there is we could just create our own data source and query K2 databases. Although there is no official announcement, we are not sure how long these OOTB reports are supported on future upgrades.
The challenge we are now facing is how to extract the exact URL for instance specific activity reports. The view flow page is easily accessible just like before.
+10
Hi Peter,
I don't think you will need Visual Studio 2008 if you are using the exported RDL files. You need to convert these files to RDLC format and then you can use them in Visual Studio 2010 in the ReportViewer control. The following link explains how to convert the RDL files to RDLC, and should do the trick: http://msdn.microsoft.com/en-us/library/ms252109(v=vs.80).aspx
If you need to customize the reports then you need to install the Business Intelligence Studio from the SQL Server 2008 (or R2) DVDs. This installs a version of Visual Studio 2008 which can only be used to design reports and will allow you to customize it. You can use this to generate new RDL and RDLC files which you use inside VS 2010 using the ReportViewer control.
Hope this helps!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.