all groups > sql server reporting services > may 2007 > threads for wednesday may 23
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
hide column in a matrix
Posted by Efi at 5/23/2007 11:33:01 PM
I'm trying to hide a column in a matrix. I have noticed that you can't just
set the columns visibility mode (no such proprty) so I tried the following:
1. set the visibility of the cells and lower level headers to hidden - works
but the upper level header still takes the space of the hidden low... more >>
How do I use a parameter in a dataset field value using an MDX query?
Posted by Roger at 5/23/2007 8:46:55 PM
I am trying to run a report using dynamic MDX dimensions.
The value of my dataset field Dimension_1 is
[SOB Year].[Yr Id].[Yr Id].[MEMBER_CAPTION]
I want to use parameters for SOB Year and Yr Id like I do on the
query.
But if I use
="["& Parameters!dimension_1_table.Value &"].["&... more >>
Date Parameter
Posted by Ridhima Sood at 5/23/2007 7:46:01 PM
hi All
I am quiet new to sql reporting so would really appreciate some help. I am
using this with CRM 3.0
I want to do a report where user can select a to date and a from date to see
all completed phone calls. However both the to and the from are based on one
field called actualend.
A... more >>
Re: Model Query Designer
Posted by fmatamoros NO[at]SPAM yahoo.com at 5/23/2007 5:52:04 PM
I added the RS extension to RSReportServer.config. Then, I restarted
the report server. Now it works!
... more >>
Programmatically change a textbox's contents
Posted by Andrew at 5/23/2007 3:10:10 PM
Quick question.... I have a C# ASP.Net (2.0) webpage with a ReportViewer
control on it. In the code-behind I set the datasource of the report and
then view the report data:
DataSet ds = DBProvider.GetDataSet(SQL, DateFrom, DateTo);
rvRR310.LocalReport.ReportPath = "RR310.rdlc";
rvRR310.Lo... more >>
Scheduling a report to run every 30 minutes
Posted by Zoomer Tech at 5/23/2007 11:38:04 AM
Hi all,
I have a customer that wants a report to pull data, and report that data
every 30 minutes is that possible in SQL 2000 Reporting? They are trying to
upgrade to 2005 based on this request. How musch more functionslity in
reporting is there in 2005 as opposed to 2000 Reporting.
... more >>
how to send all values for a field to a subreport
Posted by Stephanie at 5/23/2007 11:31:01 AM
How do I send all values of a field in a dataset to a subreport?
Stephanie... more >>
report data with different char-set other than english
Posted by PS at 5/23/2007 10:45:06 AM
In my report i have to display data from sql db which has this data string in
Russian language. The report object and the text box object have a very
promising property
called: language but setting this property to the required language is not
helping.
How can i make my report to display ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Retrieving total number of pages
Posted by Doogie at 5/23/2007 8:46:39 AM
How do I - inside my report, display the total number of pages? I
looked at the expression functions and couldn't see anything to do
that.
... more >>
he_reportViewer
Posted by Eric at 5/23/2007 8:36:02 AM
Hello All,
I have a report that uses the character "â„¢" and when it is viewed through
the reportviewer via a website, the character "â„¢" is displayed as a "?".
However when I export to either pdf or excel, the "â„¢" is correctly displayed.
Is there any documentation where I can be direc... more >>
Chart legend has too much data - how to only show 1 legend
Posted by NP at 5/23/2007 7:21:03 AM
I have created a hybrid bar chart / with line. Basically uses the bars to
show sales for each geographic region. A single line is plotted showing the
sales goal to be reached. The x axis is "Region" The y axis value 1 is total
sales $. I added y value 2 to show the sales goal $ and the leg... more >>
SSRS 2005 link reports
Posted by farshad at 5/23/2007 6:59:01 AM
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to
be directed to report B.
Can you show me guidance on where to start please?... more >>
Reporting Services 2005 on Vista
Posted by David at 5/23/2007 5:48:01 AM
Hi All
When I go to http://localhost/reports on my laptop running Vista and SQL
Server Reporting Services 2005 SP2 I recive the following error:
HTTP Error 401.1 - Unauthorized
Description: You do not have permission to view this directory or page using
the credentials that you supplied.
... more >>
Drillthrough Problem
Posted by Mike at 5/23/2007 12:59:01 AM
I have a problem with the drillthrough feature in reporting services.
When I drillthrough from report A to report B it works fine and all
parameters where processed. But if i drilltrhough from report B to report A
now the parameters where ignored and i get an cached version of report A. How
c... more >>
Culture problem with datepicker in report parameters
Posted by Stefan at 5/23/2007 12:00:00 AM
Hi,
on the server of a customer I determined the following problem: The customer
installed an English operating system (Windows server 2003) with English SQL
server 2005. I go from a German Client on a report about http://
<servername>/reports (report managers) to calendars in the report pa... more >>
Passing datetime parameter to stored procedure
Posted by Antonin at 5/23/2007 12:00:00 AM
I want to pass a date parameter to stored procedure which is expecting
smalldatetime. I need to subtract a number of days from the current time and
pass it to the stored procedure. I tried DateAdd("d", -1, Now()). I can
display the the result in a text field on the report but when passing it t... more >>
|