one page vs mult pages results
I have a lengthy report that can at times span 50-60 pages. One of the other
dba's modified the report, now the results all show up on one verrrry long
page. we have been tying for a few days to figure out how to get it to span
multiple pages again, with no luck. Would someone please advise what property
to modify to get the report to span pages again?
I would greatly appreciate it if someone could help out!! Tag: Define Data Serie Colour in Pie Chart Tag: 65460
Group Filter doesn't work as expected
Employee (Group H1) AVG( of all Ratings)
Job # (Group H2) Rating
Rating is a "Calculated" field in the Dataset.
I put a filter on Job# (Group H2) to only include Ratings > 25%
Results:
Job#'s are filtered properly and every job < 25% does NOT show. HOWEVER,
the AVG (of all Ratings) ignores the Group 2 filter and includes every job
even those with a rating < 25%.
How can I get the "Avg Rating" to also only average those ratings according
to the group 2 filter I setup?
mythreads Tag: Define Data Serie Colour in Pie Chart Tag: 65458
Bug with text orientation
I've found following bug:
When there is an polish letter (=B3, =E6, etc.) in a textbox which is set
to display vertically ("tb-rl" mode) then you may encounter problems
with orientation format in Excel export file.
Kamel Tag: Define Data Serie Colour in Pie Chart Tag: 65456
Matrix Subtotal
Dear all,
I have a sales break down matrix report like following
Prod1 Prod2
Prospect Status Amount Porbability Status
Amount Probability
p1 Declined 0 0
Follow-up 100 50
p2 Closed 200 100
Sub Total Closed 200 100 Follow-
up 100 50
Now, i don't need the subtotal -- status and probability so what
should i do inorder to hide some speicfic fields from subtotal
Thanks and regards Tag: Define Data Serie Colour in Pie Chart Tag: 65452
Problem: render a report which should show data in coulmns
Hello,
I'm designing a report which contains a sub report. The sub report show a
list of data (firstname, lastname).
I'm tyring to display data separated by columns.
When you use the report Item "List" there is only the possibility to use a
page break before or after.
Is there a way to use or implement a kind of "column break" ?
Thanks Tag: Define Data Serie Colour in Pie Chart Tag: 65451
Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite)
Hi,
A CMM Level 5 company is looking for Microsoft Business Intelligence
(MS BI) professionals for its Hyderabad location. There is a an
element of onsite travel & work to this position.
Please keep the following points in mind before mailing your CV.
1. STRICTLY NO FRESHERS PLEASE. FRESHER CVs WILL BE IGNORED.
2. Location for these positions is Hyderabad.
4. Experience criteria : 1+ years of experience in Microsoft Business
Intelligence (MS BI) in SQL Server 2005 (2005 only, not
any previous versions)
Mandatory Experience
i. Specific expertise of SQL Server 2005 Analysis Services and/or
Reporting Services and/or Integration Services. i.e SSAS,SSRS and
SSIS.
Preferred (not compulsory) Experience:
i. Appropriate Certifications.
ii. Experience of working in well known software services / product
companies.
5.If you do not have relevant experience or you do not have enough
experience, please DO NOT MAIL YOUR CV.
6.If you are sending your CVs, please put in relevant subject for the
mail; for e.g. "MS BI - SSIS - 3 yrs experience" or "MS BI SSRS - 2
yrs experience"
7. Important: - In your mail, (not in CV) please add the following
information :
Current Location: -
Current Salary: -
Expected Salary: -
Willingness to relocate to Hyderabad: -
How fast can you join if selected (i.e. notice period)?
6. Again: - Please mail your CV to wiprojects@yahoo.com
Thank You.
From,
WI Projects Tag: Define Data Serie Colour in Pie Chart Tag: 65448
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found error!
I have SQL 2005 installed on my server. When I ran a SQL report
return
with less data, it will work but when I select more data, it returned
with
below error.
Any suggestion? Below is the exception error in detail for your
reference.
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found
(rsExecutionNotFound)
Description: An unhandled exception occurred during the execution of
the
current web request. Please review the stack trace for more
information about
the error and where it originated in the code.
Exception Details:
Microsoft.Reporting.WebForms.ReportServerException:
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found
(rsExecutionNotFound)
Source Error:
An unhandled exception was generated during the execution of the
current web
request. Information regarding the origin and location of the
exception can
be identified using the exception stack trace below.
Stack Trace:
[ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot
be
found
(rsExecutionNotFound)]
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +291
Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String
executionId, Boolean fullReportLoad) +110
Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollect=
=AD
ion
requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +269
Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionSt=
=AD
ep.Execute()
+154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64 Tag: Define Data Serie Colour in Pie Chart Tag: 65442
SQL 2005 Reporting Service Requirement
Hi, What are the requirements for installing SQL 2005 Reporting Service? Can
I install it in a windows 2000 server in NT4.0 Domain?
I tried to install sql 2005 reporting service in a windows 2000 box, when I
went into Configure Report Server, everything is fine except there is a red
cross in front of Web Service Identity, and under Specify the application
Pool in which runs the report web service, there is nothing.
Can you tell me what could be the problem?
Thanks, Tag: Define Data Serie Colour in Pie Chart Tag: 65439
ParametersUsed Always Polulated after calling ReportingService.Ren
In SSRS 2000 SP2 the documentation for ReportingService.Render states that
the ParametersUsed output parameter should only be populated only if the
report being rendered is a report history snapshot. I'm invoking the Render
method with a null HistoryId as follows, so I would expect the ParametersUsed
output parameter not to get populated.
results = m_RptService.Render(m_RptCatalogItem.Path /*Report*/,
m_Format /*Format*/,
null /*HistoryID*/,
null /*DeviceInfo*/,
m_RptParameters /*Parameters*/,
null /*Credentials*/,
null /*ShowHideToggle*/,
out encoding /*Encoding*/,
out mimeType /*MimeType*/,
out historyParms /*ParametersUsed*/,
out warnings /*Warnings*/,
out streamIDs /*StreamIds*/);
The call generates the following HTTP traffic. As you can see the HistoryId
is not sent in the request yet ParametersUsed is populated in the result. If
I'm interpreting the documentation correctly this value should not be
populated in the response. I really don't what ParametersUsed to be
populated in the response. Is this the correct behavior?
POST /ReportServer/ReportService.asmx HTTP/1.1
Content-Type: text/xml; charset=utf-8
SOAPAction:
"http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/Render"
Content-Length: 524
Expect: 100-continue
Host: localhost
Cookie: sqlAuthCookie=****; UsrTkn=>****; AppTkn=>****
<?xml version="1.0" encoding="utf-8"?><soap:Envelope
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><Render
xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><Report>/ReportServerStatistics/PTest</Report><Format>HTML4.0</Format><Parameters><ParameterValue><Name>p1</Name><Value>2/11/2007
7:32:50
PM</Value></ParameterValue></Parameters></Render></soap:Body></soap:Envelope>
HTTP/1.1 200 OK
Date: Mon, 12 Feb 2007 00:32:50 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
X-AspNet-Version: 1.1.4322
Cache-Control: private, max-age=0
Content-Type: text/xml; charset=utf-8
Content-Length: 9021
<?xml version="1.0" encoding="utf-8"?><soap:Envelope
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><ServerInfoHeader
xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><ReportServerVersionNumber>Microsoft
SQL Server Reporting Services Version
8.00.1038.00</ReportServerVersionNumber><ReportServerEdition>Enterprise</ReportServerEdition></ServerInfoHeader><SessionHeader
xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><SessionId>glbci3rl3utt1iqmon253t45</SessionId><IsNewExecution>true</IsNewExecution><ExecutionDateTime>2007-02-11T19:32:50</ExecutionDateTime><ExpirationDateTime>2007-02-11T19:32:50</ExpirationDateTime></SessionHeader></soap:Header><soap:Body><RenderResponse
xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices"><Result>
Base 64 Encoded response removed to shorten post
</Result><Encoding>Unicode
(UTF-8)</Encoding><MimeType>text/html</MimeType><ParametersUsed><ParameterValue><Name>p1</Name><Value>2/11/2007
7:32:50 PM</Value></ParameterValue></ParametersUsed><StreamIds
/></RenderResponse></soap:Body></soap:Envelope> Tag: Define Data Serie Colour in Pie Chart Tag: 65438
Crystal designer features I can't find in SSRS
Coming from a Crystal background, I was assessing SSRS 2005 and ran into
two things I know will generate a lot of pushback from my coworkers. In
Crystal you can place group heading fields anywhere you want in a group
band, where as grouping appears to be accomplished in SSRS by consuming
an entire table column. I suppose I could fake it by making the detail
of the main report contain my grouping data and render the detail with a
sub-report, but that's overkill for such a common formatting feat.
Example (note the horizontal positioning of the group field):
Crystal lets us do this:
Group1
Detail1 Detail2 Detail3 Detail4
SSRS tables require me to group like this:
Group1
Detail1 Detail2 Detail3 Detail4
I would be thrilled if I'm just overlooking something obvious and you
can place a group heading anywhere you want.
Also, we recreate paper forms in some reports (invoices, POs, etc.) and
positioning of drawn lines and text is *much* easier when you zoom in
with the designer to 200%. I didn't see how to do this in SSRS
designer, what am I missing?
Rob Tag: Define Data Serie Colour in Pie Chart Tag: 65434
q; users in RS2005
How do you set up user as who can access what report in Report Manger. I do
not see security tab in RS2005. Tag: Define Data Serie Colour in Pie Chart Tag: 65430
Complex data processing in reporting remote mode / Asp.Net
Hi,
I wonder what is the best practice to use ASP.Net and reporting service
when using remote mode with complex data processing. The report data from a
few data sources and needs to use business logic (vb code) to prepare. Can
these data processing code integrate into report? If so, where to place the
trigger and load the processing function(s) before the report is loaded?
Thanks,
Luke Tag: Define Data Serie Colour in Pie Chart Tag: 65429
Subscription Job
Hi,
I have the following two questions.
1. Does anyone know if I want to re-schedule the subscription, do I have
to change it using Reporting Manager or I can directly change it in a job -->
schedule under SQL Agent? Currently I have the job setup to run every one
hour but I would like to change it to every two hours, any idea if i can
change it in a job directly?
2. I found out the user account to start the job is Network Serivice
Account. If I change the startup account for Reporting Serivces under SQL
Configuartion, would the job be run under the new startup account?
Thanks Tag: Define Data Serie Colour in Pie Chart Tag: 65427
rsInternalError
I have reporting services installed on my xp laptop and haven't used it for a
while. Now when I try to run a report I get the following error message.
@AwaitingFirstExecution is not a parameter for procedure CreateSession
Anybody seen this before? I can't find any information about this.
Thanks
MG Tag: Define Data Serie Colour in Pie Chart Tag: 65425
RS 2005 Configuration error
Has anyone seen the following?
RS Virtual Directory
System.Management.ManagementException: Provider failure
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)
RM Virtual Directory
System.Management.ManagementException: Provider failure
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at
ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)
Server is an IA64 Windows 2003 Enterprise Edition, SQL 2005 IA64 Enterprise
Edition. Is this what happens if the the install location isn't made to the
default on C:?
Thanks in advance.
--
jl Tag: Define Data Serie Colour in Pie Chart Tag: 65421
Handle Hyperlink on winforms report viewer
In a recent application i built, we had a requirement to connect to a
Sharepoint 2007 site, and pass in user form auth. credentials through
our own custom form (which had a webbrowser control built into it).
On one of the reports, the client wanted when the user click a detail
item, for it to open the link , but in the custom browser form I
described above so that it could take care of the "single signon"
behind the scenes.
I accomplished this by using the
Microsoft.Reporting.Winforms.ReportViewer control to render the
report, and then on my form which contained the report viewer control,
I handled the RepoertViewer.HyperLink event, canceled the event, and
passed the hyperlink to my custom browser form.
Hopefully this small little tid bit helps someone else Tag: Define Data Serie Colour in Pie Chart Tag: 65419
Multiple Formats...
I have a textbox that reads " Money: " and then a cash amount..... I have
formated the expression like this -
="Money: " & Format(Sum(Fields!Amount.Value),"C")
but my question is how can i get the SUM to be a different color than what
the word Money is. Currently money is defaulted to black but I want the SUM
to be green.
Any help will be greatly appreciated, thx!
--
CipherTeKST
MCSE: Security 2003, CCNA, Security+ Tag: Define Data Serie Colour in Pie Chart Tag: 65418
Multiple option report parameter against single field data
I am trying to build a report that has a multiple option parameter
that is used to restrict data returned based on if all the options
exist in a field.
The parameter lists multiple values (versions of a document), i.e.
1.0, 1.1, 2.0 etc. Each version is a separate option. Multiple values
can be selected.
The data for the versions is stored in a single field,
i.e. ;#1.1;#1.2;#2.0;#
I have been having difficulty in getting this to work when multiple
options are selected.
I started with the dataset query as:
SELECT stuff
FROM table
WHERE ([Version] LIKE '%' + @VERSION + '%')
This worked fine when a single version was selected, but not when
multiple versions where selected. I have tried a bunch of things
including creating a function that takes @VERSION and parses out the
chosen options and concatenates the command string for another like
operation. This almost worked, except that the input from the report
is supplied as: N''1.1'',N''1.2'' and when put in the function, the
comma is interpreted as an additional parameter. I have tried to add
single quotes around the input without success, RS escapes it all
out.
I get the impression that I have completely missed the boat on this
one so I am interested in other idea on how I can accomplish this. Tag: Define Data Serie Colour in Pie Chart Tag: 65417
Getparameter() problem
how to get current Getparameter() value ? i always get the old value after i
try to call getparameter() ?
Thank you
Iwan Budihalim Tag: Define Data Serie Colour in Pie Chart Tag: 65416
Document Map - Need to Remove
I have removed the Document Map labels on my text boxes. When the report is
rendered in RS, the document map pane is still displayed with only the name
of the report in the pane.
Question: how do I make this go away? Tag: Define Data Serie Colour in Pie Chart Tag: 65414
Deploy problem; RS2005
I am not able to deploy report to report server, I have this error:
The permissions granted to user <IUSR_MashineName> are insufficient for
performing this operation. Tag: Define Data Serie Colour in Pie Chart Tag: 65413
Reporting Services 2005 report in Outlook 2007
I have a Reporting Services 2005 report that is emailed to users. I
created/formatted the report based on how it looked in Outlook 2003 which
all of our users had at that time. The report is wide, but just fit in the
email window when it was full size. Now I have a user who has been
converted to Outlook 2007 and he emailed me a copy of the report he received
in Outlook 2007 and it looks like it reduced the column sizes; it does not
fill the entire email window and wraps the wording on most lines because the
column sizes have been reduced.
The report is:
Delivered by: Report Server E-mail
Include Report is checked
Render Format is Web archive
Any ideas on how I can fix this?
Thanks in advance.
--
DJanson Tag: Define Data Serie Colour in Pie Chart Tag: 65412
Permissions
I am writing my own security extension, I have it working perfectly fine on
the web service end.. I can run reports, etc... but on the report manager
site the http://host/reports site.. I dont get anything except the header...
what permissions does the user have to have to see a toolbar and reports
list? right now I get an Icon then "SQL Server Reporting Services" then
"Home" then 3 options "Home | My Subscriptions | Help" and that is it... I
cant figure out what permissions are missing... thanks! Tag: Define Data Serie Colour in Pie Chart Tag: 65411
Key can not be null
I am trying to write a security extension but every time I get past my forms
based logon screen it says "Key cannot be null. Parameter name: key" which I
cant figure out what that means, nothing I have that is a key is ever
null...
however if I do this...
Public Function GetPermissions(ByVal userName As String, ByVal userToken As
IntPtr, ByVal itemType As SecurityItemType, ByVal secDesc() As Byte) As
StringCollection Implements IAuthorizationExtension.GetPermissions
Dim permissions As New StringCollection()
return permissions
end function
and return an empty string collection of what should be permissions, it goes
right into the report manager but with no permissions, so I assume my
problem is coming from here, but no clue what it means, any help on this?
thanks! Tag: Define Data Serie Colour in Pie Chart Tag: 65406
HTML Tags in Text Boxes
I'm using a 3rd part infragistics to store comments with formatting.
Where reporting back something as simple as <STRONG><U>testing</U></STRONG>
is not rendered.
Does anyone know how to achieve this rendering within report pages?
Thanks Tag: Define Data Serie Colour in Pie Chart Tag: 65401
Anyone knows about this?
I have SQL 2005 installed on my server. When I ran a SQL report
return
with less data, it will work but when I select more data, it returned
with
below error.
Any suggestion? Below is the exception error in detail for your
reference.
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found
(rsExecutionNotFound)
Description: An unhandled exception occurred during the execution of
the
current web request. Please review the stack trace for more
information about
the error and where it originated in the code.
Exception Details: Microsoft.Reporting.WebForms.ReportServerException:
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found
(rsExecutionNotFound)
Source Error:
An unhandled exception was generated during the execution of the
current web
request. Information regarding the origin and location of the
exception can
be identified using the exception stack trace below.
Stack Trace:
[ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be
found
(rsExecutionNotFound)]
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +291
Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String
executionId, Boolean fullReportLoad) +110
Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection
requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +269
Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64 Tag: Define Data Serie Colour in Pie Chart Tag: 65394
Anyone knows about this?
I have SQL 2005 installed on my server. When I ran a SQL report
return
with less data, it will work but when I select more data, it returned
with
below error.
Any suggestion? Below is the exception error in detail for your
reference.
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found
(rsExecutionNotFound)
Description: An unhandled exception occurred during the execution of
the
current web request. Please review the stack trace for more
information about
the error and where it originated in the code.
Exception Details: Microsoft.Reporting.WebForms.ReportServerException:
Execution 'g5l5ch55vliffcvwme3wma55' cannot be found
(rsExecutionNotFound)
Source Error:
An unhandled exception was generated during the execution of the
current web
request. Information regarding the origin and location of the
exception can
be identified using the exception stack trace below.
Stack Trace:
[ReportServerException: Execution 'g5l5ch55vliffcvwme3wma55' cannot be
found
(rsExecutionNotFound)]
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +291
Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String
executionId, Boolean fullReportLoad) +110
Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection
requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +269
Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64 Tag: Define Data Serie Colour in Pie Chart Tag: 65393
How to use Parameters without letting it to Prompt to enter
Hi All,
We are using 10 parameters in SRS report. When the report is
executing, it prompts us to enter all 10 parameters.
But we don't want to enter all parameters, we should be able to enter
blank parameters without mandatory parameters.
SRS prompts to enter all parameters.
Kindly help.
Regards,
Manoj
Mobile: +91-9989010205 Tag: Define Data Serie Colour in Pie Chart Tag: 65390
Data Driven
Hi,
I understand I can create a stored procedure to return all the parameters
for data driven. The last statement of the Stored Procedure is Select *
DataDrivenTableName. However, after I put Exec SPName, and when i go to the
next page to fill out all the To, CC, Subject..., there is nothing in each
drop down box and I can't continue to finish the setup.
Any idea what's wrong.
Thanks
Ed Tag: Define Data Serie Colour in Pie Chart Tag: 65386
Reporting Services Login Issue
I have a client that has a unique situation. Here is the back ground
information:
A Reporting Services 2005 server in a DMZ. This server is not part of
any domain, only has local users.
A SQL Server with the Report Database and an Analysis Services Server
with the Cubes on which the reports are built are behind the
firewall. These servers are in a Windowss 2003 Domain using Domain
accounts for access.
The issue is getting the Report Server in the DMZ to successfully open
a report based on a Cube. Using a Standard SQL Server Login we can
successfully open a report from the Reporting Server in the DMZ that
uses a relational database behind the firewall. This works obviously
since we can use a Standard Login and not deal with the domain/no
domain issue.
When we try to setup a report that uses the CUBE, we can not get the
Domain Server to accept our "ghost" user we created. We create a
user, "reptusr" on the local server in the DMZ. We also created a
user, "reptusr" in the domain behind the firewall and gave that user
id access to the CUBE. This is not working.
I can't find a lot of information on this specific scenario so any
information anyone may have would be greatly appreciated!
Thanks in advance!
Martin Tag: Define Data Serie Colour in Pie Chart Tag: 65385
Multi-value parameters in URL
I can't find anything on passing multi-value parameters in the URL. I can
pass one and it selects from the combobox, but when I pass more than one, it
doesn't select any.
I have a parameter named Locations that is multi-value. I have tried passing
"&Locations=1,2". I have tried "&Locations='1,2'". I have tried
"&Locations=1%2c2". Nothing works. Tag: Define Data Serie Colour in Pie Chart Tag: 65383
Document Map does not display on reports rendered from a snapshot
Where I work, we are converting from SQL Server 2000 to SQL Server 2005 and
VS 2003 to VS 2005. So, I'm having to convert all of our reports to 2005.
Here's the problem...I have linked reports that generate via a snapshot.
When I open the linked report, the document map does not display. Instead,
I get an error message "Some parameters or credentials have not been
specified". This seems to only happen to reports that have a query based
default parameter. The query returns only one record. The reports run
successfully in 2000, it just the 2005 version seems to be less forgiving.
Has anyone experienced this same problem and found a solution? Thanks in
advance for any help you can offer. Tag: Define Data Serie Colour in Pie Chart Tag: 65380
Data-Driven Subscription and Multi-Value Parameters
I have see several references to the fact that you could not use data
driven subscriptions for a report that has a multi-value parameter/s.
Can anyone confirm that this is true? If so, are there plans to
change this in future releases? My life would be soooooooo much
easier if I could combine the two functionalities.
Thanks! Tag: Define Data Serie Colour in Pie Chart Tag: 65376
SQLServer Express Reporting Services Permission Problem
I have installed SQLServer 2005 Express with Adv services sp1 onto a
windows 2003 platform. I have published some existing reports and
when
trying to run these from the Report Manager on the actual server, I
get the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'Mydb'.
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
I have checked the settings for SQLServer and remote connections are
enabled (I can access the database ok). The datasource Mydb has the
correct connection settings for the database and the credentials are
set to be stored in report server and are valid.
I can't see what else is wrong - any ideas? Tag: Define Data Serie Colour in Pie Chart Tag: 65373
SRS 2000 Ampersands and GUIDs
Hello:
I'm an SRS 2000 newbie. Two questions:
1. Is there a way in SRS 2000 to convert a GUID to a string or to
pass a GUID as a parameter?
2. When a user clicks on a detailed line item, they are navigated to
a new browser window with that detail field value as a parameter.
This field may contain ampersands. The URL gets rejected due to the
ampersand Does anyone know a way around this?
Ex. ParamName = Test&Data
URL would look like the following:
http://...<reportserver>.../ReportName&ParamName=Test&Data
Can this somehow be encoded and if so, how?
Thanks so much for your help! Tag: Define Data Serie Colour in Pie Chart Tag: 65372
Multi-Column Layout
hello,
I am trying to create Mailing Labels. I clicked Report --> Report
Properties --> Layout tab, then chose to output in 3 columns. The result is
still one column of labels.
What is the proper way to print data on multiple columns?
Thanks Tag: Define Data Serie Colour in Pie Chart Tag: 65371
Subreports - Fixed Length
I have a master report with 3 Sub report each aligned to specific
space.
Since one report that feed data to the sub report has 5 pages it makes
my Master report to go 5 pages too.
Is there any way that I can make those data to show under a sub report
with scrollbar (horizontal and vertical) so that I show all the 3 sub
reports in one page (like a Dashboard)
thanks,
PDG Tag: Define Data Serie Colour in Pie Chart Tag: 65369
Reporting services 2005 crashes
Hi All ,
I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
enterprise edition 64 bit machine.
I created a project and using a wizard created a report with Analysis
services cube as a datasource.Preview works fine but when I try to fix the
fonts or add elements and try to save it it crashes.How ever with out saving
I build the report or use the debug it works fine for the first time the next
time all the columns are deleted from the dataset.
I reproduced this problem thrice using diffrent prifile logons and creating
the project in different drives.
Thank you .
Rose. Tag: Define Data Serie Colour in Pie Chart Tag: 65367
Report designer 2005 crashes
Hi All ,
I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
enterprise edition 64 bit machine.
I created a project and using a wizard created a report with Analysis
services cube as a datasource.Preview works fine but when I try to fix the
fonts or add elements and try to save it it crashes.How ever with out saving
I build the report or use the debug it works fine for the first time the next
time all the columns are deleted from the dataset.
I reproduced this problem thrice using diffrent prifile logons and creating
the project in different drives. Tag: Define Data Serie Colour in Pie Chart Tag: 65366
Report Manager in SQL Sever 2005
I just loaded Reporting Services for 2005 and when I go to
http://localhost/reportserver I do not see the Report Manager like I did in
Reporting Services 2000. I have deployed a test report to the server and it
works, but when I go to the server I get a list view of the directory and
don't get the report manager. I have a report manager directory on my c:
drive but cannot seem to find out how to launch it. Does 2005 have a web
based Report Manager? or do I have to access it through the Server
Management Studio?
John Wright Tag: Define Data Serie Colour in Pie Chart Tag: 65364
Back Button in RS 2000?
Hello.
I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I
have a "drill-through" report. Upon drilling through to the report, and then
clicking the back button to return to the main report, the report doesn't
even render. However, while developing the report and previewing it in VS
2003, there is a back button supplied there that works perfectly every time.
My question is this: is there a way to tell Reporting Services to include a
back button like the one in the report designer on the deployed report?
Alternatively, is there a way to provide a hyperlink in the drill-through
report that takes the user back to the original report (with all parameters
included in the link)?
Thanks!
John Tag: Define Data Serie Colour in Pie Chart Tag: 65363
sql server 2000 RS client-side prints strange characters
Hi,
I'm at my wit's end on this. I printed my reports from the
development environment and all characters came out right. It's only
when I printed my reports using the client-side printing after I
deployed them to my web server that the strange characters come out.
Instead of a smooth comma, I get a dot with a wavy line underneath
it. The letter y looks like the letter v with a wavy line beneath
it. The letters p and g all have strange wavy lines on their
undersides. Can someone please help me? Tag: Define Data Serie Colour in Pie Chart Tag: 65362
Problem with Drillthrough event from dll
Hello forum
We are developing a WinForrms application that uses muti-layer technology in
which the report viewer is a layer that includes a winform that belongs to a
separate project within a single solution. This tier shows all the
application reports using a single ReportViewer control in Local Mode. We
use drilling to show detail reports through links in master reports. It
works fine if we generate an exe file and it executes isolated. But when we
change the project to a class library application type and runs the report
layer (a generated dll) from the initial exe, this one show the first master
report with no problem, but when we "drilltrhough" to any detail report an
error occurs: "The definition of the <my_detail_report_name> report has not
been specified".
We solved this issue by including the form with ReportViewer control and
rdlc files in the initial project but it isn't what we want. We need to let
the report layer in a separeted layer (DLL).
We thanks any help
Tiempo Hard development team. Tag: Define Data Serie Colour in Pie Chart Tag: 65357
Bold AND Italic Text Not Possible?
Is it not possible to format text as bold and italic in SRS? I find
this hard to believe, but whenener I specify both properties
(FontWeight and FontStyle), the italic property overrides the bold
property. Anyone else encountered this problem? Is there a work-
around? Tag: Define Data Serie Colour in Pie Chart Tag: 65355
Subscriptions
I am sure this has been answered in here before, however, I really
need some help here. I am trying to do the following from within SQL
Server RS 2005 without additional code or other application.
Suibscription should send report once a day to a static distribution
list. This distribution list does not change enough to require a data-
driven subscription. However, I dont know how to avoid it.
The report should fire once a day, once a certain process is complete
and data is updated.
I thought about setting a flag in the recipient data that would cause
the report to fire, but then if nothing else is done, the report would
fire over and over all day until the flag was reset.
I suppose I could check the execution log with an sp and unset the
flag once the report has successfully been sent once that day.
I was also thinking of firing a subscription once the process to
update the data is complete.
This seems so much more complicated than it needs to be.
Any insight would be appreciated Tag: Define Data Serie Colour in Pie Chart Tag: 65352
Field Error
I am getting the following error:
The group expression for the list â??Titleâ?? refers to the field â??Title.
Report item expressions can only refer to fields within the current data set
scope or, if inside an aggregate, the specified data set scope.
When I reference the stored procedure in my report, I do not get a field
list. I believe it is because I am trying to build a report that references a
stored procedure using dynamic sql, and I am told that it has to be dynamic
sql by the DBA.
If I am correct in this, question I have is how do I build a report
referencing dynamic sql without getting this error? The stored procedure
works and returns a resultset. Tag: Define Data Serie Colour in Pie Chart Tag: 65350
Date Time Picker for RS 2005
Hi,
For some odd reason, the DT Picker on my Report(which has been deployed and
which is open via the web) is taking quite a long time to display when a user
clicks to select a date. Could you please provide me with a solution to this
issue.
Thanks. Tag: Define Data Serie Colour in Pie Chart Tag: 65348
Is there any way to choose the data Serie colour instead of using the
colours define by the SRS? I'm working in SRS2000