Security Modifications
I need to make some security modifications on an existing SSRS2005
installation. I woud like add a group to the home folder with content manager
role. When I add the group the permissions do not cascade down the report
tree.
Is there something I need to do get this cascade?
Thanks
|
3/10/2010 5:20:01 PM
|
0
|
=?Utf-8?B?VGhvbQ==?= <T...@discussions.microsoft.com>
|
|
How to create a report with two data sources and join the data between them
Hi All,
I want to define a report with two data sources one is a Hyperion OLAP
source and the other is a SQL Server database. I want the data from
the Hyperion source to pull the corresponding detailed data from the
SQL Server database. Is this possible I can link two data sources and
define one report with data from Hyperion and SQL Server in one
report.
Thanks
Karen
|
3/10/2010 10:25:20 AM
|
2
|
KarenM <karenmiddl...@yahoo.com>
|
Shared Schedules permission - How to set?
Hi,
I have setup a shared schedule for my report and want to allow a user to
modify and execute the schedule on his own needs.
The user is member of these roles for the report that use the schedule:
Browser, Content Manager, My Reports and Publisher.
There is no security tab on the shared schedules property dialog.
Appreciate any help on how to troubleshoot.
--
Thanks in advance
Bodo
|
3/10/2010 9:52:01 AM
|
0
|
=?Utf-8?B?Qm9kbw==?= <B...@discussions.microsoft.com>
|
Hyperlink to child report is LOCALHOST when exported to Excel
We have a report that has a link to a child report for each row. We used the
"Go to report" for the field's Action. Everything works fine through the
browser. However, when we export this to Excel, the links turn into
http://localhost.. which does not work for the user.
How can we fix this?
Thanks,
Bernado
|
3/10/2010 7:54:01 AM
|
0
|
=?Utf-8?B?QmVybmFkbw==?= <Bern...@discussions.microsoft.com>
|
SSRS 2008 and MOSS - Linked Reports
I know that some features are lost when publishing in sharepoint mode using
SSRS 2005. e.g. linked reports do not work. Is that resolved in SSRS 2008? We
are Upgrading from SSRS 2005 to 2008 and contemplating whether going in
Native Mode or Sharepoint mode.
Any feed back would be appreciated.
|
3/9/2010 10:05:01 PM
|
0
|
=?Utf-8?B?UmVwb3J0V3JpdGVy?= <ReportWri...@discussions.microsoft.com>
|
SSRS function to return number and not sign
Is there a function in SSRS 2008 that will return just the number part
(including decimal values) of a data item and not the negative sign
but still work when the input value is a positive value?
|
3/9/2010 5:16:33 PM
|
1
|
Robin9876 <robin9...@hotmail.com>
|
How to copy existing report/project to new report/project
I have an SRS project and report. I want to create a new project and report
from the existing one and save it/them under a new name. How do I do this?
There is no "Save Project As" option on the File menu in Visual Studio.
|
3/9/2010 4:26:02 PM
|
3
|
=?Utf-8?B?RWxhaW5l?= <Ela...@discussions.microsoft.com>
|
SharePoint Reports Not Viewable
Hello:
At a client of ours that uses SQL 2005, we created reports and placed these
reports into their SharePoint site. So, when they click on the tab labeled
"Reports", they see our reports.
Yesterday, their SSL certificate expired. Now, when they click on any of
the reports in the tab, they get a screen with an error message displayed
that says "An unexpected error occurred while connecting to the report
server. Verify that the report server is available and configured for
SharePoint integrated mode."
If our IT department installs a new SSL certificate and if we afterw
|
3/9/2010 2:17:01 PM
|
0
|
=?Utf-8?B?U1FMIFByb2dyYW1tZXI=?= <SQLProgram...@discussions.microsoft.com>
|
Cannot create Report Builder Model from WSS 3.0 using SQL2005 Repo
Error Message:
* Cannot create a connection to data source 'DS_Chevo2_JM.rsds'.
(rsErrorOpeningConnection)
o For more information about this error navigate to the report
server on the local server machine, or enable remote errors
Systems:
* Windows Server 2003 R2 running WSS 3.0 SP2
* Windows Server 2003 R2 running SQL 2005 SP3, Reporting Services, WSS
3.0 object model only
Couple of items of note: SP2 for WSS 3.0 shows installed on the SQL Server
box but in Central Administration the version still shows as 12.0.0.4518 not
12.0.0.6421 like my ot
|
3/9/2010 1:51:02 PM
|
0
|
=?Utf-8?B?b3JjYW1ham8=?= <orcam...@discussions.microsoft.com>
|
access to reporting services
Hi,
Please can someone advise how i can give a normal domain user access
to reporting services (sql 2005), he needs to be able to have full
access to view, test and change report settings, he is not a domain
admin or anything. He needs to access via sql management tools.
Have tried various things but cant figure it out.
Thanks
|
3/9/2010 11:44:40 AM
|
1
|
systemtek <dun...@systemtek.co.uk>
|
summing
I have a report with Jan-Dec and Total as columns in my report. There are a
few group totals in the report, and one of the group totals is very
complicated, based on calculated fields I have added to my dataset. I'm
wondering if I can avoid creating a Total field in my dataset for the
complicated group, and instead have my total be something like this:
=Sum(textbox88+ textbox89)
Obviously, RS doesn't like this. I can't see a way to do it in an
expression either - is it possible?
Thanks, Andre
|
3/9/2010 6:24:11 AM
|
0
|
"Andre" <...@spam.com>
|
SSRS not Initialized and not sure why
we have been rebuilding a server and having problems; says it's running but
not initialized and I do not see a db version with 'C 5.0.8' or whatever.
Any ideas or how to's would be appreciated.
--
Regards,
Pat
|
3/9/2010 12:30:01 AM
|
1
|
=?Utf-8?B?UGF0TS1SZW5v?= <PatMR...@discussions.microsoft.com>
|
Calculate the amount of time it takes for a report to run
In SSRS2005, the was a way to calculate how long a report took to run. I got
the formula here:
(http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#UsefulFooter).
The formula works flaulessly in 2005, however in 2008 the formula changes
its behavior characteristics because of the way the rendering engine was
changed in 2008.
In 2005, when the report finished the calculation showed you how long it
took for the report to run.
In 2008, it does the same thing, but then it gets all messed up when you
interact with the report by things like hitting
|
3/8/2010 9:04:01 PM
|
0
|
=?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtn...@discussions.microsoft.com>
|
Remove/hide Navigation-Search menu
Is there any way to remove or hide the links (Home/My
Subscriptions/Help/Search) in the upper left corner of all pages?
Pete
|
3/8/2010 7:24:01 PM
|
0
|
=?Utf-8?B?UGV0ZSBIYXk=?= <Pete...@discussions.microsoft.com>
|
Bypassing parameters in reports
Hi,
I have a report that, before it runs, displays a drop-down list of
parameters for a user to select. Call it Report01.
It would be useful to, from other places, say from Report02, to call
Report01, but to pass it a parameter value. In such a case the dropdown list
should not appear, and Report01 should be rendered from the passed in values.
Is this possible, and if so, any pointers to getting this to work would be
gratefully received.
regards
Carl
|
3/8/2010 1:43:01 PM
|
3
|
=?Utf-8?B?Q2FybFI=?= <Ca...@discussions.microsoft.com>
|
SSRS 2005 SP3 and Windows Server 2008 R2
Hi,
is there anything I should be aware of to install Reporting Service 2005 on
Windows Server 2008 R2?
Thanks in advance for any feedback
Adrian
--
Adrian Miller
|
3/7/2010 11:43:06 AM
|
0
|
"Adrian Miller" <adrian.mil...@hotmail.com>
|
SSRS 2008 working with table of contents
I have the following questions about creating sql server 2008 reports:
I am creating a report that will contain the following:
a. page header with the title of the report,
b. page footers that contain the page numbers, and
c. table of contents to tie about 27 subreports together,
d. several of the tables in the subreport will appear on more than
one page.
Thus, I would like to know how to tie all of this together. I am
planning on doing the following:
1. Put the title of the report in a textbox control,
2. Somehow have logic in the tables to know to wrap to the next
|
3/6/2010 4:12:01 PM
|
0
|
=?Utf-8?B?V2VuZHkgRWxpemFiZXRo?= <WendyElizab...@discussions.microsoft.com>
|
Unauthorized (401) response when using ReportServer web Service
I'm attempting to programatically Add Roles Assignments for Reporting
Services 2008 instances on a Windows Server 2008 machine but constantly get
'HTTP status 401: Unauthorized'. The identical code works on Server 2003 or
Windows XP with Reporting Services 2008. This only happens with the initial
process, no many how many times its run, the same exception. Closing down the
application then rerunning all is fine.
Versions I'm using:
Windows Server 2008 32 bit, SP2 , Build 6002.
SQL Server 2008 w Reporting Services, ver 2007.0100.1600.022
Here is the Reporting Services log afte
|
3/5/2010 10:43:11 PM
|
0
|
=?Utf-8?B?QnJhZF9TRQ==?= <Brad...@discussions.microsoft.com>
|
sql server report 2008 formatting options
The following two questions pertain to format questions I have about sql
server 2008:
1. When I export some of the sql server 2008 tables to either word or PDF,
and the table goes to two or more
pages, there is a complete empty page break. Basically I will see the table,
followed by a blank page, the table is
continued to another page, there is another empty page, the table is
continued to another page, there is another
empty page. Thus can you tell me how to make certain there are not all the
empty pages I just listed above?
2. I am thinking of creating 1 table
|
3/5/2010 7:28:09 PM
|
3
|
=?Utf-8?B?amF6enlkYW5jZQ==?= <jazzyda...@discussions.microsoft.com>
|
Incomplete RecordSet rendered in report
When I use the query builder to view a select query I get the expected number
of rows returned. When I view this in report mode only records with the first
instance of a certain field are rendered. ie:
select * from foo
order by Field2
Returns all records in the Query Builder
Returns only the first instance of each field2 in the report
I added the sort so I could compare the results. Original query has no sort.
Shouldn't the query results and the report results be identical?
Using Report Builder 2 against ODBC database. (also get the same behavior in
VS2005 BI)
I hope thi
|
3/5/2010 5:28:01 PM
|
2
|
=?Utf-8?B?UGV0ZSBIYXk=?= <Pete...@discussions.microsoft.com>
|
Cascading parameter doesn't work right in BIDS, but works fine in
FYI: SSRS 2008 on SQL 2008, VS 2008, BIDS 2008.
I have a RDL that is very basic with a cascading parameter. At this stage,
it is only parameters because the actual intense data gathering wasn't
programmed because of the cascading problem.
This problem seems to be different than the other 3rd parameter problem that
was recently fixed in a cumulative update for SQL 2008. I ran this on a
server that has SQL Server 2008 cumulative update 1 and it did not work.
Reading through the bug fix seemed to indicate this is a different bug.
The first Parameter just gets the data that i
|
3/5/2010 5:19:01 PM
|
0
|
=?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtn...@discussions.microsoft.com>
|
Analysis services connection using Excel
Server- remote win2k3 server running sql2k8 in workgroup setup - no AD.
Client - Xp prof connect to server via vpn and rdp
I am trying to connect to sql database from Excel , data , from other
sources,
from analysis services using windows authentication and I am getting an error
" Errors in OLD DB provider. Could not connect to the redirector. Ensure
that the SQL browser services is running on the 'dbservername' server.
Can you pls update on what needs to be corrected to remotely connect to
analysis services via vpn from client and also make a odbc connection
remotely usin
|
3/5/2010 4:47:01 PM
|
0
|
=?Utf-8?B?bXNsb2dz?= <myem...@nomorespams.com>
|
SSRS - Setting Permissions Through Stored Procedure
Is it possible to change the list of reports a user can access through stored
procedures? At the moment I run a stored procedure to get a list of all
reports a user has access to but then change permissions manually as I don't
have a definitive list of all relevant SQL Server tables.
SQL Servant
|
3/5/2010 3:33:01 PM
|
0
|
=?Utf-8?B?U1FMIFNlcnZhbnQ=?= <SQLServ...@discussions.microsoft.com>
|
Displaying text into Sql reports
I would like to know what I can use in sql server report 2008 to display
several sentences or paragraphs prior to where I have a table generated.
Each table in each report will display the data. To display the paragraph(s)
and/or sentence(s)
before the table containing data what toolbox item would I use? Should I use
a matrix, rectangle, textbox, and or another table?
|
3/5/2010 1:06:01 PM
|
1
|
=?Utf-8?B?bWlkbmlnaHQ=?= <midni...@discussions.microsoft.com>
|
Formatting in sql server reports
I have some sql server report service 2008 reports that will be exported to
word 2007 documents.
Are there any formatting features I should be aware of so these
SSRS 2008 reports will not have formatting problems? I want to make
certain that all the data is displayed appropriately for one page. I want to
make certain there are not page breaks between different sections of the
reports, data
that show be one one page does not overflow to two or more pages.
Thus, can you tell me what the export formatting options are that I can
use? Would I need to use the formatting options w
|
3/5/2010 12:58:03 PM
|
1
|
=?Utf-8?B?ZG91Z2xhcw==?= <doug...@discussions.microsoft.com>
|
BIDS not saving credentials
I have a shared data source for my solution. I enter the credentials and
select "save password" and all is well while I'm working on a report. But
as soon as I reboot my PC, the next time I come into BIDS and try to work on
my report it fails because the credentials are not saved. I enter them and
all is well, and we start the viscous circle all over again. The error I
receive prior to entering my credentials is this:
An error occurred during local report processing.
An error has occurred during report processing.
Cannot create a connection to data source 'MyDataSource'.
Yo
|
3/5/2010 6:34:09 AM
|
0
|
"Andre" <...@spam.com>
|
SSRS 2008 working with word 2003 or 2007
Since I am new to sql server report service 2008, I have the following
questions to ask:
1. I have alot of reports that need to have one to 10 paragraphs written
prior to when the table is displayed. Thus, I was thinking there would be
toolbox items like a 'word' document that you can drop onto a sql server
report
2008. However the closest thing I see is a texbox. Thus, is there any
feature I could use that will display the paragraphs prior to when the
repiort is generated?
(The closest item is looks I can use is a textbox. Does the textbox have
'word' document formatting
|
3/4/2010 11:50:02 PM
|
0
|
=?Utf-8?B?V2VuZHkgRWxpemFiZXRo?= <WendyElizab...@discussions.microsoft.com>
|
Graph Series Tooltip Does Not Show when Zoom Engaged in IE 8
I have the tooltip property of a graph series set to display some text.
Everything looks great until I zoom to greater than 100%; at that point, no
tooltip. I have a similar tooltip on a textbox that works fine when I zoom.
Also, when in Visual Studio 2008, the tooltip works fine with the zoom
engaged.
Any ideas?
Thanks,
Bink'
|
3/4/2010 6:56:06 PM
|
0
|
=?Utf-8?B?Qmluaw==?= <B...@discussions.microsoft.com>
|
Problem showing parameters in SSRS 2008 on Sharepoint 2007
On a MOSS 2007 server that also has PerformancePoint Server a SSRS
2008 report has been successfully deployed and is accessibly via the
page (see first link). The report has a link to a SSRS report (see
second link below).
MOSS /PPS Page.
http://myMOSS_Server/myProject/Reports/Test/myReport.aspx
Link in SSRS 2008 report.
http://mySSRS/ReportServer/Pages/ReportViewer.aspx?/myproject/myReport&rs:Command=Render&rc:Toolbar=True&rc:LinkTarget=_self&rc:Parameters=true
The report displays correctly in the portal page in the web part
area.
When the link is clicked the report generate
|
3/4/2010 5:26:02 PM
|
0
|
Robin9876 <robin9...@hotmail.com>
|
SS2000 Report too slowly
Hi all,
where can I investigate for a performance problem in one report in SQL
Server 2000 got by an asp.net application?
Luigi
|
3/4/2010 2:55:02 PM
|
1
|
=?Utf-8?B?THVpZ2k=?= <Lu...@discussions.microsoft.com>
|
Date parameter defaults?
Hi,
I'm trying to develop a report with a date parameter and I want to set a
default value of the first of the given month. I found a nice little
example that runs fine in the query analyzer but I can't get it to work in
reporting services.
Here's the example, this returns the first of the current month:
select dateadd(m, datediff(m, 0, getdate()), 0)
When I translate it to reporting services I tried this:
=dateadd("month", datediff("month", 0, today), 0)
and I get the following error:
An error occured during the local report processing.
Error during processing of
|
3/4/2010 12:00:12 AM
|
2
|
"Linn Kubler" <lkub...@chartwellwisc2.com>
|
SSRS 2008 report parameter issue
We upgraded from 2005 to 2008 version and all existing reports were migrated
with no issues. Most of these reports had date parameters and they all seem
to be working fine. Then we developed a new report, with two date parameter,
and deployed it on the server. This new report doesn't render the date
parameter on the screen. As a matter of fact, we changed the parameter type
to text and still user can't see the parameter on UI. We also removed the
data source entirely, and just had the parameter on the report, to see if
the parameter will show up on the UI, and that yielded the sa
|
3/3/2010 10:38:45 PM
|
1
|
"Gilgamesh Ankidu" <gilgamesh4e...@aol.com>
|
Adventureworks SSRS sample dashboard/gauge reports
Hi All
Can someone point me to the adventureworks SSRS sample dashbard/gauge
reports. I saw there is one for the company dashboard I cannot find it
in my sample reports. Appreciate if you can point me to the link.
Thanks
Karen
|
3/3/2010 7:54:37 PM
|
0
|
KarenM <karenmiddl...@yahoo.com>
|
Force Integers on Scale Labels in the Radial Gauge
How can I force the scale labels to display as "1" ratehr than as
"1.0000002" ?
I wanted to try to use the Radial Gauge in 2008 Reporting Services to
display elapsed time in seconds.
I set the Scale Properties for the gauge to have a "Maximum" value of
300 (representing 5 minutes) and leave the "Minimum" at zero.
under the "Multiply Scale Labels By" field I entered "=1/60" because I
want the tick labels to appear as minutes.
Problem is the labels appear carrying the decimal values.
This is a fun looking gauge and I would love to learn more about how
to use it, and I have h
|
3/3/2010 7:20:28 PM
|
0
|
TCorp <tedcor...@gmail.com>
|
Mailing Label printing
I have created several mailing labels using SQL Reporting services and am
attempting to print them with a Intermec pd-41 label printer. Every time a
report is Printed the size settings for the job changes to 1.5w 4h instead of
the setting within Windosw of 1.5h 4w. I have changed and saved the settings
on the printer in the printer settings via Windows. The end users for this
product cannot be bothered to click properties every time they are printing a
label. Has anybody else experienced this or know of a way to correct this.
|
3/3/2010 1:48:01 PM
|
1
|
=?Utf-8?B?RGF2aWQ=?= <Da...@discussions.microsoft.com>
|
Passing date parameters to .mdb datasource
I am trying to use SQL 2005 Business Intellegence Studio to create a report
against a .mdb file using an ODBC connection. What is the syntax to pass
@startdate and @enddate parameters to Access?
Pete
|
3/3/2010 12:34:01 AM
|
4
|
=?Utf-8?B?UGV0ZSBIYXk=?= <Pete...@discussions.microsoft.com>
|
URL Access, weird behavior
We are using URL access to a report server and it does work,but here is the
issue:
On first run, if I use the following URL:
http://xxx.xxx.xxx.xxx/Reportserver?/MyReporting/All+Employees&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false&rc:Parameters=true&dbName=MyDatabase
- It works fine. The report renders, but the toolbar isn't viewable.
Then if I run the same URL, in the same browser, except change the
toolbar=true, it works fine and the toolbar is viewable.
However, if I close all my browsers, open a new browser, paste in the
original URL and change 'toolbar
|
3/2/2010 6:57:01 PM
|
0
|
=?Utf-8?B?TWljaGFlbCBD?= <Micha...@discussions.microsoft.com>
|
SSRS 2005 Security Export
I have inherited a SSRS 2005 installation that has access akin to spaghetti.
I would like to export the current security setup, folders, users, roles so
that we can start to clean it up.
Is there a built in way to do this, or has someone already created a script
to do this?
It would be much appreciated.
|
3/1/2010 10:54:01 PM
|
1
|
=?Utf-8?B?VGhvbQ==?= <T...@discussions.microsoft.com>
|
Label printing
I have several label reports formatted to print on 1.5H x 4W inch labels. I
am printing to an Intermec pd-41 label printer. The printer is set to 1.5H
and 4W. My SQL report has a width of 4 and a height of 1.5, but everytime I
print the print defaults to 1.5w and 4h. The only way to get it to print is
to change the settings every time. Is there another way to get the settings
to "stick" instead of having to change them every time?
|
3/1/2010 7:06:02 PM
|
0
|
=?Utf-8?B?RGF2aWQ=?= <Da...@discussions.microsoft.com>
|
Cascading Parameters
I'm trying to set up a cascading parameter and can't seem to get it working.
It's basically a State --> Cities types of relationship (in this case, it's
actually "regions" or "districts" within a state, and the "counties" within
that district, but same difference).
I'm pulling the data from ref tables in an Oracle DB (10g)
Basically, I want to choose the District with the 1st param, then have the
2nd param build its list of available values on what was chosen.
I pull Districts just with a straight query on the database table - works
fine.
For the County parameter, I ha
|
3/1/2010 4:57:01 PM
|
3
|
=?Utf-8?B?RFRob21wc29uMjQ=?= <DThompso...@discussions.microsoft.com>
|
How to display a list of buttons at top of a SSRS report to call different reports
Hi All,
I want a SSRS report to display a list of buttons at the top of a SSRS
2008 report like this:
Overview Marketing Sales
Procurement Inventory HR
with each of the above buttons calling another SSRS report and
displaying it below the toolbar displayed above.
By default when the above SSRS report is called the SSRS report under
the Overview button is displayed and depending later if the user click
on Sales or Procurement or HR the appropriate SSRS report linked to
that should be called.
Can you please kindly share ideas how to imple
|
3/1/2010 11:13:34 AM
|
3
|
KarenM <karenmiddl...@yahoo.com>
|
How to show traffic light or status signs
Hi All
I want to display traffic light kind of display for a bunch of metrics
in a SSRS report. If the metric is above a certain value I want to
show a green traffic light next to it, if it is close to certain value
show a yellow traffic light and if it is below a certain value show a
red traffic light against the metrics.
Can you please kind advice how I can do it I am also checking if it is
possible to show a Down arrow if the value is below a certain
threshold and greater than arrow if it is above a certain value.
Please kindly share ideas how I can do this in SSRS 2008 repor
|
3/1/2010 11:04:47 AM
|
0
|
KarenM <karenmiddl...@yahoo.com>
|
How to create a report with Frames running based on a linkage
Hi All,
I want to build a SSRS report with two frames (or windows )in it.
The way I want the report to work in on the left hand frame I will
source data from a query to list products. When the user clicks on
left hand frame on a product I want the right hand frame to list all
sales for that product. I want to keep both the left and right frames
to be visible.
Please note the left frame is running a query creating a dataset
something like this:
SELECT ProductName From Products where region = p_region (the
region is selected as a report parameter)
I want the list of pr
|
3/1/2010 10:47:26 AM
|
0
|
KarenM <karenmiddl...@yahoo.com>
|
how to stop subreports shifting horizontally if no data?
I'm a complete newbie here. Hope I can explain the problem clearly
enough and sorry if I get some of the terminology wrong. I'm using
Report Designer in SSRS 2005.
I have two subreports side by side in a list area on my main report,
one on the left and one on the right.
If there are data in both subreports, they render exactly as I want
them to.
But, if the first one (on the left) has no data to display, the second
one, which should appear to the right, is rendered shifted over to the
left where the first one would have been if there were any data. I
would prefer that a blank are
|
3/1/2010 9:46:53 AM
|
0
|
helenwheelss <helenwhee...@yahoo.com.au>
|
Passing multiple parameters in URL ...need help quick
Report 1 has parameter @Department_ID
Report 2 SQL select...where department_id in(@Department_ID)
Tried Bruce's example of passing multiple params. Below:
CREATE FUNCTION parms_list_to_tbl (@list nvarchar(MAX))
RETURNS @tbl TABLE (number int NOT NULL) AS
BEGIN
DECLARE @pos int,
@nextpos int,
@valuelen int
SELECT @pos = 0, @nextpos = 1
WHILE @nextpos > 0
BEGIN
SELECT @nextpos = charindex(',', @list, @pos + 1)
SELECT @valuelen = CASE WHEN @nextpos > 0
THEN @nextpos
|
2/28/2010 7:34:01 PM
|
7
|
=?Utf-8?B?T3JpZ2luYWxTdGVhbHRo?= <OriginalStea...@discussions.microsoft.com>
|
Matrix Columns
I have a report where the customer is the rows and each column is a month o
total sales. it works, but I am show ALL the dates when I want to limit it to
the last 12 months as of today. I am not sure how to do this.
Any help is appreciated.
|
2/28/2010 3:14:20 PM
|
2
|
"kjgreen1112" <u58...@uwe>
|
reports that produce no data
In sql server report 2005 (SSRS 2005), I will be generating some reports
that may not have any data selected at times. This can you can tell me how
can you display a message like 'The report is not generated since no records'
were selected for this report. Can you tell me how to solve this problem
either with sql and/or a sql server report 2005? If not no is selected, what
will sql server report display? Would it display anything at all!
|
2/27/2010 6:17:01 PM
|
2
|
=?Utf-8?B?V2VuZHkgRWxpemFiZXRo?= <WendyElizab...@discussions.microsoft.com>
|
format in text boxes
In a sql server report service 2005 report, I need to format a few paragraphs
before I displayed a chart. Thus, can you tell me is there a way to format
messages in paragraphs foramt like you can in word? If this is not an option,
do I need to use special carriage control and paragraph indicator characters
like '\C'>
Thanks!
|
2/27/2010 6:11:01 PM
|
3
|
=?Utf-8?B?bWlkbmlnaHQ=?= <midni...@discussions.microsoft.com>
|
sql server 2005
I want like to know how to do the following in sql server report service 2005:
1. Setup a main report and have it pass selected parameters to various
subreports.
2. Setup a table of contents for a report that has a main report and
various subreports.
|
2/27/2010 6:04:01 AM
|
1
|
=?Utf-8?B?amF6enlkYW5jZQ==?= <jazzyda...@discussions.microsoft.com>
|
Report Site SSL links broken
I am successfully running a reporting services site under SSL but...
The links in the upper left corner of all pages (Home/My
Subscriptions/Help/Search) are all still pointing to http:// not https://
Where do I fix this or even better can I remove/hide these links for the
"browse" group?
Pete Hay
|
2/27/2010 12:09:01 AM
|
0
|
=?Utf-8?B?UGV0ZSBIYXk=?= <Pete...@discussions.microsoft.com>
|
Export to .csv file without column headers
I've created a report with SRS. When I preview the report, I have no column
headers. However, when I export it to a .cvs file, the file does contain
column headers. I have no header row in the table. How can I export to a
file without column headers?
|
2/26/2010 11:26:01 PM
|
0
|
=?Utf-8?B?RWxhaW5l?= <Ela...@discussions.microsoft.com>
|
Chart Question #2
SSRS 2008.
Column Chart
One bar has a value of 50. The series is grouped by activity.
Budget = 25 (green part of bar)
Forecast = 15 (Gold part of bar)
Actual = 10 (Orange part of bar)
The label puts values in the appropriate section of the bar but does not
show a total for the bar. How can I show the total?
Thanks in advance
|
2/25/2010 6:10:01 PM
|
0
|
=?Utf-8?B?T3JpZ2luYWxTdGVhbHRo?= <OriginalStea...@discussions.microsoft.com>
|
reportviewer 2005 vs 2008
Is there any offical document that states reportviewer comes in VS2005 is
supported to connect to sql 2008 report server? Thanks in advance.
wt
|
2/25/2010 5:43:41 PM
|
0
|
"Dav Tan" <davi...@newsgroups.nospam>
|
Chart Question
I am doing a column chart in SSRS 2008. Is there a function or a way to
mouse over the bar and see the data value of the column. I see there is a
way to show the value in the bar but I want to be able to mouse over it
(value appears then disappears) like in excel. Is this possible?
Thanks in advance
|
2/25/2010 5:25:01 PM
|
1
|
=?Utf-8?B?T3JpZ2luYWxTdGVhbHRo?= <OriginalStea...@discussions.microsoft.com>
|
Dynamically Changing Prompts / Hidden Properties of Report Paramet
I would like to be able to dynamically change the Prompt and Hidden
Properties of a report parameter based on another parameter.
Ideally, I would like to be able to do this within Reporting Services, but
if this is not possible I could perform a solution outside reporting services
to manually change the report before the report is rendered.
I've looked online and haven't been able to find solutions.
Any help would be greatly appreciated.
|
2/24/2010 5:51:02 PM
|
0
|
=?Utf-8?B?TWlrZQ==?= <M...@discussions.microsoft.com>
|
Error during exporting a report in PDF format (SSRS 2008)
When running an SSRS report, and exporting to PDF, you receive the error:
An internal error occurred on the report
server. See the error log for more details. --->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred
on the report server. See the error log for more details.
When checking the error log you will find:
library!ReportServer_0-5!1e34!02/19/2010-14:41:21:: e ERROR: Throwi
|
2/24/2010 4:36:01 PM
|
0
|
=?Utf-8?B?SGFyaSBNdW5pa2Fy?= <Hari Muni...@discussions.microsoft.com>
|
Navigation to URL- mailto: failing when field text includes &
I am trying to use the Jump to URL to create a mailto link that opens up an
email with text filled in.
This works great, except when the data I am pulling in includes an &.
If the field I am pulling in includes an &, then the text stops at that
point. Any suggestions on how to fix this problem.
For example I have a company name in my database - "French & Parrello" -
when the code below runs, and gets to the field, Fields!Lessee.Value , that
I am trying to pull in, the text stops at the word French.
Below is the url I am using:
="mailto:" & Fields!Expr1.Value &
|
2/23/2010 3:54:02 PM
|
0
|
=?Utf-8?B?U2FteXJh?= <Sam...@discussions.microsoft.com>
|
Obtaining information of user in AD
Hi,
Is it possible to extract AD information of the user running the SSRS
report? Currently only UserID is available.
For example, I would like to extract the user's primary e-mail address in AD
and use it to lookup other details from our HR directory (exposed as web
service).
What are the areas that I need to look into in order to achieve the above
results?
Thanks.
--
Best regards,
Jude
|
2/23/2010 4:19:01 AM
|
4
|
=?Utf-8?B?SnVkZSBXb25n?= <JudeW...@discussions.microsoft.com>
|
Defaulting the (Select All) Parameter SSRS2005 SP2
Is it possible to default the 'Select All' without adding an 'All' union to
my SELECT parameter query? I understand how to do it via the 'All'
methodology, but since 2005 SP2 has reinstated the (Select All) option, can I
just get it to default?
Thanks in advance all
Michael C
|
2/22/2010 7:45:01 PM
|
0
|
=?Utf-8?B?TWljaGFlbCBD?= <Micha...@discussions.microsoft.com>
|
Parameter Refreshing Problem
p1 = State (1-Georgia, 2-Florida)
p2 - City(A-Atlanta, B-Decatur, C-Miami, D-Daytona)
scenario1. Report1 opens(@p1 in(1), @p2 in(A,B)...works fine
scenario2. Report1 opens(@p1 in(1,2,), @p2 in(A,B,C,D) works fine
Issue: When in scenario1, the report is generated with one p1 value. When
the user goes back and adds another value to P1, the P2 parameter is not
being refreshed. But if you select all values on both, generate the report
then go back and just select one value for p1 the p2 value refreshes. Help!
|
2/22/2010 4:03:01 PM
|
0
|
=?Utf-8?B?T3JpZ2luYWxTdGVhbHRo?= <OriginalStea...@discussions.microsoft.com>
|
datadriven subscription change default parameter for weekly monthl
how can you change a data driven subscription so that you override the
default parameter to change a report so that it either contains weekly or
monthly figures
thanks
|
2/22/2010 2:32:01 PM
|
0
|
=?Utf-8?B?aWFucA==?= <i...@discussions.microsoft.com>
|
CRM Report Issue
I designed a custom report to run pending activities & assigned
activities of current loggin user.
This report is running in report server and showing current user's
assigned activities. i am passing current user name in parameters as
@User Name from sql query. After deploying this report into crm. its
throwing an error message like this.
"An error has occurred during report processing.
The Value expression for the query parameter =91@UserName=92 contains an
error: Index was outside the bounds of the array"
The current user name passing from crm report as "NT AUTHORITY\NETWORK
|
2/22/2010 10:31:49 AM
|
0
|
Siva <jksi...@gmail.com>
|
SSRS Date Picker
The date picker is added by default to the report after choosing the datetime
data type...
How can I add a custom date picker to the report?
|
2/20/2010 10:00:01 AM
|
0
|
=?Utf-8?B?eWVrdGE=?= <ye...@discussions.microsoft.com>
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 02197
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M
Pre�o: R$ 1900.00
Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar!
Audi a3 automatico
Audi a3 1.8 t automatico
Audi a3 1.8 turbo automatico
VW Golf gti automatico
VW Golf 2.0 automatico
VW Golf 1.8 turbo auto
|
2/20/2010 3:24:29 AM
|
0
|
kit solenoites audi solenoid.chicote<kit.solenoites.a...@solenoid.chicote.com>
|
Dynamic files in SSRS
I would like to convert completely from CR to SSRS. One of the most painful
areas is automated letters and "mail-merge-like" coding in .Net.
I'm curious how to make .jpg signature files dynamic in SSRS.
|
2/19/2010 6:36:01 PM
|
0
|
=?Utf-8?B?R2FyeQ==?= <G...@discussions.microsoft.com>
|
datasources
I was wondering if it is possible to join 2 different datasources in
Reporting Services.
|
2/19/2010 4:40:23 PM
|
1
|
"Ben Watts" <benryanwa...@live.com>
|
two chartarea with the same axis scale
Hi,
how can I customize the same axis scale for overlaid chartarea in one chart?
thx
|
2/19/2010 1:50:14 PM
|
0
|
"Michi" <michi1...@hotmail.com>
|
Report Server Security Settings Problem
I am unable to deploy a report to my local report server. On my Window
7 Professional machine the reporting service is running, I am in the
local administrators group on my machine, and I have administrator
rights on my SQL Server 2008 Standard installation (a full
installation). When I attempt to deploy a report from Visual Studio
2008 it says I don't have sufficient permissions. Also, when I browse
http://localhost/reports the page displays but I don't have the "Site
Settings" link. When I browse http://localhost/Reportserver I get "The
permissions granted to user '***' are insuffi
|
2/18/2010 10:23:47 PM
|
2
|
Skeptical Inquirer <wolf.ran...@gmail.com>
|
Initial Toggle State question
Report1 has the following columns (jan, feb, mar, Q1...YTD)
If the current accounting period is in Q1, the report opens with Jan - Mar
expanded and all other accounting periods will be collapsed to Qtr view.
My problem is when the report opens with the columns expanded, the Q1 node
is a plus(+) and the columns are already expanded. Can I manipulate the
initial toggle state programatically to make this right. If so, how do I get
to it? If I am barking up the wrong tree please let me know. I am using
SSRS 2008.
Thanks in advance
|
2/18/2010 4:14:05 PM
|
0
|
=?Utf-8?B?T3JpZ2luYWxTdGVhbHRo?= <OriginalStea...@discussions.microsoft.com>
|
A report embedded in an iframe when exported to a web archived format opens in the same IE window
Hi I am using SSRS2005 to produce reports which fetch data from MS SQL Server 2005 database. These reports are then embedded in an .net application in an iframe. Now when I try to export the report into a web archived format then the report opens in the same window in IE8.Due to this I have to click on the Back button on the browser window to view the remaining reports. Hence I want to open this exported report in a new window in IE8.But,I am unable to do so.
Could anyone please help me to find out as to how can I open the reports in a new window in IE8.Are there any kind of IE settings whi
|
2/18/2010 8:18:49 AM
|
0
|
CrazyKat<nos...@developmentnow.com>
|
display 2005 rdl in 2008 report service
Can sql server reporting service report 2005 rdl be displayed in sql server
report service 2008 without doing any conversions? If so, are there things I
should be aware of that might cause a problem? If not, can you point me to a
URL that will show me how to convert sql server 2005 reports to sql server
2008 reports (rdls)?
Thanks!
|
2/18/2010 5:35:01 AM
|
1
|
=?Utf-8?B?amF6enlkYW5jZQ==?= <jazzyda...@discussions.microsoft.com>
|
DESCARGAS - ANTIVIRUS GRATIS 7646
Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
http://antivirus-gratis-descarga.blogspot.com/
Links de contenido del sitio web:
http://antivirus-gratis-descarga.blogspot.com/
http://antivirus-gratis-descarga.blogspot.com/2009/08/que-es-un-antivirus.html
http://antivirus-gratis-descarga.blogspot.com/2009/08/descarga-gratuita-de-antivirus.html
http://antivirus-gratis-descarga.blogspot.com/2009/0
|
2/17/2010 6:31:01 PM
|
0
|
=?Utf-8?B?YW50aXZpcnVzIGdyYXRpcw==?= <antivirusgra...@discussions.microsoft.com>
|
RS stoped working
I have a Reporting Services server that I needed to put Integrated Services
on. After the install my Reporting Services no longer works. Get the old
"target machine actively refused" error. Nothing relating to that changed
that I am aware of. Reporting Services Configuration still looks good.
Any ideas what changed? What I need to do to get my RS working again.
John
|
2/17/2010 3:56:46 PM
|
2
|
"John" <j...@regionv.k12.mn.us>
|
Using a DLL
Hi All
I am assessing whether we should move to reporting services to make
available various company reports via the web.
While most reports have a stored procedure origin for their data, there are
a few of our reports that require some programatic massaging.
These reports typically involve some specialised data pivoting and/or
formatting.
My question is, can reporting services utilise a custom dll as the source of
data for a report? As an example, reporting services can generate a report
from a stored procedure via a select statement. Can reporting services build
a report fr
|
2/17/2010 6:28:37 AM
|
1
|
"Harry Strybos" <harrystry...@optusnet.com.au>
|
Using a dll to generate report data
Hi All
I am assessing whether we should move to reporting services to make
available various company reports via the web.
While most reports have a stored procedure origin for their data, there are
a few of our reports that require some programatic massaging.
These reports typically involve some specialised data pivoting and/or
formatting.
My question is, can reporting services utilise a custom dll as the source of
data for a report? As an example, reporting services can generate a report
from a stored procedure via a select statement. Can reporting services build
a rep
|
2/17/2010 5:58:10 AM
|
0
|
"Harry Strybos" <harrystry...@optusnet.com.au>
|
Form letter?
Hi,
We send out a satisfaction survey each week and I thought I could save my
administrative assistant some time by eliminating the mail merge step and
just create the form letter out of SSRS. Right from the get-go I'm
struggling. What is the best way to add the boiler plate text to the
report? Do I simply add a bunch of text boxes?
Since this is a survey there are check boxes and numbers to circle and so
forth so formatting looks to be complicated. What is the best way to handle
that? Is it possible to simply import a Word document?
And finally, if these other questi
|
2/15/2010 7:19:20 PM
|
2
|
"Linn Kubler" <lkub...@chartwellwisc2.com>
|
Displaying multi-select parameter on report?
Hi,
I have a report where I use a multi-select parameter to filter the report by
the user's initials who entered the record. I typically like to print the
paramters selected for a report in the header of the report. However, when
I put this parameter.value on the report I only get the first option
selected. How can I list all the selected entries?
SQL Server 2005.
Thanks in advance,
Linn
|
2/15/2010 6:41:42 PM
|
2
|
"Linn Kubler" <lkub...@chartwellwisc2.com>
|
Protocol violation w/custm scurity on XP w/ a 2nd instance of SSRS
I am having an issue developing against a secondary instance of SSRS on XP.
I install the secondary instance and everything is fine. I can browse to
both instances, the secondary using the URL 'localhosts/reportdev'.
I then implement a known custom security extension by deploying DLL's and
making various changes to config files. The custom security enables the use
of LDAP instead of Active Directory for item role assignment authentication.
This bit is fairly complicated, but is known to work.
When I then browse to the secondary instance of SSRS I receive the following
error:
|
2/14/2010 11:08:01 PM
|
0
|
=?Utf-8?B?QWxleCBUaG9tYXM=?= <AlexTho...@discussions.microsoft.com>
|
Achat acomplia france acomplia suisse au rabais au suisse Achat acomplia Simple acheter acomplia canada en linge sans presription acheter acomplia canada concern�es par cette
Achat acomplia france acomplia suisse au rabais au suisse Achat acomplia Simple acheter acomplia canada en linge sans presription acheter acomplia canada concern�es par cette
+++ PERTE DE POIDS +++ PERTE DE POIDS +++ PERTE DE POIDS +++
+
ACHETER ACOMPLIA BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACHETER-ACOMPLIA-BON-MARCHE/
http://jhku.net/ACHETER-ACOMPLIA-BON-MARCHE/
http://jhku.net/ACHETER-ACOMPLIA-BON-MARCHE/
+
+
ACHETER XENICAL BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACHETER-XENICAL-BON-MARCHE/
http://jhku.net/ACHETER-XENICAL-BON-MARCHE/
http://jhk
|
2/14/2010 11:58:56 AM
|
0
|
sdgv...@yahoo.is.com
|
Displaying Parameters in the Report Title
I would like to have a dynamic Report Title that includes the Start_Date and
End_Date parameters I have for a report. I have had no luck finding this
information elsewhere on the internet.
So, the report title would be "Number of Letters between @Start_Date and
@End_Date"
Thanks.
|
2/12/2010 6:08:01 PM
|
3
|
=?Utf-8?B?Q1N3YXJ0eg==?= <CSwa...@discussions.microsoft.com>
|
Printing Barcode Font in RS2008
We have several reports that use custom barcode fonts, and these have been
working happily for ages.
We have recently deployed our reports to a sql2008 instance and have hit a
big problem.
The Report Previews correctly in Reporting services (i.e. the user sees the
barcode)
The report previews AND prints correctly in VS2008.
but...
When we print from Reporting services the barcodes font is not displayed
(gibbersish characters are displayed instead).
We have checked that the users all have the barcode fonts installed locally.
We have also installed the barcode fonts on t
|
2/12/2010 3:21:01 PM
|
1
|
=?Utf-8?B?cHJvZ3JhbW1lcl9taWtl?= <programmerm...@discussions.microsoft.com>
|
Pagebreak between group footers
I have a report that is grouped by Salesperson, then by customer. The footer
for the customer group totals some fields for that specific customer then the
footer for the Salesperson group totals some fields for all the customers
that fall under that salesperson.
The problem is, I need that salesperson total footer to show on a new page.
I put "New Page After" the customer group but the problem is, it only works
when exporting the report to a PDF or printed. When the report is exported or
printed the Salesperson footer shows on its own page. But if you just run the
report, the
|
2/12/2010 2:49:01 PM
|
0
|
=?Utf-8?B?TWF0dCBN?= <Ma...@discussions.microsoft.com>
|
Font is not proper in PDF?
Hi ,
I have created custom report item.
In this custom report item , i have created some text using System.drawing;
It looks proper in report at the time of preview.
But when i save the report into pdf it does not look proper. It is distorted
in pdf.
Can anyon e help.
|
2/11/2010 7:46:02 AM
|
1
|
=?Utf-8?B?amF5ZGVlcCBwYXJla2g=?= <jaydeep par...@discussions.microsoft.com>
|
turning off case sensitivity
Is there a configuration option to turn off case sensitivity in the
BID/visual Studio reporting IDE/etc.?
Our db collation sequence is case-insensitive so I know the problem is
with reporting services.
My problems begins when i modify some SQL - changing the case of a
column accidently...BID then reports a 'missing column' error and i'm
spending time dealing with it. Even when i correct the SQL - changing
the case back to the original ASCII...BID still thinks its in the
changed state...regenerating the dataset does not fix the
problem....so here i am going through every control t
|
2/10/2010 8:55:48 PM
|
0
|
astrodog <kent.eil...@res-direct.com>
|
Solar cells for less than 1 USD per Watt
Do you know that you can find solar cells for less than 1 USD per Watt
on www.ebay.com ?
Regards.
|
2/10/2010 7:10:59 PM
|
0
|
".." <sustainable.future...@gmail.com>
|
End of Support Date for Report Builder 1.0
We are looking to configure an environment that uses SQL Server 2008 Report
Services and a majority of the team would like to use Report Builder 2.0.
Howerver, some members have would like to use only Report Builder 1.0. Is
there a defined end of support date for Report Builder 1.0? Is there any
known issues with using Report Builder 1.0 in an enviroment where the models
are built using BIDS 2008 and most reports will be written using Report
Builder 2.0.
|
2/10/2010 4:29:01 PM
|
1
|
=?Utf-8?B?QyBSQU1TRVk=?= <CRAM...@discussions.microsoft.com>
|
Subtract date problem
Hi there,
I'm using SSRS 2008
I have period end like 1/19/2010 field and I want to generate -5 days
(seperate textbox) from it like
1/15 1/16 1/17 1/18 1/19
I try =MyFileld.value - 1 and I got an error
How do I sbtract day fron date field?
I did also Month(myfield.value)&"/"&Day(myfield.value)-1 it works but this
is not woks allways.
Thanks
|
2/10/2010 1:39:33 PM
|
3
|
"odeddror" <odedd...@cox.net>
|
converting Crystal Reports to RS
SQL 2005
I'm brand new to Reporting Services, but have been a SQL developer for
years. Up to this point all my reporting has been done using Crystal
Reports. I'm trying to convert some existing reports from Crystal Reports
to Reporting Services. So far I'd have to say I'm not impressed with RS as
far as it's compared to Crystal. I know some of that is familiarity so I
thought I'd ask a couple of basic questions here so I can be clear of my
understanding of RS. Thanks in advance for any help/tips you can offer.
My Questions:
.. I'm using SQL Server Business Intelligence
|
2/10/2010 7:45:27 AM
|
19
|
"Andre" <...@spam.com>
|
User denied access to reports after account name change
We have several users who have gotten married which has led to their account
name being changed. Now the can not run any reports, they get an access
denied error.
The reports are being run in SharePoint integration mode.
The data connections are not using "Windows authentication (integrated)" mode.
All other users are fine.
Any ideas?
|
2/10/2010 5:02:01 AM
|
1
|
=?Utf-8?B?UmluY2V3aW5kNjA=?= <Rincewin...@discussions.microsoft.com>
|
Confused by Role Assignment for individual reports
I just built a couple reports and setup the Report Server on a 3rd
party host
The application that collects the data is public but the reports are
for a single internal user only.
I have added the report to the RS and I can execute it (I'm admin)
without a problem.
I'm trying to setup a specific login to the machine/RS so this one
user can run the reports
I've created a new user on the 3rd party Windows 2003 Server
Then went into the Report Manager, clicked Edit for the 1st report,
then Security, then New Role Assignment
I typed in the user name (I tried it with and w
|
2/9/2010 1:43:29 AM
|
0
|
mike <themusicliste...@gmail.com>
|
sql server report service connect to web service
I have a couple of questions to ask you about a sql server reporting service
connecting to a webservice within the DMZ. I am asking this question since I
want to avoid the double hop problems that occur by using IIS on sql server
2005. (This is when you use windows authenication in sql server 2005 to
connect to IIS.)
Right now my company is using sql server 2005 and may upgrade to sql
server 2008 within the next couple of months.
The following questions pertain to using sql server 2005 and visual
studio.net 2005:
1. If I want to have sql server report service 2005 conn
|
2/7/2010 9:41:01 PM
|
0
|
=?Utf-8?B?amF6enlkYW5jZQ==?= <jazzyda...@discussions.microsoft.com>
|
how to generate programmaticaly rdlc files at runtime using c#.net
Hello,
I"m working with some application development(crm solution) with require to
generate programmaticaly rdlc file at runtime, but i don't know how to do.
msdn online help only provides tutorial on how to generate rdl file but not
rdlc files.
Any Help will be welcome.
thank in advance.
Stephane
|
2/6/2010 3:59:27 PM
|
0
|
"Steph" <ntst...@hotmail.com>
|
Still not working
I used your method and I get the error- An internal error occurred on the
report server. See the error log for more details. (rsInternalError) Get
Online Help
The source of the report definition has not been specified.
My .Net command-
Process.Start("http://localhost/ReportServer?/Pages/Report.aspx?ItemPath=%2fLegReviewRS%2fReviewDetail&rs%3aCommand=Render&RevID=" & CurrentRevID)
It is a hidden parameter.
This has always worked with the following parameterized command-
Process.Start("http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fLegReviewRS%2fReviewDetail&rs%3aComm
|
2/5/2010 1:03:02 PM
|
0
|
=?Utf-8?B?R2FyeQ==?= <G...@discussions.microsoft.com>
|
Data Source Issues After Moving ReportServer DB to new server
Our report developers had created RDLs and posted to Report Manager. Then in
Report Manager, reports data source is changed to point to a single new
datasource set up in Report Manager.
Now we have migrated Report Server database to new server using
backup\restore (not RSScripter) but reports now generate error
An error has occurred during report processing.
Cannot create a connection to data source 'XXX'.
The XXX data source is seen in the .rdl file. It seems that reports revert
back to data source that was set up when developers designed reports in BIDS.
Is there a
|
2/4/2010 11:23:02 PM
|
0
|
=?Utf-8?B?VGFtbXkgTWlsbGVy?= <TammyMil...@discussions.microsoft.com>
|
ASP .NET Services Account not showing up.
Trying to configure SQL Reporting Services on a Windows 7 machine. Get to
the Web Service Identity item an ASP .NET Services Account is empty. Any
one have any idea what I'm missing? I've done this a dozen time on Vista
machines and it always has NETWORK SERVICES... in there.
Thanks
John
|
2/4/2010 10:31:46 PM
|
0
|
"John" <j...@regionv.k12.mn.us>
|
Email Subscription Column Width Issues
I have an email subscription and it always seems to condense the columns into
very strange widths. The first column simply has a one word "event" and it
always seems to have the last one or two letters pushed into two lines. It
seems as if the emailed subscription totally ignores any column width
formatting I may have done in the published report.
I did find a posted solution about editing the ReportingServices.css file
and adding a minimum width, but this did not work for me. Here's the link
for that:
http://stackoverflow.com/questions/1178838/setting-the-minimum-column-wid
|
2/4/2010 10:20:01 PM
|
1
|
=?Utf-8?B?Q1N3YXJ0eg==?= <CSwa...@discussions.microsoft.com>
|
SSRS Licensing
I'm getting ready to install SSRS 2008 on a production server. If I have a
known number of users outside my organization (ie web users) that will be
able to run SSRS reports, will we need to still buy per processor licenses?
The application that uses SSRS requires a login to be setup, so we will
always know how many users there are outside our organiziation that will be
accessing these reports. Does anyone know if we can get by with a server
license or CALs? Or does 1 outside user require us to purchase processor
licenses?
|
2/4/2010 9:51:01 PM
|
2
|
=?Utf-8?B?SmFzb24=?= <Ja...@discussions.microsoft.com>
|
Sort parameter list from Report Model
I am desperately searching for a way to sort a parameter list that is
generated from a Report Model data source. We are using Report Builder 2.0.
If this feature is not supported then I believe that this is a huge
oversight on Microsoft's behalf. Users only want to pick from a sorted list!
|
2/4/2010 8:51:01 PM
|
0
|
=?Utf-8?B?SmFtZXM=?= <Ja...@discussions.microsoft.com>
|
use not use the date parameters
I have a report (and eventually more reports) that have the 2 date parameters
for start date and end date. The users will want to only enter the start
date and not have to enter the end date which would return all appropriate
records from the start date going forward. They also want to be able to
enter only the end date and get all appropriate records up to the end date.
Is this possible in reporting services 2005 standard? If so, where and how?
I'm still learning this ssrs stuff, but getting better at it.
Thanks... John
|
2/4/2010 6:37:01 PM
|
4
|
=?Utf-8?B?Sm9obkU=?= <Jo...@discussions.microsoft.com>
|
Reporting Services deployment question
Hi,
We have two buisness units in our company and we setup two separate SQL 2005
Servers, one for each business unit. We are just about to go live on the
second unit and I have been creating some reports for them and was about to
deploy when I realized I never installed IIS on this SQL server.
So now I'm wondering what is the best course of action. Should I simply run
all the reports off the first SQL server with the existing Reporting
Services? Or, should I install IIS and configure Reporting Services on the
second SQL server for reports relating to it. Not sure how to c
|
2/3/2010 7:09:58 PM
|
7
|
"Linn Kubler" <lkub...@chartwellwisc2.com>
|