How do you write a query where only a select number of rows are returned with either the highest or lowest column value.
i.e. A report with the 5 highest salaried employees?
The windows installed on my machine has the locale en_AU and that's what Japer uses. I already tried changing the locale of all users, including the Administrator but it still uses en_AU.
How can I change that locale? Is it possible to change the REPORT_LOCALE parameter on my report?
I received such message in erlang condose at first@localhost node
=ERROR REPORT==== 1-Jan-2011::23:19:28 ===
** Node 'second@localhost' not responding **
** Removing (timedout) connection **
My question is - what is timeout in this case? How much time before causes this event?
Howto prevent this "horror"? I can restore\recover to normal work only by restart node...
But what is the right way?
Thank you, and Happy New Year!
hello
I am trying to use oprofile to generate call graph.
Compiler is g++, platform is linux x86-64, linker is gfortran
C++ code is compiled with -fno- omit-frame-pointer.
oprofile is started with --callgraph=25.
report I run with --callgraph.
the call graph is produced but it's only includes self time, which is not much use
what am I missing?
Hello,
Say I have a test like:
void TestSomething(int someParam)
{
// Test code
}
I would like to execute this test with a set of "someParam" values. I could write explicit [Test] fixtures calling TestSomething() with the parameters, which means having N methods for every TestSomething() method. I could write another [Test] method looping on "someParam" values and calling TestSomething(), it means 2 methods for every test, and the test report is not as good as with individual TestSomethingWithXValue() methods.
So, is there any way to programmatically generate fixtures for every test methods and input values?
Sorry for my english :).
I have a windows service. Service report some excel files weekly. But i got a"OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory" Ole Db error. Service use SQl Server 8.00.194 and it link another SQL Server. I do not know why i receive this error. Thanks for help.
Is it possible to report all the observers of the 'ready' events. I have a page where something is happening twice, and i'm trying to chase it back to the source.
Hi,
I have an ajax web application(asp.net). some of users report the a problemt that when they work sometimes by system ( and pages who have ajax calls) their connection to server will intrupt and just a blank page they will see.
they can't browse any other page on my site while they close all open browsers and reopen site.
Is there any idea about this and how can I fix it?
thanks
Mehdi
Why can WinMain have two return types?
If I remove it,will report this warning:
warning C4007: 'WinMain' : must be '__stdcall'
Or I'm reading int WINAPI wrongly?
Hi,
I am using jasperreport and trying to pass an alternate report runner.
• net.sf.jasperreports.engine.fill.JRThreadSubreportRunner: The initial thread-based
implementation
• net.sf.jasperreports.engine.fill.JRContinuationSubreportRunner: A Javaflow-based
implementation
I am using the second one (for the reason, it runs on tomcat server, and creating threads wouldn't be good while writing subreports). The second one depends on commons-javaflow which is a sandbox version.
Not sure if I should use it, Could somebody suggest a better way.
Thanks
Hi. I am new to grails and jasper reports. Please help me with the issue.
I am trying one example on how to save in excel format the data that we display in grails. I am able to save as excel but not able to get anything inside excel sheet after opening it, not even columns. Refer the link http://www.wysmedia.com/2009/05/dance-with-dynamic-jasper-report/ for the example I am trying.
Many thanks.
I'm trying to add a Menu Item to the Run Menu in Eclipse via a plugin.
However, I only want this Item to appear when I'm in the "Report Design" perspective (this is for BIRT).
Secondly, (if possible) I'd like the menu item to be only enabled if the extension of the open file is .rptdesign.
I'm not having any luck using either of the visibility or visibleWhen elements in the plugin.xml
Any hints appreciated,
Ro
Hi I'm having a production database and its replicated report database. How to shrink the transaction log files in the production database as the log file size is increasing. I had tried DBCC SHRINKFILE and SHRINKDATABASE commands but it does not work for me. I can't detach and shrink and attach back as the db in replication. Please help me in this issue.
Does anyone have experience developing with ESQL/C for INFORMIX-SQL, as in calling C funcs within "Perform" screen generator and "ACE" report writer?
I have ISQL without ESQL/C. I experimented compiling a perform screen, where in the instructions section I put "ON BEGINNING CALL userfunc() END" and although I don't have
ESQL/C, the Perform screen successfully compiled without errors!.. Apparently, the compiler didn't reject the C call even though there's no ESQL/C or C program linked.
Is there a way in word to save a selected portion into the database as range object.So that we can later retrieve it .
It is required to generate a report in word ,the section needs to be repeated many times.
I have searched net for quite some time but not much material is found.
thanks.
I get an "unrecognized HTTP method" when trying to do a REPORT request using httplib and gae. Is there a workaround available? An httplib patch for gae? Do you I have to find another host in order to do this natively?
According to the docs, only certain fetch actions are valid: GET, POST, HEAD,
PUT, and DELETE: http://code.google.com/appengine/docs/python/urlfetch/
fetchfunction.html
Hi everyone, this problem has me head going round in circles at the moment and i wondering if anyone could give any pointers as to where im going wrong.
Im trying to produce a SPROC that produces a dataset to be called by SSRS for graphs spanning the last 6 months.
The data for example purposes uses three tables (theres more but the it wont change the issue at hand) and are as follows:
tbl_ReportList:
Report Site
----------------
North abc
North def
East bbb
East ccc
East ddd
South poa
South pob
South poc
South pod
West xyz
tbl_TicketsRaisedThisMonth:
Date Site Type NoOfTickets
---------------------------------------------------------
2010-07-01 00:00:00.000 abc Support 101
2010-07-01 00:00:00.000 abc Complaint 21
2010-07-01 00:00:00.000 def Support 6
...
2010-12-01 00:00:00.000 abc Support 93
2010-12-01 00:00:00.000 xyz Support 5
tbl_FeedBackRequests:
Date Site NoOfFeedBackR
----------------------------------------------------------------
2010-07-01 00:00:00.000 abc 101
2010-07-01 00:00:00.000 def 11
...
2010-12-01 00:00:00.000 abc 63
2010-12-01 00:00:00.000 xyz 4
I'm using CTE's to simplify the code, which is as follows:
DECLARE @ReportName VarChar(200)
SET @ReportName = 'North';
WITH TicketsRaisedThisMonth AS
(
SELECT
[Date],
Site,
SUM(NoOfTickets) AS NoOfTickets
FROM tbl_TicketsRaisedThisMonth
WHERE [Date] >= DATEADD(mm, DATEDIFF(m,0,GETDATE())-6,0)
GROUP BY [Date], Site
),
FeedBackRequests AS
(
SELECT
[Date],
Site,
SUM(NoOfFeedBackR) AS NoOfFeedBackR
FROM tbl_FeedBackRequests
WHERE [Date] >= DATEADD(mm, DATEDIFF(m,0,GETDATE())-6,0)
GROUP BY [Date], Site
),
SELECT
trtm.[Date]
SUM(trtm.NoOfTickets) AS NoOfTickets,
SUM(fbr.NoOfFeedBackR) AS NoOfFeedBackR,
FROM Reports rpts
LEFT OUTER JOIN TotalIncidentsDuringMonth trtm ON rpts.Site = trtm.Site
LEFT OUTER JOIN LoggedComplaints fbr ON rpts.Site = fbr.Site
WHERE rpts.report = @ReportName
GROUP BY trtm.[Date]
And the output when the sproc is pass a parameter such as 'North' to be as follows:
Date NoOfTickets NoOfFeedBackR
-----------------------------------------------------------------------------------
2010-07-01 00:00:00.000 128 112
2010-08-01 00:00:00.000 <data for that month> <data for that month>
2010-09-01 00:00:00.000 <data for that month> <data for that month>
2010-10-01 00:00:00.000 <data for that month> <data for that month>
2010-11-01 00:00:00.000 <data for that month> <data for that month>
2010-12-01 00:00:00.000 122 63
The issue I'm having is that when i execute the query I'm given a repeated list of values of each month, such as 128 will repeat 6 times then another value for the next months value repeated 6 times, etc. argh!
I'm working on the MVC app where I've to generate the report in the form of HTML page. If the user click the print icon, I've to show the HTML page to user. If the user click on email icon, I've to send email with same HTML page attachment. I'm trying to find a way where I can use the same code to generate the HTML in both cases of email and print. Please provide your suggestions.
Hi, I am passing a List as a JRBeanCollectionDataSource to a Subreport, I was wondering how you retrieve the integer value and display on the report. Your help is greatly appreciate.
I have two dates:
toDate (user input in MM/dd/yyyy format)
currentDate (obtained by new Date())
I need to compare the currentDate with toDate. I have to display a report only when the toDate is equal to or more than currentDate. How can I do that?
Hi,
I would like to create a powershell script generating a report showing all compressed files/folders on remote servers. By compressed files I mean files compressed using the buildin Windows Compression utility, not zip. But I have a hard time figuring out how to localize the compressed files. Should I go with WMI or?
Thanks
Frank
I have developed an App for the Amazon Kindle Fire HD.
While distributing I got a report from amazon that its not running on almost all Kindle devices and a blackscreen is displayed. They send me a logcat log file and I found out that it's not possible to load some assets directly from APK file (accessing via C++ and zlib).
Everything is running fine if I start it via Eclipse.
Any idea whats going wrong?
Thanks!
Hello all,
While putting an image element in PDF report, how can we give the alt description or similar kind of description for that image? The idea is to read the description when some screen reader is used to read the PDF. Currently, the reader (JAWS) says just 'graphic' when encountering an image in the PDF.
Thanks!
I'm generating an HTML report by C# to print pairs of files in a table which has 3 columns: the first two columns used for the filenames and the 3rd column is a hyperlink Compare - I want this link to run WinMerge to compare to two files and I currently don't know how to do it. Please help!