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.
...
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...
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 ...
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...
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 ...
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...
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...
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 ...
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...
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 ?
Hi guys!
I've got a MS reporting services report that i want to print straight from ie. When i open the report and click on the printer button, it comes up with an error message that says "...
Hello,
I have an subtotal at the bottom of a matrix associated with a row group. How can I change the color of the background in the subtotal based of the value that subtotalled inside it w...
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 ...
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...
I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report...
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...
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?
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 ...
Hello Experts!
For creating a report using VS 2005, there's a weekly summary report where I need the following
example output from a reservation database:
I did it it with a Matrix Repor...
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...
In reporting services 2005, how would I call a function in the code behind, and successfully pass a multivalue parameter?
If i have a parameter defined for state that is multi-value, and i w...
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...
Hi,
I have a question based on finding the max entry into a certin table. This seemed obvious at first and i tried the usually, max function in the select statement, subquery in the From /Wh...
