天道酬勤,学无止境

ssrs-2012

为子报表 (SSRS) 启用 EnableExternalImages 属性(Enable EnableExternalImages property for a subreport (SSRS))

问题 我有一个主要报告,其中包括许多子报告。 在 eah 子报告中,我有一个从外部加载的图像。 我的主报告加载正常,但是当我尝试加载子报告时,我收到一条错误消息:我的子报告中未启用 EnableExternalImages 属性。 我的问题是如何启用它? 我无法通过隐藏的代码访问我的子报告。 谢谢。 回答1 从文件位置加载图像时,您需要在图像值属性的绝对文件路径前指定“文件:”。 ="File:C:\Users\Public\Pictures\Sample Pictures\Jellyfish.jpg" 希望这对其他人有帮助。

2021-09-23 12:09:09    分类:技术分享    image   rdlc   subreport   ssrs-2012

Enable EnableExternalImages property for a subreport (SSRS)

I have a main report wich includes many sub reports. In eah sub report i have an image loaded externally. My main report is loaded fine but when i try to load a subreport i get an error saying that : EnableExternalImages property is not enabled in my sub report. My question is how to enable it? i can't acess to my sub report via code behind. thanks.

2021-09-23 10:09:53    分类:问答    image   rdlc   subreport   ssrs-2012

SSRS 折线图 NULL VALUE - 水平线(SSRS Line chart NULL VALUE - Horizontal Line)

问题 我希望有人可以帮助我。 我创建了一个 SSRS (2012) 报告,随着时间的推移绘制了多个系列。 图表如上所示。 通过使空点值与线本身具有相同的颜色和大小,许多未连接的点很容易“连接起来”。 我已经用 MC113 证明了这一点。 这一切都很好 - 我在网上找到了很多有用的信息来帮助我解决这个问题。 我遇到的问题是领先的(有时是滞后的)水平线(圆圈)。 这是该系列中的数据与其余数据的开始或结束点不同的地方(上面的示例似乎从 2009 年开始,而其余数据从 2005 年开始)。 数据集来自查询,这些点作为 NULL 值返回。 我怎样才能删除这条线——这样在这种情况下——这条线将从 2009 年开始? 我尝试过过滤 - 但这只会截断所有系列(到 2009 年),而不仅仅是过滤 MC113。 有没有人有什么建议? 也许我需要研究如何呈现查询中的数据? 目前这看起来像: 非常感激任何的帮助! 回答1 好的 - 这里变得丑陋......我认为您可能需要在 TSQL 中执行此操作以找到每个系列的值不为空的最低日期,如果日期在此之前,请将线条颜色设置为白色 下面的代码将创建列来确定是否显示数据点 WITH x AS ( Select SampleDate, MC113,MC114,MC46,MC47,MC48 From sometable ) ,MinDates AS ( SELECT

2021-09-19 15:34:38    分类:技术分享    reporting-services   ssrs-2012

SSRS summing values from multiple data sets and sub reports

I have a two data sets and a sub report in my SSRS master report. I need to create a third - Grand total table or matrix that returns a field from each of the data sets and sub report. It would look like this (to start) To start I built a table and added a columns to test this with the following values. (This is in the Grand Total Row) each element alone is in the respective row. =ReportItems!tps_actual4.Value + ReportItems!Textbox1230.Value tps_actual4 comes from one dataset. Textbox1230 comes from a different dataset. the first error that comes up reads: "The value for the DataSetName

2021-09-08 23:00:33    分类:问答    sql   reporting-services   dataset   ssrs-2008   ssrs-2012

Location of configuration file used by Report Wizard Query Builder to source default values for report formatting

When I use the Report Wizard Query Builder to create a report the report is created with a selection of default values. These default values are revealed by right clicking on the Report.RDL file in Solution Explorer and opening it with the XML (Text) Editor. Examples of the default values that are applied by the Report Wizard when creating the Report.RDL file are: Example <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily> Example <Color>#666666</Color> Example <BottomBorder> <Style>Solid</Style> </BottomBorder> I know I can edit these values using the GUI or directly editing the XML file

2021-09-06 05:43:40    分类:问答    reporting-services   ssrs-2012

SSRS Tablix - Each group as group header row

I have a dataset looks like Now I want to create a report where Dept as a group should be on row header for each group. looks like I tried adding Dept as a parent group, but it appears on a column not as a header on top of each group.

2021-09-04 23:41:56    分类:问答    reporting-services   ssrs-2012   ssrs-tablix

How to get multiple pages in same report in SSRS

I created one report, and created a parameter with dimension column, my requirement is when i enter one parameter report should filter with that value when i enter two parameters report should have two pages based on the two parameter values. any section related thing available in ssrs? I referred here, something can be done through list, but list is allowing only test boxes, My report has too many tablixs to show Thanks Regards

2021-09-04 17:14:42    分类:问答    reporting-services   ssrs-2012

如何将范围分配给 ssrs 2012 中的报告变量(How do I assign the scope to a report variable in ssrs 2012)

问题 我是 SSRS (2012) 的新手,来自使用 BusinessObjects 的 loooong 背景,所以有时我很难知道如何搜索正确的术语。 我有一个这样的报告,其中的部分在 tablix 中,而总计在另一个中。 这种布局是必需的(或者这会更简单一些!) Section 1 Date 1 Date 2 Date 3 % of Grand Total Product1 value value Value Value3/GT3 (12%) Product2 value value Value Value3/GT3 (14%) Section Total Total1 Total Total3 Value3/GT3 (7%) Section 2 Date 1 Date 2 Date 3 Product1 value value Value Value3/GT3 (30%) Product2 value value Value Value3/GT3 (22%) Section Total Total1 Total 2 Total3 Value3/GT3 (22%) Grand Total GT1 GT2 GT3 GT3/GT3 (100%) 我很难计算总计的百分比,因为分子和分母不在同一范围内。 我想也许是一个报告变量,但我不知道如何从 BusinessObjects

2021-08-31 23:10:00    分类:技术分享    reporting-services   ssrs-2012

testing mdx query with parameters in SSAS

I'd like to test a MDX query in SSAS. I did the following steps until now. I opened the SQL Profiler and ran the SSRS report I found the query I needed (with parameter values) and selected it sql profiler I pasted the code in ssas Since my SSRS MDX query used StrToMember and StrToSet functions, I surrounded the parameter values with quotes, e.g. “[Measures].[Return On Average Assets]”. The query SELECT { [Measures].[Broj Pristapi] ,[Measures].[Broj Nalozi] } ON 0 , Except ( StrToSet("[Dim Ucesnici].[Naziv Ucesnik].&;[owiefwjhoef]") ,{ [Dim Ucesnici].[Naziv Ucesnik].&[kihebrgk] ,[Dim Ucesnici]

2021-08-31 15:28:41    分类:问答    sql-server   reporting-services   ssas   mdx   ssrs-2012

SSRS 的自动部署选项(Automated deployment options for SSRS)

问题 我的任务是研究使 SSRS 2012 报告的部署过程自动化的方法。 有什么好的工具吗? 我正在考虑按下按钮并部署报告的方法。 谢谢! 回答1 为了部署我们的 SSRS 报告,我们使用了这个可爱的 powershell 项目: https://github.com/timabell/ssrs-powershell-deploy 用法: .\Deploy-SSRSProject.ps1 -path YourReportsProject.rptproj -configuration Release -verbose or you can use the alternate parameter set: .\Deploy-SSRSProject\Deploy-SSRSProject.ps1 -path .\AFS.Reports.rptproj -ServerUrl http://localhost/Reportserver -Folder MyReports -DataSourceFolder "MyReports/Data Sources" -DataSetFolder "MyReports/Datasets" -verbose 完整的部署故事(对我们来说): ssrs-powershell-deploy脚本、.rptproj、.rds、.rdl

2021-08-31 05:10:22    分类:技术分享    reporting-services   ssrs-2012