|
|
|
June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Matrix Report Calculation Issue. Posted by Manny at 12/21/2006 10:43:36 PM Hi There,
I have this matrix report that shows sales for last couple of years and is
grouping on 5 different regions and separate years on different columns, I
want to calculate the % Sales for each region in another column. how do I
accomplish this in Reporting Services? I think the static...more >>
Convert multivalued parameters to a string Posted by Henrik Juel at 12/21/2006 3:30:00 AM I have read all the articles regarding this issue.
I would like to implent an "select all" function in the multivalued prompt.
The multivalued datavalues comes from a table. e.x.
select label,value from basetable
union
select 'All' as label,'%' as value
The user choice comes in the para...more >>
reportviewer in parameter Posted by ragu at 12/20/2006 10:53:10 PM hai
i have dropdown listbox i have seleect the (product id) and click the button error occur
the same path first display the report
but i select the value in dropdown list error occur
error:
The path of the item "/ReportProject3/TestReortForFunds & Program_ID = 2" is not valid. The path...more >>
Scrolling a Chart Posted by Ryan at 12/20/2006 11:24:08 AM Is anyone aware of a way (directly, otherwise, or even 3rd party) of making
it so that you can scroll values inside of a chart control?
For example, if I want to put employees along the Y axis, and sales across
the X axis (horizontal bar chart), if I have around 100 employees, the data
beco...more >>
Column header properties gone after using URL report access Posted by fparc at 12/20/2006 10:46:54 AM I set a border and interactive sort action properties to columns in a
report. When I render the report using a URL I lose those column header
properties. Is there a URL command to pass those settings with the URL?
(I'm using 'rs:Command=Render&rs:Format=HTML4.0' plus passing some
params)
For mo...more >>
How insert a table in a list Posted by ZHA at 12/20/2006 9:41:27 AM Hi there,
When I insert a table in a list and Click on preview i got this error:
"The table 'table1' is in a list that has no group expressions
defined for it. To use a data region in a list, the list must have
group expressions.
Regards
Zahid
...more >>
Reporting services permissions erorr reports not showing Posted by johnboy1973 at 12/20/2006 9:27:01 AM Hi I successfully created a 2005 report server but not when I assess
from internet explorer i cant see the reports we created, only SQL
Reporting Serices Heading and HOME
also my developers cant deploy to http:\\server\reportserver
does any one know whats wrong, or whta the default permissio...more >>
401: Unauthorized. Posted by KenLin at 12/20/2006 12:00:00 AM Dear all,
I have 2 server, Server_A is IIS, Server_B is Reporting Server(SQL2005).
I create a web project under Server_A and drop a reportviewer on the
default.aspx.
I then enter the Server URL and Report path. And build the project.
I can then browse the report without any problem if URL ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
VS2005 is ok with SQL2000 Reporting Services Posted by dgk at 12/20/2006 12:00:00 AM I've been developing reports in VS2005 using a database accessed by
Microsoft ODBC's driver (to a Cache database). I've been testing by
deploying the reports to a 2003 server running SS2005. Now I find out
that the company doesn't have a license for SS2005, just a developer
license. Does it matt...more >>
How does SSRS 2K5 generate the pages? Posted by Max Mutant at 12/19/2006 4:30:42 PM How does SSRS generate the page content?
Any reading, sites that you can share?
...more >>
Reporting Services keeps crashing! Posted by ana9 via SQLMonster.com at 12/19/2006 3:54:21 PM I have two datasets, each of which are pretty much exactly alike. Each
dataset has a corresponding matrix on the report and thats all there is.
When I run each query they work fine but when i preview the report I get the
following:
An error occurred during local report processing. An interna...more >>
Visual Studio 2005 and Reporting services Posted by Aaronous at 12/19/2006 3:41:00 PM I have created several reports using the Visual Studio 2005 tools. I would
love to be able to organize my reports in subfolders. I can't seem to be
able to do that. I can do it in Reporting services, however, whenever I
update any reports and re-deploy them from within Visual Studio, it doe...more >>
Hide Pagefooter Posted by zahid76 NO[at]SPAM gmail.com at 12/19/2006 3:19:07 PM Hi All,
I would like to show pagefooter on first page only. I tried with
Visibility -> Hidden = IIF(Globals!PageNumber=1,False,True)
It succesfully hide but showing space on other pages.
Please suggest any solution.
Kind Regards
Zahid
...more >>
subscription failing, created by user is now deleted Posted by sam at 12/19/2006 2:00:32 PM Hi,
The account of the person who set up this system has now been
deleted...about a year after he left. I've managed to recreate a
report and subscriptions and get rid of the problem.
How is this managed correctly??
Does the creator effect the subscription at run time?? It seems to.
I...more >>
seperate URL on Concatenated string Posted by Sue at 12/19/2006 12:36:09 PM Hello
I have field in a table where the value will be the hyperlink in Jump
to URL. The value in that field could be concatenated with several
string and I want seperate hyperlinks.
For example, if the field holds the value
www.google.com,www.msn.com,www.yahoo.com
I want 3 different h...more >>
Remove space between report body and footer Posted by munnyAnu at 12/19/2006 9:08:36 AM Hi all,
Can anybody tell me how to remove the space between report body and
footer?
Thanks - Munny
...more >>
Setting up SOAP Queries to sharepoints web services list.. Help Please...... Posted by RB0135 at 12/19/2006 4:21:48 AM Hi,
I am writing a report to get information from one of my Sharepoint
Services List. I am using Visual Studio.net 2005.
I create a new Business Intelligence Report through the Wizard, create
an XML dataset, point that to the Sharepoint Web Service
(http://<myserver>/__vti_bin/lists.asmx).
...more >>
Pagebreak for long texts in a textbox Posted by pebelund at 12/19/2006 2:52:00 AM Hi
I got a report than can grow depending on what information it gets.
My problem is that When I have a large text for a textbox.
Example of the problem:
I have a few textgroups thats gonna be printed out on a pdf. On page 1
we start of with some adresses and stuff and in the middle of the pa...more >>
ReportViewer 2005 control and Soap versions Posted by andygadget at 12/19/2006 2:39:25 AM We have just upgraded out systems to use SQL 2005 and the new
ReportViewer control within our applications.
Whilst this works OK on most sites, one or two cannot render any
reports, but get the cryptic message
"Client found response content type of 'text/html; charset=utf-8', but
expected '...more >>
RS Howto: TextBox.Hidden = True When TextBox.Value = ""? Posted by Pieter at 12/19/2006 12:00:00 AM Hi,
Is there a way to link the Hidden-property of a Textbox on a Reporting
Services Report to it's Value?
When the Value is empty (""), then I want the TextBox be Hidden. In case you
don't ide the Textbox, there is still white space taken.
Now I have to check in every Hidden-property of...more >>
Help abt reporting services Posted by R at 12/18/2006 8:52:37 PM Hi,
I have VS 2005 and SQL Server 2005 installed.How do i create reports
using Reporting Services ??
I can't find any tab like " Reporting Services" under File | new |
project .
What should I do ??
...more >>
accessing parameters in a subreport Posted by dbutler_05 NO[at]SPAM hotmail.com at 12/18/2006 12:13:49 PM I have a report with an imbedded SubReport. I have set up the
subreport control to pass a parameter from the parent report to the
subreport. However, I'm stuck trying to actually use that parameter
within the subreport. This parameter will be used within a SQL
statement in the dataset tab.
...more >>
Report consuing a SSIS package Posted by Joe at 12/18/2006 11:27:33 AM Has anyone had success in getting a report to generate by using an SSIS
package as it's data source? If so - can you share how you got it to work -
a couple of us who are pretty able bodied can't seem to get it to work as
Microsoft reports it should.
...more >>
calculating Grand Total in table footer from Group Totals Posted by munnyAnu at 12/18/2006 7:28:58 AM Hi All,
I have a report with one group. In the group footer
there is a TextBox ( name: txtTotal) that displays a total dollar
amount for that group. I would like to show a Grand Total dollar amount
in the table footer of the report. So
the Grand Total dollar amount would ideally be a sum of t...more >>
SSRS custom extension error - object moved? Posted by nickpup at 12/17/2006 8:05:01 PM We have developed a custom security extension for SSRS 2005. It reads data
from our SQL Server database to handle logins and authorization. We can
login interactively using and things are processed as expected, including the
ability to accept valid logins, reject invalid attempts and run rep...more >>
Linking and sorting multiple datasets in a single report Posted by Vorno at 12/17/2006 5:15:56 PM Hi,
I have got a report which uses two different datasets that combined
give me the required output. I am now required to combine the two
datasets into a single data region and sequence it appropriately. Is
there an easy way to do this within reporting services?
The sources of the datasets ...more >>
Adjust number of decimal places Posted by David Conte at 12/17/2006 2:27:17 PM I have a column used in my report that has values such as:
496.1000
These are money values and thus I require them to be in the format:
496.10
How do I get rid of the two extra zeroes?
(my sql statement actually does it, but they still appear in reporting
services for some reason)
T...more >>
Standby Server Posted by morphius at 12/15/2006 2:29:00 PM We have a process wherein the production DB is replicated to a
server.subscriberA nightly and then a job processes the database for
reporting services. Whenever the job fails we have to redo the process all
over again. By the time we are finished it is already late in the day and our
custome...more >>
how to group detail rows Posted by Rich at 12/15/2006 11:39:00 AM Hello,
I took over a report that someone else created. This report uses external
assemblies in C# which I was able to figure out how they work. What I can't
figure out is how the rows are grouped in this table in the report layout
view. There are 2 rows that are used as page headers, and...more >>
CSS - Style Sheets Posted by Chris Marsh at 12/15/2006 11:20:42 AM Am I blind, I don't see in the properties pages a CSS entry. Is this not
available in SSRS? If so, is there another method or is everything hand
coded?
Thanks
...more >>
Multi-Select Parameters Posted by bysnyder NO[at]SPAM hotmail.com at 12/15/2006 8:58:19 AM I think I am really missing something here. I am trying to set up a
multi parameter dataset. I have read through all the postings and am
looking at the Wrox book SQL Server 2005 Reporting Services. It
states the following query will work
Select ProductSubcategoryId, [Name]
>From Product...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |