Forms authentication ticket timeout
How do we change the authentication from timeout to a larger number in
report server with forms authentication? thanks! Tag: 5 digit zipcode Tag: 71496
RSClientPrint deployment question.
I have read the thread 'print active x question' posted more than a year ago
and would like to follow up...
We have an application using a webbrowser control to access reporting
services and have run into the issue of needing RSClientPrint installed
during our setup because security policies/settings may prevent the user from
installing the activex at runtime.
Has MS provided an .msi or merge module, etc. to deploy this yet? If not, is
there a definitive answer to which folder we should put the files?...is it
possible/safe to put them in Downloaded Program Files?
Thanks!
Kevin Tag: 5 digit zipcode Tag: 71495
Unable to design local report - Add new data source disabled
We recently converted a web application from VS 2003 to VS 2005 SP1. As we
desired, it was converted to the "Web application project" format rather than
the "Web Site Project" format. The application has been functioning OK since
the conversion. By the way, I did a full install of VS 2005, except I did
not elect to install SQL Server 2005 Express Edition. Our web application
uses SQL Server 2000 as the database.
For the first time recently I attempted to design a reporting services
report in "local mode". I opened the report designer and it appeared fully
functional, except that in the "Website Data Sources" window the "Add New
Data Source", "Edit Data Source with Designer" and "Configure Data Source
with Wizard" buttons were all disabled. The only enabled button was
"Refresh". No data sources were listed in the window.
I created a new strongly typed dataset/table adapter, and clicked "Refresh"
and still nothing was listed in the window. Then after some reading, I
thought maybe the designer was designed with "Web site" projects in mind and
expected to find data sources in the "App_code" directory. Of course, a "web
application" project does not need an "app_code" directory, but I created one
for this purpose and created a strongly typed dataset/table adapter in that
directory. I hit refresh in the designer, and still no data sources were
listed in the "Website Data Sources" window. And the designer requires a
data source for designing a report.
I cannot proceed until I create a data source. Has anyone else encountered
this problem? Is it related to "web application" projects? I particularly
don't understand why the "Add new data source" button is disabled. Would
appreciate any help.
Regards,
Robert Reader Tag: 5 digit zipcode Tag: 71494
Unable to specify NONE for default value of report parameter
I have a report with a single parameter that allows nulls. If I
preview the report in VS2005, the report launches immediately instead
of prompting for values for the parameters which I would expect to
happen whenever all of the parameters have default values. However, I
cannot specify "NONE" as the default value. The only options for
Default Values on the Report Parameters screen are "Non-queried",
"From query", and "Null". How do I specify tha the parameter does not
have a default value? Tag: 5 digit zipcode Tag: 71492
Check Boxes
Typically we use the wingdings font to render check boxes.
Not everyone has wingdings installed so sometimes it fails.
We have also used images.
Got any other slick ways to do this? Tag: 5 digit zipcode Tag: 71490
calculation with dates challenge
I have a start and end datetime field and a field with the lunchbreak in
minutes. Now I need to find out the number of hours and minutes (HH:mm) this
person has worked.
endtime - starttime - lunchbreak and formatted in HH:mm.
Suggestions on how to go about this in Reporting services ?
Peter Tag: 5 digit zipcode Tag: 71488
Date Parameter
I am trying to create a parameter for time period ending dates for a
report involving the number of hours employees have worked in each
time period. There are two issues that I am running into:
(1) When I do the "preview" of the report, the parameter brings back a
time period ending date for each employee. For example, there are over
100 entries for the ending date 8/6/2006, one for each employee. How
can I change it so that it only brings back one entry for 8/6/2006?
(2) Again, in the report "preview," when I select one of the dates
above, it brings back the information for all employees for all time
periods, not just the information for employees for a specific time
frame. My end goal would be to have the report set up so that there is
only one entry in the parameter drop-down list for each time period,
and when one such entry is selected, that the information for all
employees for that dates are returned on the report.
Any insight would be appreciated! Tag: 5 digit zipcode Tag: 71481
Running CRM Reports via Report Manager
How can I run reports designed for CRM to run in our Report Manager
environment with proper security rights?
Thank you. Tag: 5 digit zipcode Tag: 71480
Target Actively Refused HELP!
Hi All,
I have a reporting server on SQL 2000 that accesses cubes on a separate
Analysis Services box. For some reason administrators are able to run
reports fine however normal users receive the error:
No connection could be made because the target machine actively refused it.
I am at a loss and have no idea what to look at.
Thanks!
Ash Tag: 5 digit zipcode Tag: 71476
conditions to successfully create a subscription?
Hi,
the report I am trying to create a subscription for has no parameters. it is
not a linked report: it contains subreports and none of them has
user-defined parameter.
I tried Credentials stored securely in the RS, with a domain account (and
selecting the windows authentication), or the SA account, or another sql
account created for the occasion, the report runs fine, but I could not
create a subscription, the error being: the credentials are not stored
locally, or the report is a linked report (which it is not) with invalid
link, or has user-defined parameters which is not true.
So how to troubleshoot this problem and create the subscription? or could I
do this with a sql script instead of the Report Manager? anyone has a script
to share?
Thanks Tag: 5 digit zipcode Tag: 71463
no data handling
I have created a sales checking report which will only show the items below
the sales target, now I subcribe this report by email daily basis, but even
there are no any data on the report, it will also sumbit a blank report to
me. it is possbile to control no data handling for reporting or subcription.
Thanks for any suggestions. Tag: 5 digit zipcode Tag: 71460
Problem connecting to RS?
From SQL Server 2005 i am connecting to sql server 2000 database.
I try to connect to 'Reporting Services Configuration Manager' and i
received error message 'Provider load failure'.
What should i do to make RS work?
Should i reinstall SQL Server2005? Tag: 5 digit zipcode Tag: 71455
List Control - Group Header RS2000
I need to modify a report that has a list containing other controls,
subreports..etc that can span multiple pages. How can we show a "group
header" on each page rendered withing the list? We tried moving the list
contents into a table cell but the group headers won't repeat on each page.
Thanks Tag: 5 digit zipcode Tag: 71452
using .rdlc sub report
i want to use .rdlc for sub report
but simply couldnt get the idea of nested objects (Objectdatasource)
for subreports very clear
so for the sake of knowing i would like to see some example Tag: 5 digit zipcode Tag: 71450
Joining Tables Across Multiple Datasets
I am trying to join two tables from two different datasets in SQL
Server 2005 Reporting Services. How would one go about doing this?
Since there are technically two spots to have SQL queries (one for
each dataset), how does one go about doing SQL? Is joining across
multiple datasets even possible? If so, are there clever workarounds? Tag: 5 digit zipcode Tag: 71449
Displaying Top N subtotal as well as grand total
I am currently migrating Crystal Report XI reports over to the
Reporting Services and came across a problem.
The Crystal Report displays Top N records, subtotal of these Top N
records, and the grand total of all the records. SQL stored procedure
underneath returns all the records.
>From what I have been reading in online groups and helps, these types
of features are not directly supported in the Reporting Services. The
workaround I have found so far involves returning two sets of results
("Top N" results and "All" results) and combining the two result
sets.
Since some query takes up significant amount of time, I would like to
avoid calling the stored procedures twice if necessary. Does anyone
know how I can avoid this and work with just one result set?
Thanks in advance.
Shohei Tag: 5 digit zipcode Tag: 71443
Excel Exports Hidden Images
Hello,
I think this may be a bug with SSRS 2005 but wanted to verify in case anyone
has a remedy. My report contains a table with an image on the detail row
whose visibility is toggled based on a value. Everything works as expected
when viewing the report onscreen or exporting to PDF. However, the Excel
Export ignores the visibility expression and displays the image for every
detail row. Any thoughts or workarounds?
Thanks in advance!
Kathy Tag: 5 digit zipcode Tag: 71439
controlling text box location
I have a text box above a matrix and the matrix is set to start on a new
page. how do I get the text box to start on the new page also?
TIA
Dean Tag: 5 digit zipcode Tag: 71438
The permissions granted to user 'Adelso-PC\Adelso' are insufficient for performing this operation. (rsAccessDenied)
When access http://localhost/reportserver$SQLExpress the first time after
SQL Server with Advance Services installation on Windows Vista Ultimate, the
SQL Server Reporting Services show the following error:
"Reporting Services Error: The permissions granted to user
'Adelso-PC\Adelso' are insufficient for performing this operation.
(rsAccessDenied) Get Online Help".
After granted permissions to Adelso on the properties of the
ADELSO-PC\SQLEXPRESS database the problem persist. There are something that
I'm doing wrong or missing? Tag: 5 digit zipcode Tag: 71437
Dynamic formatting
Can someone please provide me some pointers on dynamic formatting. How
can I change the formatting information from code.
Where on SQL Books online can I get information on dynamic formatting
Thanks
Karen Tag: 5 digit zipcode Tag: 71435
Report Builder - Add a report date
any way using report builder ad hoc tool for users to add an "as of" date to
a report using the TODAY function?
Rich Belanger Tag: 5 digit zipcode Tag: 71434
Mozilla Firefox and Report Viewer Print control
Has anyone gotten the print control in report viewer to work with Firefox?
One of our clients insists on using firefox and we would like to use
reporting services. I found and downloaded the Mozilla Activex control and
plugin support, added the CLSID for the RSClientPrint control, but have not
had any success in having the control show up in the report viewer.
Microsoft's knowledge base talks about what does and doesn't work in Firefox,
but mentions only that the print control does not work in Safari. Any help
would be greatly appreciated! Tag: 5 digit zipcode Tag: 71433
Grouping Data in charts
Is it possible to group data in charts?
e.g. I need to return a graph with % and other data per office separately
for a board pack so the charts either appear per office on a page or a couple
of charts per page. Tag: 5 digit zipcode Tag: 71425
Dates and Parameters
I have created a report with parameters, I select the dates (01/05/2007) to
(01/07/07) using the calendar and then click view report the dates then reset
to (05/01/07) to (07/01/07) and no data is displayed yet the parameters which
are displayed in the report are returning the correct values. When you click
view report again without amending the dates the data is returned and the
parameters values as displayed in the report are incorrect. Please help. Tag: 5 digit zipcode Tag: 71424
sql90exception
Hi!
I'm getting this message on my 32 bit Windows 2003, SQL Server 2005, SP 2
(9.0.3054)
EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4
reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 462f8102, P7 0,
P8 00005253, P9 00000000, P10 NIL.
Is there anyone who knows what this means?
/*
Fari
*/ Tag: 5 digit zipcode Tag: 71421
Newbie Here: headers print even though drill down not clicked
I have a report containing drill down detail. The headers for the drill down
detail prints even at the summary level. This is causing two pages to print
for every one due to the headings. How can I turn the headers off unless the
user has selected to view the drill down data.
Any help would be greatly appreciated. Thanks! Tag: 5 digit zipcode Tag: 71410
Report referencing dynamic table
Hi all
Just wondering how one would approach buidling an RS report based on a
dynamic table ie. Each time the report is run, the table may have a
different number of columns.
Here is what I'm trying to acheive:
The user enters a date range for the report. The report then calls a SQL
stored proc which generates a table containing columns for each day in the
date range. That table is then used as a datasource in the report.
Any assistance guidance will be appreciated
Thanks in advance
George Tag: 5 digit zipcode Tag: 71409
run IIS error?
When i go to My computer-Manage-IIS(restart).
I have folowing error message;
The service has not been started.
I did reinstall IIS.
What should i do to run IIS?
Thanks. Tag: 5 digit zipcode Tag: 71407
images loading slow corrupts the report
I have a report with an embedded image which appears in every row(static), it
also has a report that it drills down to. This page that calls this report
uses the reportviewer. the report loads quick, but the images take a while
longer. If I hit the column that drills to the next report, I can see the
page call the server, but the report stays on the same page. Yet the
reportviewer showbackbutton becomes active. If you hit the backbutton on
the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
be found .
How do I get the images quicker?
How do I keep the above problem from happening? Tag: 5 digit zipcode Tag: 71406
Deploy Report error?
I try to deploy report "rptInfo.rdl" and I receive this error;
A connection could not be made to the report server
http://localhost/ReportServer.
Unable to connect to the remote server (Microsoft.ReportingServices.Designer).
What should i do to make this work?
Thanks. Tag: 5 digit zipcode Tag: 71405
Best Practices for RS and VSS
We are starting to use VSS2005 for storing projects and rdl files. We are
mainly using it for the versioning capabilities in VSS. Does anyone have any
tips for best practices on how to utilize Visual Studio 2005 and VSS 2005?
IF anyone has a link or two to sites that go over this topic that would be
helpful too.
The problem have had so far is trying to check out the rdl files through VSS
and then open them in Visual Sutdio to edit them. Whenever I have checked
out a file in VSS and then opened the file using the options in VSS to get to
Visual Studio (devenv) I either get a message stating that the carriage
return is messd up in the file or it opens the rdl code... not the designer
window.
If I check out the file in VSS and then open the file through Visual Studio
without using VSS to get to Visual Studio, everything works fine, but that
just seems a little too manual. Thanks in advacne for your help. Tag: 5 digit zipcode Tag: 71404
2005 Datepicker control and dateformat
Hi, we have an installation of MSSQL reporting services where users
can select data based on date ranges. Since upgrading to 2005 we now
have a nice new Date picker control alongside textareas which accept
MSSQL datetime values.
This is all very nice but the date picker automatically formats the
date to US format mm/dd/yyyy. We need it to be in dd/mm/yyyy format.
I
have checked the regional settings of both the browser/ server etc.
Scouring the Internet seems to point that this is a post SP2 problem
but there seems to be no fix other than making the datefields a type
of nvarchar and then converting them to dates in the Stored
Procedure.
If there really is no fix, how can I just disable this date picker
control? In 2000 people just entered the dates manually, this was
fine
but know there is a date picker control people are obviously going to
use it.
Thanks
Rex Tag: 5 digit zipcode Tag: 71403
Modifying Templates
If I create a new template, build reports from it, and then change the
template, will the existing reports implement the changes?
TIA
Dean Tag: 5 digit zipcode Tag: 71402
ReportViewer.PerformBack() Method Not Working
Hello,
I am using the PERFORMBACK method and am getting the
following error:
"The operation can only be performed from a drillthrough report". I
am specifically running this method
in a while loop only if IsDrillThroughReport is true. So, if
IsDrillThroughReport is true, which it is,
why would I be getting this message?
Thanks, Dean Tag: 5 digit zipcode Tag: 71401
color combinations
Where can I find some good looking examples of reports and charts that
showcase good looking design practices (my efforts leave a lot to be
desired:). I can find lots of examples for FrontPage and PowerPoint,
anything out there for SSRS?
TIA
dean Tag: 5 digit zipcode Tag: 71400
Where to install Visual Studio 2005
We currently have Visual Studio installed on the Reporting Services server.
Are there any issues with installing VS on another workstation instead?
Thanks,
Steve Tag: 5 digit zipcode Tag: 71396
Report Viewer Control Drill Through Remote Reports losing its way
Hello,
After hitting the "back Button" from a drill-through
report, it displays the parent report again.
Once I click on another drill-through report, I get the following
message:
"Some parameters or credentials have not been specified". Anyone
have any ideas?
Thanks, Dean Tag: 5 digit zipcode Tag: 71388
Showing value+percent in pie chart
Hi,
This may be a silly question, but how do I show both value and percent
in a pie chart?
Thanks in advance,
R. Green Tag: 5 digit zipcode Tag: 71387
How to stop report parameter taking default value
I have a SSRS2000 report with three parameters:
1) Company - values from a query including NULL for ALL companies - no
default value
2) From date - has default value
3) To date - has default value
My problem is that the report runs automatically when launched. Even though
there is no default value specified for the Company parameter it takes the
NULL value.
Is there any way to change this to force the Company prompt to display a
<select a value> and allow selection of one of the options?
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland Tag: 5 digit zipcode Tag: 71384
How to create installation share for BI Development Studio
We have SQL Server 2005 and reporting services on several servers. We want
to enable developers to install BI Dev Studio to their desktop machines, and
not have to obtain a SS 2005 install CD. We want to create a directory on a
share that has the necessary files so they can just install it directly.
Is that possible? If so, which directories or files do you copy to the
sahre, and from where? Is there a directory with the needed files on the SQL
Server 2005 (with reporting Services also installed) server - the one created
by running the SQL SErver 2005 installation from the CD?
Thanks. Tag: 5 digit zipcode Tag: 71383
Summing data from different years
I'm trying to use SRS to recreate a report that is currently in Crystal
Reports. This is basically what the report displays:
2004 2005 2006
Customer
Category1 $$$$ $$$$ $$$$
Category2 $$$$ $$$$ $$$$
Category3 $$$$ $$$$ $$$$
It basically groups by customer then by Invoice category, then adds up the
totals from the invoices in that category for that year. To get the totals,
I'm using an expression like this for each year:
=SUM(IIF(Year(Fields!DOCDATE.Value) = 2004, Fields!Price.Value, 0))
This works just fine if I only pull data from 2004 but if I pull data
between 1/1/2004 and 12/31/2005, The textbox just displays "#Error". It seems
that if there is data from more than one year in a category for a customer, I
get this error but if the customer for example bought in just 2004 but
nothing in 2005 it works fine as well.
Should I be doing this a different way? Tag: 5 digit zipcode Tag: 71382
On different server?
HI All,
Currently we have two servers in our poduction farm. One runs
sharepoint and the other is the database server. Can i install
reporting services o nthe sharepoint server and tell it point to the
database server? Right now I have it installed the db server, but
would like to move it to the other server.
Any ideas
Thanks!
-SJ Tag: 5 digit zipcode Tag: 71381
Interactive Sorting -prevent group from collapsing
is there a way to configure interactive sorting so that a group that has
been expanded does not get hidden again when the sort arrow in a column
heading is clicked?
TIA
Dean Tag: 5 digit zipcode Tag: 71377
Stored Proc for Report Model
Hello
I was wondering, is it possible to build a Report Model (VSBIDS2005) from a
Stored Proc?
Kind regards
Ricky
(SS2005/SSRS2005) Tag: 5 digit zipcode Tag: 71376
Blank Pages After Sub Reports
Hi -
I have a report with multiple sub reports. Each sub report is in a separate detail area of a table. When I have a have a sub report that has a lot of data there will be blank space between the sub report and the previous sub report. In this case I have a sub report for employee hours and then a sub report for expenses. Both sub reports are within a table group for project. So for each project the report should list employee hours and then display a section for all the expenses for the project. The problem arises when there are a lot of expenses. Reporting Services will start the expense area on a new page resulting in a half page of white space after the employee section. It appears Reporting Services is attempting to fit each sub report on one page. I have KeepTogether in the table properties set to false and do not have fit to one page checked anywhere in the report or sub reports. I am using Reporting Services for SQL 2000. Has anyone else resolved this issue?
From http://www.developmentnow.com/g/115_2006_8_0_23_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com Tag: 5 digit zipcode Tag: 71375
Report paging problem
I'm having a problem with a report i recently built. I use a table
with three colums and one issue I have is there is a lot of white
space left all over the report because a table group will not span
onto the next column.
With the exception of one group that is larger than 1 entire column.
That one actually fills up one column and then starts agian at the top
of the next column.
Has any one else ran into this?
Also if you know how to potentially fix this let me know.
Thanks,
Greg Tag: 5 digit zipcode Tag: 71374
Calling my RS "Invoice Report" from c# app question...
I have a parameter to bring up my report now, which works fine.
But I need to add the functionality of bringing up my report from c#
now.
Any help is appreciated.
Thanks,
Trint Tag: 5 digit zipcode Tag: 71372
I am trying to display just the first 5 digits of the zip code. How can I do
this?
On Jul 9, 2:34 pm, Shan <S...@discussions.microsoft.com> wrote:
> I am trying to display just the first 5 digits of the zip code. How can I do
> this?
>
> Thanks
> On Jul 9, 2:34 pm, Shan <S...@discussions.microsoft.com> wrote:
> > I am trying to display just the first 5 digits of the zip code. How can I do
> > this?
> >
> > Thanks
>
> Try =Fields!FieldName.Value.Substring(0,5)
>
>
> On Jul 9, 2:34 pm, Shan <S...@discussions.microsoft.com> wrote:
> > I am trying to display just the first 5 digits of the zip code. How can I do
> > this?
> >
> > Thanks
>
> Try =Fields!FieldName.Value.Substring(0,5)
>
>
"Shan" <Shan@discussions.microsoft.com> wrote in message
news:59473B89-F8DE-4B44-8C6F-E7B0C96AC3C0@microsoft.com...
>I am trying to display just the first 5 digits of the zip code. How can I
>do
> this?
>
> Thanks