Run Subreport According To Condition.

Jan 18, 2007

Hi all,

in my report, I am using a subreport which takes two parameters and in my main report there is a filed named "ProcessCode".

My problem is that, this subreport should be only run if ProcessCode is 11 oder 29. Otherweise there is no need to run subreport. the column of subreport will be shown as emtpy.

I know, I can return empty string from my stored procedure if the processcode is not 11 or 29, but I would like to learm, is it possible to not render subreport according to condition?

Thanks in advance.

View 6 Replies

Suppressing Subreport Based On Some Condition

Mar 7, 2007

I have one main report which has 5 subreport. i dont want to show all the sub reports all the time. i want to suppress any subreport based on some conditioned. can i do it in case of the SSRS. How?

View 2 Replies View Related

How To Make Subreport Visible Based On Parameter Condition?

Aug 29, 2007

Hi,

I have a subreport added to the main report and I want to make this report visible only when the parameter value is met.

Ex, I have a parameter CustName in the main report and want to show the subreport when the custName = xxxxx. There reports are parameter driven not data driven reports.

Any help is greatly appreciated.

Thanks,
Sirisha

View 3 Replies View Related

Reporting Services :: Report Builder V3 Subreport Data Retrieval Failed For Subreport

Nov 3, 2015

I am trying to create a report with a sub report in Sql Server 2012 using Report Builder Version 3. I can run the subreport without any problems. I read where using a shared connection can cause this error so both the main report and the subreport use a connection that is embedded in my report.

For testing, I created the subreport without a parameter and added it to the main report. When I ran it that way, the report worked and sub report displayed the data. So I know it can read from the database.It seems to only give me this error when I am trying to tie the two reports together using a parameter.

View 2 Replies View Related

Reporting Services :: Hiding Subreport If Parent Report Row Containing Subreport Is A Certain Value

Jul 14, 2015

Using SSRS 2014 and VS2013 rc5.

How do I hide a subreport if the parent report row containing the subreport is a certain value? I am attempting to create a statement with ageing buckets. In the main body of the report I have to display payments and invoices. If the invoice row is blank, I need to hide the row containing the subreport.

First, Is this even possible?
Second, How?

View 10 Replies View Related

How To Suppress A List Containing A Subreport, When The Subreport Returns No Data

Dec 16, 2006

Hi,

I have a report which contains a subreport placed inside a list. when the subreport returns no data. it appears as a blank space in the main report. So i want to suppress the list when the subreport returns no data. Can somebody help me with this?

thanks
shri

View 1 Replies View Related

A Subreport Which Aslo Has Another Subreport In A Master Report

Mar 17, 2008

Can we include a subreport which aslo has another subreport in a master report? (assuming all three reports have parameters too)

Thanks

View 4 Replies View Related

Can I Print The Results Of A Condition Based On The Condition?

Feb 9, 2006

For example..

select * from mytable where MyNum = 7

If this brings back more than 1 row, I want to display a message that says,

Print 'There is more than one row returned'

Else (If only 1 row returned), I don't want to print anything.

Can I do this? Thx!

View 1 Replies View Related

COndition Spli - Error Date Condition

Apr 19, 2007

Dear friends,

I'm having a problem... maybe it's very simple, but with soo many work, right now I can't think well...

I need to filter rows in a dataflow...

I created a condition spli to that... maybe there is a better solution...

And the condition is: Datex != NULL(DT_DATE)

(Some DATE != NULL)

[Eliminar Datex NULL [17090]] Error: The expression "Datex != NULL(DT_DATE)" on "output "Case 1" (17123)" evaluated to NULL, but the "component "Eliminar Datex NULL" (17090)" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row). The expression results must be Boolean for a Conditional Split. A NULL expression result is an error.

What is wrong??

Regards,

Pedro

View 4 Replies View Related

Reporting Services :: SSRS IIF One Condition Or IIF Another Condition

Jun 22, 2015

I am trying to write an visibility function to have message shown based on two different IIF conditions:

If behavior is to Add a customer ( if message =NAME ALREADY EXISTS, return " NAME ALREADY EXISTS", otherwize return " NAME CREATED")If behavior is to Delete a customer (( if message =NAME DOES NOT EXIST, return "NAME DOES NOT EXIST", otherwize return "NAME SUCCESSFULLY DELETED")
I tried the following which doesn't work:
=IIF((UCase(First(Fields!Message.Value, "DataSetName")) = "NAME ALREADY EXISTS"), "WARNING: NAME ALREADY EXIST", "NAME CREATED"),
IIF((UCase(First(Fields!Message.Value, "DataSetName")) = " NAME DOES NOT EXIST"), "WARNING: NAME DOES NOT EXIST", " NAME DELETED")

View 6 Replies View Related

Transact SQL :: How To Add Condition In Where Clause According To Another Condition

Oct 17, 2015

I write a query to get some data as the following. but i need when a user check specified condition a query parameter change to specified condition :

create proc proc_ReservationDetails
(
@status nvarchar(50) = null
)
as
begin
select reservationId, reservationStatus, reservationDesc

[Code] .....

View 3 Replies View Related

An Easy Way To Reference The Nth Row From A Table Meeting A Condition X, And The Mth Row From The Same Table Meeting Condition Y

May 10, 2006

Hi

I am developing a scientific application (demographic forecasting) and have a situation where I need to update a variety of rows, say the ith, jth and kth row that meets a particular condition, say, x.

I also need to adjust rows, say mth and nth that meet condition , say y.

My current solution is laborious and has to be coded for each condition and has been set up below (If you select this entire piece of code it will create 2 databases, each with a table initialised to change the 2nd,4th,8th and 16th rows, with the first database ignoring the condition and with the second applying the change only to rows with 'type1=1' as the condition.)

This is an adequate solution, but if I want to change the second row meeting a second condition, say 'type1=2', I would need to have another WITH...SELECT...INNER JOIN...UPDATE and I'm sure this would be inefficient.

Would there possibly be a way to introduce a rank by type into the table, something like this added column which increments for each type:

ID
Int1
Type1
Ideal Rank by Type

1
1
1
1

2
1
1
2

3
2
1
3

4
3
1
4

5
5
1
5

6
8
2
1

7
13
1
6

8
21
1
7

9
34
1
8

10
55
2
2

11
89
1
9

12
144
1
10

13
233
1
11

14
377
1
12

15
610
1
13

16
987
2
3

17
1597
1
14

18
2584
1
15

19
4181
1
16

20
6765
1
17

The solution would then be a simple update based on an innerjoin reflecting the condition and rank by type...

I hope this posting is clear, albeit long.

Thanks in advance

Greg

PS The code:

USE

master

GO

CREATE DATABASE CertainRowsToChange

GO

USE CertainRowsToChange

GO

CREATE TABLE InitialisedValues

(

InitialisedValuesID int identity(1 ,1) NOT NULL PRIMARY KEY,

Int1 int NOT NULL

)

GO

CREATE PROCEDURE Initialise

AS

BEGIN

INSERT INTO InitialisedValues (Int1 )

SELECT 2

INSERT INTO InitialisedValues (Int1 )

SELECT 4

INSERT INTO InitialisedValues (Int1 )

SELECT 8

INSERT INTO InitialisedValues (Int1 )

SELECT 16

END

GO

EXEC Initialise

/*=======================================================*/

CREATE TABLE AllRows

(

AllRowsID int identity(1 ,1) NOT NULL PRIMARY KEY,

Int1 int NOT NULL

)

GO

CREATE TABLE RowsToChange

(

RowsToChangeID int identity(1 ,1) NOT NULL PRIMARY KEY,

Int1 int NOT NULL

)

GO

CREATE PROCEDURE InitialiseRowsToChange

AS

BEGIN

INSERT INTO RowsToChange (Int1 )

SELECT 2

INSERT INTO RowsToChange (Int1 )

SELECT 4

INSERT INTO RowsToChange (Int1 )

SELECT 8

INSERT INTO RowsToChange (Int1 )

SELECT 16

END

GO

EXEC InitialiseRowsToChange

GO

CREATE PROCEDURE PopulateAllRows

AS

BEGIN

INSERT INTO AllRows (Int1 )

SELECT 1

INSERT INTO AllRows (Int1 )

SELECT 1

INSERT INTO AllRows (Int1 )

SELECT 2

INSERT INTO AllRows (Int1 )

SELECT 3

INSERT INTO AllRows (Int1 )

SELECT 5

INSERT INTO AllRows (Int1 )

SELECT 8

INSERT INTO AllRows (Int1 )

SELECT 13

INSERT INTO AllRows (Int1 )

SELECT 21

INSERT INTO AllRows (Int1 )

SELECT 34

INSERT INTO AllRows (Int1 )

SELECT 55

INSERT INTO AllRows (Int1 )

SELECT 89

INSERT INTO AllRows (Int1 )

SELECT 144

INSERT INTO AllRows (Int1 )

SELECT 233

INSERT INTO AllRows (Int1 )

SELECT 377

INSERT INTO AllRows (Int1 )

SELECT 610

INSERT INTO AllRows (Int1 )

SELECT 987

INSERT INTO AllRows (Int1 )

SELECT 1597

INSERT INTO AllRows (Int1 )

SELECT 2584

INSERT INTO AllRows (Int1 )

SELECT 4181

INSERT INTO AllRows (Int1 )

SELECT 6765

END

GO

EXEC PopulateAllRows

GO

SELECT * FROM AllRows

GO

WITH Temp(OrigID)

AS

(

SELECT OrigID FROM

(SELECT Row_Number() OVER (ORDER BY AllRowsID Asc ) AS RowScore, AllRowsID AS OrigID, Int1 AS OrigValue FROM Allrows) AS FromTable

INNER JOIN

RowsToChange AS ToTable

ON FromTable.RowScore = ToTable.Int1

)

UPDATE AllRows

SET Int1=1000

FROM

Temp as InTable

JOIN Allrows as OutTable

ON Intable.OrigID = OutTable.AllRowsID

GO

SELECT * FROM AllRows

GO

USE

master

GO

CREATE DATABASE ComplexCertainRowsToChange

GO

USE ComplexCertainRowsToChange

GO

CREATE TABLE InitialisedValues

(

InitialisedValuesID int identity(1 ,1) NOT NULL PRIMARY KEY,

Int1 int NOT NULL

)

GO

CREATE PROCEDURE Initialise

AS

BEGIN

INSERT INTO InitialisedValues (Int1 )

SELECT 2

INSERT INTO InitialisedValues (Int1 )

SELECT 4

INSERT INTO InitialisedValues (Int1 )

SELECT 8

INSERT INTO InitialisedValues (Int1 )

SELECT 16

END

GO

EXEC Initialise

/*=======================================================*/

CREATE TABLE AllRows

(

AllRowsID int identity(1 ,1) NOT NULL PRIMARY KEY,

Int1 int NOT NULL,

Type1 int NOT NULL

)

GO

CREATE TABLE RowsToChange

(

RowsToChangeID int identity(1 ,1) NOT NULL PRIMARY KEY,

Int1 int NOT NULL,

Type1 int NOT NULL

)

GO

CREATE PROCEDURE InitialiseRowsToChange

AS

BEGIN

INSERT INTO RowsToChange (Int1,Type1 )

SELECT 2, 1

INSERT INTO RowsToChange (Int1,Type1 )

SELECT 4, 1

INSERT INTO RowsToChange (Int1,Type1 )

SELECT 8, 1

INSERT INTO RowsToChange (Int1,Type1 )

SELECT 16, 1

END

GO

EXEC InitialiseRowsToChange

GO

CREATE PROCEDURE PopulateAllRows

AS

BEGIN

INSERT INTO AllRows (Int1, Type1 )

SELECT 1, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 1, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 2, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 3, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 5, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 8, 2

INSERT INTO AllRows (Int1, Type1 )

SELECT 13, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 21, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 34, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 55, 2

INSERT INTO AllRows (Int1, Type1 )

SELECT 89, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 144, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 233, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 377, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 610, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 987, 2

INSERT INTO AllRows (Int1, Type1 )

SELECT 1597, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 2584, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 4181, 1

INSERT INTO AllRows (Int1, Type1 )

SELECT 6765, 1

END

GO

EXEC PopulateAllRows

GO

SELECT * FROM AllRows

GO

WITH Temp(OrigID)

AS

(

SELECT OrigID FROM

(SELECT Row_Number() OVER (ORDER BY AllRowsID Asc ) AS RowScore, AllRowsID AS OrigID, Int1 AS OrigValue FROM Allrows WHERE Type1=1) AS FromTable

INNER JOIN

RowsToChange AS ToTable

ON FromTable.RowScore = ToTable.Int1

)

UPDATE AllRows

SET Int1=1000

FROM

Temp as InTable

JOIN Allrows as OutTable

ON Intable.OrigID = OutTable.AllRowsID

GO

SELECT * FROM AllRows

GO

View 3 Replies View Related

Subreport Help

Apr 25, 2008

I'm having trouble getting a subreport to work inside a main report.
I keep getting this error upon preview:"A parameter in the subreport 'Summary' has the name @DB. Parameter names must be CLS-Compliant identifiers"

Here's a description of my setup right now.

In my Main Report, I have a Year(String) and CompanyCode(string) Report Parameters, with Available Values that I specified.
Right Clicking the subreport, in the SubReport Properties(still on the main report), I specified the subreport I want to use and on the parameters tab, I have two parameters @DB with the value of =Parameters!CompanyCode.Value, and @Yr with the value of =Parameters!Year.Value

In the Subreport, the Dataset has 2 parameters, @DBName and @Year
On the Layout section, the Report Parameters are the same as the main report.

I do not have a dataset on the main report because it's not needed, I basically only need it to pick between either the Detail and Summary sub-reports to show.

Any help on this would be greatly appreciated, I'm still pretty new to SRS, but I'm learning quickly and have picked up a lot, some things I still struggle with.

Thanks!

View 3 Replies View Related

SubReport

Feb 13, 2007

Hi guys, I am new to Rs2005. I have created 4 seperate reports that each use their own datasource. I want to display these 4 reports as 1 big report. I want a title page followed by a summary page. The summary page must include the 4 reports within its summary, ie...report 1 on page 3, report 2 on page 5 etc..... The page numberering must also match up. Therefore page 1 is the title page and page 2 is the summary. If this is possible, how do i reference the report names within the same report to display on the summary page. Can this be done? I will very much appreciate your help.

View 1 Replies View Related

Columns In Subreport

Dec 20, 2005

SQL Server DB; using Access ADP frontend; i have a report that shows companies; and a subreport that shows all the employees for that company and the committees they serve on.

There is a one to many between Committee and MemberContact

Committee
Marketing
Customer Service
Membership

I would like to display in a subreport info like this
Joe Blow - Marketing, Customer Service
Jane Blow - Membership, Marketing

Which is a concatonation of the fields on the one side of the relationship.
Possible? help appreciated.

View 1 Replies View Related

Subreport In The Table

Oct 4, 2007

Dear All

I have 2 report. one report master and the other is detail report.
i have this record

NetSales 1000
-------------Gross 1200
-------------Discount 200
Contribution 1 800
-------------zzzz 100
-------------yyyy 100

Contribution 1 is Netsales-zzzz-yyyy. in my cube i use customrollupcolum. so that in pivot table this condition is no problem. but in the RS is problem.

so, in RS i use 2 report. one report as master define group1 (NetSales, Contibution 1). and the other report as detail of master report. so i use subreport in the table in master report. but the parameter in the sub report cannot handle value parameter from table (netsales,contibution 1).

how can i do that

thanks

View 2 Replies View Related

Referencing Subreport Value

Nov 16, 2007

Hello,

I need to sum up a sub-report value, but I don't know the syntax to reference the subreport.

How do I reference a subreports value to sum it up?

Thanks,

View 7 Replies View Related

Can I Specify SubReport Name At Runtime?

Aug 4, 2006

I want to combine a bunch of reports (which are stand alone reports on there own) as subreports in a parent or master report. We have done this in Crystal Reprots in order to get a group of reports out in one file.

The issue with Reporting Services is the header and footers of the subreports are not rendered, so I have to repeat the logo information for each subreport in the body of the parent report. I can do this in a table or list or rectangle, but I have to do this for each subreport. Is there any way that I can specify the name of the subreport at runtime? That way I can put everything into a List and drive it from the database. I noticed that the dropdown to select the report name does not allow you to create an expression for this field.

View 3 Replies View Related

How To Get Scrollbar For A Subreport

Jul 31, 2007

Hi,

Can anyone tell me how to get a scrollbar inside a subreport.I'm using SQL Server 2005 Business Int. Solution.I'm having more than 1000 rows for a subreport.I want to fix the width and hieght of the subreport so that i can get a scrollbar in the subreport.Please, help me regarding this.

Thanks,
Saradhi

View 3 Replies View Related

Using A Subreport In A Group

Jun 26, 2007

We have a strange problem. We have a grouping that returns summed values in textboxes (in the group header) and the last column includes a subreport. When we run the report, the textboxes in the group returns the sums, however the subreport displays "No Rows Returned" as that is the parameter value for NoRows. However, we know that there should be some rows in the subreport as when we preview that report using the same parameters, it displays properly.

Just for fun, we created a new group header (using the same grouping level) that included nothing except for that subreport and when we preview the report, it properly shows the subreport values.

What could be wrong here? And thanks for the information.

View 1 Replies View Related

Overlay A Subreport

Mar 3, 2008

I added an action to a date field in a table that jumps to a report. Is there any way to overlay this report over the current window without clearing the screen and showing the report on a new page? That seems extremely UN-windowslike. I can't add it as a subreport and then conditionally make it visible because I'm using the date field as a parameter for the subreport.

Thanks.

View 9 Replies View Related

Bugs In Subreport

Jun 27, 2007

I have a table contain a sub report . when I run on preview (visual studio), no problem . but when I run from my application , the report viewer just show "Report been generated" , never show the report .

after try and error I discover that when the query from main report return no records , plus the table contain a sub report , the problem occur only if you run it from your application using report viewer . not from visual studio . is this a bugs? anyway to resolve this or work around?

thks

View 1 Replies View Related

Subreport Snapshot

Aug 23, 2007

I get an error "Error: Subreport could not be shown." when I set subreport rendering from snapshot. When I render subreport with the most recent data everything works fine.

Does anybody know how to use snapshots for subreport? Thanks in advance.

View 1 Replies View Related

SubReport Issue

Apr 13, 2007

Hello:

I have a subreport in a group footer in a table and when I set the subreport property to hidden the report prints fine however, when I set the subreport property to visible it appears to overlay a portion of the data in the prior rows and it overlays some of the data in the rows that follow the subreport.

Has anyone come across this situation?

An example of my report with and without the subreport follows:

** Example of Report without Subreport **

DIR # ST DIRECTORY NAME PUBCO CLOSE ISSUE

1361 AL BALDWIN COUNTY 0913 03/29/2007 06/01/2007

COPYING SERVICE

1918 2HSC $164.00

2971 2HSC $164.00

MAILING SERVICES

1918 2HS $124.00

2971 2HS $124.00

DIR # ST DIRECTORY NAME PUBCO CLOSE ISSUE

1658 AL MOBILE 0913 03/29/2007 06/01/2007

COPYING SERVICE

1918 2HSC $164.00

2971 2HSC $164.00

MAILING SERVICES

1918 2HS $124.00

2971 2HS $124.00

** Example of Report with Subreport **

DIR # ST DIRECTORY NAME PUBCO CLOSE ISSUE

1361 AL BALDWIN COUNTY 0913 03/29/2007 06/01/2007

COPYING SERVICE

1918 2HSC $164.00

2971 2HSC $164.00

MAILING SERVICES

1918 <----- The subreport appears to overlay the data

2971

** SUBREPORT WILL PRINT HERE AND IT PRINTS AS EXPECTED **

<------ The directory information is overlayed

COPYING SERVICE

1918 <----- The subreport appears to overlay the data.

2971 It continues this way throughout the report.

MAILING SERVICES

1918

2971

View 1 Replies View Related

Subreport Visibility

Apr 17, 2007

i want to display the reportheader and footer of a sub report from master report eventhough there is no data is populated for subreport.

View 1 Replies View Related

NoRows SubReport

Sep 12, 2006

Greetings,

I have a report which contains three subreports. Each subreport is contained within a rectangle in the main report so I can force a page break after each subreport. In each of the subreports, there is a graphic and a text box on one line, then another text box below those two items, then a table below all that. My problem is that if one of the subreports returns no data, it is resulting in a NoRows sort of situation and not even the graphic and the two text boxes are shown. I understand that you can set a NoRows message, but ideally, I want my NoRows message to be the graphic and the two text boxes, not a plain text message.

I'm not sure if this is even possible or at the very least if I could conditionally force a page break in my rectangles based on whether one of the subreports returns a NoRows situation.

Thanks In Advance

View 6 Replies View Related

Scrollbar In Subreport

Apr 29, 2007

Hello,

I'm doing a report with six subreports, I would like to put a scroll bar in the subreports to keep all of them with the same size. Anyone knows if it's possible ?

If someone could give me some tip, it will help me a lot.

Thanks.

Maurício

View 3 Replies View Related

Subreport With A Matrix

Jan 18, 2007

Hello,

I got a report with a landscape format, and inside it i got some subreports, but two of them are subreports with matrixes. Those two subreports are making the page to be printed into 2 pages, but the second page is always empty, is there a bug, a misconfiguration or misusage of the subreport?

Because instead of having 42 pages i will have two times more. How can i avoid this?

Using borders i noticed that it is the subreport that grows much more than when it is generated individually, since individually it fits in one landscape page, as a subreport it needs 1, 5 that makes it 2 pages, and the last one always empty

Thank you

View 5 Replies View Related

SSRS - SubReport DW

Jul 17, 2007

Dear friends,

I'm getting an error when I add a subreport in a main report and using paramters...

The error is:

"Error: The SubReport could not be shown"

In the data tab of subreport I insert the parameter, and in the main report I select the subreport and add the parameter...

Someone knows what's the problem?!
regards!!!

View 5 Replies View Related

Looking For A Subreport Does Anyone Has A Sample

Jan 25, 2007

I am new to reports and worked on few but a single report using 1 stored procedure.

Any sample or webcast.

now i have a requirement creating report within a report(subreport)

first stored procedure will bring few records and now using a id of each row i need to bring there child records(from child table)

is it possible to show master record and then its related child records.

and then number 2 master record and its related child records

Please help thank you very much for the information.

View 3 Replies View Related

Subreport Name Reminder

Nov 29, 2007

Hello !

I'm currently working on a big report project.
There is a main report and about 15 subreports in that main report
There is nothing more than subreports in the main.

Since sub-reports are very similar from one to another, i'm trying to find a way to remind at every page the name of the subreport which is currently displayed.

I've tried two solutions... doesn't work :

A textbox on the main report... but only the name of the main report is available
A textbox on every subreport... but then, the name of the subreport appears only at the end of the subreport, which comes oftently after more than 10 pages.If someone should help for that, i would be grateful.

Rod

PS : don't hesitate to ask details, my english might not be perfect

View 4 Replies View Related

HELP: Alternates From A SubReport

Nov 27, 2007

Hello, I'm sorta new to SSRS and had a question hopefully someone can answer. Right now I'm using a stored procedure in oracle to pass the first set of data to my report. My report is fairly simple in that it is a header a detail row and a footer for totals. There isnt any grouping or sorting of data, it just displays basically exactly what the stored procedure passes it. It's a list of customers and their information. Here is the tricky part where I am having trouble.
One of the columns is for Social Security Numbers(SSNs) and the stored procedure doesnt send the SSN. The SSN is passed from another query that is dependent on the customers ID number. So, as of right now in the details section under the SSN column I put a subreport for the SSNs. Also, some customers have more than one SSN so the subreport creates more rows according to the how many it needs to display all the SSNs. I like this because it doesnt repeat all the customers information for every SSN they have.
But where I work they dont want to have multiple files for every report and just want to keep 1 report with 1 report file. So, how can I accomplish this exact same report without using a subreport?

Hope someone can help me and thanks ahead of time.
-Evan

View 6 Replies View Related

Overlay Subreport

Nov 6, 2007

Is it possible to open a subreport in a window that overlays the main report instead of opening a new window? I don't think I can place it on the main report because I need to pass a different date to the subreport depending on which cell in the main report is clicked to call.

I could make it invisible and use a field to change it, but I haven't found how to pass it different parameters when it's on the same page as the main report.

Thanks.

View 5 Replies View Related