Questions tagged [report-designer]

1

votes
1

answer
142

Views

Installed barcode plugin did not show in palette

I have installed Birt barcode plugin in my BIRT Report Designer. But it did not show in my palette. I downloaded the jar from here and installed it in my plugin. After that I restarted all of my programs but then it still did not show. Am I missing something? here is where I installed the jar and d...
AyukNayr
1

votes
1

answer
286

Views

Drill Through/ Drill Linking/ Drill Down using Pentaho Report Designer

I'm using Pentaho Report Designer Version: 8.0.0.0-28. I have one summary report (1) and one detailed report (2). Let's say I have this scenario: I have these columns in (1): Employees, Total hours (2): Employees, Day, Total hours per day I would like to make a link between (1) and (2) so if I cli...
metk
1

votes
0

answer
150

Views

The report definition has an invalid target namespace ISSUE

IDE : VS Studio 2017 DB : Oracle SQL I keep on having this kind of error Things I do resolving this but nothing helps me w/ my issue : I already add the latest version (140.1000.523) of Microsoft.ReportingServices.ReportViewerControl.WebForms I also tried to find the TargetServerVersion but seems o...
1

votes
1

answer
175

Views

Pentaho Reporting: Date picker parameter not parsing into user console web page report

I am developing a report using the Pentaho Report Designer. One of the parameters is Date Picker. When I try to publish the report in pentaho user console, I get an error message saying - 'Error parsing parameter information'. However, when I change the date parameter type to any other option like d...
Kuldip.Das
1

votes
1

answer
135

Views

IFS Report Designer - Register a new layout to the database

I am a student working for an IFS implementation project and currently learning how to use IFS Report Designer. However, I am stuck since my new layout is not shown in the drop down list when I try to print from Report Archive even though my new layout is created in Report Definitions and deployed s...
Hien Nguyen
1

votes
2

answer
40

Views

authenticating pentaho server in spring application

I have a spring application with users having roles and based on roles the user is authenticated to particular functions. if I integrate Pentaho server in this application how can avoid the re-authenticating Pentaho server.?
Naresh Vadla
1

votes
2

answer
2k

Views

Visual Studio 2010 Crashes when Creating or Editing a Report (.rdlc) with the Report Designer

This is an issue I had with VS 2010 RC and was hoping would be solved with the first official release. Sadly it wasn't. What I have is a number of reports originally created with VS 2008. When opening any of these for editing in VS 2010's Report Designer VS hangs for about two minutes and then shuts...
David Perlman
1

votes
1

answer
758

Views

Connection keeps closing in VS2005 Report Designer

I'm trying to design a report in VS2005 BIDS Report Designer, but every so often, I haven't figured out any regular action that might cause it, but when I try and run the query, I get the following error: An error occurred while retrieving the parameters in the query. DeriveParameters requires an op...
ProfK
1

votes
1

answer
6k

Views

Error Connecting to Oracle Database from Pentaho Report Designer

I am new to Pentaho, and I am struggling to set up a new database connection. I am trying to connect to an Oracle 10g database, but whenever I test the connection, I get the below error. It doesn't really seem to list any specific error message so I'm not really sure what to do or where to go from t...
knt
1

votes
2

answer
1.3k

Views

Empty reports in Pentaho Client Console

I'm trying to publish a report to the bi-server, so I can visualize it from the Client Console (http://localhost:8080/pentaho/Home) I configured successfully a JNDI data source to a remote Database (Oracle 10g) from the Administration Console, this is the url I used: jdbc:oracle:thin:@MY_SERVER_IP_H...
Hidalgo
1

votes
1

answer
1.7k

Views

How to create Dynamic SQL in Pentaho Report Designer?

I have a requirement where columns of the SQL will be generated based some selection, these columns are coming from Metric dimension but there is no metric ID present in Fact table. SQL would be something like below: SELECT Location_Nbr, Day_Nbr, (Column_List- Coming from some other query) FROM (Tab...
user3298072
1

votes
1

answer
89

Views

How to create a Report if you have fixed rowheaders

Hi i'm trying to create the following construct. Like you may can see i have 2 Columns 'Tag' and 'Angebot' My 'Tag'column will have a fixed number of rows (foreach weekday 1 row) where 'Angebot' will contains a List of items foreach row from 'Tag' (so i will get 7 List's) i can't throw them in one...
WiiMaxx
1

votes
1

answer
898

Views

Pentaho Report Designer Inline css/html styling when report output is HTML

Hi pentaho has an example in its sample reports email_inventory_inline_HTML.xaction and inventory.prpt in the directory: biserver-ce\pentaho-solutions\bi-developers\reporting\unified-file-format. The xaction script sends a report defined in inventory.prpt by email ( within the body of the email ). H...
flexxxit
1

votes
1

answer
289

Views

Excel export from Pentaho Report Designer missing commas

Using Report Designer, when I preview the data in a PDF, the number formatting for PDF is correct in which there is a thousands separator--a comma after 3 digits--but the Excel output has it missing. Excel - 857320 PDF - 857,320 What changes can be made to the attributes so that the comma is pres...
asarapure
0

votes
1

answer
11

Views

Group by does not provide accurate grouping

Attempting to create outputs that match the following screenshot: When I attempt the following query: SELECT t.amount, d.DOMAIN_NAME,td.month_number FROM transaction t JOIN transaction_date td ON t.trans_date_key = td.trans_date_key JOIN domain d ON t.domain_key = d.domain_key WHERE td.month_number...
cKdarlin47
1

votes
2

answer
593

Views

Order elements in Pentaho Report Designer in a Group Header

I know that PRD doesn't do any ordering, but rather takes in ordered data through SQL and displays them. This has worked for elements in the Details section but doesn't seem to work for group headers. Example: I have a report that displays a list of cars and are grouped by the header 'Product Line'...
Hemmy
1

votes
1

answer
33

Views

Pentaho Reporting: Columns getting restricted in Pentaho reports

I have too many columns (more than 15) to be shown in the reports but the pentaho report designer is restricting the same. I can only show 5-6 columns. How to expand the area size of the report columns?
Kuldip.Das
1

votes
1

answer
0

Views

Host the Visual Studio Report Designer so end-users can design reports

I'd like to re-host the Visual Studio Report Designer in my own application so that my end-users can use it to design new reports or edit existing reports. Is this possible?
Erik Forbes
1

votes
1

answer
1.3k

Views

Pentaho Report Designer stacked percentage chart Y values

I'm new to Pentaho, and I have a small problem I cannot seem find an answer to. I'm running stock Pentaho 5.0.1 stable Report Designer. I have a bar chart that I have setup with a data source, everything there is showing/working correctly. I have changed the bar chart to a stacked percentage, and...
Nathan
1

votes
1

answer
269

Views

Pentaho Report Designer for MongoDB

I just downloaded Pentaho Business Analytics to try its reporting features on a Windows 8 machine. Currently I'm trying to use Report Designer to create a report for a MongoDB datasource, so following the guidelines from the book, I'm using these steps: Select the Data Tab. Right Click on the Data S...
1

votes
3

answer
201

Views

How to do source control with Pentaho Report Designer?

We are using Pentaho Report Designer (PRD) to build out some PDFs and Excel files to the customer. Does anyone have a good strategy for doing version control on these reports? The prpt files seem to be a zipped set of xml. Is there a better format so we can tell what changed from one commit to anoth...
Adam
1

votes
1

answer
184

Views

Report validation failed Pentaho

I have created a report using Pentaho Report Designer. the report data retrieved from Oracle database. Once I upload the report to the pentaho bi server and try to retrieved the report I have this error Report validation failed. pentaho tomcate log shoes this error 18:10:09,019 ERROR [AbstractRepo...
S Gaber
1

votes
6

answer
20.9k

Views

Pass dataset to subreport with SQL Server Reporting Services

I'm using SQL Server Reporting Services and the report designer that comes with Visual Studio. I've got a really big report. It's actually so large that Visual Studio hangs (sometimes for hours at a time) or just crashes when I make changes. There is preciously little I can do to solve the problem,...
Juliet
1

votes
3

answer
1.9k

Views

Using CASE statements as a precursor for COUNT function in single (large) SQL query, syntax [closed]

I'm having trouble incorporating a bit of logic into a large SQL query. I'm using SQL Server Reporting Services 2005 with the Report Designer, and it only gives you one area to define a single SQL query to populate the report with. Hopefully someone can tell me what's wrong with my syntax so I can g...
1

votes
2

answer
2.2k

Views

Start by displaying print-layout in VS10 Report Designer when running the form

When I run my report from VS10, I have to switch everytime to print-layout. Because I need to make 100+ small adjustment to my big table, I have to press the print-layout button everytime to see the result. Is there a way, I can set it up, so I start by seeing the print-layout when running the form?...
radbyx
1

votes
1

answer
1.1k

Views

Error in querying a remote Oracle Database from Pentaho Report Designer

I'm trying to get some data from a remote Oracle Database, so I configured a new connection to the database and whn I press Test, it says that the connection was established succesfully, but when i tried a simple select query, Report Designer gives me an error: org.pentaho.reporting.engine.classic.c...
Hidalgo
0

votes
0

answer
4

Views

Syncfusion Report Designer Customization

How do we get the RDL content From SyncFusion Report designer? How can we load Syncfusion resport designer by RDL content (No external files just RDL xml is there). var designer = $('#ReportDesigner1').data('ejReportDesigner'); //How will I get RDL content from this? designer.openReport('/Catagory2...
developer_.net
1

votes
1

answer
1.6k

Views

message-field Pentaho Report Designer

I'm using Pentaho Report Designer 3.9.3 and I'm looking for a way to format the font weight, size, and color of each data type within a message field. My message field is as follows. USAGE FROM $(MAX_DATE, date, MMMM dd) TO $(MIN_DATE, date, MMMM dd) Which gives the output: USAGE FROM December 09 TO...
Tone
1

votes
1

answer
130

Views

pentaho report designer display field over field2 if 'field2' is not present

Let's say I want to make 2 text fields next to eachother. On the screenshot below you can see 2 fields. The field on the left will always show. But if the field on the right isn't filled in, I want to make it disappear but the text from the first field would have to go over the whole width of the pa...
Decypher
1

votes
1

answer
1.2k

Views

What is the purpose of uploading any file to the SSRS Report Server?

I am new to this Microsoft SSRS Reports Server. I am trying to create reports with images and links to external reports/websites. I just saw this option to upload any file to the reports server. But I do not know how to use these uploaded files in the Report builder/designer. I am able to select the...
vengi83644
1

votes
1

answer
1.4k

Views

Pentaho Report Designer Dynamic Heights

I have a report with 3 columns, ITEM, DESCRIPTION and QTY. The ITEM and QTY fields are single line values, however the description is multi line, can be 1 line, can be 30 lines, or any number in between. The problem is the ITEM and QTY columns do not grow to the same height as the description column...
crankshaft
0

votes
0

answer
2

Views

How to query external DataFactory in Pentaho Reporting

I need to implement the following report in Pentaho Reporting using java: Student 1 - Calification 1 - Calification 2 Student 2 - Calification 1 - Calification 2 ... The report receives all the information from the code. It has no access to the database. I am implementing this using Subreports. I tr...
Fabricio
2

votes
1

answer
3.3k

Views

Reporting Services 2010 RDLC: Passing Querystring Parameters from an RDLC

I'm trying to build a simple RDLC report that shows some data, and has a 'select' link that sends the browser off to a certain url with some data in the querystring (a key). In the vs2010 report designer, I can double-click on the column, then select action, and there are a bunch of thigns that see...
Brian MacKay
6

votes
4

answer
28k

Views

Visual Studio 2010: The report definition is not valid. Details: The report definition has an invalid target

Re: The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. Report expert needed, beam on over... Here are the step I went through today to accomplish thi...
Mac McCaskie
2

votes
1

answer
3k

Views

Pentaho Report Designer: Passing list of values as parameters to report

Report Objective: Performance analysis of players by statistics comparison Desired Report Layout Please refer to the layout and read on. The player names need to be added from a list which could be anything like entry text box, multicheck box, dropdown etc. If I select Jake Tyler in this list, the r...
AS91
2

votes
1

answer
556

Views

SSRS Pie Chart - Get Label Lines to Point Inside the Chart

Is it possible to have the label pointer lines to point within the pie chart area? I found that you can control the line size and bend with the Custom Attributes, 'LabelsHorizontalLineSize' and 'LabelsRadialLineSize' on the Chart Series, but can they point inside instead of outside? Basically, I cur...
Lenny K
1

votes
3

answer
4.4k

Views

How to use more than one query in Pentaho Report Designer?

I am trying to add two queries in Pentaho Report Designer so that I could get query results from more than one table. Here is my case: Query 1: SELECT `raw_crawl_shop_list`.`sales`, `raw_crawl_shop_list`.`keyword`, `raw_crawl_shop_list`.`number` FROM `raw_crawl_shop_list` LIMIT 1 Query 2: SELECT `...
Summer Sun
4

votes
1

answer
1.2k

Views

Visual Studio Report Designer: How do I print something on every second page of a report?

I have a report in Visual Studio Report Designer that prints a contract. I want it to have certain terms and conditions on the back of every page. How can I print something on every second page (which I'll then duplex)? I've tried putting it in the page header\footer (it just gets cut off), and I've...
Hotchips
2

votes
2

answer
3.3k

Views

Pentaho Report Designer - Dynamic Data Sources

I have a local instance of the Pentaho Report Designer running on my box and it has a local development database configured as its data sources. (2 datasource configs, both pointing to the same local data server; source and target databases.) Obviously, when I publish this report to the production B...
Lorin S.
2

votes
2

answer
874

Views

How to design report at run time SSRS

most of the time we point store procedure or table and then SSRS report designer show us field and we just drag drop those field on to report designer surface. after all we call those report programmatically and pass parameter and report shown on report viewer. now my company want that customer will...
Thomas

View additional questions