EzDevInfo.com

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 be the right time/place to use SWITCH.

(There is a strong possibility that more franchises will use their own logo in future.)

=Switch 
(
Parameters!UserFranNr.Value = "99","ID99",
Parameters!UserFranNr.Value = "87","ID87",
"ID0"
)

I have not found any documentation that explains how to implement a default value using SWITCH.

Is this even possible? If so how? If not any decent alternatives? Thanks

Resources: Expression Examples (Report Builder and SSRS) Define Formula Dialog Box (Report Builder)

Plus here and other forums.

Display history of a single test result in Jenkins - additional plugin or config issue?

Currently our Jenkins server only displays a history/graph for the overall number of passed/skipped/failed tests - I'm assuming that's the behavior out of the box.

If you select a single test, you'll get information for how long the test was failing (assuming it did fail).

However, we'd like to see is a history for that single test across the different builds to identify whether the test has been failing in the past (and when) even though it just passed. If you find a build where it failed, you could click on it, and investigate what might have caused the failure; if it passes again, you could check whether something actually fixed the test, or whether it was failing randomly all along.

Is this something that can be done somehow through the config, or do we need an additional plugin for this? If yes, which one?

Not sure if this makes much difference, but we're using Java (Maven) & TestNG (Surefire).

How do I group data in an ASP.NET MVC View?

In reporting tools like Crystal Reports, there are ways to take denormalized data and group it by a particular column in the data, creating row headings for each unique item in the specified column.

If I have this:

Category1    Data1
Category1    Data2
Category1    Data3
Category2    Data4
Category2    Data5
Category2    Data6

The reporting software will group it like this:

Category1
      Data1
      Data2
      Date3
Category2
      Data4
      Data5
      Data6

Is there a way to do this in an ASP.NET MVC view, perhaps using a simple linq phrase or linq extension method with a foreach or a nested foreach?

Sql Server Services - Overview anyone?

In Short

I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer.

The Scoop

I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These have usually been based on SQL server and a range of custom tables and views.

Just recently I have had the need to do some reporting that goes a little beyond the straight forward, and so I have started to look into SQL Server Reporting Services (SSRS). In doing so I feel like i have opened up Pandora's Box.

There is reporting services, integration services, Analysis services, Business intelligence, etc etc. This has got me wondering what they all do, and if I could (or should have been) leveraging these tools to do some of the heavy lifting for .net applications.

My immediate research efforts on Microsoft have stifled me with impenetrable marketing and business speak. My Google searched have turned up no comprehensive overview of what these tools are, or they fit together, or even which tool should be used when. One of the biggest problems i am having comprehending the options is that they all seem kind of the same to me!

So, all of this to say, if some kind sole could set me straight and point me in the right direction, I would be very grateful :)

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

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. Thanks in advance.

I'm aware of this question but it seems to me there are just answers related to java

Easy to use web-based reporting tool [closed]

I'm looking for recommendations for an easy to use reporting/business intelligence tool that can interface with an sql server or access database. It can be web-based or a desktop tool.

Ideally it would be freeware or low cost, and easy to use for users who are not that technically savvy (below the level of someone who can generate reports and complicated queries in Access).

Any tools I've seen so far (such as Crystal Reports) are either too expensive or too complicated to use for non-power users.

php reporting tools [closed]

I have been developing with PHP for over ten years (since PHP version 3) and have used many different programming languages.

But I have never seen any PHP reporting tools. I am looking for something similar to

• Jasper Reports
• Crystal Reports
• Fast Report
• Quick Report
• Report Builder

I am not looking for:

• FPDF
• PHPExcel
• TCPDF

There must be a report designer and report library.

Has anyone seen PHP reporting tools comparable to those I mentioned?

What are the drawbacks with Jasper Reports? [closed]

I'm evaluating report engines for a Java desktop application. I need to print receipts, invoices and reports. I'm looking at Jasper Reports since it seem to be the most popular reporting engine in the Java world. What are the biggest drawbacks and disadvantages with using it in a small business system?

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 actual key_reads.

Ok, so what does that mean. What does it tell me about how I'm supposed to tune the server?

What is your reporting tool of choice? [closed]

Every project invariably needs some type of reporting functionality. From a foreach loop in your language of choice to a full blow BI platform.

To get the job done what tools, widgets, platforms has the group used with success, frustration and failure?

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

F# and "enterprise-level" reporting

Based on your actual experience, a whitepaper or other respected referenceable study, is F# currently a viable tool for corporate-/enterprise-level reporting?

^{Attention: Before voting to close this question as "not constructive", please read the bit at the bottom.}

Background
I currently work at a large corporation which makes heavy use of many different reporting tools, including (but hardly limited to) SAS, Cognos, SSRS and even a good smattering of COBOL. Each tool has its rightful place and many of them are, in most respects, equivalent in feature set, etc. Most of our tools are able to output to PDF, Excel and databases relatively easily and in those cases work wonderfully.

Unfortunately, my organization, like many, makes use of Excel spreadsheets and, love it or hate it, we spend many hours writing .NET console applications to extract information from and insert information into Excel spreadsheets. (I'm not interested in arguing the merits or detriments of this approach. It is what it is and there's no way I can change it.)

As great as the reporting technologies listed above are, they fall flat when it comes to advanced ETL from or into spreadsheets. They just weren't designed for it and while they are perfectly adept at formatting a report as an Excel spreadsheet, they aren't very good at updating an existing spreadsheet or extracting data in some very specific way (extract only values highlighted in red, for example). So we end up writing a LOT of .NET console applications to do this bit. (Again - not interested in debating the approach. It is what it is. I know - I don't like it either.)

.NET is, in my opinion, a fantastic framework and flexible enough to handle almost any programming task, so we could theoretically handle all of the reporting in .NET. But - trying to handle all of the reporting in .NET takes too long. We have to write all the boilerplate stuff ourselves. I like to leverage the power, simplicity and robustness of the actual reporting tools we already have.

So, we end up writing two applications for a single task - for example, a SAS job to load the data from multiple data sources, do the transformations and store the result in a permanent or temporary location, and a second .NET job to take the results and load them into the spreadsheet. (I know.)

The Point
I've been seeing and hearing a great deal about F# in the past couple years and I've dabbled in it a bit myself. I learned OCAML in college and I love functional programming. When called for, I'd love to do all the programming for a particular report on a single platform (if not a single language). The question, though, is whether the F# language and the .NET framework are fully ready for enterprise-level reporting - and I'm talking reports that must be run accurately and efficiently. Microsoft is certainly selling it hard, but I want to know if anyone with experience in other reporting technologies has actually tried it in a production environment. How does it compare with other reporting technologies and can it be easily integrated into a corporate environment? How did you address security? Done right, what kind of memory-profile does F# require (we're talking millions of records)? Does it process tabular data well? Is it efficient? How easy is it to maintain (especially if the code grows)? What kind of third-party add-ons, plug-ins, etc. are required to get something working (or can it do most everything out of the box)? How much work (programming hours, etc) is required compared to other reporting systems (for similar results)?

If you have no experience with F#, or if you use F# exclusively, then I'm not particularly interested in your opinion - I'd like to hear from those who have actually bridged the gap and can relate, from experience, the opportunities and pitfalls in using F# as a reporting engine for big data (millions of records, outputted to a variety of formats).

I've seen a few questions that already cover some of this ground:

• Statistical functionalities of F# (or .NET libraries)
• Your experiences with Matlab/F#/R for data analysis and modeling algorithms

But they are a few years old. Several versions later, is F# up to the task? Or am I a dog barking up the wrong tree?

EDIT

Just for clarity, I am particularly interested in F#'s new information-rich programming. Prior to F# 3.0, it was merely an interesting technology, but F#'s recently added capabilities to use database type providers and its query expressions make it look like a viable alternative to other report authoring technologies. Microsoft is certainly suggesting it is.

An acceptable answer would contain a first-hand account (or a reference to a documented case study) of implementing an enterprise-level reporting engine built in F# and a comparison to another reporting technology of any performance gains or losses, etc. It doesn't have to be too detailed - just enough to convince an average (competent) manager that F# would be an appropriate/inappropriate technology for bulk/batch data processing. Has it been done? Who did it? What were the results? How complicated was the implementation (relative to similar technologies)? Does it perform well?

Why am I asking a subjective question?
Like most good stackoverflow members, I frequently vote to close subjective questions. According to the FAQ, subjective questions should be avoided but are not banned entirely. The FAQ links to six guidelines for great subjective questions which I have tried to follow. Please read those guidelines before voting to close this question.

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 is 2.5670909 the value shown in the report 2.56 (this is brilliant!) If CUL1.Value is 0.006709 no value is shown (I would like it to show 0.00) If CUL1.Value is 0 no value is shown ( I would like to show 0)

Thanks.

Enterprise Reporting Solutions [closed]

What options are there in the industry for enterprise reporting? I'm currently using SSRS 2005, and know that there is another version coming out with the new release of MSSQL.

But, it seems like it might also be a good time to investigate the market to see what else is out there.

What have you encountered? Do you like it/dislike it? Why?

Thank you.

Best ASP.NET reporting engine with custom reports creation ability

We need to choose the reporting engine for our ASP.NET application. The main functional requirement is an ability for end users (not programmers, just normal users) to create custom reports. We will be using SQL Server as a database so I am aware of some options: SQL Server Reporting services, Crystal Reports, Active Reports, even WindwardReports.

But frankly speaking I've never used any of those except Reporting services and it's quite difficult to choose which one suits the best to customer needs of custom reports creation. Is it possible to get some pros and cons for these options or at least your advice on what would be better to use in this case. Thanks a lot.