Hide Collapse All/Expand All Textbox For Groups When Printing Report
Feb 29, 2008
Hello all,
I have a report with some groups which can all be expanded/collapsed by clicking on a textbox with an action attached to it.
The example I used can be found here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=600583&SiteId=1
But I want to hide the row containing this textbox (or the textbox itself) on the actual printed report.
Is there any report item that can tell me if the report is in preview phase, or can it be solved in any other way?
Kind regards,
Dirk Holland
View 1 Replies
ADVERTISEMENT
Feb 27, 2007
I have a relatively simple problem.
I have a db-query that returns quite a few rows which I must show in a table.
At initial load the report only shows the row group heading for the detailed data, and when clicked the detailed data for a group expands.
My problem is that reporting services assumes that when collapsed it should summarize everything in each column and display it.
Here is an illustration of the problem.
First the detailed view of my data (Notice the 5th and 6th rows which are simply the values in the 1st through 4th rows divided into groups - and the "Total" row shows the actual total for Row 1 Group Header:
[-] "Row 1 Group Header" "Detail data 1" "10" "Detail data 2" "10" "Detail data 3" "4" "Detail data 4" "6" "Row 1 group 1" "20" "Row 1 group 2" "10" "Total" "30"
The detailed view is just as I want it - no problems there.
However, when the detailed view is collapsed, reporting services calculates the sum for the column - which is 90 - not 30 as is the actual total:
[+] "Row 1 Group Header" "90"
Is there any way I can redefine the formula/insert filters used for calculating the "collapsed-total" for each column when the row is collapsed? Or maybe simply prevent it from showing a "collapsed-total" altogether? Or can you think of another way to structure the data so the "collapsed-totals" gives me the actual value (30)?
I thought about splitting the values into a column for each data-group, so that I'd have a column for the "Detail data n" values, a 2nd column for the "Row 1 group n" values and a 3rd column for the "Total" values - this would yield correct "collapsed-total" values. But is really a plan B - I really do not want to do that unless it is the only way out of my dilemma.
View 2 Replies
View Related
Dec 21, 2007
Hi All,
I have a report that is grouping phone calls by "Category" (Outgoing, Incoming, Voicemail, etc). When the report is rendered, each category (along with totals) is shown and the details (each actual call) are hidden. Using toggling, I allow the user to burst open any category to view all of the call details.
I join the query for this report so that even if a category has 0 calls for the day, it is still shown. When expand a category with no calls I get a blank record (as I should, because there are no call details).
The question I have is ... Can I have the toggle be conditional? Can I have the ability to toggle thr group only when there are call details? Can I have the + to the left of the category name not be shown?
Thanks in advance for any help!
Merry Christmas!!!
-Matt
View 5 Replies
View Related
Jun 11, 2007
Hi'
I have a problem with collapsing of groups. It seems that the reports saves the expand/collapse state of groups between renderings ... bug or feature?
In my report I have a dataset which contains some numerical data over time.
The report is designed to show data from a selected month as well as January to selected month.
A parameter is used to select the month.
The presentation looks like the following:
Company total
Department
Employee
Employee
...
Department
Emplyee
...
...
The employees have their initial state set to hidden, with their respective department as toggler.
This works perfectly ... within Visual Studio.
When I deploy this report to my web server strange things happens.
Fx
1) If I expand one department to see the data for the employees for may and then decide to look at data from another month.
2) I change the month parameter and click 'View report' to render the report again.
3) The report renders as it should. All departments are collapsed.
4) If I then expand some other department than before, both the newly selected department and the old one are expanded ... a behavior that is not that practical
It seems that the report saves the expand/collapse state for the groups between renderings. So when I click expand for the second time it expands the one I just clicked and the department which was expanded before rendering.
What to do?
View 3 Replies
View Related
Mar 28, 2007
I posted last year about getting and Expand All/Collapse All link working in reports, and it does work perfectly for on-demand reporting. I was able to get these working using the boolean report parameter and then the Jump to Report option going back to itself changing that parameter.
The issue that I have just discovered is that when a report with these Expand All/Collapse All links are in a report snapshot, clicking those links will cause it to re-render the report from the datasource at the time the link is clicked. This is an issue for one of the datasources we are using because the data is always changing, so when it goes back to re-render the counts and data returned are completely different then they were when the snapshot was first created. As time goes on the data will no longer even be in the datasource since it can only maintain 4 months of data.
Is there another way to get all detail groups to expand/collapse at once that does not require the report to be completely re-rendered from the datasource?
View 1 Replies
View Related
Feb 27, 2007
On one of my reports, the +/- for expand/collapse of groups is reversed -- i.e. when the group is expanded it displays "+" and when the group is collapsed it displays "-". The display of the document map is correct.
Has anyone else had this problem?
thx
Helen
View 9 Replies
View Related
Jul 9, 2015
In my report i have more than 10 sub reports each should be displayed when we click on some label but my requirement is to expand all the sub reports at a time or collapse the sub reports.URL.....problem here is it is a genius solution working beautifully in my local machine but in the client server if i click on the Expand/Collapse radio button it is asking for the parameters again.
View 9 Replies
View Related
Jul 7, 2006
Is there a way to expand/collapse all items in the documentmap ?
I know there is an option DocumentMapCollapsed but this is to collapse/expand the documentmap panel. I would like to control the collapse state of the items into the document map ...
thanks in advane
View 3 Replies
View Related
Dec 6, 2007
has anyone out there found a way to get the best of both recursive hierarchy and drill down in the same report, ie without needing to know how many levels there are in your hierarchy, still being able to report them like a tree view with collapse and expand capability at each level?
View 3 Replies
View Related
Aug 7, 2007
Hi,
How do I programmatically check a row group's Visibility or Expand/Collapse flag in a matrix table? For example, I have a matrix table contains the following groups:
Row groups: Facility --> Category Type --> Category
Column groups --> year, quarter, month
I want to be able to programmatically update the table content if Category rows are not visible (Category Type row group is collapsed).
Thanks.
SouBee
View 3 Replies
View Related
Apr 17, 2008
Hi,
I have 3 textboxes going down.
box1
box2
box3
Is there a way to hide the box2 (with some condition) and shift up the box3 when displaying the result?
like this:
box1
box3
I know how to use the hidden property but it leave a blank space between box1 and box3.
FYI. I'm trying to do this in the PAGE HEADER section.
thank you for your help.
jib
View 4 Replies
View Related
Apr 11, 2008
Hello!
I'm using business objects to show the report Some fields have expression like
=Fields!Customer.Value.Address.Street
but when Address value == null then textbox will show #Error label.
Any ideas how to hide this #Error label, beacause if Customer does not have address I'd rather see empty value than #Error in report
Thanx
View 6 Replies
View Related
Aug 10, 2015
So I have been asked by our sustainability person to create report from our printing data that actually shows the number of pieces of paper used. This is easy enough for single-sided printing, but when printing in duplex the software does not take into account that 3 printing pages actually equates to 2 pieces of paper. I know this sounds simple, but say I have a print job record that looks like this:
Submitted printed total_pages duplex
8/10/2015 8/10/2015 42 1
This is a print jobs that if done correctly is actually 21 pages( duplex printing). If the job is say total_pages =5 I cant just divide by 2 because its actually using 3 pieces of paper ( yes they are wanting this data don't ask why). How can I adjust some sql to accurately depict 5 pages, front and back, as 3 pieces of paper?
View 2 Replies
View Related
May 3, 2007
I have deployed a report that is configured for landscape printing. It does print in landscape, however, only the first seven columns appear on the first page and the other five columns appear on the next page. Is there a method, like in print preview setup in MS Excel, where we can scale down the print (like to 80%) so all columns appear on each page?
Thanks!
View 3 Replies
View Related
Nov 27, 2007
Hi,
On a report I have a textbox. When a user prints the report I don't want the textbox printing. Does anyone know any code which will set the visibility of the textbox to False when printing??
View 1 Replies
View Related
Jun 10, 1999
I have multiple security groups for which I would like to print off the
different table rights associated. Is there a quick and easy way to
accomplish this? Thanks, Craig.
View 1 Replies
View Related
Jan 10, 2008
I have an interesting problem to report that I'm hoping someone will be able to assist in solving.
I have a report that contains a table inside of a list. When I view this report on my local machine via Visual Studio, everything appears normal, the columns are all the correct size. However, as soon as I publish this report to the report server and attempt to view it via Report Manager, one of the columns expands horizontally!
From all of the documentation I have read, I understand that Reporting Services does not provide the ability for columns to expand horizontally, only vertically. Can anyone help explain why this is happening or a possible solution to turn this automatic expanding off?
Many thanks,
canuck81
View 4 Replies
View Related
May 24, 2007
I want to add up the values in a couple of text boxes in another textbox. How do I refer to the textboxes?
fields!textbox1.value doesn't work..what does?
View 1 Replies
View Related
Oct 9, 2007
Hi,
It appears to work fine on my end however on my clients end, whenever they try to print a report that displays perfectly within the report viewer to their printer by selecting the printer button in the report it never ends up printing.., however if they go into printer setup and change the page range to print from all pages to just maybe one page and then select the print button it seems to print fine..
The printer seems to receive the information as the light flashes but no page kick out when all pages is selected to print..
Any help would be greatly appreciated..
View 1 Replies
View Related
Aug 12, 2014
I have a report parameter textbox in my SSRS report which has the parameter properties as "allow null value" and "allow blank value" checked.
How I can ensure that when the value is entered in textbox, it should accept any character ie. The SQL code I should write so that all the characters inputted via the report parameter are accepted.
View 1 Replies
View Related
Mar 6, 2007
Hi All
I have a reporting viewer in a windows form that behaves very strange. When I open the form and run the report it shows up nicely in the report viewer. If I print the report it only prints one page. When i print the report a second time the whole report is printed. Next I'll change the report parameters and run the report, then it shows up nicely in the viewer, but when I print the report the first report is printed.
Does anyone know what to do with this problem?
Thanks in advance
View 9 Replies
View Related
Apr 5, 2007
Hi,
I am having problems printing a new table we added to an existing report. When I preview the report in Visual Studio everything looks good. But when I click the print layout view button the "header" portion of the report shows on one page and the detail shows up on another. Has anyone seen this happen before?
Thanks,
Jon Edwards
View 2 Replies
View Related
Sep 26, 2007
hello there,
i have created a report now i want to have the report print on one page instead of two pages which is doing now.how can i do that.i am using SSRS 2005.
please help
cheers
zolf
View 1 Replies
View Related
Feb 3, 2007
I have a field on a Group Footer which is a Sum field based of an IIF statement.
Here it is.
=Sum(IIF(Fields!EXPR1.Value=2 and Fields!Type.Value=1,Fields!Quantity.Value,0))
If I do not use the AND, by by only checking on one field it works fine and it returns a result, however if I use the AND Operator I get the #Error when previewing the report.
Does anyone have any idea why this is happening. Any suggestion would help/
THanks
View 3 Replies
View Related
Sep 26, 2007
hello there,
i have created a report now i want to have the report print on one page instead of two pages which is doing now.how can i do that.i am using SSRS 2005.
please help
cheers
zolf
View 3 Replies
View Related
Jan 15, 2008
Hi,
I have developed report(SSRS 2005) using Matrix control and Chart, on web in works good, but when user prints the report
it cuts matrix and prints it on separate pages.
my requirement is to print every thing in a single page, no matter how much data i has.
i tried landscape print (by changing width 11 and height to 8.5) but no result,
does any one know the solution....?
thank you...
View 8 Replies
View Related
Sep 12, 2007
I am running SSRS 2005, rendering reports locally using a report viewer. Rather than direct the viewer to an .rdlc file, I use an XMLDocument. A few of my reports have a large image in the background that needs to be invisible when the report prints. This was straightforward - I just use a report parameter and set the visible state of the image to the value of the parameter. The hard part is getting the report to print without an error.
Initially, I render the report with the following code:
Private Sub ShowReport()
Try
With Me.ReportViewer1
.Reset()
.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
.LocalReport.LoadReportDefinition(New System.IO.StringReader(_Doc.OuterXml))
.LocalReport.DataSources.Add(_Item1)
.LocalReport.DataSources.Add(_Item2)
.LocalReport.SetParameters(_Param)
.RefreshReport()
End With
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
This code works fine. I have hidden the print button on the report viewer, and to print, the user must press my button which runs the following code.
Private Sub PrintReport()
Try
_Param(0) = New Microsoft.Reporting.WinForms.ReportParameter("ImageVisible", "False")
ShowReport()
ReportViewer1.PrintDialog()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
Resetting the parameter and re-displaying the report works fine on its own. The PrintDialog method works fine on its own. When combined in the same Sub like this, I get the following error:
"Operation is not valid due to the current state of the object".
Does anyone know how I could get it to print without an error? I would be very grateful for any help.
View 1 Replies
View Related
May 16, 2007
Hi,
I am rendering the report from remote server and I am displaying it. when I try to print the report from my application it is printin properly. but when I try to print it from IIS it is showing an error message that "No printers are Installed ". I did not specify any printer name in my application. How can I resolve this problem.
Thanks
rahul
View 1 Replies
View Related
Feb 28, 2007
Hello
I have a report with pie and bar graphs, I have the paper size 16.54 x 11.69 for landsacpe, there are twelve graphs ,two placed side by side , and in the report manager, the appearence is perfect ,spread over six pages. I have Pagebreakatend True for all the graphs. The problem is with printing, on printing , the are tottaly misaligned,any tips are welcome
Thanks
Inder
View 4 Replies
View Related
May 12, 2008
Hi All,
I would like to control user access to my Report Manager.In detail,I would like to hide some report folders from certain users when they access the Report Manager.Some of the users are not suppose to see certain folders on the report manager,and some users are suppose to see all report folders.
How can I do this?.Where should I include this settings?
View 4 Replies
View Related
Nov 19, 2007
Hello,
I have a report with parameter whice is a multi value parameter.
The problem is that this parameter does not always get a value and when he doest get a value the user gets an error message like:
The "all_names" parameter is missing a value.
Is there a way to hide this error from the user?
I can't check the "allow null value" for this parameter because its a multi value parameter.
Thanks.
View 3 Replies
View Related
Aug 30, 2006
I have a report that is setup to print landscape.
I deploy to Report Manager, print it, and everything works great.
If I create a linked report from the deployed report, the linked report prints portrait.
Does anyone know of a workaround or am I just doing something wrong?
Thanks!!
BobP
View 6 Replies
View Related
Aug 8, 2007
I have a report that only has one page when previewed but when it's printed there are two pages. This is a problem because I get two printed pages to my report with "1 of 2 pages" on the first page and "2 of 2 pages" on the second but there is only data on the first page and the second has header and footer but no data.
Is there a way to force the report to fit everything on one page? Or some other setting I am missing?
Thanks.
View 4 Replies
View Related
