| Groups | Blog | Home |
|
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 Reports Services installation problem. Posted by Kam at 4/27/2006 11:39:02 PM In my laptop, I got W2003 server Std, Sharepoint portal, SQL 2000 and SQL 2005.
After I have trouble to run the Http://server/Reports. I applied SP1, then I
under install the SQL2005, but failed to remove the Reporting Services.
Then I re-install the SQL 2005 with a new instance name, then app...more >>
SQL Mobile Posted by Timk at 4/27/2006 9:00:02 PM I might be in left field here, especially since I believe reporting services
is entirely a server side report generation engine, but....
I would like to generate (not just view something from regular srs -- I want
to produce something from my local SQL Mobile right on the mobile device,
whi...more >>
parameter problem Posted by minority at 4/27/2006 7:58:56 PM hi all,
i have a parameter ParamA that refers to another parameter ParamB.
select ParamA from property where chain like (@ParamB+'%')
i set ParamB to allow blank value.
how do i enable ParamA if ParamB is blank? cos currently, ParamA will
be disabled for selection if @ParamB is not spec...more >>
SQL Server Business Intelligence Development Studio? Posted by Asaf at 4/27/2006 4:43:01 PM Hi,
I have installed VS.NET Pro 2005 & SQL Server 2005 Developer Edition with
full install.
From some reason I don't see the "SQL Server Business Intelligence
Development Studio" on my machine so I can't create reports.
Any help will be much appreciated.
Regards,
Asaf
...more >>
Paramter posting back? Posted by sellerss at 4/27/2006 3:39:32 PM I have a report with four paramters.
A "Start Year" and "End Year" that are strings with values from a query, so
available valuse are 2003,2004. 2005, and 2006.
Two datetime for a "Start Transaction Date" and "End Transaction Date".
When I set the "Start Year" parameter, the report seems to...more >>
Different footer size for first page Posted by Andrey at 4/27/2006 1:11:01 PM Hi,
I am trying to create invoices where first page should have ~3.75in footer
with remittance slip. All other pages should have small footer.
Body of the report is one big table with groups.
What is the [best] way to accomplish this? Footer size could not be
formula-based (at least tho...more >>
Trigger an email subscription Posted by Maxwell2006 at 4/27/2006 12:19:07 PM Hi,
Can I trigger an email subscription by using command lines or url command?
Thanks,
Max
...more >>
Help with using integrated security Posted by Ben at 4/27/2006 10:43:01 AM I am building a reporting aspect of my .NET web app, and I have already come
accross the problem where if the app is hosted on a server and the backend
SQL database is hosted on another server, I cannot use integreated security
to retrieve data from the sql server (unless deligation is turned ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSRS 2005 Custom security extension question - LogonUser Posted by nickpup at 4/27/2006 8:30:02 AM We are implementing the SSRS 2005 custom security extension described in
http://msdn2.microsoft.com/en-us/library/ms160724.aspx. We have the sample
running, but the LogonUser method never seems to be called. Shouldn’t this
routine be called as a result of the user logging into Logon.aspx o...more >>
Report Parameters > non-queried Posted by Asim.Humayun NO[at]SPAM gmail.com at 4/27/2006 8:16:58 AM Hi,
How can I add multiple values in non-queried "value" box.
I have a parameter name "Country".
I have a label USA which has three values.
Label Value
USA 555,666,777
The above example doesn't work with my stored procedure which has where
clause as
...more >>
access denied when deploying to prod Posted by Carrie at 4/27/2006 7:57:01 AM I'm trying to deploy my reports to my production server and I'm getting
'rsAccessDenied:The permissions granted to user 'domain\me' are insufficient
for performing this operation'
I asked my dba to give me full permissions on the reportServer and
ReportServerTempDB databases in production AND...more >>
iff statment problem - what am i doing wrong Posted by pbuzzby NO[at]SPAM gmail.com at 4/27/2006 7:55:10 AM Hi
i have the following iff statement.
=iff(Fields!Measures_MeasuresLevel.Value=cost,Sum(
Fields!Financial_Year_All_Financial_Year_FY01_02.Value),0)
I get an error "Name iff is not declared"
What do i have to do in order to get iif statements to work?
Ta
Paul
...more >>
RS2005 MDX report parameters Posted by jhcorey NO[at]SPAM yahoo.com at 4/27/2006 7:43:36 AM With a report is created against a cube, the data designer generates
the mdx. If a field is checked as a parameter, the mdx will include
something like this:
SELECT ( STRTOSET(@ProductDimCatgLabel, CONSTRAINED)
As a default when the report is run, a dropdown presents all possible
values.
Be...more >>
IIS 405 Resource Not Allowed Posted by Trapper at 4/27/2006 7:43:03 AM I have several Reports that when I Click on the "View Report" button I
receive a 405 Resource Not Allowed Error. I have re-installed Report Server
and updated to Service pack 2 for Reporting services, with no change in the
outcome.
The Initial load of each of these reports works fine, howe...more >>
Make a SELECT DISTINCT in Reporting Services Posted by rebeuapaname NO[at]SPAM hotmail.com at 4/27/2006 7:08:49 AM Hi,
I have a stored procedure, that can't be modified.
It return data like these (the real one is more, and more complex of
course)
A ....
A ....
A ....
B ....
B ....
B ....
C ....
C ....
I want to make a table with only theses entries :
A
B
C
How can i do it in reporting s...more >>
how can i display 14/02/2004 to FEB 06 Posted by mur via SQLMonster.com at 4/27/2006 6:49:02 AM hai,
i want to display date 14/02/2004 is in the format of FEB 06.
how can i format the date to get this result
please tell me the ways ,any one worked one this.
thanks & regards,
mur.
--
mur
Message posted via http://www.sqlmonster.com...more >>
Global variable for hyperlinks in reports Posted by David at 4/27/2006 6:42:01 AM We are using Reporting Services 2000. We have several reports that all
contain an "Edit" hyperlink that goes to a URL not related to the report
server url. We cannot directly enter this URL into the "Jump To" section,
because the url is different depending on the environment (dev, test,
pr...more >>
Date and Time Parameter: Posted by Deborah via SQLMonster.com at 4/27/2006 5:26:53 AM I have a report that I will use a DateCreated value for the date and time
parameters. The time stamp for the DateCreated value does carry dates and
times. This report is for three 12 hour shifts and the hours run from 7:00
PM to 7:00 AM. I need to set my default parameters to display as yester...more >>
Get report design from Report Manager Posted by IanP at 4/27/2006 3:00:02 AM If you cannot find the current Visual Studio sln project file, can you obtain
the report design from the Report Manger to plug back into the designer to
ensure that you start from the most current report verision held on the
server?
Thanks
Ian...more >>
Using URL access to report server over the internet Posted by jonny at 4/27/2006 2:46:32 AM I've got an ASP.NET 1.1 application running on
http://www.webapplication.com and a report suite hosted by SQL RS 2000
on http://www.reportserver.com.
Webapplication.com uses URL access to the report server to make use of
the HTML report viewer toolbar rendering reports inside of a IFrame
usin...more >>
Matrix calculation using more than one column Posted by stu... at 4/27/2006 2:25:01 AM I have a matrix of data for a period of months. What I am trying to do is to
add a column at the end which will be YOY change. So how in a matrix do I
reference the value in column 4 (for example) and the last column. Also how
do I add this calculated column to the end of the matrix.
...more >>
formatting matrix subtotals Posted by Silent Bob at 4/27/2006 2:18:00 AM Hi,
have had a look at the archives and there is some good info there
about having different formatting for subtotals as compared to the
actual data columns. What I want to do though, is have the same
formatting applied to the subtotals as to the data columns.
I have 9 data columns which...more >>
Dynamically delete a row from report Posted by beatmasta at 4/27/2006 12:31:02 AM Hi,
I have a report containing some values. Surprise? :)
I want to delete rows containing values 0 and null from the report. I need
to include those rows to the sql query, but don't wan't them to be seen in
that particular table. Can the dynamic deletion of a row be done?
Thanks for helping...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |