Questions tagged [reporting]

A report is a purposeful presentation of data, typically for human review. Automated error-logging is a humble form of reporting; "Business intel" suggests a sophisticated and multi-layered form.

A report is a purposeful presentation of data, typically for human review. The presentation can be designed for immediate export or paper print, or for viewing on-screen as a GUI element. Reporting functions are often an extension of database queries with additional functions for grouping, sorting and formatting.

Automated error-logging is a humble form of reporting; "Business intel" suggests a sophisticated and multi-layered form.

These can be classified as Reporting Services

3692 questions
109
votes
21 answers

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted to user are…
jbcedge
  • 18,965
  • 28
  • 68
  • 89
72
votes
8 answers

What's the best approach to printing/reporting from WPF?

I have an upcoming project which will have to be able to print simple reports from its data. It'll be WPF-based, and I'm wondering which way to go. I know that WPF introduces its own printing technology (based on XPS) which looks quite easy to use.…
Matt Hamilton
  • 200,371
  • 61
  • 386
  • 320
57
votes
4 answers

Where does a published RDL file sit?

When publishing a reporting services report. Where does the actual .RDL file sit on the server? I can redownload the .RDL file via browsing through the report manager? But where is this file situated on the reporting services server? Thanks
user110714
57
votes
2 answers

In a Maven multi-module project, how can I disable a plugin in one child?

I have a maven multi-module project (boy, I've written that opening way too many times on this site). Almost all the modules (that is, the ones that have code in them) should run the maven-site-plugin to generate reports about code coverage, etc. …
Coderer
  • 25,844
  • 28
  • 99
  • 154
57
votes
2 answers

What is MySQL "Key Efficiency"

MySQL Workbench reports a value called "Key Efficiency" in association with server health. What does this mean and what are its implications? From MySQL.com, "Key Efficiency" is: ...an indication of the number of key_read_requests that resulted in…
tylerl
  • 30,197
  • 13
  • 80
  • 113
51
votes
1 answer

Report Builder 3.0 SWITCH expression DEFAULT/ELSE

I am trying to display a different logo based on the users franchise number. Parameter = UserFranNr If the value <> 99 and <> 87, then the embedded image to display is ID0. (Embedded image names are strings.) This works with nested IIFs but seems to…
50
votes
10 answers

How do I get a summary count of missing/NaN data by column in 'pandas'?

In R I can quickly see a count of missing data using the summary command, but the equivalent pandas DataFrame method, describe does not report these values. I gather I can do something like len(mydata.index) - mydata.count() to compute the number…
orome
  • 45,163
  • 57
  • 202
  • 418
47
votes
5 answers

How to generate stats for a GitHub project?

Is there an easy/efficient way to generate some high-level reports for a particular GitHub project? e.g. lines of code committed over time, top contributors, etc
user217562
  • 1,557
  • 2
  • 13
  • 22
47
votes
8 answers

Error while uploading a report

I have create a report using visual studio 2015 with SSDT Tools installed from the following link https://msdn.microsoft.com/en-us/mt186501 The database is on SQL Server 2014. The reports work on my machine however when I try to upload a report on…
Abe
  • 1,879
  • 2
  • 24
  • 39
46
votes
9 answers

Passing a parameter via URL to SQL Server Reporting Services

I'm trying to pass a userId (string) in the URL which will be passed to the database and used by a query in SSRS. base URL: http://blah/Reports/Pages/Report.aspx?ItemPath=MyReport I tried this, but it doesn't…
AwkwardCoder
  • 24,893
  • 27
  • 82
  • 152
45
votes
7 answers

The type or namespace name 'Reporting' does not exist in the namespace 'Microsoft'

I simply get the following error: The type or namespace name 'Reporting' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) after adding this to my code: protected…
dieKoderin
  • 1,552
  • 3
  • 19
  • 39
43
votes
4 answers

How to open an .rdl file in Visual Studio?

I have an .rdl file that I need to open in Visual Studio. When I try to open this file, I got an XML file. However, I am unable to see the designer format. I don't know which version of Visual Studio is used to create this .rdl file. Is it possible…
Anupa Sankar
  • 491
  • 2
  • 7
  • 17
43
votes
7 answers

When to build a separate reporting database?

We're building an application that has a database (yeah, pretty exciting huh :). The database is mainly transactional (to support the app) and also does a bit of "reporting" as part of the app - but nothing too strenuous. Above and beyond that we…
Adrian K
  • 9,880
  • 3
  • 33
  • 59
43
votes
6 answers

SSRS expression to format two decimal places does not show zeros

I am using the following expression to format my value to show only two decimal points. Which Works fine if the value is not 0. However when the value is 0 it does not show 0. eg. Expression used =Format(Fields!CUL1.Value, "##.##") If CUL1.Value…
Abe
  • 1,879
  • 2
  • 24
  • 39
41
votes
11 answers

Reporting (free || open source) Alternatives to Crystal Reports in Winforms

In my winforms project I'm looking for a Crystal Report's like solution free or open source that allows me printing and PDF'ing the Content of a DataSet. ¿Any suggestion or Ideas? I need something simple but fast, Crystal seems very slow for me.…
Jhonny D. Cano -Leftware-
  • 17,663
  • 14
  • 81
  • 103
1
2 3
99 100