Menu
  • HOME
  • TAGS

Export Moodle report in csv file

php,database,csv,report,moodle

You need a plugin to do this, try one of these: https://moodle.org/plugins/view/report_customsql https://moodle.org/plugins/view/block_configurable_reports If your're wanting to write code to do this, then take a look at lib/csvlib.class.php - that is a helpful wrapper for the standard PHP csv functions....

In BIRT how to change the default time range into week base

java,report,birt

You can compute the first day of the current week in default value expressions of report parameters. For example: BirtDateTime.firstDayOfWeek(BirtDateTime.today()) A simple report example using this kind of "BirtDateTime" expressions and default values here EDIT: In order to extract 7-last-days we can set a such expression for default value of...

Font data could not retrieved PdfSharp/MigradDoc

asp.net-mvc,azure,report,pdfsharp,migradoc

Make sure the Arial font is installed on the server - or use a private font (include the font with your project). The API has changed with version 1.50. A sample for version 1.50 can be found here: http://forum.pdfsharp.net/viewtopic.php?p=8961#p8961 A sample for the API used by version 1.3x can be...

SSRS - Fields working in Data Set, but won't appear in report

sql,sql-server,reporting-services,dataset,report

Try referencing your dataset explicitly, by changing this: =Fields!CustomerName.Value To this: =Fields!CustomerName.Value,"MyDatasetName" ...

Unable to make sub reports with Jasper

java,reporting-services,jasper-reports,report,subreport

I found out that for my situation, it is best to use Tables instead of subreports. This is what I did. Create tables in Detail Band. Create and assign separate data sets to these Tables. Now, eventhough I don't need a query for the main report, I must provide one...

Digital Metaphors Report Builder Surround Group Inside Box

delphi,report,reportbuilder

I'm not sure I have understood your question, but try taking a look at using a region, with all members of the group in it, including the lines/shape used, you can then group the items together.

gwt code splitting with an existing Project

gwt,report,project

Typically, you split your application into logical pieces based on a user behavior, not a code structure. For example, if all users enter View A, and then only some of them go to View B and very rarely users go to View C (e.g. "Settings" view), then View B is...

Artifactory plug in

jenkins,report,jenkins-plugins,artifactory

What you need is the Generic (a.k.a freestyle) build. In this type of build, you can specify which artifacts from your Jenkins workspace should be deployed to Artifactory and under which path. You can deploy an archived results and then by using the archive browsing feature get a fully working...

Export report from report viewer to memory stream and then email report

c#,asp.net,report,reportviewer

I worked this out by loading the local report into a byte array, writing to a file stream and then loading it into memory stream where I could then email. Warning[] warnings; string[] streamids; string mimeType; string encoding; string filenameExtension; byte[] bytes = ReportViewer1.LocalReport.Render( "PDF", null, out mimeType, out encoding,...

Backport Cognos Reports to Durable Model

report,business-intelligence,cognos,cognos-bi,cognos-10

To make all reports "durable" you must re-build them by opening and re-dragging each query subject item into the report in place of the existing item. This resets the reference to the design language name. There is no easy way to do it. However, all future development will be durable....

MS Access 2010 Date range results not as desired

sql,ms-access,report

I would do this in two ways. First is to convert the date value to Double as that is how JET interprets dates. DoCmd.OpenReport "fullreport_rpt", acViewReport, , _ "[Assignment] = '" & lngMyEmpID & "' AND [Start] BETWEEN " & CDbl(Me.DateRange1_txt) & " AND " & CDbl(Me.DateRange2_txt) & _ ,...

How to turn off auto changing of words in reports like Height, Width and Count in Access 2000

ms-access,report,ms-access-2000

Height, Width and Count are reserved words in Access VBA so using them is going to cause you problems. If you are working in a form try changing the text [Form]![Height]+[Form]![Width]+[Form]![Count] and for a report do the same except with [Report]![Height]+[Report]![Width]+[Report]![Count]. It's hard to test this without changing my language....

Graphical representation of test results of phpunit

phpunit,report,summary,phing

What you can do is to use PHPUnit and generate HTML report for test coverage. It's similar to junit log: phpunit --log-junit results/phpunit/junit.xml --coverage-html=results/phpunit/covegare -c tests/phpunit.xml Then you can use Jenkins - Post-build Actions Publish Junit test result report Publish HTML reports This way you will have tests results but...

Triggering MS Access Macro when emailing PDF of Report

ms-access,pdf,report

Move the existing macro from the On Load event to the On Open event of the report.

Visual Studio 2013 Report RDLC with related datasets

visual-studio-2013,report,relational-database,rdlc

To group data in a report: Click the Design tab. If you do not see the Row Groups pane , right-click the design surface and click view and then click Grouping. From the Report Data pane, drag the Date field to the Row Groups pane. Place it above the row...

Date picker in BIRT 3.7 not working

jsp,report,birt

The Web Viewer uses the FramesetFragment.jsp and the HTML view uses the RequesterFragment.jsp. If you update the RequesterFragment.jsp with the same code as what you added to the FramesetFragment.jsp it should solve your problem. You'll still want to add it to the end of the HEAD tag. I'd suggest also...

Filter Access 2010 Subreport by Criteria Not Used In Subreport

sql,ms-access,report,ms-access-2010,subreport

Try using a UNION query and also list out the specific fields. The # of fields must be the same in both SELECT statements, and the fields must be the same data type. For example, if Field1 is a Long, then Field4 should also be a long (see example below)....

how can i add a report record in openerp odoo?

report,odoo,openerp-8

In General Directory file structure for creating the Qweb Report in ODOO report directory file contain __ init __.py file which is use as the manifest file for any python module its kind of entry point of the python module. (add the entry point of the your_report_parser_class_file.py file) your_report_parser_class_file.py file...

Active Reports 9: Multi-Colum SectionReport, is this possible?

c#,report,activereports

did you try ColumnCount and ColumnDirection properties on the detail section http://www.programering.com/a/MDNxQDMwATg.html

Determine a “combined availability” ratio for two servers

c#,sql-server,report

Here is an algorithm: Combine the 2 lists Order this list by EventStart Iterate over the sorted list Take current and next entry, compare current [EventStart, EventEnd] with the next EventStart An overlap would indicate 2 servers were unavailable at the same time Time complexity: O(NLog(N)) = O(O(N) + O(NLog(N))...

BIRT - using multiple webservices to get the data

web-services,report,birt

WS1 is not fired unless it is explicitely bound to a report element. Typically, to achieve this we apply following steps: insert a data element at the beginning of the report body turn the property visibility of this new element to false (or let it visible during testing) bind it...

Mass file generation with razor

razor,model-view-controller,service,report

I had really good expierience with Razor hosted outside ASP envirnoment, for rendering emails for example. I used Razo Engine (v2) and do not have any problems with multithreading and memeory leaks. Highly recommended it. Moreover in v3 they natively support parallel template rendering An early look at RazorEngine v3

Crystal reports group selection sorting

parameters,crystal-reports,report,group

I presume you mean filtering. I have had some experiences of if clauses not working correctly in filters. Use or instead: ({?customer num} = "<ALL>" or {AR_OpenInvoice.CustomerNo} = {?customer num}) and ({?SmanFilter} = "<ALL>" or {AR_OpenInvoice.SalespersonNo} = {?SmanFilter}) ...

Problems adding DataTable as datasource in C1Report (VB) ComponentOne

vb.net,report,componentone

I think the issue is because you've set the Calculated property of the fields added in the Detail section to False. You need to set it to True in order to bind data to the fields.

MS Access — quick filter on a subform, then pass the filter to a report

vba,ms-access,filter,report,subform

If your command button is on the main form, then you want a different filter: you want the filter that is on the sub-form. Something like: Option Explicit ' <- be sure this is at top of module ' ...and run Debug>Compile so it can perform its check '' And...

SQL Datename within a function

sql,tsql,report

I apologise but the answer was is as follows: Datename(mm, (dbo.fn_ConvertUTCtoShopDateTime( Visit.ORGID, dbo.fn_GetTrolleyreportcrossingafter ( Visit.ORGID ,Visit.Trolley_ORGID ,'South Shop' , TrolleyMovement.ActualStartDateUTC , 90 )) AS [Month2], ...

Why is my custom SS3.1 report returning an error “[Notice] Object of class GridState_Data could not be converted to int”

php,report,silverstripe

There error is the two dimensional array in the columns function is not being set correctly. The variable name is missing and in the incorrect place for each column. Either you can set the columns like this: public function columns() { return array( 'Title' => array( 'title'=>_t('PageListByTypeReport.PageName', 'Page name') ),...

R Knitr PDF: Is there a posssibility to automatically save PDF reports (generated from .Rmd) through a loop?

r,pdf,dynamic,report,knitr

Adapting your example: You need one .rmd "template" file. It could be something like this, save it as template.rmd. This is a subgroup report. ```{r, echo=FALSE} #Report Analysis summary(subgroup) ``` Then, you need an R script that will load the data you want, loop through the data subsets, and for...

Getting a Sum and Count from Different Tables

mysql,report

How about using summaries and LEFT JOIN operations, like so? SELECT Contact.name, COALESCE(p.seconds,0) + COALESCE(e.seconds,0) seconds FROM Contact.Name LEFT JOIN ( SELECT ContactID AS id, SUM(totalSeconds) AS seconds FROM ContactPhone GROUP BY ContactID ) p ON Contact.id = p.id LEFT JOIN ( SELECT ContactID AS id, COUNT(*) AS seconds FROM...

Display multiple specific records in a report

vba,ms-access,access-vba,report,ms-access-2013

You can use the WhereCondition option of the DoCmd.OpenReport Method to filter your report as needed. Const cstrReport As String = "YourReportNameHere" Dim custNames As String Dim lItem As Variant Dim strWhereCondition As String With Me.yourListBoxName For Each lItem In .ItemsSelected custNames = custNames & ",'" & Replace(.ItemData(lItem), "'", "''")...

Use a query to sort a report in MS Access

sql-server,sorting,report

If I'm not wrong.. First create the Query in ACCESS (Create tab -> query) There you will be able to create that query, save it, then go to your report and set its source to this query, the last step will be to set each textbox/label source to the query...

jQuery UI tabs not showing up in TestNG report

jquery,jquery-ui,report,testng

Ok, it seems that I forgot to add jQuery library itself. Case closed!

SQL Report Builder 3.0 - generate multiple reports between date range

sql,sql-server,reporting-services,report,reporting

You can pass date range as parameters to query, bring bring back data to report, and use grouping controls to show those 50 reports on every page. Use can use 'List' for that purpose. Put existing report into a list and just pass complete data source to the list. If...

Most efficient solution for printing large amount of data

vb.net,printing,report

You should always create reports for anything you want to print. There are other options but they often take longer (PrintDocument) or they're harder to maintain (PrintDocument) or they're not very professional (screen/form print) or they only work until you get more data than what is visible on the users...

Designer and Engine for generating dynamic PDF documents

php,pdf-generation,report

I have found a solution for this, so I will leave it here in case someone else is looking for anything similar. I am using Apache FOP as the PDF generator. I have Apache Tomcat with FOP as a webapp installed on a server, I call it locally through PHP...

Only include specific issues in maven-changes-plugin JIRA report

java,maven,report,jira,maven-plugin

Unfortunately, this appears to be a bug. The RestJiraDownloader that the plugin uses does not use the filter property at all. I filed an issue: https://issues.apache.org/jira/browse/MCHANGES-353. I actually checked out a local copy and fixed it and it works as expected. Hopefully I'll get some time to submit a patch....

MS Access WhereConditions in xml export

sql,xml,ms-access,report,where

Im allready found answer. Create your own Report with filter, make export and at end just save moves (I dont know how it is in Eng lang). Than make makro DoCmd.RunSavedImportExport "NAME-saved" Thats all :) ...

Is it possible to convert three row in section details of a crystal report to three column

crystal-reports,report

If i understand your question correctly, Yes it is possible. There are 2 ways: 1) Using CrossTabs. 2) At data level using SQL Pivot. 1) Using Crosstabs: http://reportsyouneed.com/understanding-crystal-cross-tabs-part-1/ Cross tab 2 Cross tab 3 2) Using SQL Pivot: Pivot 1 Pivot 2 Almost what you want There are may other...

DHIS2 - Data Visutalization/Reports

charts,configuration,report,dhis-2

To use the stored values of completed data sets, once must run Analytics. See the image below for reference. First Click on Analytics and Data Mart Second click on the Start export with Analytics tables update check box marked. NOTE: This action can only be performed by a user with...

Multiple subreports for each value in a field for a parameter

stored-procedures,reporting-services,ssrs-2008,report,subreport

I can create a tablix of subreports, it will display the subreport for each Child as the tablix increments.

display parameter value within formula crystal reports

parameters,crystal-reports,report,formula,value

First thing to note is to select the value of the parameter before running the report then you can get the value. IF ({parameter1}) = 1 AND ({parameter 2})=14 THEN 'text' & {?parameter3} & 'text' ...

Change page orientation Subreport, Crystal Reports

crystal-reports,report,subreport

Place the subreport in its own section. Then, in the Section Expert for the section in which the sub report resides, set the orientation of that section to landscape.

How do i count unique dates in crystal report?

c#,crystal-reports,report,grouping

There are two ways. you can use anyone of these method as per your requirement. 1.) Create a sql query and group by the field that you want. how you can get the no of count record in your sql query Count(1) As TotalItems. You can use that field in...

SQL Report Builder 3.0 - Invoice Like Report with total at bottom (multi page)

sql,reporting-services,report,reporting

turns out its really simple, right click on the footer of the page and select properties.. then untick "Print on first page" and there you have it, it only appears on the last document of a multi-page report ...

how to deploy crystal report on client machine, in vb.net

vb.net,crystal-reports,report

you need to install crystal report viewer only to client PC, not the whole software just the viewer. depends on client PC 64 bit or 32 bit, and the version has been developed with....

Output department and direct reports

powershell,report,output

Let see if we can make this a little easier and efficient. Import-Module ActiveDirectory $documentOld = "C:\Temp\Old_Supervisor_list_mo_yyyy.txt" $Users = Get-AdUser -Filter * -Properties name,Enabled,Manager,extensionAttribute14 | Where-Object{$_.Enabled} $Users | ForEach-Object{ $props = @{ Name = $_.Name Department = $_.extensionAttribute14 DirectReports = ($_.Manager | Where-Object{$_} | ForEach-Object{Get-Aduser $_ | Select-object -ExpandProperty Name})...

Adding diffrent hyperlinks to each row in Reporting Services

sql-server,reporting-services,hyperlink,report,action

You can add the URL using the expression. On click of the expression button pop up will be open and then you can select the your field as the value. And then set the expression as =Fields!Description.Value If you want to pass some argument with it you can concat with...

Creating dataset outputs..where to start with this one?

sorting,report,sas,datastep

/* Creating Sample dataset */ data input_dataset; infile datalines dlm=","; input Event : $10. EventType : $ 10. FName : $10. LName : $10. Age : 8. Gender : $10. Score : 8. ; datalines; Mile,Sprint,John,Smith,19,Male,15.31 Mile,Sprint,Alex,Doe,19,Male,13.21 Mile,Sprint,Ian,Sore,19,Male,23.51 Mile,Sprint,Sean,Lae,19,Male,12.34 Mile,Sprint,Mike,Rai,19,Male,17.27 Mile,Sprint,Connor,Te,19,Male,11.23 Mile,Sprint,Simon,Doe,19,Male,15.21 Mile,Long,Jane,Joy,37,Female,35.12 Mile,Long,Victoria,K,37,Female,27.31 Mile,Long,Chris,Li,25,Male,23.43 ; run;...

The base class includes the field 'report', but its type (Microsoft.Reporting.WebForms.ReportViewer) is

c#,asp.net,report

I've found an answer that seems to make sense: Try to add the reference: Microsoft.Reporting.WebForms and afterward, if you get another error try to compare between <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0 and the version that is written in the reference you added, if there is a difference change the version to...

Merge files by wildcard recursively to create a report (batch)

batch-file,merge,report

You could use for /r "path\to\directory" %%I in (*) to loop through all files and directories recursively starting at path\to\directory. Echo the fully qualified path, and type the file contents. Redirect all output into report.txt. @echo off >report.txt ( ( for /r "%~1" %%I in (%2) do ( echo %%~fI...

Documentation with Diagram “Hyperlinks” in Enterprise Architect?

documentation,report,documentation-generation,enterprise-architect

As Geert has already noted, there is a difference between "proper" elements and diagram-only elements. This is actually reflected in the document template editor, where there is an "Element" section inside the "Diagram" section. This will produce output for all elements in the diagram, whether or not they are also...

Error while running report northwind using vs 2010 and ms access

winforms,report,ms-access-2007,ms-access-2010,northwind

Edit: if you want to know why it dint work in the first place , go to reference and right click on microsoft.Reportviewer.Common and click view in object browser.Here you can see it was pointing towards version 9.0 which is not compatible(atleast in vs 10). Changing the reference worked (from...

How to concat string with expression?

report,reportviewer

You got it almost right. The expression should be: = "Equipment: " & Fields!EquipmentName.Value ...

Visual Studio 2013 - Add Item > Report option missing

c#,visual-studio-2013,report,rdlc

After installing VS 2013 Update 4 (http://www.microsoft.com/en-us/download/details.aspx?id=44916) I'm able to see Reporting item templates. Please note: I had installed Report Viewer Runtime and Redistributable package as suggested by @Scott before installing Update 4. That time Reporting item templates were not available. Now I'm not sure if Update 4 in itself...

How do I do my Pentaho Report take the Excel datasource file along to BA/BI Server?

excel,report,pentaho,transformation,kettle

This one's tricky, as you need to refer to the file inside the PRPT (which is basically a ZIP file). Here's a procedure that worked for me: 1) Add the Excel (or whatever) file as a Resource in Pentaho Report Designer (PRD). For my test, I used the customers-100.txt file...

Select only users that are (at least) member in certain groups

sql,postgresql,report,exists

In other words, you only want users that have at least one group_id which is <> 5: SELECT user_id, group_id FROM group_users gu WHERE group_id <> 5 -- optional, might help performance OR EXISTS ( -- just this works, too SELECT 1 FROM group_users WHERE user_id = gu.user_id AND group_id...

Generate pentaho report designer prpt file using java

java,report,pentaho,designer

After searches I couldn't find some special library to generate prpt file. So I found another way. The solution is to generate all necessary files & folders inside prpt file by yourself (programmatically, or by hand), and then zip them without compression. Then you can just rename extension from zip...

List&Label 16: Stop header of table to be copied on new page

forms,report,reporting,listlabel

I just found out how to do it: Open the detail menu of the table Select "Table Header" Set the condition for visibility to FirstHeaderThisTable ...

Shared variable is executing after subreport Crystal Reports

variables,crystal-reports,report,shared,subreport

Place shared variable in a different section than your subreport is. Put your sureport in a section above your main report is and go to details section expert and check underlay section below.

How can I make a checkbox print one report if checked, another if left unchecked?

ms-access,checkbox,report

You will have to use VBA for this in your OnClick event of the button: Dim ReportName As String If Me!CheckSummary.Value = True Then ReportName = "NameOfNormalReport" Else ReportName = "NameOfSummaryReport" End If DoCmd.OpenReport ReportName ...

BiqQuery which tool is used to produce reports online? [closed]

report,google-bigquery

Well, if your output fits in Excel and you are experienced there go ahead with that. Other tools are: Tableau Shufflepoint QlikView + Demo Bime Analytics + Demo Jaspersoft Metric Insights R Today re:dash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite and custom scripts....

SSRS 2008 matrices with stepped column

matrix,reporting-services,ssrs-2008,report,ssrs-tablix

At the end to do this I give up on using matrices and use subreports instead. I separate the report into three pieces. one main report with two subreports. the header is main report, two subreports is in left and right, all using tablix. the main report has some custom...

Performance on BIRT for 125k record data set

performance,report,birt

The only way I found to resolve this issue was to schedule the report to run as a PDF which takes about 5 minutes in total

Can’t Open Reports in a Microsoft Access Database

vba,ms-access,report

As much as you probably don't want to hear this, I have encountered this a number of times and the best solution was to create a new database and copy each item into it one-by-one. Sometimes a database carries enough corruption so that even a compact/repair doesn't remove it. As...

Underline a single word in List & Label [closed]

c#,report,reporting,designer,listlabel

Use the Formatted Text object instead of unformatted text. This gives you all the options to format single words.

Change ABAP report language at runtime

report,translation,abap

I just found the solution: There is none, since there is none needed. SAP is not caching the language-dependent text symbols. You can at any point in the execution change the runtime language via: SET LANGUAGE 'EN'. The reason I thought it did not work was, that I was using...

Hide Picturebox if image is invalid

vb.net,image,telerik,report,picturebox

Do a webrequest on your website. For example: Public Sub Run() Dim myReportImage As Image = GetControl("ReportImage") myReportImage.Visible = CheckWebImage() ' or myReportImage.Enabled = CheckWebImage() End Sub Private Function CheckWebImage() As Boolean Dim url As New System.Uri("http://www.url.com/yourImage.jpg") Dim request As System.Net.WebRequest = System.Net.WebRequest.Create(url) Dim response As System.Net.WebResponse Try response =...

MicroStrategy CREATE REPORT statement syntax

dynamic,report,microstrategy

Unfortunately it's not possible to create a report using MicroStrategy Command Manager. As you can see from the Outline window below (this shows all possible outlines in Command Manager with code samples) for you can list your reports, delete them or alter some properties of your MicroStrategy Reports. As you...

Drill through reports in SSRS

sql,reporting-services,charts,report,ssrs-2008-r2

Yes - this can be done. On the charts, Series Properties, you use the Action tab and Go To Report. Choose your drill through report and Add the parameters. For your Agent parameter, you would use your =Fields!AssignedTo.Value as the parameter Value. This will pass the selected pie slice as...

CListCtrl: single column without column headings?

list,view,report,scrollbar,clistctrl

I think you are searching for CListBox. See here for more. If you would like to continue with CListCtrl then use List view or Small Icon instead of Report view. For more see here.

Don't produce report if there is no data - PDF

reporting-services,report,suppress

If you are distributing your report using subscriptions and you have Enterprise Edition, then you can look at using Data Driven Subscriptions which will give you control over how and when reports are distributed based on whatever logic you need. Otherwise, there is no way to do what you are...

Starting from a template to generate ODT document with JAVA

java,templates,report,odt

I have found XdocReport https://code.google.com/p/xdocreport/ and it does exactly what i'm looking for with complete documentation and samples.

How to make QR Page Footer or Band to be under Band Details not at the page end?

delphi,layout,report,quickreports

Summary Bands print only at the end of the report immediately after the last 'detail' (unless the AlignToBottom property is set to true). You should add a TQRBand to the report and set the BandType property to rbSummary. EDIT If you need to show intermediate results on every page you...

VBA - System generated report amendments

excel-vba,report

The below code should meet your needs. It checks if the first row in your range is odd or even, which determines into which column it moves (the first row in a "series", which has the value, moves to the first column, and the second, with totals, moves to the...

How to avoid data being cut when presenting a BIRT report as PDF?

pdf,design,scripting,report,birt

The large blank space we can see below this table suggests there is a fixed margin or something like that which prevents all rows to be displayed. What is the value of the "Page break interval" property of the table? By default it is 40, try to decrease it until...

Force table to display 5 rows with or without data

php,html,mysql,table,report

As you are already counting the $row_count variable, you can add simple while loop, like this: <? while($row_count < 5){ ?> <tr> <td >&nbsp;</td> <td >&nbsp;</td> <td >&nbsp;</td> <td >&nbsp;</td> </tr> <?php $row_count++; }?> What is &nbsp;? Is it needed? Also check the @paxdiablo's answer about limit 5 option for...

Show page title for all pages when we print XSLT Report using XML

xml,xslt,header,report,title

I'm not sure what exactly are you trying to do, but it seems you need to read on XSLT. First, you need to remember that everything needs to be added to an HTML tag so that it is displayed in the style or the place you desire. Second, you need...

QlikView: How to set a selection for PDF reports?

pdf,report,qlikview

Ok - I did not found an option in qlikview, but a very clean workaround. Add a field to your calender IsYesterday with if(Date = today()-1, 1, 0) Don't set the Day, Month, Year fields with the document trigger, but set the IsYesterday field to 1 Make sure, you ran...

Save SSRS Report as PDF in C# programmatically

c#,reporting-services,report

The webservice URL you are using (ReportService2012) is for managing the report server objects. If you need to render reports, you should be using the ReportExecution2005 webservice. To get started, you should take a look at the Render method. To specify credentials you can add the folowing line (I'm the...

Creating vertical column table in RDLC

c#,.net,winforms,report,rdlc

It looks like a candidate for a Matrix report. Here is simple explanation: http://www.gotreportviewer.com/matrices/

Reporting tool for a java application

java,jasper-reports,report

you can use tableau reporting tool also too generate ad-hoc report. user can put filter on data from tool only and also much more features....

Showing “#Error” in ssrs 2005 report

reporting-services,report,visual-studio-2005

You need make sure both the divider value are non zero and also make sure the right conversion is done lots of time thee error raise in ssrs expression is due to the fact that conversion is not done.And also make sure the all the values in column are numeric....

Sharing my cognos reports with my peers

report,cognos,cognos-10

In Cognos Connection, open the report's Properties. On the right-hand side there is a link to 'View the search path, ID and URL'. If you click on this link, a popup appears; you can copy the value under 'Default Action URL' and provide that to your peers, and it will...

How to generate report from mysql database in android app?

android,eclipse,report

Connecting directly to your MySQL database from your android app is not a good idea You may want to create a web page (php etc) on the server that does the query and returns JSON back to your android app The result will be cleaner and you can control access...

Try to make a Crystal Report that takes a parameter

vb.net,visual-studio-2013,crystal-reports,report

You can do that on Crystal. Go ahead and create a parameter and under List of Values select dynamic. Then choose the database field you want that parameter to pull records under Value. You can also setup some properties for that parameter under settings. See picture below as example. When...

Power and timing reports of two different vhdl designs

performance,report,vhdl,timing,area

Digital circuit performances is measured in terms of: throughput, max operating frequency, latency, area and power. Your 3 clock cycles is the latency, which is quite easy to deduce from your VHDL since your FSM is 3 cycles from input to output. Max operating frequency and area are given by...

Change the database in Microstrategy Intelligent Cube

report,cube,microstrategy

You cannot modify just your cube to point to a different database if it was not create as a FFSQL report (in that case it's easy, you just change the database instance used), but you have a couple of options: Modify the database connection setting for the database instance used...

Jump to Page in C1PrintDocument

report,componentone,print-preview

They key was "PreviewPane.StartPageIdx" txtPageNum.Text = (PreviewPane.StartPageIdx + 1).ToString...

Add Number for Every X line

crystal-reports,report,crystal-reports-2008

Follow the process. Create a formula @counter and place it starting of the detail. Shared Numbervar counter; counter:=counter+1; counter Create another formula @display and palce after counter and all other fields after that. shared numbervar counter; Shared numbervar display; if counter mod 2=0 then display:=display+1; display ...

Report is not loading when using parameters

reporting-services,ssrs-2008,report

it was because one of my reports was having more than 1000 values. So I have made the following changes in web.config of the Reports server and it is working fine. <add key="aspnet:MaxHttpCollectionKeys" value="10000" /> ...

Libre Office Base; Opens reports in read-only

report,readonly,libreoffice,libreoffice-base

Just do a SAVE AS for your read-only report file. And then open the resulting .odt document. It will be editable.

How to increase amount shown elements report most viewed

magento,report

The limit is actually defined in class Mage_Reports_Model_Resource_Report_Product_Viewed_Collection. File: app\code\core\Mage\Reports\Model\Resource\Report\Product\Viewed\Collection.php class Mage_Reports_Model_Resource_Report_Product_Viewed_Collection extends Mage_Reports_Model_Resource_Report_Collection_Abstract { /** * Rating limit * * @var int */ protected $_ratingLimit = 5; //change this value ..... } ...

Cognos Duplicate maximum count Column value

report,cognos-10

Try this based on your expanded explanation: CASE count(distinct [division] for [Customer]) WHEN 2 THEN 2 WHEN 1 AND [division] = 'Q' THEN 1 WHEN 1 AND [division] = 'Z' THEN 0 END We count the distinct values of 'division' for every value of 'Customer'. If the count is 2...