EzDevInfo.com

report interview questions

Top report frequently asked interview questions

Something like Crystal Reports for PHP?

I'm looking for something that works in PHP and is similar to crystal reports. I basically need to have a layout setup that means I can output invoices just by inserting the data, and then send it to a printer.

The closest I've found so far is PDFB, but It's a bit of a pain as it needs to have precise positioning.

I'd like to have something that could generate an invoice based on a template (preferably XML based) and then output it to a form easy for us to print (PostScript would be nice!)

It needs to have support for barcodes too (though these can be generated as a GD image)

Another requirement is that this must be FLOSS


Source: (StackOverflow)

App shutdown with EXC_RESOURCE, WAKEUPS exception on iOS 8 GM

Does anyone know what this kind of exception is on iOS 8?

=== from crash report ===

Exception Type: EXC_RESOURCE
Exception Subtype: WAKEUPS
Exception Message: (Limit 150/sec) Observed 206/sec over 300 secs
Triggered by Thread: 14

Seems to only happen on iOS 8... Our app is shut down quite randomly at arbitrary intervals with this exception..

Any clues are welcome. Thanks!


Source: (StackOverflow)

Advertisements

How can I generate an HTML report for Junit results?

Is there a way to (easily) generate a HTML report that contains the tests results ? I am currently using JUnit in addition to Selenium for testing web apps UI.

PS: Given the project structure I am not supposed to use Ant :(


Source: (StackOverflow)

Updates units in new iTunes Connect reports

The 'Sales and Trends' section in iTunes Connect was heavily redesigned. The info popup for Units says

"By default, updates and previous purchase downloads are excluded."

But how can I switch from 'sales' to 'updates' as from now ?


Source: (StackOverflow)

Remove data.frame row names when using xtable

OK, I admit this one is a bit uptight (read: "stupid"), and I assume it's quite easy too. I'm writing a report and I want to use xtable package for LaTeX table generation (note that memisc package does the job, but say I want to do this solely with xtable).

Let's use standard mtcars dataset and reshape package:

mdtf <- melt(mtcars, id.vars = c("am", "cyl"), measure.vars = c("mpg", "hp", "wt"))
( res <- cast(mdtf, am + cyl ~ variable, mean) )
  am cyl      mpg        hp       wt
1  0   4 22.90000  84.66667 2.935000
2  0   6 19.12500 115.25000 3.388750
3  0   8 15.05000 194.16667 4.104083
4  1   4 28.07500  81.87500 2.042250
5  1   6 20.56667 131.66667 2.755000
6  1   8 15.40000 299.50000 3.370000

If I wrap this inside xtable, I'll get row names (1..6):

xtable(res)
% latex table generated in R 2.13.0 by xtable 1.5-6 package
% Fri Mar 25 09:40:12 2011
\begin{table}[ht]
\begin{center}
\begin{tabular}{rrrrrr}
  \hline
 & am & cyl & mpg & hp & wt \\ 
  \hline
1 & 0.00 & 4.00 & 22.90 & 84.67 & 2.94 \\ 
  2 & 0.00 & 6.00 & 19.12 & 115.25 & 3.39 \\ 
  3 & 0.00 & 8.00 & 15.05 & 194.17 & 4.10 \\ 
  4 & 1.00 & 4.00 & 28.07 & 81.88 & 2.04 \\ 
  5 & 1.00 & 6.00 & 20.57 & 131.67 & 2.75 \\ 
  6 & 1.00 & 8.00 & 15.40 & 299.50 & 3.37 \\ 
   \hline
\end{tabular}
\end{center}
\end{table}

Now, is there any chance that I can avoid this (in one-liner, if possible)?


Source: (StackOverflow)

Fast query runs slow in SSRS

I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up to 5 minutes to complete. This is not just happening on the first run, it happens every time. Additionally, I don't see this same problem in other environments.

Any ideas on why the SSRS report would run so slow in this particular environment?


Source: (StackOverflow)

Crystal Reports vs. Microsoft SQL Server Reporting Services

I am developing a WPF application, and I need your advice.

I have to generate reports in my application. What should I use, Crystal Reports or SQL Server Reporting Services? Which one is better, and why?


Source: (StackOverflow)

How can I prevent Java from creating hsperfdata files?

I'm writing a Java application that runs on Linux (using Sun's JDK). It keeps creating /tmp/hsperfdata_username directories, which I would like to prevent. Is there any way to stop java from creating these files?


Source: (StackOverflow)

Generating a report by date range in rails

How would you go about producing reports by user selected date ranges in a rails app? What are the best date range pickers?

edit in response to patrick : I am looking for a bit of both widget and active record advice but what I am really curious about is how to restfully display a date ranged list based on user selected dates.


Source: (StackOverflow)

How to pass main report data source to subreport (JasperReports)?

I'm using JasperReports and I fill the JRDataSource for ther report. Now, I want to pass the main REPORT_DATA_SOURCE to the subreport. How can I do this?

As far as I know the REPORT_DATA_SOURCE is a consumable object, so it can only be used once, right?. Can I copy this data source and pass it?

BTW: I use iReport for creating the layout.


Source: (StackOverflow)

Create a parameter in rdlc report

I am a newbie to rdlc reports. I need to create a parameter that i will pass to a subreport. However I cannot find where in the report designer to create parameters.I am using VS 2010

Thanks in advance


Source: (StackOverflow)

Viewing Code Coverage Results outside of Visual studio

I've got some unit tests, and got some code coverage data. Now, I'd like to be able to view that code coverage data outside of visual studio, say in a web browser. But, when I export the code coverage to an xml file, I can't do anything with it. Are there readers out there for this? Do I have to write an xml parser and then display it how I want it (seems like a waste since visual studio already does this.) Seems kinda silly to have to take a screenshot of my code coverage results as my "report" Suggestions?


Source: (StackOverflow)

How to limit RDLC report for one page in a PDF ?

I have a RDLC report and I am displaying it on the Report Viewer Control in my front end application. I am able to view the report perfectly.

But the problem arises when I try to export the report to a PDF (using the built-in option).

I print the report in 3 pages whereas my client wants it to be in a single page. I can't figure out the reason for it as in my report viewer I see only one page but in a PDF there are 3 pages.

Can something be done about it so that I can control the size of the report?


Source: (StackOverflow)

JUnit output in Maven reports

I am using Maven for my project and have following question:

I want to see the logging output of my JUnit tests (log4j, System.out, whatever) in test reports. Do you have any idea how to achieve this?

Thanks ;-)


Source: (StackOverflow)

MySQL open source reporting services

I am currently working on a project where reporting services are required. The database back end is built using MySQL and I would like to have something with similar functionality to say SSRS.

Does anyone have any experience with an open source solution for this? Any they would particularly recommend? It would have to be accessed via a browser.

Thanks,

David


Source: (StackOverflow)