all groups > sql server reporting services > september 2004 > threads for tuesday september 21
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
Conditional Count for Row Group together with Column Group
Posted by JiaN at 9/21/2004 9:55:03 PM
Division =Fields!Status.Value
Total
=Fields!Division.Value
=Count(iif("Status"=Fields!Status.Value,1,0),"Division")
Total:
the above is the matrix that i had done to count some values. The
"=Fields!Status.Value" is a c... more >>
Split Month in a week
Posted by TA at 9/21/2004 9:29:07 PM
Hi
I am writing a report that reports on Sales and Budget, of course I can
filter sales by transaction date, but the budget is a little bit harder.
The buidget covers a hole month, so what I have to do is to calculate the
budget amount by deviding, but if the month end in the middle of the... more >>
How to determine in a report if the dataset has data
Posted by Stephen Witter at 9/21/2004 8:37:19 PM
Is there anyway to tell if a report has data? I am looking for an
expression or something that would allow me to display a message if
the dataset is empty.
... more >>
Problem with BorderStyle while Exporting to PDF
Posted by Ponnurangam at 9/21/2004 8:28:13 PM
Hi,
I have lines of BoderStyle: Dotted, BorderWidth: 0.5pt in my report
When I preview it and print it I get the dotted lines
But if I export the same report to PDF and then print I get Dashed lines
instead of Dotted Lines
It's very important that I get Dotted lines.
Can Someone Help... more >>
Webservice ... Save PDF file?
Posted by Rich Miller at 9/21/2004 8:12:36 PM
Can you use the Webservice to simply run a report and save the results to a
file?
Examples appreciated.
Thanks.
... more >>
Matrix region formulas
Posted by BoruRR at 9/21/2004 7:59:04 PM
Hi,
I would like a Matrix report with
Jan, Feb, Mar, Total on columns
where total sums up all the month values in that row.
And something like
2003, 2004, Difference2003-2004 on columns
AddColumn does't seem to do the trick
Thanks!... more >>
Can set anonymous to ReportServer
Posted by ad at 9/21/2004 7:59:01 PM
I want to all user can see my reports in the server just like they can see
my web page.
I set the virtual directory ReportServer's access to anonymous.
If there any dangers to do that?
... more >>
Reformatting Parameters before using them in Sql query
Posted by Urs Eichmann at 9/21/2004 5:22:16 PM
Hello,
We use Reporting Services to do reports from a (rather old iSeries /
AS400) database. Date values are stored as numeric data in the format
YYYYMMDD, rather than with a proper "Date" type. This is quite common in
older host-based databases.
In one of our reports, the user should be a... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Report Authentication
Posted by Prem at 9/21/2004 4:09:08 PM
This is a newbie question. I have the report viewer component on one of my
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.
... more >>
Installation issue
Posted by J. Gonzalez at 9/21/2004 3:29:09 PM
Hi everyone,
I'm hoping someone can help me out on this one. I'm getting an error when I
try to install rs developer edition on my box. The message is "could not
start the reportserver service on Local Computer Error 193: 0xc1" I had a
previous version of rs (rs evaluation edition) prior... more >>
Custom coding
Posted by Al Santamaria at 9/21/2004 3:25:31 PM
I'm using the Report.References collection to link to some external
Assemblies (developed in C#). Also, I use the Report.Classes collection to
instantiate some classes defined in that assemblies. This works, as I'm
able to show a custom Windows form from the constructors of the instantiated
cl... more >>
print as landscape
Posted by Joe Scalise at 9/21/2004 2:43:47 PM
Is there a way to get reports to print as landscape instead of potrait
automatically? I changed the Layout from properties to the correct width
and page height, the display looks fine but when I print, it tries to print
it on potrait setting. I've tried printing from both the report previewe... more >>
Subscriptions - External Email
Posted by lukeguerrant NO[at]SPAM gmail.com at 9/21/2004 2:30:34 PM
I am trying to email an external email address via a subscription.
Every time I try to email the report externally to our company I get
an error that the email address is not valid. The email address is
valid. I tried testing this on one of my own personal email
addresses.
I understand tha... more >>
License
Posted by Craig van Nieuwkerk at 9/21/2004 1:47:02 PM
Hello.
I was at Borcon (Borland Developer Conference) last week and saw a talk by
Don Farmer on DTS and Reporting Services. When asking a few questions
afterwards some of the MS guys seemed to indicate that I could deploy
reporting services without SQL-Server and just using MSDE. They indicate... more >>
Reports without Using VS ?
Posted by Richard Morey at 9/21/2004 11:59:07 AM
Can I create reports for Report Services without having Visual Studio? If
so.. how?
Thanks,
Rich
... more >>
Repeating data regions on every page
Posted by Raul R at 9/21/2004 9:59:30 AM
Hi all, I want to create an invoice that will repeat numbers dates and
shipping info on every page that the list of items grows on to. You know,
to simulate a standard preprinted invoice page but fully generated by
reporting services.
Any assistance is appreciated.
Raul Rubio
... more >>
Invoice form layout
Posted by Brian Smith at 9/21/2004 9:45:29 AM
Is there some way to simulate a fixed form layout for an invoice? I want to
have a fixed set of columns with dividing lines and totals boxes at the
bottom, regardless of how many actual rows of data are displayed. I've
tried 2 approaches (using PDF rendering only):
1. overlay a table with a set... more >>
Help me install eval, please.
Posted by Steve Mahon at 9/21/2004 9:21:51 AM
I little experience with sql and no experience with rs. Recently, during a
..net class, the instructor demonstrated rs with the bikeworks db and I was
blown away. I want to give the same demo to the bosses here, so they will
send me to sql and rs classes. Our server is SBS2003 premium with sql... more >>
how do you set a cookie for axshdocvw
Posted by johnlee22 NO[at]SPAM yahoo.com at 9/21/2004 8:38:55 AM
I am using forms authentication in our reporting service. After
authenticating, I get a cookie back and want to set that cookie in the
axshdocvw browser control to view the report so the user doesn't have
to log in again. How can I do this? I tried sending the session id as
a parameter in the re... more >>
Design question
Posted by jhcorey NO[at]SPAM yahoo.com at 9/21/2004 8:02:03 AM
We currently have an ASP.NET app that includes some reports. I'm
considering
making the data available in RS and I'm looking for some opinions
about
the feasibility and difficulty in doing this.
The app uses ODBC to connect to DB2. The users use their DB2 userid
and password, and this is w... more >>
Manipulating dates in an expression
Posted by Nick Caramello at 9/21/2004 6:26:41 AM
Does anyone know a way to subtract a date from a date
parameter (e.g. = Parameters!Date.Value - 1, which of
course does not work)
thanks... more >>
|