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
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
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
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
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
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
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
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?
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?
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
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
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
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
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”
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?
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
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
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
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
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....
Is it possible to convert three row in section details of a crystal report to three column
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
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
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?
/* 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
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)
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?
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
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
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?
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]
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
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
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...
Change ABAP report language at runtime
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
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...
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
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
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
As you are already counting the $row_count variable, you can add simple while loop, like this: <? while($row_count < 5){ ?> <tr> <td > </td> <td > </td> <td > </td> <td > </td> </tr> <?php $row_count++; }?> What is ? 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
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?
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
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...
Reporting tool for a java application
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
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?
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
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
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
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...