FAQ Database Discussion Community


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

java,report,birt
I meet a problem that I have two parameters, the start date and end date. I want the default date automatically change into week base. For example, today is may 24, so the default start date should be may 17, and the default end date should be today, and then...

Multiple subreports for each value in a field for a parameter

stored-procedures,reporting-services,ssrs-2008,report,subreport
I have a Report and a Subreport, with the Report having 30 instances of the Subreport organized to fit neatly on the page. The only parameter for the Subreport is Child and the only parameter for the Report is Parent (not the actual values but it might make it easier/more...

display parameter value within formula crystal reports

parameters,crystal-reports,report,formula,value
I'm using Crystal Reports 14. I have a formula which based on two parameters (from month, to month) display different text AND different parameters My code is as follows IF ({parameter1}) = 1 AND ({parameter 2})=14 THEN 'text {?parameter3} text' My problem is that instead of the value of paramter3,...

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

report,google-bigquery
I'am new to BigQuery and I come to Google cloud from "oracle forms/reports"... Can someone give me some direction which tool is used to produce some kind of report connected to BigQuery? For now I have tried to export BigQuery datas into CSV and use that data in Excel or...

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

sorting,report,sas,datastep
The variables in the data set are: Event, EventType, FName, LName, Age, Gender, Score. I am trying to create a report that gives me the Lowest 5 scores per event/event type per each Age(18-65) per Gender. For example, I want the 5 lowest scores for everyone who participated in EventA...

Font data could not retrieved PdfSharp/MigradDoc

asp.net-mvc,azure,report,pdfsharp,migradoc
I have an ASP .NET MVC web application and I'm using PdfSharp/MigraDoc to generate the reports. When I publish the application to azure and print the report the following exception is raised: Internal error. Font data could not retrieved. I have this method that define the report style and I...

Save SSRS Report as PDF in C# programmatically

c#,reporting-services,report
I've read through multiple articles regarding this issue however they have all ended up with it not working, or are in vb.net. What I currently have: The reports are accessed via a URL which renders them as a PDF and saves them in the downloads folder when the user clicks...

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

crystal-reports,report
Is it possible to convert three row of section details in crystal report to three column?

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

r,pdf,dynamic,report,knitr
I would like to create a loop, which allows me to automatically save PDF reports, which were generated from a .Rmd file. For instance, if a variable "ID" has 10 rows, I would like R to automatically save me 10 reports, into a specific directory. These reports shall vary based...

Performance on BIRT for 125k record data set

performance,report,birt
I've got a data set consisting of 125,000 records which takes about 2 minutes to load when I run the query in SQL developer. In BIRT I create a data source and data set and just drag the data set onto the canvas. I don't add any formatting or grouping...

Change the database in Microstrategy Intelligent Cube

report,cube,microstrategy
How to change the database of an already created Intelligent Cube in Microstrategy? I have a cube which is getting data from Tables in production. We have same tables in other database as well. Is there any way i can modify the cube to use the new database?...

CListCtrl: single column without column headings?

list,view,report,scrollbar,clistctrl
If I set View = Report, then you get a single column and a vertical scrollbar (what I want). However you also get an area at the top reserved for column headings even if you don't have column headings (not what I want). If I set View = List, then...

Getting error in running ExportReport Python code in ArcMap

python,report,arcgis,arcmap
i am unable to generate pdf report using ExportReport function of Arcgis 10.2. getting error of IOError: Could not open report template tried different template files but still getting this error. Template directory is correct. checked all the directory positions. Code import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Users\Abrar ahmad\Documents\ArcGIS\New_Rwp_Cencus(12-17-2014).mxd") df = arcpy.mapping.ListDataFrames(mxd)[0]...

Output department and direct reports

powershell,report,output
I am trying to create an "initial" text file that will hold a script run of all users + department + direct reports. My next step after making this file is to create another file the same way but compare it to the original to see if the department for...

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

java,maven,report,jira,maven-plugin
I'm currently using the maven-changes-plugin to generate a JIRA report for a given fixVersionId, as follows: <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-changes-plugin</artifactId> <version>2.9</version> <configuration> <fixVersionIds>16355</fixVersionIds> </configuration> </plugin> However, what if instead of specific fixVersionIds, I want to be able to include specific issues? Is there a way to do that? I don't see...

SQL Report Builder 3.0 - generate multiple reports between date range

sql,sql-server,reporting-services,report,reporting
I've done some research on this but I don't think I'm typing in the right thing to find what I am after..... Basically I have a working report which displays the order information based on the OrderID (parameter).. so 1001, 1002 etc. What im now trying to do is group...

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

sql,postgresql,report,exists
I been working on a query to get a users list with their respective groups. I got that covered. However there are some restrictions: if The user is ONLY member of group5 it should not appear on the list If is member of group5 and other groups it should appear...

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

pdf,design,scripting,report,birt
After exporting report in PDF format I realized that a few rows were hidden. As you can see in the image: Notice that the 1st row in the second page is not the next row fetched by the data set, which should actually be 10 January 15 03:00. Also, there's...

Adding diffrent hyperlinks to each row in Reporting Services

sql-server,reporting-services,hyperlink,report,action
So I need to add different hyperlinks on each generated row. What I mean, I have SQL query to select some data like this: Name Description First First should be clickable and open www.url1.com Second Second - open www.url2.com Third Third- open www.url3.com .... SQL query: -- this is example...

MS Access WhereConditions in xml export

sql,xml,ms-access,report,where
I'm trying make an XML export of Report. It works, but I cant make filter criteria. I want to filter by DATE, 4 months to the past. Dim sXMLPath As String sXMLPath = "z://export1.xml" ExportXML acExportReport, "export1", sXMLPath, , , , , , [DATUM] > Date - 120 And [DATUM]...

Triggering MS Access Macro when emailing PDF of Report

ms-access,pdf,report
I created a Macro in MS Access 2010 for the OnLoad event of a report that hides a subform on the report if a check box on the report is not checked. That works fine but what I am trying to do now is have the same thing happen when...

how can i add a report record in openerp odoo?

report,odoo,openerp-8
I'm using OpenERP 8 odoo and I'm following the report creation tutorial but I get stuck at where i can but the report record code for example: <report id="account_invoices" model="account.invoice" string="Invoices" report_type="qweb-pdf" name="account.report_invoice" file="account.report_invoice" attachment_use="True" attachment="(object.state in ('open','paid')) and ('INV'+(object.number or '').replace('/','')+'.pdf')" /> Thanks in advance Reference : http://blog.emiprotechnologies.com/create-qweb-report-odoo/...

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

c#,asp.net,report
I'm desperate. I have this page with a report viewer that worked until a couple of days ago. I haven't changed my webconfig or anything else, but I am getting this error now. Here's my ASP.NET code: <%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="RisultatoStampaPdf.aspx.cs" Inherits="Fatture.Pagine.StampaDocumenti.RisultatoStampaPdf" %> <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0,...

How do i count unique dates in crystal report?

c#,crystal-reports,report,grouping
i have a crystal report of sales and its grouped by sale date. this add a grouped by header on report. Is it possible to count how many of this headers are on the report? the reason is i need to count unique number of sale dates! thanks...

Starting from a template to generate ODT document with JAVA

java,templates,report,odt
I have tried a few APIs : JopenDocument and ODFDOM and both of them don't offer what i'm looking for. I want to be able to do the following : Start from a template . Process this template with JAVA to generate ODT/Docx reports. I need those two functionality :...

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

sql,reporting-services,report,reporting
I am just wondering if anyone knows how I can set some data to be put at the bottom of a multi-page report (not in the footer) or in the footer and it to be only included on the last page if the document is a multi-page report lets say?...

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

vb.net,crystal-reports,report
I am working on VB.net project with Crystal report. My problem is that, on the client's machine Crystal report forms are failing with the following error; Error-> "Either the crystal report registry key permissions are insufficient,or the crystal reports run time is not installed correctly" Any idea how to solve...

Date picker in BIRT 3.7 not working

jsp,report,birt
After using the following guide I am unable to get the date picker to work other than in BIRT's report viewer. http://terrarum.net/blog/adding-a-calendar-widget-to-birt.html Here is the extract from my FramesetFragment.jsp page <script src="birt/JSCal2-1.9/src/js/jscal2.js" type="text/javascript"></script> <script src="birt/JSCal2-1.9/src/js/lang/en.js" type="text/javascript"></script> <link rel="stylesheet" href="birt/JSCal2-1.9/src/css/border-radius.css" type="text/css"/> <link rel="stylesheet"...

Generate pentaho report designer prpt file using java

java,report,pentaho,designer
My question is, how can I generate Pentaho Report Designer's saved .prpt file using java, without Report Designer itself? Is there any libraries for that? I need to generate those files programmatically, then later open using Report Designer and fix some values....

Visual Studio 2013 Report RDLC with related datasets

visual-studio-2013,report,relational-database,rdlc
I currently have two tables in a database "customer" and "pricelist" where a customer can have multiple pricelist items linked to their ID. I'm trying to build a report in VS2013 where it lists all customers [alphabetically], then all of their pricelist items [alphabetically], then page break between each customer....

Reporting tool for a java application

java,jasper-reports,report
I am developping a web application (front end Angularjs, back end Java). I am looking for a reporting tool. My client want editable reports (ie reports with inputs inside, like text input, combo box, ...) so he can fill them himself and then print them. (I know Ms Access can...

Report is not loading when using parameters

reporting-services,ssrs-2008,report
I have created a ssrs report and uploaded it in reportserver which is working fine. Then I have added 4 parameters to the same report. It works fine in my local machine,But not working when uploaded to report server. Is it because of any permission issues?

Mass file generation with razor

razor,model-view-controller,service,report
I have to produce many text files on some event, for example, on end of a business day. These files contain data entries and will be consumed by several enterprise systems. To solve this task (I work with Microsoft technologies) I can use Biztalk, XSLT or some template engines. Not...

Sharing my cognos reports with my peers

report,cognos,cognos-10
I am using cognos 10.2 . I have generated some reports as administrator in report studio. Now I want to share those reports with my peers. When I share the URL of the report I generated, its asking for username and password. I created a user and gave them those...

gwt code splitting with an existing Project

gwt,report,project
I have a project with a mobile and Desktop view, with over 100 classes, my question is now : What the best way is to splitt up this code ? looking in the complier report which class is over 10kB and call it via a runAsync?...

Hide Picturebox if image is invalid

vb.net,image,telerik,report,picturebox
I am creating reports using Telerik Reporting Tool and has some image on it. I display the Image in the picturebox using a URL that came from the clients but there are instances where the given URL is invalid so it will display an error message in the report. I...

MS Access 2010 Date range results not as desired

sql,ms-access,report
I am using this command to open a report DoCmd.OpenReport "fullreport_rpt", acViewReport, , _ "[Assignment] ='" & lngMyEmpID & "' AND [Start] BETWEEN DateValue(#" & Me.DateRange1_txt & "#) AND DateValue(#" & Me.DateRange2_txt & "#)", _ acDialog, OpenArgs:=Me.reporting_combo & " For " & Me.rMonthly_txt & Me.DateRange1_txt & "-" & Me.DateRange2_txt [Start]...

Drill through reports in SSRS

sql,reporting-services,charts,report,ssrs-2008-r2
I am making a report that takes in date parameters to filter result and shows the result in a pie-chart. I want to create a drill-through (could be drill down or any other type) where if a user clicks on a part of a pie chart which is divided by...

Problems adding DataTable as datasource in C1Report (VB) ComponentOne

vb.net,report,componentone
I'm having troubles to assign a datasource to a code-generated c1report. This is the datatable data. This is the output result pdf view. I'm using Visual Studio 2008 with ComponentOne 2009. The result pdf file as not the correct data, only the titles repeated to bottom. Then, this is the...

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

batch-file,merge,report
I want to traverse all subdirectories in the directory given, and write the contents of each file(as well as the filepaths) into a single report file. Example: File tree: c:\root_dir: dull_file.txt subdir relevant_file.txt c:\root_dir\subdir: really_relevant_file.txt also_relevant_file.dat Input: C:\> make_report.bat c:\root_dir *relevant* Output when writing C:\root_dir> type report.txt: c:\root_dir\relevant_file.txt <file contents...

BIRT - using multiple webservices to get the data

web-services,report,birt
I am trying to generate a report using Eclipse BIRT report designer. The scenario is this: There are 2 web service data sources. There are 2 datasets for webservices 'WS1' and 'WS2' respectively. The output element 'COUNTRYID' of one webservice 'WS1' would go as input for another webservice 'WS2'. What...

DHIS2 - Data Visutalization/Reports

charts,configuration,report,dhis-2
I am getting No Values found while trying to configure report/charts in DHIS2. I have been Created DataElements Created Category Options Added a Category to include Category Options Created a Category Combination item to and added the category created in Step3 in it. Now updated the DataElements and assigned the...

How to concat string with expression?

report,reportviewer
I have a textbox, and I want to set it's value to this: Equipment: Equipment Name So I tried to set this at textbox expression value: "Equipment: " & =Fields!EquipmentName.Value Altought this doesn't work. How can I concat "Equipment" with an expression?...

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

delphi,layout,report,quickreports
I need to make report, that has summary after Details had printed, not after every each Detail. I only know the Page Footer, but it's at page bottom not after the Detail Band. Is there a QRBand that could go after Detail Band? Or can you make PageFooter height resize...

Jump to Page in C1PrintDocument

report,componentone,print-preview
I have a form in my application that is used for previewing a report. It has a C1Ribbon at the top which contains navigation buttons, and a C1PrintPreview displaying in a PreviewPane. I want the navigation buttons in the ribbon (first, previous, next, last), as well as a text box...

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

ms-access,checkbox,report
I am using Access to print employee reports and I have built a search form to facilitate this and query these reports. I have detail and summary reports and I want to make it so I only have one button for the open report, preview report, and print report buttons,...

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

forms,report,reporting,listlabel
I have a combit List & Label 16 form in which i have a reportcontainer with a table. The table is pretty simple and looks basically like this: Header ------------------------------------- Row 1 Column 1 | Row 1 Column 2 Row 2 Column 1 | Row 2 Column 2 ... Now...

SQL Datename within a function

sql,tsql,report
I'm having issues when trying to get a datename Month within a conversion. My current query is used to check the time a Trolled passed 'South Shop' however I now require the query to take the conversion then display me the month only. Current query snippet: dbo.fn_ConvertUTCtoShopDateTime( Visit.ORGID, dbo.fn_GetTrolleyreportcrossingafter (...

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

ms-access,report,ms-access-2000
For a (old) project I created a report in Access 2000. In this report I wanted to create a field that multiplies 3 table fields values, namely: Aantal, Hoogte and Breedte. So I put it in my text field the following: =[Hoogte] * [Breedte] * [Aantal]. The language of my...

VBA - System generated report amendments

excel-vba,report
I am having some issues in creating a macro that will amend a system generated report. I would like to be able to paste my system generated report into excel and through pushing a button (macro) that it will select every other line of my data and copy the figures...

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
As an exercise to help me learn about writing custom reports, I've written a very simple custom report to list pages by their page type. I wrote the code based on the standard report cms/code/reports/BrokenLinksReport.php (included as part of the CMS) but am getting an error: [Notice] Object of class...

Power and timing reports of two different vhdl designs

performance,report,vhdl,timing,area
Let's suppose I have two circuits (described in vhdl), the first one performs the following algorithm in loop(pseudo code): C<=A+B; D<=C+F; RES <= D; I represent this algorithm applying the Finite State Machine(FSM) logic. Thus: State1:C<=A+B; out_ready<='0';--the result is not ready yet nextstate<=State2; State2:D<=C+F; nextstate<=S_out; S_out: RES<=D; out_ready<='1';--the result is...

How to generate report from mysql database in android app?

android,eclipse,report
I was thinking about creating an app which could be used to add data into a MySQL database and generate the data into a downloadable report, but I'm wondering: is it possible to generate and download a report (PDF or Excel file) using an android app?

Cognos Duplicate maximum count Column value

report,cognos-10
I am trying to flag the occurrences of a data item in column [Customer] determined by column [Division] and set three values for it in column [flag]. If data item [Customer] has both ‘Q’ and ‘Z’ data item values for column [Division] in separate rows I want the value of...

Digital Metaphors Report Builder Surround Group Inside Box

delphi,report,reportbuilder
I'm interested in creating a report that contains a group in it. I'd like the group to be enclosed in a box where the box surrounds the group in every page I've tried this using lines and placing them in such a way that there is one on the group...

Documentation with Diagram “Hyperlinks” in Enterprise Architect?

documentation,report,documentation-generation,enterprise-architect
I'm struggling to get all the required (and only the required) information into the documentation of my Enterprise Architect Project. Precisely: we have modelled various requirements and displayed the source "standards" for these requirements in our diagrams by using the "hyperlink"-element out of the common toolbox. (This allows us to...

Export Moodle report in csv file

php,database,csv,report,moodle
Does anyone know any Moodle built in feature to export custom report into a csv file? I've tried to find in documentation but there is nothing. There's this old book which also have no practical information on exporting report into a csv file. I've tried to dig into the source...

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

reporting-services,report,suppress
I have a report for which there is sometimes no data to output. This report is run along with several other reports and all are then output to PDF. However, this report still produces the header and footer with a blank page even tho there is no data. I can...

Odoo8 Qweb generated pdf document. The tablerows on the 2nd page are jammed

pdf,report,wkhtmltopdf,odoo,qweb
On the 2nd 3rd etc. page the tableheader and tablerows of quotation or invoice are jammed, when I print the document in pdf format. This works the same (wrong) way in my own written templates too. Brand new installed LinuxMint17 (Ubuntu clone), latest odoo8 (2015-01-29), wkhtmltox0.12.2.1 Is this a bug...

Add Number for Every X line

crystal-reports,report,crystal-reports-2008
I've a stupid issue but I can't solve it. I need to add number beside every x records as the following: 1 123123 material1 1 123543 material2 2 123332 material3 2 123432 material4 as you see the first column is a number for every two rows.. I need to do...

Graphical representation of test results of phpunit

phpunit,report,summary,phing
I am using phpunit to do functional tests. I use the log-junit option to generate results in JUnit-XML format. I then use phing to read this XML and generate a HTML report. The report is fine and neat. However, I have two questions:-- Can I also show the results in...

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

c#,asp.net,report,reportviewer
I currently have a page which displays a local report (which takes parameters in a report viewer control on my webpage. I have a requirement were the user wants the report to be generated and then emailed via a button click or page load. I have the below code which...

Showing “#Error” in ssrs 2005 report

reporting-services,report,visual-studio-2005
In a field of my groupfooter section of a table I am writing This, =FormatPercent(IIf((Fields!TotalTask_p1.Value+Fields!SuperVisorsCode.Value)>0,(Fields!TotalCommittedTask_p1.Value+Fields!SuperVisorsCode.Value)/(Fields!TotalTask_p1.Value+Fields!SuperVisorsCode.Value),0)) It is not raising any build error. But when I preview the report it shows "#Error" in that field. What should be done?...

Getting a Sum and Count from Different Tables

mysql,report
I'm guessing this is too local but I can't figure out a way to make it more general (which might be why I'm not able to find my answer on Google). We have an application that tracks contacts for our business. These contacts (Contact table) are either contacted through the...

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

xml,xslt,header,report,title
I want to print report by having PatientID in all pages as heading or title so that it will print page title in all the pages when we print I'm not sure how to write XSLT for showing title in all pages Any help will be really appreciated Below is...

Filter Access 2010 Subreport by Criteria Not Used In Subreport

sql,ms-access,report,ms-access-2010,subreport
I have a subreport in Access 2010 that basically acts as an index/table of contents. The user can use a search form to filter projects by specific criteria. Only the matching reports should appear in the report and index. The report filters fine, but the Index doesn't. Some of the...

Change ABAP report language at runtime

report,translation,abap
I was under the assumption that each time I use the following statement during the runtime of an ABAP report, the text-symbols from the respective language would be used from there on out (if they were translated accordingly): SET LANGUAGE 'EN'. However, this language switch only seems to work once,...

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

c#,report,activereports
I'm trying to get a SectionReport to have more than one column. The report is very long and there is plenty of space on the right side of the list (see upload) How can I do that in Visual Studio 13 (C#) using Active Reports 9? The data comes from...

Display multiple specific records in a report

vba,ms-access,access-vba,report,ms-access-2013
Let's say I have a single table called "Customers". It contains 2 fields: Name Address I want users to be able to select multiple records by selecting their names. For example something like having a list box containing all the names of the records in the database. I want users...

Underline a single word in List & Label [closed]

c#,report,reporting,designer,listlabel
I'm creating a form in combit List&Label 16 and trying to underline a single word in a label but I can't find the option to do so... Do you know if and how I can to this? The way I did it now is to split the label in 3...

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

sql,sql-server,reporting-services,dataset,report
I have a data set that gets its values from a stored procedure, and I'm positive that the stored proc is working correctly since I'm getting results in SQL Server. However, when I call the fields in an expression (for example, =Fields!CustomerName.Value) and preview, it just displays a blank spot...

Crystal reports group selection sorting

parameters,crystal-reports,report,group
I am working on a report that has two parameters that gives the user the ability to sort the records. One being the salesman and the other being the company code which is just the first three letters of the company name. They want the ability to sort these records...