|
|
|
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 Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 How Query Same Columns w/Mulitple Criteria Posted by Mike Harbinger at 10/6/2004 11:37:57 PM I am trying to build my first report that is more than a simple columnar
report and wonder if you guys can help. I need to query the same sets of
fields but with different criteria and compare them over time as follows:
-show order NetAmount, Gross Amount, %NetAmount for each sales person for
...more >>
How does one secure the ReportServer folders\report listings? Posted by VChandy at 10/6/2004 6:01:02 PM How can I prevent a user from directly going to a browser and accessing
https://localhost/reportserver?
The problem is the user can then click on of the RDLs and it comes up with
the report displaying all the parameter options even though in my app I hide
the same through url access.
If ...more >>
Error exporting subreport to excel Posted by AR at 10/6/2004 5:55:02 PM Hi,
I have read this in the previous post that it is not possible to export
subreport to excel using table/matrix format. Though one of the post says
that you can do it using list (for table format only). Can you pls also
highlight how to have one record in one report attached to one correspo...more >>
installing only Report Manager on web server (Daniel Rieb help?) Posted by FurmanGG at 10/6/2004 5:53:03 PM I followed the instructions for installing Report Manager and NOTHING else on
a separate web server. The instructions came from:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9750be7e6c083a7b/6b15e50db9740949#6b15e50db9740949
I'm pretty darn...more >>
Dynamic Proxies - ServiceDescriptionImporter() Posted by Simon at 10/6/2004 5:45:03 PM Hi,
I have a DPE (data processig extension) that calls a Dynamic Proxy DLL -
this DLL has been declared in a Code Group of the rssrvpolicy.config file -
for developmental purposes, it uses the "FullTrust" PermissionSet and it all
works well ... to a point.
In the dynamic proxy code when ...more >>
Slow PDF and Excel rendering Posted by Rodrigo Sánchez at 10/6/2004 5:01:50 PM I have a report which is very slow to render on pdf format, is there a way
to help RS speed up the rendering in this formats?
Its a long report and contains embeded images in page headers, has anyone
experienced slow performance when rendering, any dos and donts?
thanks in advance
...more >>
Toolbar rendered when using URL access Posted by adrianM at 10/6/2004 4:58:36 PM Question:
Is there any other way to show the toolbar when a report is rendered outside
of URL access??
Thx
...more >>
Exporting Schedules and Subscriptions Posted by Carlos E. Mosquera at 10/6/2004 3:59:02 PM Hi,
Exists some way to export schedules and subscriptions to another reporting
services database???
Please, i need this information.
--
Carlos E. Mosquera
DBA - Project Manager
BAC Panamá...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Another IIF statement question Posted by Kelly at 10/6/2004 3:19:24 PM I have a matrix table set up that returns some invoice amounts for each
customer, by month. The months are going across the top; the customers going
down the side; amounts as the 'data' portion.
Anyway, in my actual database table, some customers didn't have invoice
amounts for certain months ...more >>
Custom "Report Viewer" does not show the images.. Posted by Raj Chidipudi at 10/6/2004 3:02:46 PM Hi Guys,
We have a Custom Report Manager web page, uses "Report Viewer" Server =
Conrtol which is part of the Samples, which will take the URL of a =
Report and display it. Our Custom Report Manager works in the same way =
as Standard "Report Manager" of Reporting Services, using =
"Replacem...more >>
NULL DateTime parameters via URL Posted by Ron Lytal at 10/6/2004 2:28:54 PM My report has DateTime parameters and is being accessed via URL. These
parameters are set to "Allow NULL". When I access the report with the
parameter in the URL like this
&DateTimeParm=
I get the error "rsReportParameterTypeMismatch". When I omit the parameter
from the URL completel...more >>
Render multiple reports simultaneously Posted by Stewart S at 10/6/2004 2:05:04 PM Is it possible, using http or ReportingServices API, to simultaneously render
multiple reports in the code behind a web app command button? If so, will all
reports render to separate web pages? Would there be an obvious way to move
back and forth between the reports (that is, would the reports...more >>
2nd POST-How to change color for a visited field? Posted by amma at 10/6/2004 2:01:01 PM Hello All,
I have a parameterized report (Report1), which has a field (say
'Control#')that has 'Jump to Report' navigation property setup. When the
user selects their parameters, Report1 displays, say 10 records displayed on
the Report, and when the user clicks on Control# of Report1, it Ju...more >>
Extracting Month Name from Date Posted by Blake Gremillion at 10/6/2004 1:59:03 PM Is there a function for getting the Month name from a date string? For
example, '01/20/2004' would return 'January'
...more >>
Multiple Attachments Posted by dlong at 10/6/2004 1:59:02 PM How do I get multiple attachments into one mail note. I have five reports
that I what my uses to receive in the form of Excel and PDF attachments and I
do not want them to get five Emails. Is this possible with subscriptions
Thanks
Doug
...more >>
Re: Displaying values of a textbox Posted by Ponnurangam at 10/6/2004 1:17:45 PM Use
textbox2.value: =ReportItems!textbox1.value
"Sanjeev" <sanjeev@microsoft.com> wrote in message
news:<uafhla3qEHA.3700@TK2MSFTNGP15.phx.gbl>...
> Hi,
>
> I want to display the value of one textbox in another textbox.
> Does anyone know the syntax for this expression.
> Both ...more >>
Where is STSADM.exe? Posted by CJ Taylor at 10/6/2004 1:04:57 PM Hey everyone,
My SA and I have been working with trying to get Reporting Services to work
on our Win 2003 EE Server for the past two days. We got it to work locally
on the XP Pro machines and more than impressed...
However, we read that Sharepoint Services (default installed with Win2003)
...more >>
Microsoft Acknowledgement? Posted by fzuma NO[at]SPAM yahoo.com at 10/6/2004 12:58:26 PM Can I please, at least, get an acknowledgement from someone at
Microsoft that they have seen this posting? Without a response
whatsoever in a month's time, I'm wondering if it was posted at all.
Hopefully I can get some sort of input as well as a viable workaround
or plans for this bug to be f...more >>
Email address disappears in subscription Posted by garyc at 10/6/2004 12:49:03 PM When I am in a subscription for a report in RS (SP1 installed) and I click on
Select Schedule, and then click on OK, any email addresses that I had in the
subscription are gone. Any addresses that I have in the Cc: or Bcc: are still
there but the To: list is empty.
Is this normal?...more >>
Putting a db field in report header Posted by Rodrigo Sánchez at 10/6/2004 12:09:48 PM I need to put a field in the report header, i think the way to do it is to
put a hidden textbox in the body and reference it from the header, but i
dont know how to make the expresion for that, is that the correct way to do
it?, is there better way?
...more >>
"Server Application Unavailable" error on generating PDF reports Posted by Azul at 10/6/2004 11:06:11 AM Hi,
I'm using ASP.NET with SQL Reporting Service to generate PDF reports.
Most of the time it works well.
But sometimes PDF doesn't come out (esp. if the report is complicated),
with the error message at below.
I use 2 separate servers for Web Server / Reporting Service.
And i suspect a ...more >>
Changing Service Account Posted by dachrist at 10/6/2004 10:15:04 AM We need to change the account that the ReportServer service runs under. Is
it as simple as changing the account that the service logs on with, or is it
more involved?...more >>
Deploying to a webserver Posted by JerryK at 10/6/2004 10:09:07 AM I'm confused...
I was able to get my Web Host to install Reporting Services.
I understand that after I deploy my reports to my Web Host's server, that
the URL I need would look something like this:
http://myWebHostServer/ReportServer
My question is: If my Web Host has dozens/hundreds of us...more >>
Windows Integrated Security Posted by Mayur Patel at 10/6/2004 10:05:12 AM Hi,
When user clicks on the report, i want to take the identity of the user and
go to DB and return some rows depending upon the identity of the user. Any
ideas
Thanks..
...more >>
IIF statement issue Posted by TBraun at 10/6/2004 10:01:03 AM Here is the iif statement I have in the report:
=iif ((Sum(Fields!EXTENDED_MARGIN.Value) = 0) or
(SUM(Fields!TY_QTY.Value)=0), 0,
SUM(Fields!EXTENDED_MARGIN.Value)/SUM(Fields!TY_QTY.Value))
If I put in just the basic iif statment evaluation returning a 1 for true
and a 2 for false, it wo...more >>
Server Application Unavailable Posted by amiraj NO[at]SPAM gmail.com at 10/6/2004 9:53:12 AM All of sudden we started finding the below problem with reporting
services in our servers. All other web apps are working find under the
default web site except reports and report server.
Any one had this problem?
Server Application Unavailable
The web application you are attempting to acce...more >>
Can we break a chart line Posted by ad at 10/6/2004 9:45:27 AM I have a line chart which describe the number of absent students every week.
There is summer vocation during a year (week 27th to week 39th)
I want to the line break up when summer vocation.
Can we break line where summer vocation?
...more >>
Question for MS - code behind Posted by moondaddy at 10/6/2004 9:23:12 AM Are there any plans for putting code behind the report similar to code
behind for aspx pages? And if so, will there be events like OnFormat for
sections or objects similar to other report writers? And if not, is there a
different technique for achieving the same functionality?
Also, will the...more >>
alternate row color in groups Posted by NI at 10/6/2004 9:21:02 AM Hi:
I am trying to alternate row colors within groups, and I do this
<BackgroundColor>=iif(RunningValue(Fields!Country.Value,CountDistinct,Nothin
g) Mod 2, "Cornsilk", "White")</BackgroundColor>
but the problem is my country field has duplicates, and the color is
not alternating in suc...more >>
How can I set the page orientation to landscape Posted by Savita Gupta at 10/6/2004 9:18:10 AM Hi
How can I set the page orientation to landscape of my reports? My report
has 9 subreports. Please help.
...more >>
security question Posted by David Bailey at 10/6/2004 9:09:52 AM I have a situation where I am using one report to deliver information to
different offices. Each office should only their information. Area
management should be able to see the offices that they manage.
So, I've created a parameter which offers the end user a list of choices
based on their u...more >>
Installing SQL Reporting Services Posted by dmg at 10/6/2004 9:05:07 AM How can I install the server and client components for SQL Server Reporting
Services? Where are the install files located?...more >>
Custom Reports using Reporting Services Posted by snbat at 10/6/2004 8:05:03 AM I have a couple of quetsions regarding the Reporting Services. Any response
will be greatly appreciated.
I am looking to see if the user has the capability to design thier own
reports using the reporting services..
Is it possible to provide the report design capability to the user so that ...more >>
SubReport Error Posted by BobB at 10/6/2004 8:05:03 AM Hi,
I've created a report that executes 3 subreports. When I run it for an
Officer everything works fine. When I try a different Officer I get the
following: "An error occurred while executing the subreport 'subreport2':
Error during processing of 'OfficerID' report parameter." In fact ther...more >>
### I think its a bug ### - Export to excel Posted by NI at 10/6/2004 7:53:02 AM Hi:
I have a report with 2 tables in it, both have drillthroughs. I need to
toggle the visibility between the two tables based on the report parameters,
and hence have an expression in the visibility of the tables properties.
1) Loss of data when exported to excel (sublevels not exported...more >>
Using Reporting Services Posted by Angel at 10/6/2004 6:39:05 AM Hi everyone!
After a 3 hours of fooling around with reporting services I managed to get
the server components install on one of my server and even created a report
in my development machine with little or not effort. It took a bit of doing
figuring out how to deploy the report but finally ...more >>
bind matrix or table to image or map Posted by Salvatore at 10/6/2004 5:55:07 AM Hi
I want to create a report where data is fixed to certain areas on a map (eg
I have an image of Switzerland and regional data. The data should be
displayed ontop of certain regions of the map). When I deploy the report and
open it in Preview or with a browser, everything is moved: eg, if I...more >>
ODBC SPROCS and unnamed parameters Posted by paul.scott NO[at]SPAM klm.com at 10/6/2004 5:25:27 AM I have a stored procedure outlined below that I access on SQL Server
6.5 via ODBC.
CREATE PROCEDURE usp_SQLREPORTING_TEST @userid VARCHAR(6) AS
SELECT * INTO #TEMP_CM FROM tblUser WHERE userID LIKE @userid
SELECT * FROM #TEMP_CM
When I add the data set to SQL reporting services I ca...more >>
Releasing SQL Rep.Services Reports Posted by jonskin at 10/6/2004 3:55:32 AM Having developed my C#, SQL Server, .Net Web application I can create a
Setup.exe for the Web App using a Setup Project. The Setup.exe can be copied
to any transfer medium and the App. can be installed and run on the
production machine (as long as it supports .Net and IIS).
When it comes to ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |