Custom Arrangement Of Parameters In SQL Reporting Services

Oct 9, 2006

Hi,

I have problem with SQL Reporting Services, actually i want display the 3 parameters in a single line in a report i.e. in the while preview of the report and after deploying the report (by default it is showing 2 parameter per line). for example if have 6 parameters i wanted it display it in 2 rows and 3 columns format.

Please can any one help me in this regard.

Thanks

View 5 Replies


ADVERTISEMENT

Reporting Services && Custom Assemblies

Mar 2, 2004

Hi everyone,

I am testing reporting services custom assembly feature, but have problems.

I have referenced my dll, put my class name and instantiated it...

when i try and use a method within my instantiated class, it says "file or assembly name was not found".


Any ideas?

View 2 Replies View Related

Reporting Services Custom Code

Jun 6, 2007

I created a class library which uses a web reference
My SSRS report uses the class through its custom code
I copied the dll & dll.config of the class library to the VS2005 private assembllies and the report works
I copied the dll & dd.config to the reportserver bin and gave the assembly full trust by adding the necessary code group
I even added a code group the give the dll.config file full trust as well
Yet on Repost server, the report does not work
Any ideas
I suspect it is a permission problem

View 4 Replies View Related

Custom Authorization In Reporting Services

Dec 4, 2006

For custom authorization, I am overwriting the CheckAccess method.

But how do I know what I am trying to access in CheckAccess method? I need to know what report the check access method is trying to execute for our requirements.

How do I get that?

View 1 Replies View Related

Custom Authorization In Reporting Services

Oct 3, 2007

I need to implement custom security in reporting services. I have followed the standard example here:

http://technet.microsoft.com/en-us/library/ms160724.aspx



I got authentication to work without too many problems, and it authenticates by querying my custom table. I want to also maintain my authorizations in the same manner. I want to be able to define in my own tables that user test1 has permission to view reports 1, 3, 5, and 8. User test2 can view reports 1,3,5,8, and 9. User test3 can view 1, 2, and 4. Etc.

The authorization extension, contained in my version of Authorization.cs is where I expected to be able to do this. I wanted to be able to write code that queries my own tables and says, "does this user have permission to view this item?" Getting the this user portion is easy as is obvious in the many checkAccess methods. But being able to tell what item I am currently dealing with has proved impossible from the context of Authorization.cs, which implements IAuthorizationExtension. Knowing what type of item I am dealing with is obvious, but I need to know something that uniquely identifies the exact item I am dealing with.

How can I determine in checkAccess or any of the other available methods what "thing" they are looking at? What can I examine to determine that for instance this particular authorization request is against "Report 1"? It seems that if I was allowed to completely override Authentication to use my tables, I should be able to override Authorization to do the same. Is this possible or am I missing something?


Can anyone help? Thanks.

View 2 Replies View Related

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

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

Reporting Services :: SSRS Custom Code

Apr 24, 2015

Can we call custom code in parent report, which written in the subreport.

View 5 Replies View Related

Need Help Regarding Custom Colors For Charts In Reporting Services

May 30, 2007

I need some help regarding Custom Colors implementation for Charts in the Reporting Services.



What we are trying to do is to make every color for every Series(see example below) to be a customized Corporate color.



For example each of the series on the Chart should be in specific Custom Color:

Series 1 - "LightBlue"
Series 2 - "LightYellow"

Series 3 - "DarkBrown"



All I found from MSDN is how to do it in the Chart Properties in a Code section (right click on the report outside the chart -> Properties -> Code tab -> paste the Custom Code ).



And then to use it in the Chart color definition as:


Code Snippet=Code.GetColor( Series# )











But we are trying to do it in a separate C# class that would be updated only in one place, instead of changing 30 reports each time something is changed. So that it could be generic.





The C# class:






Code Snippet

namespace CustomColorPalette

{

public class CustomPalette

{

public CustomPalette()

{

}



public static string GetColor(string GroupingValue)

{

int groupingValue = int.Parse(GroupingValue);

string[] colorPalette = {"Green", "Blue", "Red"};

if (groupingValue < colorPalette.Length)

{

return colorPalette.GetValue(groupingValue).ToString();

}

else

{

return "Black"; // if # of Series is more than defined - all undefined will be = Black color

}

}



}

}









I tried 2 different ways:





1.



Then I put a code into a Custom Code section of a report:






Code Snippet

Public Function GetColor(SeriesNumber as String)

Return CustomColorPalette.CustomPalette.GetColor(SeriesNumber)

End Function







And in the Chart Custom Color settings I put:




Code Snippet=Code.GetColor( Fields!SeriesNumber.Value )





And after compilation I get an error:



Error 303 [rsCompilerErrorInCode] There is an error on line 2 of custom code: [BC30451] Name 'CustomColorPalette' is not declared. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0










2.



Second way I tried:





Then I put a code into a Custom Code section of a report:






Code Snippet

Dim X As CustomColorPalette.CustomPalette

Protected Overrides Sub OnInit()

X = new CustomColorPalette.CustomPalette()

End Sub









And in the Chart Custom Color I put:




Code Snippet=Code.X.GetColor( Fields!SeriesNumber.Value )







And after compilation I am getting an error like this:

Error 302 [rsCompilerErrorInExpression] The BackgroundColor expression for the chart €˜chart2€™ contains an error: [BC30456] 'X' is not a member of 'ReportExprHostImpl.CustomCodeProxy'. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0



Is there any workaround? Or all I can do is to make the Custom Colors manually in each report, and if something need to be changed - I will need to change it in each report separately





Thanks,

Alex

View 5 Replies View Related

RS 2005 - Reporting Services - Custom Code Box

Aug 30, 2007

Does anyone know if this box will accept VB.Net code or just VB code (old style) .... nothing indicated within the applicaiton IDE ....

Thanks ...

View 1 Replies View Related

Reporting Services :: How To Set Custom Variables In Report Builder 3.0

Oct 19, 2011

i am using Microsoft Sql Server 2008 Report buider 3.0. and i generated report and that report how to use custom variables.

View 2 Replies View Related

Reporting Services :: Custom Shapes In SSRS Report

Aug 20, 2015

I have an application that will ask a user about faults in a car. The info is stored in a database.

I want to create a report that will have a 'picture' of a car, as in the below; and will be highlighted depending on which part is faulty.

For example, if the bonnet is faulty, then it must be highlighted in a specific color.

View 5 Replies View Related

Reporting Services :: How To Add Custom DLL In SSRS Report 2010

Jun 17, 2015

I am working on SSRS report with project server 2013 and I want to add custom dll in  SSRS report.I have create dll first then add into GAC Assembly After that i have add this dll in report project in SSRS.when i have try to deploy and build report...

.An error Occurred during local report processing.

Failed to load expression host assembly.

Details : Cannot Perform CAS Asserts in Security Transparent methods.

View 6 Replies View Related

Displaying Custom Error Messages In Reporting Services

Nov 12, 2007

Hi all,
We are displaying an SQL Server 2005 Reporting Services report in our ASP.NET 1.1 application by accessing the report through URL and embedding the same in an iframe HTML web control. The user can export the report contents into CSV format by making use of the export functionality provided by Reporting Services.
Now we have been asked to display a warning mesage to the user when the no. of records in the report exceeds 1 million i.e. if the no. of records in the report exceeds 1 million and the user tries to export the report to CSV format by clicking on the "Exprot" link button, we need to display a warning message to the user.
My doubt is whether this can be done in Reporting Services. Are there any programmatic interfaces exposed by Reporting Services which might help us implement this requirement ?

Thanks,
CodeKracker.

View 4 Replies View Related

Reporting Services :: How To Write Custom Legend Text

Oct 23, 2015

I was trying to write a custom legend text for a chart that I have in SSRS. In the chart I have a Bar chart and a Line chart. I have two values coming from a dataset. One is a running value. All the series values are from year dataset.

I need to get a custom legend text for the three data series looking like this. "2013- Mth", "2014-Mth". Year should be dynamic and coming from the dataset.

I tried writing an expression in the series legend option as shown below.

But I don't get the required text for the chart. I only get the default series text for the legend. If I only write a text without the dynamic year taken from the dataset columns I get the custom text. But not when I concatenate the dynamic year series with the static text. Any property to enable/disable?

View 2 Replies View Related

Reporting Services :: Custom Sort Column Groups

Jun 3, 2015

Is it possible to do custom sort for a Column Group?

i.e. if the columns are coming out as A   B  C, is it possible to change it B   C   A  (or anything else). 

View 5 Replies View Related

AnyOne Has Implemented Custom Subscriptions Of Reports(Reporting Services 05) ?

Dec 28, 2007

Any One has implemented Custom Subscriptions of Reports(Reporting Services 05)

View 4 Replies View Related

Reporting Services :: Using Custom Code To Create A Heatmap?

May 21, 2015

Below is code I am using to create a heatmap in SSRS. THe code seems to be working well except for one glitch. Sometimes numbers in the "middle of the pack" are white. Obviously they should be one the of colors listed below. Why numbers would be white when I declared only white for IsNothing. 

  Public Function GetHeatmapColor(ByVal textBoxValue, ByVal minDataSetValue, ByVal maxDataSetValue) As String
        Dim colours As String() = New String() {"White","DarkGreen","Green","ForestGreen","LimeGreen","YellowGreen","Yellow","Gold","Orange","DarkOrange","OrangeRed","Red"}
                If IsNothing(textBoxValue) = True Then
            Return colours(0)

[Code] ....

View 6 Replies View Related

Reporting Services :: Add Two Different Custom Calculated Fields From Two Different Datasets In Matrix

May 22, 2015

I am not sure if this is possible or not, we have two datasets and each one has an additional calculated field which breaks the value JobBilledExVAT into three years.

So it reports for example how much we billed in May 2015, 2014 and 2013.

I have got the table to display this when reporting on one dataset by grouping by year

The datasets both look similar to this 

SELECT
  Practice.ibvSalesByJob.JobBilledExVAT
  ,Practice.ibvSalesByJob.[Year]
FROM
  Practice.ibvSalesByJob
  INNER JOIN Practice.idvJobType

[Code] ...

The calculated field is 

=Switch(Fields!Year.Value = Parameters!Year.Value ,"15", Fields!Year.Value = Parameters!Pre1Year.Value ,"14", Fields!Year.Value = Parameters!Pre2Year.Value ,"13")
The field I am looking to add together is below
=Sum(Fields!JobBilledExVAT.Value)

If I do the below on the dataset associated with the matrix it displays the sum for each year correctly, I would however like to add the Sum(Fields!JobBilledExVAT.Value) from a different dataset (ABS1M) for the relevant year.

I tried this

=Sum(Fields!JobBilledExVAT.Value) + Sum(Fields!JobBilledExVAT.Value, "ABS1M")

However this adds 2015, 14 and 13 from ABS1M and doesn't add them individually if that makes sense? With the calculated field it only shows Year under the main dataset heading not 15, 14 and 13 separately.

I was think of using LOOKUP however I don't know how this would work as 15, 14 and 13 are not displayed under the dataset.

View 5 Replies View Related

Can We Use Java Script Coding Into The Custom Code Of SQL Reporting Services?

Jan 19, 2007





Is Custom code of Sql Reporting services will only support VB Coding? Can't we use Java Script coding into the custom code of SQL Reporting services?

View 3 Replies View Related

Reporting Services :: Unrecognized Identifier Error In Custom Code?

Sep 11, 2013

I've made a Report porting from SS2008 to SS2008.

In a textbox I use a:

Number -> Custom Format

like these:

=Code.FormatString(Fields!NumDecRpt.Value)

but gives me the "Unrecognized identifier" red squiggle.

My FormatString function (in the rdl file) is this:

Public Shared Function FormatString(ByVal Decimals as object) As String
  dim format = "N0"
  if not (Decimals is nothing or Decimals is System.DBNull.Value) then
    dim decs as integer
    decs = Convert.ToInt32(Decimals)
    if decs>0 then
      format = "N"+decs.ToString()
    end if
  end if
  return format
End Function

What's wrong with this?

View 11 Replies View Related

Reporting Services Custom Authentication And Web Reportviewer - Familiar Question

Feb 20, 2007

This is a subject that has been brought up before but I have not seen a definitive answer/solution.
We have implemented a custom authentication extension (forms authentication) for reporting services and it has been working just fine under "normal" conditions; "normal" being users logging in, viewing reports, and then moving on.
Recently some reports were created by our report group and they contain Dundas gauge controls for "dashboard" style reports. These reports are meant to be up all day and they post back every few seconds because the data they present is mission critical.
This of course exposed the inability of the reportviewer control to stay in the context of Report Manager when it comes to the cookie exchange and authentication thus resulting in the following error:
<html><head><title>Object moved</title></head><body>
<h2>Object
moved to <a
href="/ReportServer/logon.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>

I created a quick ASP.NET web application and added the reportviewer to it, implemented IReportServerCredentials and the report came up as expected but behaved the same way as it did in Report Manager. Same with a Windows Forms application.

Increasing the cookie timeout in the forms authentication tag is an option, but not an attractive one. Extending the reportviewer control is also an option, but I don't know if that is a good candidate right now because I don't see anything extensible yet.

Is this just the nature of RS with custom authentication or is there a viable solution out there right now?

Any and all answers are much appreciated and I thank you in advance.

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

Is The Custom Report Item Sample Still Included In SQL Reporting Services 2005?

Dec 27, 2006

Here:
http://msdn2.microsoft.com/en-us/library/ms160911.aspx

I read that this sample is included, however when I install the samples the other three are in the "Extension Samples" directory but the "Custom Report Item Sample" is missing. Can anybody please tell me where I can find it?

Thank you!

View 4 Replies View Related

Reporting Services :: Setting Data From Custom Library Not Working In SSRS

Sep 22, 2015

I have a SSRS report that uses a custom library. The custom library returns a string values, and I have tested this with a windows application.In the SSRS report. I have set the expression value for a text box as  =CodeReportingLibrary.CodeReportingFunctions.GetImage(1232)

However, when i preview the report the text box value shows as #ERROR. I checked the error list and I get a warning message : Warning 1 [rsRuntime ErrorIn Expression] The Value expression for the textrun ‘Textbox5.Paragraphs[0].TextRuns[0]’ contains an error: Attempt by security transparent method 'CodeReportingLibrary.CodeReportingFunctions.GetReferenceImage(Int32)' to access security critical method 'Microsoft. TeamFoundation. Client. TfsTeamProjectCollection..ctor(System.Uri)' failed.  Assembly 'CodeReportingLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' is partially trusted, which causes the CLR to make it entirely security transparent regardless of any transparency annotations in the assembly itself.  In order to access security critical code, this assembly must be fully trusted.

I have updated the rssrvpolicy.config in ReportServer folder, to include my custom dll.

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="CoDeMagSample"
Description="CoDe Magazine Sample. ">

[code]....

View 4 Replies View Related

Reporting Services :: Custom Code Throws Error With Email Subscription

Apr 20, 2015

I have a SSRS report that parses RTF to TXT and displays it in a report.  The report works fine and everything displays correctly.  The subscription email, however, contains a report with errors: Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture= neutral,PublicKeyToken=b77a5c561934e089' failed.The report contains embedded code as well as references to System.Security and System. Windows. Forms.  I've updated .....Reporting ServicesReportServer ssrvpolicy.config and ....Reporting ServicesReportManager smgrpolicy.config to change permissions to FullTrust.

View 2 Replies View Related

Reporting Services :: How To Get Custom File Name In Manually Generated SSRS Report

Jul 9, 2013

I am creating a SSRS report which would be executed by User manually through ReportServer URL.User would be generating the SSRS report for different Customer ID based on ad-hoc basis.

I am passing CustomerID as input parameter to the report. Is there any way to get the manually generated SSRS report name as 'Report_CustomerID_TodayDate.xls'.

E.g.If User is generating report for Customer ID 123 today then report name should be 'Report_123_07092013.xls'

View 2 Replies View Related

Reporting Services :: SSRS Custom Start Date Subscription Parameter

Jun 3, 2015

Is it possible to have a custom start date parameter on a report? I would like to have a cumulative daily report for the week, Friday to Thursday. The final daily to run on the Friday, then the next week begins.  I have a enddate, which is today()-1 (for previous day); I need a start date to be variable.

In other words,

On a Monday, report pulls data from last Friday to Sunday;
On a Tuseday, report pulls data from last Friday to Monday,
On a Wednesday, report pulls data from Friday to Tuesday, etc,
until on Friday, the report pulls data from last Friday to Thursday.

View 4 Replies View Related

Reporting Services :: SSRS Custom Data Processing Extension Error

May 5, 2015

I am using Custom Data Processing Extension to call a stored procedure. Iam getting following error when creating a dataset in report designer using the extension. I wrote the code in c#.

could not update a list of fields for the query. verify that you can connect to the data source and that your query syntax is correct.(Details-Object reference not set to an instance of an object.)

Here is my code

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;

[Code] .....

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







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