all groups > sql server reporting services > march 2006 > threads for friday march 10
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
Line break after group
Posted by Dutch at 3/10/2006 3:04:26 PM
I need to insert a line break in a detail row after certains groups of data.
example:
Week Day Detail
1 Mon 1
1 Tue 1
1 Wed 2
1 Thu 2
1 Fri 1
2 Mon 1
2 Tue 1
2 Wed 2
2 Thu 2
2 Fri 1
I need it to have a line break after week 1, 2, etc. Also, the detail column
has aggregates, ru... more >>
Missing DEVENV.EXE (SQL Server Business Intelligence Dev Studio)
Posted by Serghios at 3/10/2006 2:51:16 PM
Hi,
I have installed SQL 2005 and all components. However the SQL Server
Business Intelligence Dev Studio is missing. I have reinstalled and still
have the same issue.
Any help appreciated.
Serghios... more >>
How do I resolve this? Urgent please reply asap !
Posted by SDRoy at 3/10/2006 1:12:26 PM
Hello:
Can someone please tell me how to convert this Crystal report formula to an
expression in SQL reporting ?
@VoidAmt =
if {payment.status} = 'VOID' THEN {paycheck.checkamt} * -1 ELSE 0
In crystal report field I have Sum(@VoidAmt).
How do I convert this as an expression in SQL repo... more >>
Change ReportServer database
Posted by Rick at 3/10/2006 1:02:27 PM
We have installed Reporting Services on a new server using the local
database. Now we want to point to a ReportServer database on another
database server.
How can we change the server used for the ReportServer database to point to
a different server?
Thanks
--
Rick... more >>
Dynamic Server Path
Posted by Sunny at 3/10/2006 11:05:27 AM
I have images shown on a report that are stored on a server.
Problem is when developing the server path is different from my live server.
So whenever we deploy the report on the server i have to make a change
manually to the path of the images....i need to make this dynamic.
How can i do this.... more >>
obtaining an image from another server
Posted by Brandon at 3/10/2006 11:00:47 AM
Hello,
My report gets an image off another server. It works fine in testing, but
when I deploy it to my production server the image doesnt show up. I put a
try/catch around the code and output the error to a text field in my report,
only to see the following:
System.UnauthorizedAcce... more >>
RS/AS 2005 Reports on Cube datasource, drilldown not working
Posted by DTK at 3/10/2006 8:59:07 AM
I have an AS 2005 cube created.
I am able to generate reports in RS 2005 by setting the report datasource to
point to my cube.
I have tried to setup a report to drillthrough to another report ( also
based on the same cube datasource ) via the TextBox Navigation/Jump To Report
setting.
... more >>
Page size and relative lengths?
Posted by David at 3/10/2006 8:51:21 AM
Is that a way to set my page size as a relative (px,em,ex,%) lenght instead
of an absolute (in,pt,pc,mm,cm) lenght? ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Reporting Services DB Best Practice.
Posted by Kevin Antel at 3/10/2006 7:18:10 AM
Ok, so, I see in an early post, that I need to ask a bigger question.
I have a production SQL 2005 Standard Server. I have another SQL 2005
Standard server that is used for reporting services only. What is the best
method for updating that reporting services DB on a 15 - 30 minute cycle.
... more >>
error message for blank reports
Posted by bevarg at 3/10/2006 6:36:28 AM
When requesting reports, if a user supplies values in the parameters
for which there is no data on the database, how can I stop him/her on
this screen with an error popup display box or a message on the report
like 'no records available for the specified criteria' instead of
generating a blank r... more >>
How to deplory reports using visual studio and Forms Authentication?
Posted by Patrick Dinger at 3/10/2006 6:13:49 AM
Hi,
i successfully installed the forms authentication example on my report
server.
The problem i am facing now is that i am no longer able to deploy my
reports using visual studio to the report server as i did before. Is
there a possibility to still use visual studio for deploying?
If not,... more >>
Querying Active Directory thru Custom Code
Posted by Gio at 3/10/2006 4:11:35 AM
Hi,
I'm trying to retrieve user email from AD through Custom Code (stolen
from an existing asp page) and then to display it in a report (...
=Code.UserMail(User!UserID)...)
But I get this error:
"Cast from type 'Field' to type 'String' is not valid."
Thanks for any help!
Here's my custo... more >>
Send an email to a different address for each group in a report?
Posted by klar02 at 3/10/2006 12:25:00 AM
Is there a way to send an email to a different email address for each =
group in a report? I would like to send a monthly report card to each =
Nurse Unit at our hospital. There would be many nurse units so I don't =
want to have to schedule a separate job for each unit.
Any ideas?
Andy... more >>
Error! Must declare the varaible
Posted by MVA at 3/10/2006 12:00:00 AM
Hi
Can someone help me with the following problem? I have a report that needs
two parameters at runtime. If I execute this report on the same server as RS
with a data source that is connected to a database on the same server as the
RS server. Then the report execute without any problems.
Th... more >>
|