Questions tagged [report-designer]

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
129

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.3k

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.2k

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
3

votes
1

answer
564

Views

BIRT Report Designer empty DataSet scripting

I am using BIRT Report Designer 4.4.0 and I kept getting the error message org.eclipse.birt.report.engine.api.EngineException: Cannot fetch the next data row. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot move down to next row in the result set. SQL error #1:The result set is closed ;...
jera
1

votes
1

answer
913

Views

SSRS - Group Columns Together

All: I have the following data (see Raw Data attachment). Inside my SSRS Report, I have a column for "Name / Stream / Offer One / Offer Two" (Name is the column for the "Value" column shown in the image). I need my SSRS Report to display one row of the "totals" for each Name. Then under this, I nee...
A M C
2

votes
2

answer
3.3k

Views

ssrs return max date from multiple lines with identical invoice numbers

ok, I'm pulling invoices with unique dates but identical invoice numbers. I want to pull only the lines with the largest date, ignoring the rest. I've tried grouping the DATE by max() but it still returns all dates for that invoice. is there an equivalent to lastdate() that I can use in ssrs? selec...
nbpeth
2

votes
1

answer
5.2k

Views

Connecting Postgres ODBC to SQL Server Reporting Services/Data Tools/Report Builder

I've been using Crystal Report for my Adempiere (ERP Software which i believe use Postgres ODBC) I want to try SSRS cause i've heard some good things about it. At this point i just want to try the SQL Server Data Tools to try and create some reports and see whether i find it easy before attempting t...
user2500196
5

votes
1

answer
377

Views

Oracle SQL - How to strip leading bytes from BLOB (and return as RAW)?

I'm writing a query for a reporting tool (Pentaho Report Designer) where I need to retrieve some jpgs that are stored in the Oracle 11 database. The trick is that the jogs (stored as BLOBs) include a 12 byte header (added by another application) that I need to remove. The reporting tool also require...
whitegoose
3

votes
6

answer
11.3k

Views

Can I use @table variable in SQL Server Report Builder?

Using SQL Server 2008 Reporting services: I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so DECLARE @Results TABLE (Number int ,Name nvarchar(250) ,Total1 money ,Total2 money ) insert into @Results(Number, Name, Total1) select number, name,...
edosoft
2

votes
1

answer
2.5k

Views

Parameter Pentaho Report Designer with MDX

I am doing a report, using Pentaho Report Designer. My datasource is a Mondrian Cube with MySQL JDBC. I am using MDX queries, and I want to put paramerize it. I have to configure a parameter with its own query. I'm having trouble relating the main query and the parameter query. For that, I am using...
adayall
2

votes
1

answer
922

Views

WPF 4 Embeding Report Designer

Is it possible to embed the Visual Studio 2010 report designer functionality into my WPF application? Initially I was considering the use of Report builder, but for providing ad-hoc reporting capability from within application, I need to teach users too many steps before they start creating a simple...
Bhuvan
4

votes
2

answer
1.5k

Views

Pentaho Report Designer PDF export is not showing the Japanese characters

I have created a report using Pentaho Report Designer 3.9.1 and it contains Japanese characters. When I try to export the report into PDF, I am not getting the Japanese characters in PDF. Instead of Japanese characters it's showing as empty in PDF. When I try to export into Excel, Japanese character...
Rajasekaran M
2

votes
0

answer
199

Views

How to Display Dynamic Columns in pentaho reporting?

Am new to pentaho reporting. My requirement was, i have 20 fields, in those 20 fields user can give any fields by choosing their own sothat it populates that columns into report Example: Columns Names: A B C D E F G H ..............till Z Requirement: User can pick any of the columns above need to b...
Sekhar
2

votes
1

answer
60

Views

Incorrect number formatting in Pentaho Report

I'm using Pentaho Report designer 3.9 for a legacy project that has some reports that should support different languages (English, Spanish and Euskera). I have a problem with the number formatting. While in English and Spanish numbers show properly (#.###,## in Spanish and #,###.## in English), in E...
ferpinan
2

votes
1

answer
739

Views

Pentaho Report Designer error in query

I am trying to create my first report in Pentaho Report Designer. I have created a JDBC Data Source and added a query: SELECT a.* FROM (SELECT Sum(loan_receivable_detail.interest) AS interest, loan_account_opening_id FROM loan_receivable_detail GROUP BY loan_account_opening_id) AS a Howeve...
ANonmous Change
2

votes
4

answer
19.8k

Views

In SSRS, can you set a rectangle to grow with its contents?

I'm working on a report in SSRS (SQL Server Reporting Services) right now, and I'm having a problem getting a rectanlge I draw on the page in the report designer to grow. Basically, I've got a rectangle drawn, and then I put a text field inside of it. The contents of this text field can be either...
Sam Schutte
2

votes
1

answer
1.9k

Views

WPF Report Designer

Does anybody know of a tutorial or sample code on how to create a simple designer control in WPF? I am trying to write a simple designer in WPF where users can drag and drop data items (charts & lists) on specific points on a page (e.g. Line 3, Coloumn 24).
Soni Ali
2

votes
1

answer
599

Views

Cannot access SQL server instance from SSRS Report Designer - Named Pipe error

I have the following setup configuration for SSRS: Sql Server 2014 running on VPS1. Protocol enabled: TCPIP SSRS 2014 installed on VPS2, and configured to access SQL Server ReportServer database from VPS1 Reports from SSRS use a shared data source which use SQL Authentication, to connect to databas...
bzamfir
2

votes
1

answer
1.4k

Views

How to use custom utility classes in RDL?

how do you use your own utility classes (those you use in application code) in Microsoft reporting in local mode? Is it even possible? I have read some specification and there are some elements that indicate it can be done but it is not really clear on what to do. Simply calling the code does not wo...
Amy West
2

votes
0

answer
35

Views

Pentaho Kettle don't work after packages update on Ubuntu 14.04 [SOLVED]

The spoon was working normally until an Ubuntu update was run. After updating the . / spoon.sh command don't start the application. I accessed the update log and saw that it only updated things pertaining to postgresql as shown below:      Start-Date: 2018-08-17 08:26:45     Commandline: apt...
Danilo Santos
2

votes
0

answer
495

Views

Runtime report designer tools for MVC

I have a web application, with a couple of fixed, reports that the user can generate, with a couple of filter options for each report. Every now and then, our customers would request for a unique report that will take quite a bit of customization on our side. Is there a tool that would allow the use...
Null Reference
5

votes
1

answer
184

Views

Pentaho: how to create complex reports

I have to build a complex report (e.g. header, text and multiple lists and charts, arranged here and there on multiple pages). Something like a complex invoice. I've found no examples on the net for such reports in Pentaho. I tried with subreports, but it results in 30 nested subreports, which I thi...
Don
4

votes
1

answer
3.1k

Views

SSRS 2008 Dataset move up and down

Using single transaction when processing the datasets, I would like to change the order my datasets currently appear under the folder Datasets. Is it possible to move up or down any created dataset? I didn't manage to do it so far, and I'm not very enthusiast in creating my 25 DS again... thanks in...
largo68
2

votes
3

answer
3.1k

Views

Get first Saturday of month and last Friday of last week of month

This need is a little strange, and I can do it in C#, but can't seem to get the expression syntax right for Report Designer. I want to set default Start and End parameters for a report. To do this, I need "date only" values for the first Saturday of a month, and the Friday date of the last week o...
DJGray
8

votes
1

answer
838

Views

Can We Use the VS 2015 Report Designer in VS 2017?

The newest Report Viewer for Visual Studio 2017 has some bugs that prevent us from using it. We’ve downgraded to Microsoft ReportViewer Runtime 2015 for Web Forms (v 12.0.2402.15). However, the report designer in Visual Studio creates new reports in the new “2016” format, and even editing old...
Sandy Gettings
1

votes
1

answer
345

Views

Adding Chart to RDLC Report

I have the following Report created with Microsoft Rdlc Report Designer for Visual Studio: which Iam rendering to PDF. This works fine. If I add an empty chart to the report like this: Iam instantly getting the following Exceptions, when trying to render the report to pdf: Microsoft.Reporting.WebFor...
Moritz Schmidt
0

votes
1

answer
108

Views

Previous date in Report paramter in Pentaho report designer

I need a parameter Report_date in Pentaho report designer. Using SQL SERVER Database when User select Report_date in the query I want to fetch previous date data from the selected date .(date format yyyy-MM-dd) for example user select '2017-11-08', I need data of '2017-11-07'. 2,In second one i need...
Khokae