Hi,
I think this is a simple question but I am just not sure how to do it right, as a newbie.
All I want to do is generate a report of company employees grouped by their date of hire.
...
Hello
I would like my report to display the following based on the below database information. If the actual achievement date is null then I would like the value to be blank in the report r...
Hi,
I am using
=FormatDateTime(Fields!myDate.Value,dateformat.shortdate) and it is returning "MM/DD/YY"
My reginal settings are "DD/MM/YY". So why is it returning "MM/DD/YY"??
I ...
I have a crystal report with two subreports. The subreports are different summaries of the numbers shown on the main report (i.e. should be looking at the exact same data). One of the parame...
It's along story, but I will try make it as short as I can.
RS is installed on the same server with the WebServer. I run this from a
domain network PC:
http://WebServerName/Reports/Pages/F...
I am using Reporting Services 2005 and SQL Server 2000. I placed a reportviewer control on my ASP2.0 webpage to display a report.
When I tried to export my report to an Excel file, I g...
Hi All,
The textbox is using the following expression
= sum(iif( Fields!Opportunity_Type.Value = "Renewal", Fields!DT.Value, 0.00))
Previously in the database when the column DT is of ...
Hello,
When we create a grouping for RDLC report, we can insert a total for that grouping on the footer section by using =sum(fields!quantity.value). It works when the value in integer, but c...
How do I format the following:
=Fields!School.Value & " Percentage (" & (Count(Fields!S_SSN.Value) / Max(Fields!StudentPop.Value))*100 & "% )"
so my percent shows now digits to the right of...
1) when i format a numeric field like #.###,## i want that the , is the decimal separator and . is the thousand operator but its just the opposite while in other applications o...
In reporting services I have a report with parameters.
one of the parameters is a select from list and when I run it I get <select a value> and this open the list and I select.
I don't want...
using reporting services, i have no problem exporting reports to PDF format
however, when i export reports to Excel format, i see 'rubbish/not my stuff' in MS Excel.
how can i solve this ?
Is there some way to allow the user to expand all items displayed in a report that are collapsed by default when a report generates?
I am going to advice a customer what reporting solution he should implement in his new system. The system is on a Windows 2003-platform. The data is stored in an Oracle database, but the custo...
In SQL Server Reporting Services what have many date parameters declared as DateTime and so they display a pure date with the time of "12:00 AM". We want the DateTime data type for validation...
Hi all,
I am after creating a custom report generator within my VB.Net 2005 application. It would need to pull information out of a SQL database and allow users to design custom forms in a si...
Using SQL v2K, reporting services, visual studio 2005, version 8.0.50727.42
I am an RS newbie, I had created a project, nothing crazy, it worked quite fine. Now, however, when I login to VS ...
i have a matrix that has a series of row groups, and then a few column groups with the data that i am pivoting. what i am trying to do is get the Sum of the data in the row groups and display ...
I need to know how to a "not like" condition is crystal reports. I know how to do a "like" condition ex.{AllSeriousAllergy.ListAllergy} like '*Hives*'. For some reason not like is not working...
Is there any way to make the width of a table column adjust automatically based on a value returned by the dataset? I have a report that just barely can print in 8.5x11in landscape. If some ...
Using reporting services I am trying to set the visibility on a text box using the IIF condition.
if parameter value != -1 then show report
else if parameter value = -1 and parameter value...
I am trying to add a total to the bottom of a matrix report. My report looks like this...
VALUE1 VALUE2 VALUE3
...
I am having trouble understanding how to create drill down "expand/collapse" groups.
I want to have two groups: Builder, Project, then list of plans under that
I want to have an option to...
Hi Experts:
Im currently using Business Intelligence Development Studio 2005 to create reports using Reporting Services. I usually export the data into excel or I create a schedule job in SQ...
Hi there,
I would like to know, how would I write the code in the textbox expression to have a switch statement, that changes the value of the output and shows only a certain percentage val...
