I am using the report viewer control on an asp.net page. Once the report loads I click on the Print icon, get prompted to install what I believe is an Active X component, and finally get a po...
how do i change my date format in sql server reporting services 2005 to be yyyy/MM/dd HH:mm
All;
I have an issue in tyring to place a filter on a table in my report.
I have one dataset that i want to filter and display serveral times in one report. The query is complicated and...
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,
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...
I am pulling data from a database whose field is not in the bes format.
Specifically, it is in this text format although it should be a datetime...
[year][month][day]
20070305 for 200...
Hi,
We have Business Objects 5.x . We are planning to migrate the
existing Business Object based reporting to MS SQL server reporting services. We are looking for the advantages and disadv...
I'm trying to format two date fields in Cognos 8.2 Report Studio. The two date fields are Project Start Date and Project End Date. The result should display in this format, mm/yy - mm/yy. ...
In reporting services my report keeps displaying the DateTime as HH:mm:ss dd/MM/yyyy when what i really want is the date and time portions to swap around ( dd/MM/yyyy HH:mm:ss )
The procedu...
Can anyone tell me how to deploy SSRS reports in a sharepoint portal?
i want to format a number "my way" in a MS RS Report.
The number is f.ex. (formatted by N2) gives me 123,400.50. Trying to change it to : 123.400,50
In other words: Change the decimal "poin...
Hi,
I need to be able to dynamically add an image to a reporting services report. I'm going to be providing functionality for the user to select an image and I will be storing it as an ima...
hello dear helper
i want to refresh my crystal report from wintin my application. i have desinged a button to inwok the Crveiwer but every times it shows the previously refreshed data and i ...
I've got a report that works great, except every time it runs, my user has to "select all" from the drop down parameter.
I would like the report to run with that parameter pre-populated.
...
I have create a report using SQL Reporting Services which group by a field. In the report I use a
global field Global!PageNumber for the page number. Is there a way to reset the page number ...
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...
Hello,
I'm formatting a column to currency on a SQL report.
I need to allow for up to 4 places right of the decimal. (i.e. $5.1234)
Now, more than often i don't have 4 places to the ...
Hello - Let's say in reporting services 2005 I have a table (reporting services table populated from a dataset) which has column headings like:
State | FirstName | LastName | Address
and t...
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 a report we have in our project, we receive fields in each record that must be placed on their own line, but within the same column. For example, if we have 4 maintenance codes in the curre...
HI!
I have an SSRS 2005 Reporting Services report with a table that has a drill down group. The report opens with the group details suppressed. The report also has interactive sorting s...
I am working in Reporting Services SSRS 2005. I have a date parameter which is populated by a SP. It passes
value on to the Report field =Parameters!Date.Value(0),=Parameters!Date.Value(1),=...
I've analyzed the servers we are using for SSRS 2005 and 2008 and we discovered a small issue, though I can't seem to find what the cause is as it isn't affecting anything that we can find. In...
Hi
I have a report (.rdlc) that I am showing in a Report Viewer control. One of the column is contains a HTML-formatted string. Is there any way to show the data formatted?
Hello there.
I've got a little problem.
I'm deploying reports in RS. I also have to rebuild old CrystalReports-Rreports in RS. 90 % of them are using a "keep together" function.
I've ...
