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....
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...
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...
sql,sql-server,reporting-services,dataset,report
Try referencing your dataset explicitly, by changing this: =Fields!CustomerName.Value To this: =Fields!CustomerName.Value,"MyDatasetName" ...
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...
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.
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...
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...
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,...
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....
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) & _ ,...
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....
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...
Move the existing macro from the On Load event to the On Open event of the report.
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...
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...
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)....
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...
did you try ColumnCount and ColumnDirection properties on the detail section http://www.programering.com/a/MDNxQDMwATg.html
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))...
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...
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
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}) ...
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.
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...
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], ...
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') ),...
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...
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...
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), "'", "''")...
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,jquery-ui,report,testng
Ok, it seems that I forgot to add jQuery library itself. Case closed!
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...
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...
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...
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....
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...
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...
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.
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' ...
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.
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,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 ...
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....
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})...
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 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;...
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...
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,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...
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...
You got it almost right. The expression should be: = "Equipment: " & Fields!EquipmentName.Value ...
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...
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...
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...
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...
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 ...
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.
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 ...
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....
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...
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
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...
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...
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 =...
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...
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...
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...
I have found XdocReport https://code.google.com/p/xdocreport/ and it does exactly what i'm looking for with complete documentation and samples.
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...
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...
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...
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...
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...
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...
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...
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....
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....
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...
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...
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...
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...
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...
report,componentone,print-preview
They key was "PreviewPane.StartPageIdx" txtPageNum.Text = (PreviewPane.StartPageIdx + 1).ToString...
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 ...
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" /> ...
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.
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 ..... } ...
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...