MS SQL Server :: Parameters && Reporting Model

Report Model Parameters?

Apr 3, 2008

Question.... I don't even know if this is possible.

I work for a Education Service Center that deals with school distrcit data. I have created various report models that work fine for these districts. Is it possible to pass parameters or filter out data in report models...Lets say I have ReportModel1 and this contains all campuses....and if jdoe logs in I only want him to have access to campus1.

This application I have created is in ASP.NET and grants permission at sign on based on their Active Directory memberships to groups. They can see the canned reports via a reportviewer control and I pass parameter values for campuses to filter it out accordingly.

They access report builder via a menu button linked to http://servername/ReportServer/ReportBuilder/ReportBuilder.application
I was wonder if their is code or method of passing a parameter or filter type to accomplish the same here?

I could always create report models for each campus....

ReportModelCampus1
ReportModelCampus2
ReportModelCampus3
....etc....

But this seems rather ridiculous.

Alex Flores

View 2 Replies View Related

How To Use Cascade Parameters With Report Model

Jun 25, 2007

Hi,

I know the use of cascading parameters when you use queries in your dataset.

But could somebody explain to me how to use them when using a reportmodel ?

Vinnie

View 1 Replies View Related

Show Model Parameters In Web Application

Apr 4, 2007

Hi all,

I have a datamining model and i want to show the model parameters on a webpage. The model is a decisiontree. Is there a method i can use to show a formula of the decisiontree on a page or is a visual representation the only solution to visualize the tree?

How can i visualize the tree? Can I use the data mining add-ons for office 2007 to make a tree in visio and afterwards publish the tree on a sharepoint site? If that is possible is the visualization dynamic, if the model changes does the visualization changes too?

The data mining viewers i think, i can't use because there work only with windows forms. Are there other methods to visualize a decision tree on a webpage?

Thanks,

Dennis

View 6 Replies View Related

How To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder

Mar 12, 2007

I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?

View 2 Replies View Related

Report Model Deployment : The Model ID Of The Submitted Model Must Match That Of The

Dec 5, 2005

Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:

View 9 Replies View Related

Connection String For Reporting Model

Apr 11, 2007

Hi,

I've just created a reporting model to use with my reports.

I have deployed the model to my localhost reporting server.

The name of my model is : mod_agentreporting

Can someone give me the right connection string that i have to use ?

Is there any advantage for using reporting models as datasources for reports

or a shared data sources ?

Thanks already in advance for your remarks.

Vincent

View 1 Replies View Related

Reporting Model With Multiple Dimension

Oct 17, 2007

Hi Experts,

I have a analysis service cube conaining 4 dimensions. Is it posible to create a report using Report Model(which I already created) through Report manager? I'm currently using SSRS 2005. Please let me know the procedure?

Thanks & Regards,
Naveen J V

View 1 Replies View Related

Need Help With Reporting Parameters

Mar 20, 2007

I am new to resporting servies. I am using VS2003 with SQL Server 2005. I have a report parameter called TestStep which I populate from a stored procedure. The values are something like Step1, Step2, and so on.

Now I use this parameter to filter the results of another stored procedure to only show results based on the test step. What I would like to do is give the user the ability where if he/she selects 'ALL' in TestStep then I retrieve results for all the test steps.

So far, I have been able to display Step1, Step2 etc. in my TestStep parameters and then use the value selected by the user to filter the results. I would like to display results from all TestSteps in case user selects 'ALL' in the TestStep parameters. How would I add 'ALL' as an option into my TestStep parameter and then use filter only if TestStep is not equal to 'ALL' ? I can't change the stored procedures.

View 2 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

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

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

Parameters From Cube To Reporting Services

Mar 10, 2008

I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in the following scenario:
I have a dimension "Period" as Paremeter.
The Period dimension has a hierarchy as year- quarter- month.
So, I would like to create a drilldown parameter for period as year - quarter - month.

Please let me know, how to acheive this.

thanks,
Naveen.

View 1 Replies View Related

Passing Parameters From ASP.NET To Reporting Services

Aug 30, 2007

I have an asp.net app that is calling a reporting service url. on that url I pass two parameters as query strings. In the Report I defined the query string parameters in the Report Parameters. I then want these two parameters to be passed to the stored procedure in the report. How can I make this happen? The parameters seem to get to the Report but I can't seem to get them mapped to the stored proc. In the data set I defined the stored procs parameters and mapped them to the corresponding Report Parameters but still no go.

I'm assuming there's something fundamental I'm missing here about passing parameters to reporting services.

Thanks

View 1 Replies View Related

Reporting Services :: Same Report Different Parameters

Sep 8, 2015

1 report but different departments run this report with different parameters. Atm I have copied this report for the 4 departments and adjusted the default parameters accordingly (highly inefficient). Isn't there a way to just have one report and that I can adjust the default parameters in code based on user or group ?

View 6 Replies View Related

How To Pass Parameters To IE From SQL Reporting Server

Aug 27, 2007

I will like to configure the Report or the Report server to pass parameters to Inetrnet Explorer when creating the report.
Is there a way to do that ?

View 1 Replies View Related

Power Pivot :: Building A Model Based On Multinational Model With Different Languages?

Oct 19, 2015

I need to develop a language specific dwh, meaning that descriptions of products are available from a SAP system in multiple languages. English is the most important language and that is the standard. But, there are also requirements of countries that wants productdescriptions in their language.

Productnr Productdesc Language
1 product EN
1 produkt DE

One option is to column the descriptions, but that is not very elegantly. I was thinking of using bridge tables to model this but you have to always select a language in a filter (I think)..

I'm thinking of a technical solution, such that when a user logs on, the language is determined and a view determines whether to pick a certain product table specific for a certain language. But then I don't have the opportunity to interchange the different language specific fields in a report (or in my case PowerPivot).

View 2 Replies View Related

Reporting Services Parameters - Alignment. Here's The Problem :

Jan 31, 2007

Can we have more than 2 parameters displayed in a single row on report (when browsed using web browser). The parameters BY DEFAULT - seems to be lined up in an array of 2 columns, and N rows - which gets frustrating because so much of space is left blank (gray space just left of <View Report> button and to the right of parameters line-up).

How can we have more than 2 parameters displayed in one single row ? As this will help the actual report content to take up more space on the screen than the parametes taking up almost 1/2 of the screen.

Thanks a bunch for ideas.

RJ

View 1 Replies View Related

Passing Parameters To A Reporting Service Report

Sep 15, 2007

Hi:

I am new to reporting services and wanted to see if anyone had any experience trying to do this...that "this" is passing a parameter to a report, but having the user fill in some others. I can pass all of my parameters to the report or let the user fill all of them in, but it doesn't seem to let me fill in one and have the users fill in the others.

Does anyone know if this is possible?

View 1 Replies View Related

Reporting Services :: Date Range Parameters Are Off By One Day?

Apr 21, 2015

I have a Start Date and End Date parameter in my SSRS report. The results are off by 1 day. For example if I enter 4/2/2015 and 4/20/2015 it will return a few results from 4/1/2015 to 4/19/2015.

View 4 Replies View Related

Customized Parameters Area For Reporting Services

Oct 23, 2006

Has anyone customized the parameters area to pretty it up and make it more configurable like control number of columns etc?

Or can anyone direct me to a third party component?

Thanks.

View 2 Replies View Related

Reporting Services :: Passing Parameters To MDX Dataset

Oct 1, 2015

I have an MDX data-set query as follows: -

Member [Measures].[Measure3] As [Measures].[Value Rent Period Receipts]
Member [Measures].[Measure4] As (([Measures].[Value Rent Period Receipts]*-1)/[Measures].[Value Rent Period Debit])

Select {[Measures].[Measure1]
,[Measures].[Measure2]
,[Measures].[Measure3]

[Code] ....

There are two parameters; the value of lag passed to the LastPeriods function, and tenancy types passed in the where clause

I have a third parameter I would like to use called FirstDate and this I would like to pass to the LastPeriods function as the second argument

FirstDate is a value from my Time dimension, something like [Time].[Fiscal Time].[Sep. 15]

When editing the query to: -

Member [Measures].[Measure3] As [Measures].[Value Rent Period Receipts]
Member [Measures].[Measure4] As (([Measures].[Value Rent Period Receipts]*-1)/[Measures].[Value Rent Period Debit])
Select {[Measures].[Measure1]
,[Measures].[Measure2]

[Code] ....

The code errors. I have tried all sorts of formats such as LastPeriods(@LagMonths,[@FirstDate]) and LastPeriods(@LagMonths,[Time].[Fiscal Time].[@FirstDate]), but nothing works

View 2 Replies View Related

Reporting Server - Passing Parameters Programtically

Jun 28, 2007

We've developed several reports where you can type in / select variables and run them, affecting their outcomes.

We'd like to change this so if the user clicks on a link from our Intranet, this takes them straight to the report with the appropriate parameter(s) - rather like the "jump to report" function within a report - i.e. the url for that function...

Is this possible?

Steve

View 4 Replies View Related

How To Add Optional Parameters For SQL Reporting Service 2005

Jun 14, 2007

Hi friends,

I am developing reports using SQL Server 2005 Reporting service

I want to pass optional parameters to Report using dropdown

I filled dataset using EmpId and EmpName. and assigned this dataset to

query the values.

I checked properties for Report Parameters of Allow Null, Allow Blank values

Even i checked this properties, it enforces me to Enter some value for dropdown while running or previewing the report

I don't want to enforce the user that value must be selected.

In short, How we can able to pass multiple parameters which are not mandatory.

Pls reply me ASAP

Any suggestion is appreciated

Thanks in Advance.

Regards

Suds

View 9 Replies View Related

Reporting Services :: SSRS Cascading Parameters

Jun 26, 2015

I am using SSRS 2008 with a SQL Server 2008 R2. It's been many years since i have used SSRS but i have used this and some other reporting tools in the past.I have created a cascading parameters where upon selecting 'ALL' or one of the other values in parameter A , the other values gets displayed in paramter B which is working in the Report builder. i am handling this in the dataset query where i handle that through a case statement ( something like WHERE 1 = (CASE WHEN @Prm_A = 'ALL' THEN 1 END) OR column_X= ( CASE WHEN @Prm_A <>'ALL' THEN @Prm_A END ).Also tried WHERE @Prm_A = 'ALL' OR column_X= @Prm_A

This seems to work in the report builder on my machine or when i run it by editing the report on the web, but when i publish it on the report server, i don't see that behavior, meaning it does not cascade. I also tried to simplify it by making the query simple(WHERE column_X= @Prm_A ), but it still would not cascade on the web.

View 2 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

Parameters &&amp; Reporting Model

Parameters && Reporting Model