Recent questions tagged reporting

0 votes

755 views

1 answer

reporting services - SSRS 2012 Report Models

I am preparing a SSRS 2008 R2 commercial demo for my company, using Report Model to produce a kind of " ... reports? Thanks in advance, Daniele See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

954 views

1 answer

reporting services - How to Display beyond 24 hrs in SSRS 2008 in HH:MM:SS format

I have a report in SSRS 2008 that pulls data from a table with a column, TotalTime that is an Integer value in ... How do I solve this? Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

832 views

1 answer

reporting services - Excel Export Fail when Number of rows in the Excel sheet exceeded the limit of 65536 rows ssrs

In SSRS 2008 (I use Sql Server BIDS to create reports) how to solve "Excel Export Fail when Number of rows ... of 65536 rows ssrs" issue Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

798 views

1 answer

reporting services - SSRS Report Render report in PDF Via URL

I have an SSRS2016 Report that I'm able to connect to in the browser: http://vmbksa69901mcz/reports_ssrs1d/report/DAS ... I'm doing wrong here. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

reporting services - SSRS csv export with comma in the column header names

By default, csv takes the text box name as the csv header name for the columns. The text box does not allow ... only for one report; not global. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

747 views

1 answer

reporting services - SSRS: Relative URL Hyperlink

In SSRS 2008 I would like to create a relative path URL. Long story short I have a subscription that outputs a ... .Value.ToString() + ".html" See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

728 views

1 answer

reporting services - Add the columns automatically in SSRS report

Currently we are having 6 columns in our database table which we are showing in the SSRS report but in future if ... 8/2000 Thanks for any help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

762 views

1 answer

reporting services - Adding values to a Report when there is no Data in query SSRS

I have a query that returns Sales representatives number, Category, Sales. The result is something like this: ... comparing what it exists. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

650 views

1 answer

reporting services - Substitute command for OVER in SSRS

How can I implement the OVER() command in SSRS 2008? Is there a trick to it, or am I stuck? And ... construct or statement is not supported. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

728 views

1 answer

reporting services - How can I eliminate #error on SSRS expression when dividing by zero?

I am trying to eliminate #error when dividing by zero on my SSRS report. I have the following expression ... into this much appreciated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

547 views

1 answer

reporting services - SQL runs slow in SSRS, but fast in SSMS

I have this query: Select '<ALL>' as name, '<ALL>' as pid, '<ALL>' as type union all Select distinct ... kind of a problem with SSRS before. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

566 views

1 answer

reporting services - Report footer is not exported to Excel

I am using SQL Server Reporting Services 2008 for reporting. When we export the report to Excel, the footer image ... know a solution for this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

646 views

1 answer

reporting services - How to set 20 record per page when i rendering reports in SSRS 2008?

I have created Report in SSRS-2008 using Tablix Data region. My dataset returning 1000 rows. When rendering into ... me step by step solution. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

514 views

1 answer

reporting services - SSRS 2008 printing single page renders different for print

I have a problem with SSRS 2008 reports rendering differently on the reporting server than the way it renders when ... time to figure it out. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

526 views

1 answer

reporting services - Force SSRS 2008 to use SSRS 2005 CSV rendering

We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering ... 2008 R2 deployed side by side. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

920 views

1 answer

reporting services - Lookup function in SSRS report

I have one dataset Dataset1 and in that I am displaying data based on grouping. The data is like this ... be used in calculated field. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

663 views

1 answer

reporting services - Report group headings not repeating on every page

I have an RDLC report with three tables and associated data sets. In my second table, I cannot get the two ' ... columns on each page' checked. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

518 views

1 answer

reporting services - use two different datasets in single report

I have two different-2 datasets with different fileds which are getting populated through two stored procedures with same ... for the same.. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

757 views

1 answer

reporting services - SSRS - Expression using different dataset fields

I have a report with multiple data-sets. Different fields from different data-sets are used in different ... Field / Fields.Dataset2.Field See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

652 views

1 answer

reporting services - Nested IIF or SWITCH Statement syntax needed correctly

Can somebody please tell me what I am missing in this formula in SSRS? Or better yet can somebody please write ... Thanks guys I appreciate it. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

705 views

1 answer

reporting services - ssrs expression to split string possible?

so in my query i have select columnx from tblz it returns 001.255556.84546 I want to be able to split this ... column3 = 84576 is this possible? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

reporting services - Render SSRS Report with parameters using SOAP in Powershell

I've been toying with this for days with no luck. Essentially I'm trying to build a simple library to ... proper object and pass parameters? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

691 views

1 answer

reporting services - formatting fields to show currency in SSRS

I am trying to format a field for salary and can't seem to bring out the currency symbol when doing the ... (Fields!number.Value, "￡") See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

574 views

1 answer

reporting services - Repeat parent group if child group goes to another page

I have a report that allows Finance to print off multiple invoices at the same time. The problem I'm running ... to repeat on subsequent pages? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

690 views

1 answer

reporting - BIRT: Alternating row Color in a table group

Has anybody an idea of how the highlighting condition has to look like, to create alternating rows in groups? I want the ... 'm using BIRT 2.1.3 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

reporting - BIRT: Alternating row Color in a table group

Has anybody an idea of how the highlighting condition has to look like, to create alternating rows in groups? I want the ... 'm using BIRT 2.1.3 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

836 views

1 answer

reporting services - SSRS migration from 2008 to 2016

We need to migrate SSRS 2008 to SSRS 2016 which includes: All RDL reports Subscriptions User Access I cannot find ... from 2008 to 2016 server See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

432 views

1 answer

reporting services - Two chart types (bar and line) in same SSRS chart

How can SSRS 2005 represent two chart types (i.e., bar and line) on the same chart? I am trying to ... done using SSRS? Or simulated visually? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags