Sybase 9.0.2 + MS Reporting Services 2000 - RS Missing Parameters

Aug 15, 2007

People, help me with this? Already broke my brain.

I have some data on Sybase 9.0.2.3198,
i'm tryin to render report with MSSQL ReportingServices 2000 Eval SP2.


the report designer is fyiReportDesigner 3.0 - and I can do preview with it.

after deployment I'm tryin to render it, RS gives me an error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'Data'. (rsErrorExecutingCommand) Get Online Help
Column '@start_date' not found


I tried connect through ODBC and OLEDB both - same result.


ps I'm gonna kill somebody real soon.


the sql:

WHERE PERIOD.BEGINDATE between CAST(@start_date as timestamp) and CAST(@end_date as timestamp)

these are the RDL-file pieces:

<QueryParameters>
<QueryParameter Name="@start_date">
<Value>=Parameters!start.Value</Value>
</QueryParameter>
<QueryParameter Name="@end_date">
<Value>=Parameters!end.Value</Value>
</QueryParameter>
</QueryParameters>


<ReportParameters>
<ReportParameter Name="start">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2007-08-15</Value>
</Values>
</DefaultValue>
<Nullable>false</Nullable>
<AllowBlank>false</AllowBlank>
<MultiValue>false</MultiValue>
<Prompt>Start</Prompt>
</ReportParameter>
<ReportParameter Name="end">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2007-08-15</Value>
</Values>
</DefaultValue>
<Nullable>false</Nullable>
<AllowBlank>false</AllowBlank>
<MultiValue>false</MultiValue>
<Prompt>End</Prompt>
</ReportParameter>
</ReportParameters>

View 5 Replies


ADVERTISEMENT

Analysis Services 2000 + Reporting Services 2005 + Parameters

Sep 16, 2007



Hi All,

I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?

Regards,
Joseph

View 1 Replies View Related

SQL 2000 Reporting Services - Parameters

Mar 23, 2004

I am trying to figure how to programmatically pass parameters to the report in SQL Reporting Services using web service API and then send this report to the printer. I found code in C# on how to print and it does work very well. I am hoping to add report parameters to this module. Any ideas, samples or help would really be appreciated.


here is the code for printing

using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.Drawing.Printing;
using System.IO;
using System.Web.Services.Protocols;
using PrintReport.reportserver;
using System.Runtime.InteropServices; // For Marshal.Copy

namespace PrintReport
{
/// <summary>
/// A simple console application that demonstrates one way to
/// print Reporting Services reports to a printer.
/// </summary>
class app
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{
PrintExample pe = new PrintExample();
// The name of the printer should be added here;
// this could be a local or network printer.
pe.PrintReport(@"\jacc-fs120S2500 PCL IT");
}
}

class PrintExample
{
ReportingService rs;
private byte[][] m_renderedReport;
private Graphics.EnumerateMetafileProc m_delegate = null;
private MemoryStream m_currentPageStream;
private Metafile m_metafile = null;
int m_numberOfPages;
private int m_currentPrintingPage;
private int m_lastPrintingPage;

public PrintExample()
{
// Create proxy object and authenticate
Console.WriteLine("Authenticating to the Web service...");
rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
}

public byte[][] RenderReport(string reportPath)
{
// Private variables for rendering
string deviceInfo = null;
string format = "IMAGE";
Byte[] firstPage = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
Byte[][] pages = null;

// Build device info based on the start page
deviceInfo =
String.Format(@"<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>", "emf");

//Exectute the report and get page count.
try
{
// Renders the first page of the report and returns streamIDs for
// subsequent pages
firstPage = rs.Render(
reportPath,
format,
null,
deviceInfo,
null,
null,
null,
out encoding,
out mimeType,
out reportHistoryParameters,
out warnings,
out streamIDs);

// The total number of pages of the report is 1 + the streamIDs
m_numberOfPages = streamIDs.Length + 1;
pages = new Byte[m_numberOfPages][];

// The first page was already rendered
pages[0] = firstPage;

for (int pageIndex = 1; pageIndex < m_numberOfPages; pageIndex++)
{
// Build device info based on start page
deviceInfo =
String.Format(@"<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage></DeviceInfo>",
"emf", pageIndex+1);
pages[pageIndex] = rs.Render(
reportPath,
format,
null,
deviceInfo,
null,
null,
null,
out encoding,
out mimeType,
out reportHistoryParameters,
out warnings,
out streamIDs);
}
}

catch (SoapException ex)
{
Console.WriteLine(ex.Detail.InnerXml);
}

catch (Exception ex)
{
Console.WriteLine(ex.Message);
}

finally
{
Console.WriteLine("Number of pages: {0}", pages.Length);
}

return pages;
}


public bool PrintReport(string printerName)
{
this.RenderedReport = this.RenderReport("/SampleReports/Company Sales");
try
{
// Wait for the report to completely render.
if(m_numberOfPages < 1)
return false;
PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = printerName;
PrintDocument pd = new PrintDocument();
m_currentPrintingPage = 1;
m_lastPrintingPage = m_numberOfPages;
pd.PrinterSettings = printerSettings;

// Print report
Console.WriteLine("Printing report...");
pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);
pd.Print();
}

catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
// Clean up goes here.
}

return true;
}

private void pd_PrintPage(object sender, PrintPageEventArgs ev)
{
ev.HasMorePages = false;
if (m_currentPrintingPage <= m_lastPrintingPage && MoveToPage(m_currentPrintingPage))
{
// Draw the page
ReportDrawPage(ev.Graphics);
// If the next page is less than or equal to the last page,
// print another page.
if (++m_currentPrintingPage <= m_lastPrintingPage)
ev.HasMorePages = true;
}
}

// Method to draw the current emf memory stream
private void ReportDrawPage(Graphics g)
{
if(null == m_currentPageStream || 0 == m_currentPageStream.Length || null ==m_metafile)
return;
lock(this)
{
// Set the metafile delegate.
int width = m_metafile.Width;
int height= m_metafile.Height;
m_delegate = new Graphics.EnumerateMetafileProc(MetafileCallback);
// Draw in the rectangle
Point destPoint = new Point(0, 0);
g.EnumerateMetafile(m_metafile,destPoint , m_delegate);
// Clean up
m_delegate = null;
}
}

private bool MoveToPage(Int32 page)
{
// Check to make sure that the current page exists in
// the array list
if(null == this.RenderedReport[m_currentPrintingPage-1])
return false;
// Set current page stream equal to the rendered page
m_currentPageStream = new MemoryStream(this.RenderedReport[m_currentPrintingPage-1]);
// Set its postion to start.
m_currentPageStream.Position = 0;
// Initialize the metafile
if(null != m_metafile)
{
m_metafile.Dispose();
m_metafile = null;
}
// Load the metafile image for this page
m_metafile = new Metafile((Stream)m_currentPageStream);
return true;
}

private bool MetafileCallback(
EmfPlusRecordType recordType,
int flags,
int dataSize,
IntPtr data,
PlayRecordCallback callbackData)
{
byte[] dataArray = null;
// Dance around unmanaged code.
if (data != IntPtr.Zero)
{
// Copy the unmanaged record to a managed byte buffer
// that can be used by PlayRecord.
dataArray = new byte[dataSize];
Marshal.Copy(data, dataArray, 0, dataSize);
}
// play the record.
m_metafile.PlayRecord(recordType, flags, dataSize, dataArray);

return true;
}

public byte[][] RenderedReport
{
get
{
return m_renderedReport;
}
set
{
m_renderedReport = value;
}
}
}
}


Thanks
Tom

View 7 Replies View Related

Reporting Services 2000 / 2005 Parameters

May 29, 2007

Hi all,



Is there any way to pass a dataset parameter in RS 2000? Basicly, I have some data in my web page and want to print it. But I don't want to create another page to pass parameters to RS. I want to print the page as it is with the data already in the page, so if there is a way I can send the data through a dataset to the report directly, would be great. Is there?



Thank you very much,



Marco

View 6 Replies View Related

Multiple Value Parameters In SQL Server 2000 Reporting Services.

Jul 5, 2007

Hi all,

I need to know how, and if, possible to create a multiple value parameter in SQL Server 2000 Reporting Services. I need this for a client of mine. Any help/tips/etc will be greatly appreciated.

Thank you,

View 2 Replies View Related

Hidden Parameters In SQL Server 2000 Reporting Services.

Jun 27, 2007

Hi all,

I am having a problem. I know of hidden parameters in SQL 2005 RS, but I need to have this functionality as well for SQL 2000 RS. I read on the Net that MS SQL 2000 RS Service Pack 1 adds this functionality. I have installed SP4 for SQL 2000, then I installed RS SP1 on my laptop, but I don't see that functionality in VS 2003 Enterprise Architect. I even installed RS SP2 on my other machine, but still no joy. Am I missing something here or is Microsoft lying about this functionality? My client will be upgrading to SQL 2005 sometime in the near future (if they don't change their minds again), but I need to implement this kind of functionality now. I can't wait for them to upgrade to SQL 2005. This parameter I need to hide in the reports is necessary to ensure the reports show data by specific department. I'll implement it in such a way that when they call the report from the web application, I'll pass the departmentID to the report via the query string.

P.S. It is not possible for me to achieve this using JOINs in the queries. The parameter lists themselves depend on this value.

Thanks a lot in advance for this

Ciao,

View 3 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Mar 22, 2008



Hello,

I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?

Any help is appreciated

View 1 Replies View Related

Reporting Services :: Parameter Is Missing A Value

Nov 9, 2008

I have an issue where I need to set a whole bunch of internal parameters' values to the result of a dataset first executed with the report...nothing new or majestic about it.
 
The problem is that the 'First dataset', under some parameter values, return no records..it is empty (which is fine). But this meas that these internal parameters error my report as the 'NEED' a value even though I have specified a default, I still get the 'Paremeter X is missing a value' error. I just want the other datasets, which are reliant on these erroring parameters to either execute with parameter values of 0 or not execute at all. Thus I want the sub datasets to return with blank data in this case or not execute at all.
 
How can I achieve this?

View 10 Replies View Related

Parameters In Reporting Services And Data Source Is Analytical Services

Dec 10, 2007



My requirement for the parameter is multivalue parameter with a text box. for example when user enters aa15 it need to include product aa15. when the user enters aa15, aa16, zz15 than it needs to include all the three products. the last case is when the user enters AA** than i need to inclued all the products start with AA. when i use default multivalue parameter with data source analytical services than i am getting a drop down box. I dont want that. I need a text box where user can enter the value.
1. In sql we have a like key word to query . for example select * from product where product like "AA%".
what is equavalent mdx query to get such results ?
2.How to impliment the multivalue parameters without using dropdown box?

View 1 Replies View Related

Import Specification Missing In Reporting Services

Apr 25, 2007

I am using Reporting Services to create reports on an Access database. I am using the OLEDB provider to connect to the Access 2000 database file. Provider=Microsoft.Jet.OLEDB.4.0. When I try and establish a connection to one of the queries in my database, I get the error message below. I had copied the access database from a previous version in which the Import Specification below was used. The import specification is no longer necessary. How can I get Reporting Services to not look for this text file specification?



TITLE: Microsoft Report Designer
------------------------------

An error occurred while executing the query.
The text file specification 'CEU06_FULL_REG_INFO Import Specification' does not exist. You cannot import, export, or link using the specification.

------------------------------
ADDITIONAL INFORMATION:

The text file specification 'CEU06_FULL_REG_INFO Import Specification' does not exist. You cannot import, export, or link using the specification. (Microsoft JET Database Engine)

------------------------------
BUTTONS:

OK
------------------------------

View 3 Replies View Related

Missing Embedded Images In Reporting Services

May 24, 2007

We currently have reports for a client running on SQL 2000 RS. The strange thing (problem) is that we can see any embedded image in the Report when we Preview it, and view it on our testing server (SQL 2000), but at the client's site (also running SQL 2000) the images don't appear at all. The same goes for any graphs inside the report as well. This is very puzzling as we cannot find out what the problem is. The other strange thing is that we can see the images on the client's site when running them through Report Manager, but when we go through the application using the Reports, then the images do not appear at all. We have no idea of what's wrong. The app is running on 2003 Server x64, the database is being hosted on another server running 2003 Server, and the report server is running on another server running Windows 2000 Server.

Any help will be much appreciated.

View 2 Replies View Related

Reporting Services :: All Underlines For Hyperlinks In All Reports Are Missing

Nov 16, 2010

Recently we upgraded to SSRS-2008 R2 from SSRS-2008 (enterprise edition) and noticed that all the underlines for hyper-links in all reports are missing. Also the font color has reset back to default color (had set to blue to indicate a hyperlink).

Redeployed the same report from VS-2008 SP1 but no luck. Although the formatting (color + underline) looks ok in the preview mode in VS.if there's any workarounds as many end users are getting confued with this change.

View 13 Replies View Related

Reporting Services :: Missing Data In Lync Reports?

Sep 29, 2015

I have deployed Lync 2013 and monitoring which all went through fine. However just one of the monitoring reports (conference join time) shows no data even though there is data within SQL All other reports are fine and all datainformation is displayed. I've tired to publish the reports again but this has not made any difference.

View 3 Replies View Related

Reporting Services :: Report Designer Tool Box Items Missing

Aug 10, 2015

I have a project with SQL sever reports in it. During a test upon returning to the VS 2013 Professional interface, the tool box area still had the previous information displayed and never returned to what should be there for the report design tools.I restarted VS, and the toolbox no longer looked like it did before. Specifically, the datatable tool among others was missing. I was unable to "refresh" the datatable after making changes to it.

I opened other Reports in design mode, and the tools did not show up for those either.The Report Items in the toolbox does contain things like Pointer, Text Box, Line and so forth.

View 4 Replies View Related

Reporting Services :: Missing SSIS Extension In Config Files?

Oct 15, 2010

in order to use an SSIS package as a data source in a report, I need to enable the SSIS extension in the RSReprotDesigner.config and RSReportServer.config files.  That extension is in neither of these files. I have SSIS running on my machine with Reporting Services.

The path to RSReportServer.config: C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportServer

The path to RSReportDesigner.config: C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssemblies

Why is this extension not in either of these files?

The following is an abbreviated list of what's present in the RSReportServer.config file:

<Data>
 <Extension Name="SQL"
 <Extension Name="SQLAZURE"
 <Extension Name="SQLPDW"
 <Extension Name="OLEDB"

[Code] ....

The following is an abbreviated list of what present in the RSReporDesigner.config file:

<Data>
  <Extension Name="SQL"
  <Extension Name="SQLAZURE"
  <Extension Name="SQLPDW"
  <Extension Name="OLEDB"

[Code] ....

I'm running SQL Server 2008 R2

ProductVersion  ProductLevel  Edition 10.50.1600.1  RTM   Enterprise Edition (64-bit)

The operating system is Windows 7 Professional 64 bit.

View 6 Replies View Related

Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services

Dec 6, 2006

I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.

One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:

Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?

Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.

Thanks to anyone who can help.

-- Mark

View 1 Replies View Related

Reporting Services :: Missing Arrow To Navigate Back To Parent Report

Aug 5, 2008

I have a series of drill-through reports from a parent report. While in BIDS I get a blue arrow that allows we to get back to the parent report from the drill-through report.  I do not see this feature available on the RS web interface.  How are users expected to navigate back to the parent report?

View 3 Replies View Related

Reporting Services :: SSRS 2008 R2 - Missing Data When Exporting To Excel Or CSV

Oct 28, 2014

When exporting SSRS 2008 R2 report  to an csv or excel file not all the rows are being exported. The number of rows is less then 500 and it seems to be a pretty straight forward export.

View 3 Replies View Related

Reporting Services :: ReportServer And ReportManager Directories Missing After Installation And Configuration

Aug 24, 2015

I contact you because we installed Report Services 2012 and after configuring werb service URL, database, Report Manager URLs... the URLs linked to the Report server + Report Manager does not work.After searching in IIS, it seems that even if virtual directories are created, they are linked to directories which does not exist :- c:Program FilesMicrosoft SQL ServerMSRS11.ReportReporting Services does contain only LogFiles and RSTempFiles directories.

View 7 Replies View Related

About Reporting Services Parameters On 2nd

Mar 2, 2008



Any body plese tell me How to set the Parameters at the time or report design and how to use that parameter to call report from web application.Suppose i want to display report depend on Prodid(field in table).
And Suppose i want to display report between dates.

Regards.

View 5 Replies View Related

About Parameters In Reporting Services

Mar 4, 2008

I have ony query in my dataset at design time with parameters.
I am getting the correct data when i pass parameters.
Supose,i dont pass any parameters,I need Total data.
Now how can i write other query in my Data set.
Regards

View 4 Replies View Related

SQL Reporting Services Parameters

Dec 13, 2007

Hi Friends,

We are implementing one SQL Server 2005 Reporting services for my client. I want to know, is there any possibilty to keep track the parameters at SQL Reporting sever side, which i am sending it from my UI.

Please help me in this regard.

Thanks,
Rao.

View 3 Replies View Related

Reporting Services :: Data Driven Subscription Button Is Missing - SSRS 2012

Jun 23, 2015

The 'Data Driven Subscription Button' is missing from the Subscription option for any report developed in Microsoft SQL Server 2012 SSDT...

Following version is running on SQL Server : Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)

 Oct 19 2012 13:38:57
 Copyright (c) Microsoft Corporation
 Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

And Report Server Log is saying: resourceutilities!WindowsService_15!a64!06/23/2015-10:05:08:: i INFO: Reporting Services starting SKU: Enterprise

I am having all SSRS roles including Content Manager,  etc..

View 3 Replies View Related

Reporting Services :: Email Option Is Missing In Manage Subscription (SSRS 2012)

Aug 29, 2015

In the Project Web Access (PWA 2010), I have created Report Library which contains .rdl files --> Manage Subscription --> Add Subscription --> Email subscription is missing

Did i missed out some thing but other email functionalities like notifications, Approval workflow are working fine so no issue with SMTP.

View 4 Replies View Related

Reporting Services :: Added Parameter In Report Builder Now Missing Query Results

Oct 30, 2015

So, this is my Query for dataset "SalesOrder":

SELECT
SO_Header.Customer
,SO_Header.Status
,SO_Header.Customer_PO
,Customer.Name
,SO_Header.Order_Taken_By

[Code] ...

I would like to have a parameter on my report to Select by Order_Taken_By. My attempt at that is here:

Dataset called OrderTaken:

select distinct SO_Header.Order_Taken_By
from SO_Header
Under the report Parameter Properties named @Order, under Available Values
Selected "Get Values from a query"

I have DataSet: OrderTaken

Value Field: Order_Taken_By
Label Field: Order_Taken_By

The values of the field Order_Taken_By is all text characters, no integer values.

Running the inital Query by itself yields results. When I add the parameter, I can make a selection, but now I get no results, even though there should be values for the choice I've chosen.

View 11 Replies View Related

Reporting Services :: Installing Report Viewer 2012 Runtime Missing CLR Types

Dec 27, 2012

I have a win.forms application part of functionality of which is to show rdlc report. When I try to launch the application it says that ReportViewer assembly is missing, which was expected. When I downloaded and try to install viewer runtime from here: [URL] .....

I receive that Microsoft SQL Server System CLR Types are not installed and must be installed first. I downloaded appropriate installation from [URL] .... and it installed successfully. But when I try to run viewer runtime installation it still says that Microsoft SQL Server System CLR Types are not installed. What do I miss?

View 7 Replies View Related

Reporting Services :: Missing Tabs And Site Settings Link In Report Manager?

Aug 5, 2010

Installed SQL Server 2008 with Reporting Services to a Windows Server 2008 box.  Tried to open the Report Manager and had no tabs and no Site Settings link - just a blank home page. I am logged onto the server with local administrator rights, so it shouldn't be a permissions issue.

Thinking the installation was bad (IIS was not installed before installing SSRS), I uninstalled and re-installed SSRS after setting up IIS 7 on the server.  Still the same issue - just a blank home page in report manager with no ability to add users or assign roles or see anything except the links for "Home", "My Subscriptions", and "Help".

View 14 Replies View Related

Report Parameters In Reporting Services

Nov 21, 2004

Hi guys & gals

I'm just setting up Reporting Services for our company and it's a great product, no doubt about it. However, I've come across a problem I can't solve and I wonder if any of you can help.

I've produced a sales report and I want my users to be able to enter a list of sales periods to include on the report. For example, the user might want to view the report for periods 10,11,13,14 and 17 and exclude periods 12,15 and 16. Obviously, the underlying query will probably involve an IN() clause but I'm struggling to think of a way that the user might be able to enter these parameters.

The most obvious way might be by typing in a comma separated string, but I don't know how to then put those values into the query.

Anyone got any ideas?

View 1 Replies View Related

MS Reporting Services Date Parameters

Mar 26, 2008

Hi,

Not sure if I will be able to get the answer I need on this forum but hopefully I will!

We have a previous report that uses the code:

AND T1."Decision_Date" BETWEEN '2005-07-01 00:00:00.000' AND '2006-06-30 00:00:00.000' AND T1."Decision_Type_Description"

With this the report was run with the "static" dates, the new report (in MS reporting services) requires that the user be able to enter in the start date range and the end date range.

I have come up with something like:
(T1."Decision_Date" = @Start_Year) AND (T1."Decision_Date" = @End_Year)

But not working. Can anyone assist?

Thanks,

jonathanr

View 1 Replies View Related

SQL Reporting Services Passing Parameters

Aug 25, 2005

I am creating a drill through that will go out and find the correctreport out of 27 that equal my 2 parameters NAME_ID and DETAIL_ID.Does anyone out there have any ideas for me? I can make it conect to 1report. I do not know how to make it search for the correct report

View 1 Replies View Related

Passing Parameters In Reporting Services

Mar 10, 2007

Hi all.
I can pass parameters from my front end(C#.net) to my reports(in Business Intelligence Project).
I want the reverse of it. I want to pass parameter from my report to my windows application project.

Any help would be appreciated.
thanks
-Ron-

View 5 Replies View Related

Its Not Report Parameters (ITS REPORTING SERVICES I THINK)

Jan 5, 2007

i am trying to generate a report based on 3 parameters
age, location, ethnciity

every thing works fine in data and layout tab,
when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time.

i tried executing the query in data tab, it takes less than a sec.

any ideas??

am i doing somethign wrong in parameters??

View 7 Replies View Related

Reporting Services - Variables/Parameters - Is This A Bug?

Jun 3, 2006

When creating a Reporting Services report and declaring local variables as part of your query in a dataset there is sometimes a problem. When you hit run in the Data section and the €œDefine Query Parameters€? box pops up, all the variables are not there. Sometimes when you go to properties (€¦) of that dataset the parameters are gone. Is this a bug? This is happening both in RS2000 and 2005.
Thanks

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved