all groups > sql server reporting services > december 2004 > threads for tuesday december 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 31
GetScheduleProperties()
Posted by FNDS at 12/21/2004 4:35:14 PM
I create a report subscription in code. Everything works fine:
string id = service.CreateSubscription(reportName, extensionSettings,
description, eventType,matchDataParam, parameters );
I get the id back and store it in the database. When I try to pass the id
to GetScheduleProperties() I... more >>
different dataset inside table header
Posted by plandry NO[at]SPAM newsgroups.nospam at 12/21/2004 4:31:04 PM
Hi, I need to access a secondary dataset inside a table header. I have a List
item defined, and a TextBox inside it. When I try to access a field in the
secondary dataset, it says that field is outside of scope. How can I
accomplish this? If it's any help, here is the RDL:
<TableCell>
... more >>
Integrate Reports in ASP.Net Web Form
Posted by Kiran at 12/21/2004 4:01:17 PM
Hi,
I have my reports at http:\\localhost\ReportServer and need to use them in
ASP.NET Web Form.I have a few questions reg. this
------> I want to generate a PDF when a button labeled "Generate Report" is
clicked"
(1) I tried this using the below code:
Dim myResponse As Byte()
Dim u... more >>
Dynamic SQL in a RDL file?
Posted by Scott Meddows at 12/21/2004 3:55:14 PM
Can I put parameters and change the SQL in a dataset using expressions?
Thanks
Scott
... more >>
How to avoid Jump/out of fram w/ ReportViewer
Posted by Walter at 12/21/2004 3:47:07 PM
Hi there,
I've got a nice drill-down, drill-up parent child MDX report, that works
fine when viewed within the reporting services window. However, when I am
viewing it through the ReportViewer the navigation action click jumps the
result out to a new window. I cannot seam to find a way to k... more >>
Top 10 MDX
Posted by Carlos Krauss at 12/21/2004 3:33:01 PM
I am trying to get the Top N sales for the customers for a datawarehouse
using the following MDX:
="SELECT {[Measures].[Net Sales],[Measures].[Qty Lb]} ON COLUMNS,
TopCount(ORDER({[CustomerSalesPerson].[Name].Members},[2004], DESC),"&
Parameters!TopCustomer.Value &") ON ROWS,
{[TimeBy... more >>
Q: dlookup
Posted by JIM.H. at 12/21/2004 3:17:07 PM
Hello,
Is there any function like dlookup in reporting services. I need to bring
some data from another table..
Thanks,
Jim.
... more >>
Matrix Row Headers After Data
Posted by Sean Carpenter at 12/21/2004 2:38:42 PM
I have a report that uses Analysis Services data in a matrix. The column
groups in the matrix are based on date, and the number of column groups is
variable based on the start time and end time entered as report parameters.
I'd like to display the row headers after the column groups, regardle... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Subscriptions Eating up Processor and Memory
Posted by Cooper at 12/21/2004 1:57:03 PM
Is anyone using alot of subscriptions? Currently I just 10 subscriptions
made, all of which generate .pdf's and either email the pdf or stick it out
on a file share. I scheduled some of these subscriptions to run every hour(as
a test). It seems that the subscriptions dramatically effect the pe... more >>
Same Line, Different Lengths
Posted by box2003 at 12/21/2004 12:24:55 PM
Two identical length lines and properties, one in the Page Header and the
other in the Body Area. When previewing in the report preview window, the
line lengths look good and the same length in the preview window. When the
report is deployed to the server and viewed, the line lengths are dif... more >>
Request failed with HTTP status 404
Posted by Priya at 12/21/2004 12:21:03 PM
Hi
I have a .net application that lists all the reports within a specific
folder using RS.children methodand then calls a specific selected report in
Report viewer. My application code and reporting services are in two
different servers however in the same domain. The problem is that when I... more >>
Status of SP2?
Posted by Shane Castle at 12/21/2004 11:29:02 AM
So where are we with SP2? This super double top secret stuff is great and
all, but it would be nice to understand what changes we will be getting and
when. Rumor has February/March, and so it would be nice to truly understand
what the future holds. Cognos and BO don't even keep their expect... more >>
GRAPH exported to EXCEL ARE NOT EXCEL GRAPH
Posted by Jean-Marc Pugin at 12/21/2004 10:35:08 AM
Hi,
Graph exported to Excel by RS are static images (?!;$%).
Is there a way to use RS to generate Excel files that contain REAL Excel
graphs interactive on a local subset of data stored in the Excel file.
Many Thanks.... more >>
Repost:External Assemblies in Reports
Posted by ALI-R at 12/21/2004 9:33:25 AM
Hi ALL,
Is it true that any custom assembly that I create ,by defualt has
"Execution" permission and if it dosn't attempt to have access to protected
resources like files ,that secuity policy will do and I don't need to change
any security policy???
I've cretaed a simple Assemly which only ... more >>
LogonUser method from a windows app with RS using forms authentica
Posted by Nathan at 12/21/2004 9:03:06 AM
I have successfully implemented forms authentication and have written a
custom security module to suit my needs. During my initial testing of
reporting services, I used windows authentication. I had written a vb .net
windows application that provided similar functionality to the "RS"
appli... more >>
What is the code to generate a PDF in my custom delivery extension
Posted by Adam at 12/21/2004 8:33:02 AM
Hi,
I need to know the code that is used to generate a PDF file out of a report
that is created in a custom delivery extension I am writing. I'm using the
Sample Printer Delivery Extension as the base to extend upon. I need to
change this to generate a PDF instead of an IMAGE, afterwards I wi... more >>
Data Processing Extension (Login failed for user '(null))
Posted by Ajay Kumar at 12/21/2004 8:29:02 AM
Hi all ,
I have created custom Dataprocessing extention for reporting service , the
custom dpe code requires calling to other dll for datamanuplation ( which is
another layer and i have to use this layer for manuplation on to the dpe) it
works fine during design time in vs.net but on depl... more >>
Reporting Services
Posted by mvp at 12/21/2004 8:11:06 AM
Hello I am a SQL SERVER Programmer and new to Reporting Services.
Where can i find MS Reporting Services in SQL SERVER 2000 and also what else
i need to have to begin with Reporting services (just to create simple report
initially).
thx
... more >>
HTML5 - rendering extension that is not registered?
Posted by Brian at 12/21/2004 8:06:14 AM
Hello,
I'm new to reporting services and trying to evaluate the best use for
our needs. One of the first things I've come across is that extensions
listed in the documentation (I'm running RS SP1 on SQL DEV) are not all
valid. The HTML5 rendering extension in particular does not seem to
exist... more >>
Cannot Access Report Server
Posted by Jake Taylor via SQLMonster.com at 12/21/2004 7:08:50 AM
Hi!
I installed RS on a Server with the following:
Windows Server 2003
IIS 6.0
Sharepoint Server/Services 2003 w/ SP1
SQL Server 2000 w/ SP3
I followed the instructions to the letter on the topic "Side by side installation of RS with Sharepoint" and did not receive any setup errors. How... more >>
WindowsXP problem
Posted by Soan at 12/21/2004 6:43:03 AM
Does someone knows if there is a problem with WindowsXP??
We have an application an from it we call an display the common GUI from
Reporting Services. A user installed WindowsXP and now he must have IE always
open and he can not export anymore. Do I have to change something in the
configura... more >>
Parameter Valid Values
Posted by Ale Dori at 12/21/2004 6:41:08 AM
How can I obtain the valid values from a query based parameter using the
Reporting Services web services ???
The ValidValues property don't return them.
Thenks... more >>
Juggling Parameters
Posted by Bassist695 at 12/21/2004 6:27:06 AM
I am reporting off a star-schema data warehouse. I have three datasets that I
use to populate parameters, and one master dataset that uses the values from
all three to populate the report. The way I have set up the master dataset
is:
SELECT *
FROM t_policy_info
WHERE month_key = @month... more >>
PageNumber in the body
Posted by Ola A. at 12/21/2004 4:15:02 AM
There is Globals.PageNumber variable that can be used only in page header
and footer.
How can I get page number in page body?
Ola A.
... more >>
Installation sequence
Posted by Keith Macdonald at 12/21/2004 3:55:01 AM
Just want to check whether I have the correct installation sequence...
(1) Windows Server 2003 then updates/service packs
(2) IIS6 then updates/service packs
(3) SQL Server 2000 then updates/service packs
(4) Reporting Services
Is that correct?
Thanks... more >>
Variables in the Mail Subject
Posted by Steve Morris at 12/21/2004 2:03:03 AM
I would like to use other variables in the subject line of the email apart
from the two defaults (@ReportName,@ExecutionTime). For example, I would like
the subject line to be "Report x - Week y : Year z" where y and z are two of
the parameters for the report. Is this supported in RS and, if s... more >>
Error when generating in Excel
Posted by Mukund at 12/21/2004 1:09:02 AM
I am currently having a problem in production when generating a report in
Excel. I get the following error:
Reporting Services Erro
--------------------------------------------------------------------------------
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderi... more >>
|