MS SQL Server :: Default Non-queried Report Parameter Not Updated When Project Is Deployed

RS2005 Non-Queried Default Value Not Set After Deploying To Report Server
Hi all,

I'm not sure if this is a bug in Reporting Services 2005 but whenever I use a string as a non-queried default value for a multi-value param, it will not be set after I deploy the report to Report Server. It works fine in the preview tab of Report Designer though. I haven't tried it on single valued params but I'm guessing same applies.

Anyway, if you guys encounter this too, the way to solve it is quite simple. Delete your previous report from the server and deploy it again. The default value will now be set properly. Hope this helps!

Thanks also to another post from "smhontz" who encountered this in RS2000:

Cheers,
INK

View Replies !

Multi-value, Non-queried, Report Parameter Expression Problem
I need to use a non-queried report parameter to filter a dataset for a report.

The dataset column I'm filtering is numeric. The dataset is not a sproc, it's a table in SQL Server that I am querying.

The Non-queried parameter values (Multi-value) are 1, 2, 3, 4, 5, >=6.

Selecting the >=6 throws the error: "Error converting data type nvarchar to numeric."

Which sucks.

Because...when I go straight into my dataset I can filter my numeric column with the exact same values (=1 or =3 or >=6) and everything works fine. The error is only raised when I use the @Parameter in the dataset.

I've tried eveything, researched everywhere online and I can't find any guidance anywhere.

View Replies !

Queried Parameter Based On A Queried Parameter
FOA, I am using the webservices of the RS2005.

I created a report with same parameters. Two of them a based on a query. The first query contains a simple select * from ... the result will be stored in the parameter @param1. The second parameter contains select * from ... where ID = @param1. So far...
If a pass the reportparameters of the report i will get a valuelist for the first query, but nothing for the second one.

How can I manage that the second parameters also gets a valuelist?

regs

View Replies !

Best Practice For Formulating A Default Value For A Queried Parameters

In general, what is the most appropriate way to specify a "data driven" default for a report parameter. Seems to me like options are:

1. construct an expression which operates on one of the existing report datasets (possibly the same data set used to populate the defaults dropdown)

2. construct a new dataset which returns a single value which is the desired default

what's the "normal" approach?

For example, I have an MDX dataset which contains the list of dates for which data is available. There is generally some data available for today, but normally the user is interested in the most recent day with data prior to today.

So which would be the better option out of the two above (or a third option if I'm missing something!) to tell my parameter to set itself to:

"The most recent day prior to today for which data exists".

View Replies !

Passing Parameter Query From SQL Function To Access Project Report
I can pass a parameter from an Access Query to an Access Report (MDB) by entering [Select Date] in the Query criteria and by placing an unbound control with a control source =[Select Date] on the report. I can't get this to work from a SQL Function Criteria to an unbound control on the Access Data Project Report. In the Function Criteria, I enter @SelectDate. In the Report control, I enter @SelectDate and it gives me an 'Invalide Column Name' error. Any idea how I can pass a parameter from a SQL Function to an ADP report?

THANKS!

p.s. I tried searching for other postings on this without any luck.

View Replies !

Default Value For Report Parameter
I have a report which has paramets as startdate and enddate. I want to set default value as yesterday. So when It opens it shows yesterday data.

I have a expression like this.

(DATEDIFF(dd, 0,MoneyFlowTransaction.ProcessedTime) = DATEDIFF(dd, 0, GETDATE()) - 1)

But I'm wondering how I set this as dafault value.

can anyone help me pls?

View Replies !

Updating A Previously Deployed SSIS Project
I have an SSIS project with 5 packages that are currently deployed in production and working fine. I need to update one package to accomodate some new enhancements.

I am now ready to go from the staging environment to production, so I copied the production .dtsConfig files to the working folder and did a Rebuild All of the deployment image. But if I simply copy the newly built package to the server and import it into the SSIS Package Store, it retains the values of the config files on the staging server, even though it has been rebuilt with the production config files.

I can attempt to run the package from the deployment folder, and when the Excecute Package Utility comes up, I click on Connection Managers and all of the connection manager properties are the same as the staging server.

But if I go ahead rerun the installation program to deploy it on a temp folder and then import the single package that I want to update, it works correctly.

Is there any way I can just redeploy one package without redeploying all of them?

View Replies !

Use Report Server Project To Connect To Report Model Project Data Source View?
Hello,
I've created a Report Model Project that can be used by Report Builder to generate ad-hoc reports. I'm trying to create a connection string in my Report Server Project that points to the Report Model Project data source view.

All I can do is create a regular datasource, which bypasses the metadata contained in the Data Source View.

Basically I want my Report Server Project and my Report Builder reports to leverage the same metadata. Is this possible? If so how do I get the connection string?

Thanks!!
-Matt

View Replies !

Datetime Report Parameter Default Value
Issue 1:

I have a report parameter StartDateTime. I set the default value to Now(). When I go to preview, the StartDateTime parameter is empty and its been locked. I am not even able to set it to different value in preview.

Can anyone help me how to set the datetime parameter to default value(Now).

Issue 2:

I have a stored procedure which takes StartDateTime parameter. Whenever the report refreshes using autorefresh interval, the startdatetime should default to Now. Right now the startdatetime defaults to whatever the value is there before i hit view report. how to do that using stored procedure.

Thanks fro your help.

View Replies !

Monthly Parameter Expressions [Formerly:Queried Parameters]
Hello,

I need to be able to set the date parameters of a report dynamically when it is run based on system time. The problem I am having is being able to compare the dates (StartDate & EndDate) against [Service Date 1]. Essentially this report will only pull the current month's data.

The date fields being created with the GETDATE, DATEADD & DATEDIFF functions are working correctly. Do I need to create a separate dataset to be able to run the parameters automatically in the actual report?

Any help would be greatly appreciated!

SELECT         TodaysDate =GetDate()-2,dbo.[Billing Detail].[Service Date 1], DATEADD(mm, DATEDIFF(mm, 0, DATEADD(yy, 0, GETDATE())), 0) AS StartDate, DATEADD(dd, - 1, DATEADD(mm, DATEDIFF(mm, -1, GETDATE()), 0)) AS EndDate, dbo.[Billing Detail].Billing, dbo.[Billing Detail].Chart, dbo.[Billing Detail].Item,
                      dbo.[Billing Detail].[Sub Item], dbo.Patient.[Patient Code], dbo.Patient.[Patient Type], dbo.[Billing Header].Charges, dbo.Practice.Name
FROM         dbo.[Billing Detail] INNER JOIN
                      dbo.Patient ON dbo.[Billing Detail].Chart = dbo.Patient.[Chart Number] INNER JOIN
                      dbo.[Billing Header] ON dbo.[Billing Detail].Billing = dbo.[Billing Header].Billing CROSS JOIN
                      dbo.Practice
WHERE         (dbo.[Billing Detail].Item = 0) AND (dbo.[Billing Detail].[Sub Item] = 0) AND (dbo.[Billing Detail].[Service Date 1] Between StartDate AND EndDate

View Replies !

Dynamic Default Value For Parameter In OLAP Report
I'm trying to set up a parameter report from a OLAP cube. I need 3 dynamic parameters(ThisYear, ThisMonth, YESTERDAY).

THISYEAR: =CStr(DatePart("yyyy",Today()))

THISWEEK: =CSTR(DATEPART("ww",Today()))

YESTERDAY: =CSTR(Datepart("d", Today().AddDays(-1)))

So far so good. I want to send this report by email everyday, so I need to set these parameters as a default value. This is where I run into problems.

When I add any of these parameters I get the following error "The restrictions by the CONSTRAINED flag in the STRTOSET function were violated". This problem occur when I choose NON-queried under Report->Report Parameters, and set a default value for THISYEAR under DEFAULT VALUES

=CStr(DatePart("yyyy",Today()))

Hope someone found a way around this problem.

Thanks in advance!

View Replies !

Dynamic Default Value For Parameter In OLAP Report
I have a basic SSRS report against an SSAS database with a "start date" parameter. I want to set the default value of that date parameter to Today's date. What is the easiest way to do this? I have no problem doing it against a relational source, just haven't done it against an OLAP source.

Thanks for any ideas.

-Josh R.

View Replies !

Setting Default Value Of A Report Parameter Dynamically
Hi all,

Does sombody have experience on dynamically set or change the default value of a report parameter?

Assuming: report parameters p1, p2, p3, p4 have been set up(and have their default value 'all') with the creation of the report1; report browseing is through reportviewer that embedded in the web application; datasource is datacube

What I want to do: based on the login user of the my web application, set default value of p1 as the user's username.

What I did is:

Microsoft.Reporting.WebForms.ReportParameter reportParam = new Microsoft.Reporting.WebForms.ReportParameter("P1","Mary");

ReportViewer1.ServerReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter []{ reportParam });

what I got when reveiw the report:

P1 has no default value, and p2, p3, p4 greyed and could not choose value from them.

Any idea and suggestion will be pre-appreciated!

Jone

View Replies !

How Do You Get The Last Child Of A Report Parameter To Show Up As A Default
Dataset "FromTimeDimension" is a report parameter and has values (yyyymm)= 200601,200602,200603,2000604....... I would like to always have the default for this parameter to always be the latest month...ie November is the most recent month in our cube, so I would want the parameter to default to "200611". However, when I try to use the "last" function, the error says that aggregate function cannot be used.

View Replies !

Default Value Or Value Provided For The Report Parameter Is Not A Valid Value.
Hi All,

My report has a drop-down list which will be used to filter the process name.

I create new dataset "PackageName" in my report using below query.
select distinct process_package_name
from [Work Breakdown Element Map] AS wbemap
WHERE (wbemap.project_name =@Project)

Then, I set process_package_name from the PackageName dataset to ProcessName variable as an Available values and Default Values .

After that, set filter
=Fields!process_package_name.Value In =Parameters!ProcessName.Value

I pack this report to my process template and create new team project using this process template.
After I create some new instances and force the Warehouse to update by run the WebService.
The report also found the new process name (They shows in the drop-down list) but the detail of report is not show.

Default value or value provided for the report parameter 'ProcessName' is not a valid value. (rsInvalidReportParameter)

I test and it work in the report project but it does not work in the real project.
Any idea?

thanks,
Sora.

View Replies !

Linked Reports Not Being Updated When Master Report Is Updated
Since updating to SQL Server 2005 SP2 I've noticed two things about Linked Reports.

1. I do a lot of 'Snapshot' reports. With SP-1 if I updated a master report and made any changes to the Parameter List - it undid all my custom parameter changes on linked versions (restored to the Master Reports Defaults). While this is no longer happening with SP2 - it is still 'unhiding' the parameters.

2. With SP-1 if I added/deleted columns or made other changes to the report structure - the linked reports would pick up on the changes with their next refresh. With SP-2 I'm finding that I have to 'Re-link' the linked report back to the master report before the changes are refreshed. This is very time consuming especially with each report having 8 or more Snapshot reports pre-set up.

Am I missing something - or is this a 'bug'...

Any help would be appreciated...

View Replies !

Define Default For Date Report Parameter / Analysis Services
I have a report which will one day display some data from an analysis services cube. my first step is to create a drop down parameter enabling the user to choose the date. I'd like to display only dates that have data, and I'd like it to default to today.

So I've created a dataset that will be the datasource for the dropdown displaying the available non-empty dates, which works fine.

SELECT measures.turnover ON COLUMNS,

nonempty([TBL DIM DATE].[DATE_ONLY].[DATE_ONLY].ALLMEMBERS ) ON ROWS

FROM [Itdev1 Hk]

I've also set the report parameter up to be a queried paramter,and to use the above dataset as it source, with [DATE_ONLY] displayed. and [DATE_ONLY] as the value.

Now, how do I get it to default to the last valid member in the list?

View Replies !

PageBreaks Not Properly Rendered In Deployed Report On Report Server
Hi All,

We have 10 charts in One RDL file, out of these 10 charts 3 Pie charts are displayed dynamically,
Using 'Visibility' property expression in the 'Hidden' sub property as below.

Code Block
=iif(Sum(Fields!Total.Value, "DataSet")=0,true,False)

Which returns 'true' or 'false' for 'Hidden' property.
Each chart has to be displayed on separate page, hence we have set 'PageBreakAtEnd' Property to true for each chart.

Problem:
But, when this RDL file is deployed on report server, these charts are all displayed on single page without any page breaks.
however, when the RDL file is exported in PDF format, the report is rendered with charts on separate pages as expected.

Is there any way to ensure the charts are rendered properly, in report viewer of report server ?

View Replies !

Problem Deploying Custom Report Item. Items Shows In Preview Screen In VS, But Not In Server Deployed Report
I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

    <ReportItems>
      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
    </ReportItems>

3. Updated the rssrvpolicy.config file with the following entry.

                          <CodeGroup
                    class="UnionCodeGroup"
                    version="1"
                    PermissionSetName="FullTrust"
                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                            <IMembershipCondition
                                class="UrlMembershipCondition"
                                version="1"
                                Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
                          </CodeGroup>

I've also tried using the StrongNameMembershipCondition with no better results.

4. The dll and its dependencies are copied to the bin directory of the report server.

5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.

This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.

View Replies !

Can I Alter A Report That Has Already Been Deployed To My Report Manager
I have some OLAP reports in which I have to alter the MDX statements each month, in the VS2005 report designer. They are deployed to the web and they contain Descriptions and Subscriptions which I create once they get to the web. The way I am currently updating them each month is by editing the reports in VS2005 and re-deploying them to the Reports Server. I then have to add the descriptions again and create new Subscriptions because the orig reports are deleted when the new ones, with the same name are deployed. There has to be a way that I can just alter the existing reports in the web environment and not have to recreate the Subscriptions each month. Any help would be appreciated.

View Replies !

How Do I Enter In A Default Values For A Report Parameter That Accepts Multi Values

I have my stored procedure set to
Territory_code IN (@Territory)

, now , how do i enter in more then one value. When i select the multi value check box, it gives me more spaces. But then doesnt recognize the values when i put in more then one. am i doing something wrong?

The field is a Varchar 20

View Replies !

How Can I Change The Data Type Of The Parameter For The Deployed Stored Procedure ??
Hi

I have Try to Create Stored Procedure in C# with the following structure

[Microsoft.SqlServer.Server.SqlProcedure]
public static void sp_AddImage(Guid ImageID, string ImageFileName, byte[] Image)
{

}

But when I try to deploy that SP to SQL Server Express , The SP Parameters become in the following Stature

@ImageID uniqueidentifier
@ImageFileName nvarchar(4000)
@Image varbinary(8000)

But I don€™t want that Data types .. I want it to be in the following format

@ImageID uniqueidentifier
@ImageFileName nText
@Image Image

How Can I Control the data type for each parameter ??
Or
How Can I Change the data type of the parameter for the Deployed Stored Procedure ??
Or
How Can I defined the new Data type ??

Or

What's the solution to this problem ??

Note : I get Error when I try to use Alert Statement to change the parameter Data type for the SP

ALTER PROCEDURE [dbo].[sp_AddImage]
      @ImageID [uniqueidentifier],
      @ImageFileName nText,
      @Image Image
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [DatabaseAndImages].[StoredProcedures].[sp_AddImage]
GO

And thanks with my best regarding
Fraas

View Replies !

Problem With Deployed Report

I deployed my phone directory to the server and now dynamic images are no longer being displayed. They are specifically employee photos based on a naming convention. I used the path as ''file:/// etc.'' and when I open up my start menu and throw it into run it works fine. It also runs fine in my visual studio report, but for whatever reason when its deployed it no-longer runs. Does anyone know what could eb causing this problem?

View Replies !

Unable To Run A Report, After It Is Deployed
I encountered the following error after I deployed a report . The deployment process was successful, however, when I try to run the reports from the remote machine, It gives me an error message saying:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'SessionOLAP'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

On the other hand, I deployed this report on the local machine where the reportserver resides and it is running perfect.

Do you have any idea how to deal with this problem?

View Replies !

Unable To Run Report When Deployed
Hi all,

When I run the SSRS report in development mode, it is working fine. When I run in deployed localhost, I faced an error message as below:

The permissions granted to user 'FAROUKYEWNOTEBOASPNET' are insufficient for performing this operation. (rsAccessDenied)
Hope someone can enlighten me on this.

Regards,
Farouk Yew

View Replies !

Report Shifts When Deployed

Hi, I was hoping someone can help me fix a problem I am having when I deploy my rs report. What happens is when I view my report in designer everything works fine, however when I deploy me report to the report server and begin to drilldown into the matrix the entire report shifts down each time I toggle one of my drilldown fields. This causes the top of the report to disappear. The user than has the scroll up each time to reposition the report. Has this happened to anyone else? Does anyone how to fix it?

Thanks!

View Replies !

Deployed Report Fails To Start
VS2005 project with imbedded SQL Server reports works fine in VS IDE going agianst a network SQL Server 2005 or the local SQL Server 2005. However, when the application is deployed (to another computer). the application starts and connects successfully to the network SQL Server 2005. Everything works until the user tries to produce a report. Then the following error is generated:
Named Pipes Provider, error: 0 - No process is on the other end of the pipe (the verbose part of the error message is left out). SQL Server agent is running both on the file server and the local computer. Also, named pipes and shared memory are enabled in file server and local computer (TCP and VIA protocoles are disabled). Same is done for Client protocoles.
Any suggestions are greatly appreciated.

View Replies !

Generating A Pdf Document From A Deployed Report Using Asp.net
Hi All,

I am using ssrs and vs2005 to develop reports.The deployed reports are placed in the source directory(c:source) and i am using a asp.net page with a button on it to generate a report in .Pdf format and after generation this Pdf document will be placed in a destination folder(c: arget).

Can anyone help me out in solving this or atleast direct me as how to go on with it?

thanks

View Replies !

Image Will Not Render In Deployed Report
I have an RS report that pulls an employee photo into an image control from an internal Sharepoint web site. The report works fine in preview but the deployed version cannot access the link. Based on this and the fact that the deployed report can easily pull photos from a public bio site, I am assuming there is an authentication issue. We have verified that the SQL Server service account (which runs SQL, RS and IIS, all one the same server) can access the site so we are not sure where the authentication is failing and under what account RS or IIS is trying to access the site.

View Replies !

Cannot Execute/view A Deployed Report In Rpt Mgr
I'm still trying to get a recent install/setup of Reporting Services 2005 working. I have Report Server installed on ServerA which already had IIS running on it, the Report Catalog can be found on a 2nd server, ServerB, with SQL 2005 Std Edition installed.

I am able to browse to the Reports Manager site and see the test report I deployed there through Visual Studio 2005, installed on my machine. But when I try to view the report, I get:

An error has occurred during report processing.
Cannot create a connection to data source '[our db name]'.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'

Now, when I created the data source for that report, I used a Trusted Connection, which of course worked for me when authoring on my machine since I belong to a Windows group that has been granted access to the SQL Server and db in question.

Since Reports Mgr requires Windows authentication, I assumed that when attempting to view the report from within Reports Manager, it would again use my credentials. So I'm confused where the local system account, NT AUTHORITYANONYMOUS LOGON is coming from.

Any help would be greatly appreciated.

M Noreen

View Replies !

How To Use Default Parameter Values With A Date Parameter From A Cube/Reducing Parameters

Hi,

I have parameters in my report. The user can choose the year, month and date (3 parameters).
Now I want to set default vaules for the parameters , so that the user sees the report for example for the current day without selecting the parameters. I tried to set the type of the parameters to DateTime and the default value for example for the year to "=Today().Year" . But when I execute the report an error occures . Something like : no validValue for this parameter.

My Attributes for the year month and date are from an Analyis Services Cube from a Server Time dimension .
Does somebody know how to make it possible to set default values for this parameters?

Other question :

Does somebody know how I can reduce the values for a parameter. For Example I have a parameter "year" from a server time dimension from a cube. The values which are available are "Year 2004", "Year 2005", "Year 2006", "Year 2007".
But I want that the user only can choose "Year 2006" or "Year 2007" ant not every Year or "All".
Or Other Example: The User should only choose a Date that is int the past or Today but not a Date in the future.

Thanks !

JF

View Replies !

Default Parameter Value Is No Longer Part Of Cascading Parameter In SSRS 2005?
Hi,

I need "conditional" cascading parameters: In Report Manager when one changes parameter 1, parameter 2 get changed based on parameter 1. Optionally, one can also enter values to parameter 2 directly.

I was able to achieve this in SSRS 2000 (SP2) with the following setups. SSRS 2005 and SP1 no longer works - Parameter 2 always shows its default value regardless whether one select a value in Parameter 1 or not.

Parameter 1
available values: from query
default values: non query (specify a value "<None>")
Parameter 2
available values: Non query (no value specified)
default values: from query (based on Parameter 1)

It seems to me that the default value in SSRS 2000 is considered as cascading parameter. But it is no longer the case in SSRS 2005.

Is this a SSRS 2005 bug? is there any other work arounds or suggestions?

Thanks.

Kong

View Replies !

Running A Report Deployed On Reporting Server From C#

I have a report deployed on reporting serice. I am using reporting web service.
How can we call the report, assign parameters and execute it on a webpage

View Replies !

How Do I Get Visual Studio To Open A Deployed Report?
Greetings,
I have a report that was previously deployed to a reporting services host (running Reporting Services 2005 SP2) and I'm running the version of Visual Studio that came with reporting services on the same reporting serviceshost. The deployed report was never opened on this particular server, so it doesn't appear in the recent files list. Is there a trick to open a deployed report in all of Visual Studio's report editing glory? Visual Studio has a File Open option to open an analysis services database, a project, or a file. A "deployed report" seems to be none of these options since it's an RDL file stored somewhere that IIS can find it. I know that I can use Report Manager and export the RDL for the report and then edit that RDL file in Visual Studio, but doing that appears to disable all of Visual Studio's report editing features (ie it works no better than notepad). What's the trick to get Visual Studio to open the deployed report and allow all of it's editing tools to work properly and then save the updated report back to the reporting services server?

Thanks,
Ron

View Replies !

Can A Report Be Deployed In A Compiled/binary Format?
we're about to plan exactly how we install rs reports on our customers' systems and are wondering if there is more of a binary/compiled format that can be deployed as opposed to the xml source we see in .rdl files?

We keep the lowest form of everything (.dlls, sql scripts etc) in deployment directories and wonder if RS2005's lowest (or most efficient for deployment) form is the .rdl itself. I noticed that Reporting Services (when scripting a report in mgt studio) shows what appears to be the .rdl wrapped in VB but dont really know if that form has to be stored or not on the ReportServer DB in order for RS to work. I couldnt find a ReportServer DB table that had this form but have to believe it is there somewhere if Reporting Services can display it. But maybe a format more geared toward execution is stored along side it?

So if .rdl can be considered "source code" I guess the question is "does it need to be deployed in that form for RS to work or is a more binary like format also available"?

View Replies !

Report Viewer To Get Data From RS Deployed On Separate Network.
Hi,

I am using Reporting Services in the following way. The application implements a three tier Architecture viz Web Server, Application Server and Database Server. Reporting Services 2005 is installed on the Database Server.

The application uses ReportViewer Control which is part of an ASPX page deployed on the Web Server. For ReportViewer Control to fetch data from Reporting Services using RS API, we have to set ReportServerUrl and Report Path. In this scenario, the web server cannot communicate to the database server directly. The web server is in the DMZ and it can only communicate with the Application Server which is in a separate Network.

How can I use Report Viewer Control to fetch data from Reporting Services which is on the Database Server.

Thanks & Regards,

Rajiv

View Replies !

Color Property Works In Preview But Not In Deployed Report
Hi,

I'm having a problem with an IIF statement to set the Color property on a textbox in a matrix report.

If the value is > 0 the Color should be Red

If the value is <=0 then Color should be Blue

In preview in Visual Studio 2005, all textboxes display the correct colours. However, when the report is deployed, all colors are black. It seems to ignore the formatting.

Has anyone encountered similar behaviour and is there a workaround?

View Replies !

Unable To Display Report Header Image When Deployed
Hello All,

I am unable to display report header when I deploy the reports on report server (Internet). However, they look perfect when previewed in the BI studio. Any clue where could be the problem?

Thanks in Advance!

Rashi

View Replies !

Can I Import A Deployed Report Back Into Visual Studio?
I created and deployed a report to my Report Server and everything is functioning fine. However, my laptop was inadvertantly wiped when I was having it serviced and I had not backed up this report to VSS. Is there a way to import that deployed report back in to Visual Studio or do I have to basically rebuild my report from scratch?

View Replies !

Deployed Report Only Showing 2 Inches On Web Page With FireFox
When I deploy a report, and then browse to it with FireFox, I only see 2 inces of the report. I can scroll through the entire report, but only see the 2 inch window's worth at any time.

Its like the html element the report gets put into has a hard coded height, and doesnt auto size to show the eintire report.

It works fine with IE, but we are a FireFox shop.

Anyone know how to fix this?

View Replies !

Parameter Defaults Not Updated When Deploying From BIDS
Hi,

Ever since working with RS I had noticed that deploying reports felt inconsistent and didn't always seem to work, requiring sometimes for me to delete and re-deploy the reports before seeing changes applied. This has the knock on effect of generating new report ID's (GUID's) for the reports and any data in the ExecutionLog table for your reports becomes useless inhibiting effective usage reporting.

I never quite put my finger on exactly what the issue was until recently discovered that "by design" report paramerter defaults are not updated when deploying reports from BIDS. This is because MS envisaged that DBA's or Report Adminstrators would be responsible for changing parameter defaults and prompts once the reports are deployed.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1

I disagree and having discussed this with the product team here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2181673&SiteID=1 it seems a sensible option would be to add a deployment option to the reporting services project definition similar to the OverwriteDataSources option.

I have posted a product feedback report on the Connect site https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299372

Please vote for this to be added to Katmai (RS 2008).

View Replies !

Automatically Open A Default Project On Application Launch
I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches.

Perhaps there's a certain registry key I could edit?

View Replies !

Report Parameter - Suffix A Text To Report Parameter Prompt String

Is it possible to include a text/string as suffix(append to the end of textbox) to an report parameter prompt string ? Something like this

Enter Date: [ Textbox ] format:mm/dd/yyyy

Enter Age:[Textbox ] e.g 50

I need to include text like the one that I have highlighted in blue. Could someone help me out?

View Replies !

Quality Of Deployed Graphs Displays Poorly Using IE In Report Server

Created a graph in VS and then deploy to my Report Server.
When I view in IE the tables display crisply but the graphs are 'choppy'.

When I display them in VS they look great.
How can i improve the quality of the dispalyed graphs.

Thanks

View Replies !

Code!func To Get Values In Header Only Works In IDE And Not Deployed Report (also Worked Ok In RS2000)
I have code

Function GetDealCount(reportItems)

return iif(IsNothing(reportItems!txtDetailCountRows.Value), 0, reportItems!txtDetailCountRows.Value)

End Function

Function GetSumNotionalAmount(reportItems)

return iif(IsNothing(reportItems!txtDealSumNotionalAmount.Value), 0, reportItems!txtDealSumNotionalAmount.Value)

End Function

That I am calling from a textboxes in the page header

= Code.GetDealCount(ReportItems) & " Deal(s)"

also

= Parameters!BaseCurrency.Value + " " + Format(Code.GetSumNotionalAmount(ReportItems),"N2").ToString().Replace(",","'")

When I preview the report in VS.NET I get values showing.

When I deploy the report I just get #Error showing.

Also this report used to work fine in RS2000

Does anyone know the cause of this issue?

View Replies !

Passing A Report Parameter From A Visual C# Form To A Report Parameter
Request is to have a Requirement number from the requirement form generate a report in Reporting Services with the requirement number as a filter.

I can set up the parameter - how does the value get there? Should I be asking this question in the Visual C# group?

Thanks!

Terry B

View Replies !

Download And Create A Report Project From A Report Server
Before I start coding ...

Is there any existing software/trick/hack to create a Report Project from the DataSources and Folders/Reports on a Report Server, i.e. the inverse of Deployment?

Would there be anybody interested in such a thing, and, if not, why not?

View Replies !

Parameters Filtering In Report Server Project Report.
Dear All,

Is it possible to poplulate some control like Dropdownlist (for example, with Product names Or Product Ids) from database table in SSRS project type and then filter report by choosing various choice pre-populated in dropdownlist control.

Project Type is : SQL Server Reportings 2005.

Desired Action: Report will run in browser, User will choose specific product and Run the report(filter) to show that product relate results.

any help,

Thanks,

View Replies !

Query Criteria / Parameter For A Whole Project
I have a large collection of 'projects', i.e., RS reports for each of our customers. Each project is effectivley a library of maybe up to 15 reports. They are usually modified slightly according to the customer's requirements.

Most of the reports use a variery of SQL tables / views and to ensure the customer only sees theor data. I am currently changing the query criteria for each report in the project each time I deply a new library / set. This is time consuming and open to the risk that I mis-key the criteria for one or more report. The criteria is always the customer's account number and is common across most of the database tables. E.g: WHERE (LIVE_INVOICESUMMARY_CRREPONLY.IS_SUCODE = 'DH166'...

Is there any easy way to set this criteria at the project level, rather than at individual report level? Can it be done by getting the SQL query to refer to something in the custom code?

I know I can use parameters, but again, these have to be set per individual report.

I'm on SQL2000

View Replies !

How Can I Report On Entered And Updated Records
My database has many table, each table has a DateEntered (datetime), EnteredBy (nvarchar(50), LastUpdate (datetime), and LastUpdateBy (nvarachar(50). Is there an easy (ha) way to pull a list of the records that were entered and/or updated for a date range. Hopefully without a select for each table.
Maybe a tool someone knows of?

View Replies !

Call Report With Datas Updated
Hello,

View Replies !

Team Project In TFS - SSIS Project Sets Itself As The Startup Project

For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.

I am using Visual Studio 2005 SP1.

View Replies !