Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

sql

Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

Report Layout... TextBox Issue

I have two TextBoxes, they are next to each other and they touch.
According to their properties they are the same height, they are also the
same distance from the top.
Preview: they line up perfectly
After Deployment: one appears as though it is a slightly different height
Export To PDF: suddenly they're the same again
Why is this happening and how can I fix it?There are various properties on the text box you can set to specify where
it is located. If they have the same properties, that means they actually
want to be located in the same space. But the HTML viewer will position
them differently because it does not support overlay.
<Height></Height>
<Width></Width>
<Top></Top>
<Left></Left>
--
| Thread-Topic: Report Layout... TextBox Issue
| thread-index: AcS6nZhfn6F0qzGsTYehI9XjssWUhg==| X-WBNR-Posting-Host: 64.86.141.134
| From: "=?Utf-8?B?TUVSNzg=?=" <MER78@.discussions.microsoft.com>
| Subject: Report Layout... TextBox Issue
| Date: Mon, 25 Oct 2004 07:19:10 -0700
| Lines: 10
| Message-ID: <4592BB8A-993A-4A7A-98F1-2690E2E5658E@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33048
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have two TextBoxes, they are next to each other and they touch.
|
| According to their properties they are the same height, they are also the
| same distance from the top.
|
| Preview: they line up perfectly
| After Deployment: one appears as though it is a slightly different height
| Export To PDF: suddenly they're the same again
|
| Why is this happening and how can I fix it?
||||I think I mis-worded my question... I've had endless problems with text boxes
that touch... at least according to their properties they don't overlap... it
looks ok in one format... in another boxes get pushed onto other lines etc...
especially in excel...
I've started using a table for text boxes that touch whenever I can...
though it took me awhile to notice that you can use a table without having it
connected to a data source... if you put all of your stuff in header rows.
""Brad Syputa - MS"" wrote:
> There are various properties on the text box you can set to specify where
> it is located. If they have the same properties, that means they actually
> want to be located in the same space. But the HTML viewer will position
> them differently because it does not support overlay.
> <Height></Height>
> <Width></Width>
> <Top></Top>
> <Left></Left>

Report Layout Width and Height for Landscape on Legal Paper??

I have a very large report that can't squeeze into Landscape on Letter size
paper. I was wondering if anyone knew the dimensions for Landscape on Legal
size paper. Is this possible?
Thanks in Advance.A4 21x29.7
Letter 21.5x27.9
Siew Fai|||Thanks.
"Siew Fai" <siewfai.hoy@.gmail.com> wrote in message
news:1118265794.339658.254270@.z14g2000cwz.googlegroups.com...
> A4 21x29.7
> Letter 21.5x27.9
> Siew Fai
>

Report Layout Troubles

I have created a tabular report that has four columns. Using the ruler at the top of the design page I have placed all columns inside my margins. When I view this report or print it the last column spills over to another page. I have designed this report to have portrait orientation. Is this an issue or am I doing something wrong. Does the ruler at the top signify a location on the page? Any help or ideas is greatly appreciated.
Thanks
-JWTake a look at my blog entry: http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx. It covers logic and physical pagination rules.

Report Layout Troubles

I have created a tabular report that has four columns. Using the ruler at the top of the design page I have placed all columns inside my margins. When I view this report or print it the last column spills over to another page. I have designed this report to have portrait orientation. Is this an issue or am I doing something wrong. Does the ruler at the top signify a location on the page? Any help or ideas is greatly appreciated.
Thanks
-JWTake a look at my blog entry: http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx. It covers logic and physical pagination rules.

Report layout question

win server 2003
sql server 2005

Hi, I need to create a report with the following layout

f1title f2title f3title f4title f5title
+field1 field2 field3 field4 field5
clicking on the + will display
f6title f7title f8title f9title
field6 field7 field8 field9

is this possible?
If it is please describe how.

TIA

this could be done through toggle items:

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

Report layout matrix/dynamic columns...

Hello

Could someone please help me with how I can produce a report. I'm new to Reporting Services and I'm thinking this should be so easy, but it doesn't seem to be. A simplified version of my data is:

Table 1
=======
JobNumber Date Staff
123 01/01/06 5
444 01/03/06 6

Table 2
=======
JobNumber FieldName FieldValue
123 Apples $13.23
123 Deleted False
444 Deleted True
444 Oranges 23

I need to create a report with the following output:

Report
======
JobNumber Date Staff Apples Deleted Oranges
123 01/01/06 5 $13.23 False
444 01/03/06 6 True 23

The FieldNames in Table 2 are variable, any number of new field names could be added and I don't know what they are. I have tried using a matrix, a subreport and I cannot get either to produce the desired result.

Also I have control over the layout of table 2 if that helps. It was originally set up as:

JobNUmber Apples Deleted Oranges
123 $13.23 False Null
444 Null True 23

Thanks in advance.

Maybe you can join the tables together to get something like:

JobNumber FieldName FieldValue

123 Date 01/01/06
123 Staff 5
123 Apples $13.23
123 Deleted False
444 Date 01/03/06
444 Staff 6
444 Deleted True
444 Oranges 23

Then you can use a matrix, grouping by JobNumber on the rows and FieldName on the columns.

-Albert

|||

Cheers Albert. I think I can achieve that, but how do I get my Staff and Date columns into the matrix? If I add them to it then I can't get column headers for these fields? I end up with something like this

Report
======
Apples Deleted Oranges
123 01/01/06 5 $13.23 False
444 01/03/06 6 True 23

Cheers

|||

You need to do something like this:

SELECT JobNumber, FieldName, FieldValue FROM [Table 2]
UNION SELECT JobNumber, 'Date', Date FROM [Table 1]
UNION SELECT JobNumber, 'Staff', Staff FROM [Table 1]

Does that work for you?

-Albert

Report Layout depending on Rendering Format

Can I vary the layout (visibility) depending on the rendering format?
Example: If 'PDF' add a title page, if 'HTML' no title page.
ThanksIs there anybody who could help me on that issue?
"Niklas" wrote:
> Can I vary the layout (visibility) depending on the rendering format?
> Example: If 'PDF' add a title page, if 'HTML' no title page.
> Thanks|||It is not possible to have a title page in one output format, but not in
other output formats.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Niklas" <Niklas@.discussions.microsoft.com> wrote in message
news:BFB7935D-892E-4A66-BBBF-1F39B21C8608@.microsoft.com...
> Is there anybody who could help me on that issue?
> "Niklas" wrote:
> > Can I vary the layout (visibility) depending on the rendering format?
> >
> > Example: If 'PDF' add a title page, if 'HTML' no title page.
> >
> > Thanks

Report Layout after deploy

Hi everybody,

I have problem to creating the report using report server. After report degining as report project, the report appeared proper in the layout . But it doesn't show with proper alignment, After deploy this report in the reporting server . How to rectify this.

Please anybody is in, share with your idea.

Good day

What do you mean by alignment ? Make sure that Reporting Services tries to guess (also in the designer) how you want to data to be displayed in the report, meaning that like in excel numeric values are aligned right and string values are aligned left by default.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Try viewing the report as a PDF - sometimes there are differences in the way it is displayed as a web page and PDF.

The PDF may be closer/the same as the way you designed it.

99

|||

It sounds like you have overlapping report items (rather than e.g. an item being contained within another item).

Overlapping items are only supported in PDF, image rendering, and preview, but not in HTML.

-- Robert

|||

Yes, You are right. The controls are overlapped in my report degin . After rectify this, the report display properly. After that, i m facing another problem for using the subreport. it hasn't display properly. If you have any solution, please provide to me

Thanks

Report Layout - forcing absolute position

Greetings,

I have a report with all of the required data, but am having trouble with the positioning of the elements.

The report has header-like, body and footer-like sections but I am forced [I think] into using only the body section of the report since SSRS won't let me put fields in the header/footer area (msg: fields cannot be used in headers or footers).

btw - my report is always one page... never more. The center section (a table) may change in number of rows, but it will always fit on the page.

So -- easiest way to ask this is: how can I lock the position of a field (or text box) to ensure it will always be in the same spot (acting like a header / footer)?

Thanks in advance.

If you use a table, you could use the table header and footer which would remain consistently in line with the table body of data. It really depends on the details of your needs.|||

I think that since I'm inside the "body" section, it is in a dynamic "flow" mode... so regardless of what I put in the middle, I always want a certain textbox (that has a data field in it) to sit at the absolute bottom of the page...

know what I mean?

|||

Just a note in case some cool MS guys are watching....

This is really a problem when migrating from Foxpro reports to SSRS. This is something you want the public to do (so foxpro can die a happy and content death), but yo uaren't making it easy.

The biggest thing I see so far [after attacking only one complex report] is the inability to make headers / footers use database fields... something that you can do in the dying product called foxpro...

|||

I think I need some more info. Since this is in the footer, I'm not sure why you can't use one of the aggregated (First, Sum, etc.) references to the field. If it isn't aggregated, I don't quite get how it is meaningful in the context of the footer. If the data in the footer is the same for the whole report, you can just setup a parameter that receives the value and then display the parameter value in the footer.

Anyway, more details on the data would help.

|||

In this case, we have a form that gets printed with the same basic "body" data, but different addresses in the [typical] header area, and dynamic "form number", "who's copy", etc in the footer.

So, I have one form that I can feed a dataset that fills ALL of these fields in for the multiple copies.

One might be (variables in red):

Form# 10001
Copy: Original

second copy would be:

Form# 10001b
Copy: File

So even in this simple environment, I might need these two lines at the absolute bottom of the page.... but they can [currently] move based on how many lines end up in the "body" table and change based on which copy's data I send to it.

One option I am considering is to fill the table full with blank lines to ensure correct placement... but that's more of a bandaid untilI figure out the right way to lock a textbox in place.

Hope this helps -- thanks for the consideration....

|||I think you may be able to just stretch down the size of the report in design veiw to be the height of the printable area for the report. Then place the "footer" fields at the bottom. If it doesn't keep your exact placement then you may want to use a Rectangle from the toolbox, and make it the size of the whole printable report. Then place your report objects inside where you want them.

Report Layout

I must be missing something really obvious, but, how can I specify whether a report (.rdlc) if being designed for landscape or portrait paper? It would be nice to have some sort of mark on the guides or the grid to show where the edge of the selected paper type is.

Regards

GrahamI agree on the markers but we couldn't get it in. If you go to the report properties dialog, you will see the page width and height. If your width is more than your height, you will be in landscape, otherwise portrait.|||

Not true (for me).

I have already set those, set the body size to at least 1/2" + smaller, and the L and R margins to .2 each. The report previews in Landscape and prints or PDF's in portrait.

What should I be looking for?

MDM

Report Layout

I must be missing something really obvious, but, how can I specify whether a report (.rdlc) if being designed for landscape or portrait paper? It would be nice to have some sort of mark on the guides or the grid to show where the edge of the selected paper type is.

Regards

Graham
I agree on the markers but we couldn't get it in. If you go to the report properties dialog, you will see the page width and height. If your width is more than your height, you will be in landscape, otherwise portrait.|||

Not true (for me).

I have already set those, set the body size to at least 1/2" + smaller, and the L and R margins to .2 each. The report previews in Landscape and prints or PDF's in portrait.

What should I be looking for?

MDM

Report layout

Hey guys,

I want to create a report called "Report X", which has four reports under it. Assume the following scenario.

1. Report X

1.1. Bar chart report

1.2. Pie chart report

1.3. Matrix report

1.4. Pie chart report

In addition to this, there are about four parameters that should be available for all reports. So my question is: what approach should I follow to implement/design a report for the above requirement. Can anyone give me how to design the report layout.

Any idea is appreciated.

Thank you for your cooperation in advance.

Sincerely,

Amde

You can add the four reports as sub-reports of Report X, and pass in the four parameters from Report X to the sub-reports.|||

Hi Fang,

Thank you for your response. The thing is I don't want to use the sub-reporting concept becuase of the performance issue.And I am looking for if there is alternative way to design the report using data regions insteade of creating sub reports. As you know Data regions provide much of the same functionality and flexibility as subreports, but with better performance.

Sincerlely,

Amde

|||

If you don't want to use subreports, you can just add four dataregions - a bar chart, a pie chart, a matrix and a pie chart, one below the other, to the main report. They can use the same dataset, or you can have multiple datasets in the main report. As for the parameters, just define them on the main report level, and reference them from the individual dataregions.

Can you elaborate a little bit more on the subreport performance issue? Are you concerned with the fact that a separate query needs to be executed for each subreport?

|||

Dear Fang,

Basically, I am not that much concerned on the performance impact that sub reports would bring. I can use sub reports. However, I was just curious to know if there is an alternative way to design the report so that I can select the best one.

By the way, if I add all the four regions in the main report, can I use a list data region to put all of them in the list?

The last but not the least, I want you to provide me your suggestion on which alternative is a good approach and easy to design the report (the sub report or add all data regions in the main report?)

Appreciate your feedback

Sincerely,

Amde

Report Layout

Hi,

When I preview my Reporting Services Report in VS2005 the report uses 2 separate pages. Even when there is very little data on Page 1 it will display something on Page 2.

How do I get all data on the one page?

Thanks.

Hi,

I guess the reason could be that the body of the report exceeds the width of the page. Try reducing the width of the body.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||tried reducing width but no difference|||

Hi,

Could you mention the width of the page and the width of the report body. Also mention the width of the Left and Right margins of the page.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Body:

Size: 16.75cm(w), 11.25cm(h)

Report:

InteractiveSize: 8.5in(w), 15in(h)

PageSize: 21cm, 30cm

Magins: 2.5cm, 2.5cm

|||

Hi,

Ok. So now let us calculate the width of the report.

report body widht = 8.5 in = 21.59 cm.

As I said before, the report width should be less than the width of the page

widht of the page = 16.75 cm

width of the report body = 21.59 cm

Try reducing the width of the report body.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

didn't make a difference.

everything seems fine with the width.

Its the two textboxes located at bottom left of report that appear on the second page.

|||

Got it.

There was a ListView in behind one of the tables. Removed that and it works now.

Thanks for the help!

|||

Its about the height then. I hope you arent using a control that increases the height of the page, there by throwing the boxes onto a different page.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||Ok cool..didn't see your earlier post. Glad you could solve it.

Report Layout

I have 2 tables in Access. I use VB to view a report in Crystal Report.

Table1: StaffMaster

EmpCode
EmpName

Table2: StaffHrs

EmpCode
Rfs
Project
Month_Year
ATH

I wish to display a report in Crystal Report as follows:

EmpCode | EmpName | Rfs | Prject | Month_Year | ATH

How do I accomplish this? Can this be done using crosstab query?

The criteria is for Month_Year. I tried using Crosstab query, but I have problems with the date format. The date should be displayed on the report as mmmm yyyy format. Can it be done using the following query?

"SELECT StaffMaster.EmpCode, StaffMaster.EmpName, StaffHrs.RFS, StaffHrs.Project, StaffHrs.Month_Year, " & _
"StaffHrs.ATH FROM StaffMaster LEFT OUTER JOIN StaffHrs ON StaffMaster.EmpCode=StaffHrs.EmpCode " & _
"WHERE StaffMaster.EmpCode=StaffHrs.EmpCode AND StaffMaster.Discipline='Architecture' AND " & _
"StaffHrs.Month_Year BETWEEN #July 2004# AND #September 2004#"

If so, how will I display the fields in the appropriate places?

ThanksI landed up in the crosstab query, without the date criteria, which I think will give me the result I want. I ignored the date criteria, so that I can retrieve all the records in the StaffMaster table, which is what I want. But one problem is that, the recordset contains all the dates that are there in the StaffHrs table. I would like to find out, if the Month_Year field of the recordset is the same as that I want, and then display it into a field. The Month_Year field is not fixed, as it depends on the user's selection. So it cannot be specified in the code. I know this can be done with formula fields. But how?

This is the crosstab query:

strsql = "TRANSFORM Sum(StaffHrs.ATH) AS SumOfATH " & _
"SELECT StaffMaster.EmpCode, StaffMaster.EmpName, StaffHrs.RFS, StaffHrs.Project " & _
"FROM StaffMaster LEFT JOIN StaffHrs ON StaffMaster.EmpCode = StaffHrs.EmpCode " & _
"Where (([StaffMaster]![Discipline] = 'Architecture')) " & _
"GROUP BY StaffMaster.EmpCode, StaffMaster.EmpName, StaffHrs.RFS, StaffHrs.Project " & _
"ORDER BY StaffMaster.EmpName " & _
"PIVOT StaffHrs.Month_Year"

The Field Count is 18. But this may also vary depending on the Discipline that the user selects.

If, for example, the Discipline is Architecture, then the field count is 18. I did a looping just to see what the fields are. This is the code:

For I = 1 To Report.Database.Tables(1).Fields.Count
K = Report.Database.Tables(1).Fields(I).DatabaseFieldDisplayName
MsgBox K
Next I

The result I got is as follows:

<>
01/01/05
02/01/05
03/01/05
04/01/05
05/01/05
05/01/04
06/01/04
07/01/04
08/01/04
09/01/04
10/01/04
11/01/04
12/01/04
EmpCode
EmpName
Project
RFS

If the result is this, how will I find out the appropriate data for the corresponding date and display it in the corresponding fields? The user needs to view the data for 6 months from the month he selects.

Thanks

Report Layout

I'm working on a report that could potentially require 13 or so datasets in
order to get the specific fields that I need for each section of the report.
The SQL table is structured as follows:
select
year,
branch,
measure,
jan,
feb,
mar
from tblBPM_BP
I was trying to bring all of the measures in on one dataset, but I need to
be able to further filter the data for each section of the report (i.e. Sales
& headcount). Is there a better technique than using a dataset for each
section of the report?What about using filters.
"DJONES" wrote:
> I'm working on a report that could potentially require 13 or so datasets in
> order to get the specific fields that I need for each section of the report.
> The SQL table is structured as follows:
> select
> year,
> branch,
> measure,
> jan,
> feb,
> mar
> from tblBPM_BP
> I was trying to bring all of the measures in on one dataset, but I need to
> be able to further filter the data for each section of the report (i.e. Sales
> & headcount). Is there a better technique than using a dataset for each
> section of the report?
>|||Can I filter out data in a table w/i the report designer?
"Victor" wrote:
> What about using filters.
>
> "DJONES" wrote:
> > I'm working on a report that could potentially require 13 or so datasets in
> > order to get the specific fields that I need for each section of the report.
> > The SQL table is structured as follows:
> >
> > select
> > year,
> > branch,
> > measure,
> > jan,
> > feb,
> > mar
> > from tblBPM_BP
> >
> > I was trying to bring all of the measures in on one dataset, but I need to
> > be able to further filter the data for each section of the report (i.e. Sales
> > & headcount). Is there a better technique than using a dataset for each
> > section of the report?
> >|||Table properties -> Filters
"DJONES" wrote:
> Can I filter out data in a table w/i the report designer?
> "Victor" wrote:
> > What about using filters.
> >
> >
> > "DJONES" wrote:
> >
> > > I'm working on a report that could potentially require 13 or so datasets in
> > > order to get the specific fields that I need for each section of the report.
> > > The SQL table is structured as follows:
> > >
> > > select
> > > year,
> > > branch,
> > > measure,
> > > jan,
> > > feb,
> > > mar
> > > from tblBPM_BP
> > >
> > > I was trying to bring all of the measures in on one dataset, but I need to
> > > be able to further filter the data for each section of the report (i.e. Sales
> > > & headcount). Is there a better technique than using a dataset for each
> > > section of the report?
> > >|||That will do the trick. Thanks!
"Victor" wrote:
> Table properties -> Filters
> "DJONES" wrote:
> > Can I filter out data in a table w/i the report designer?
> >
> > "Victor" wrote:
> >
> > > What about using filters.
> > >
> > >
> > > "DJONES" wrote:
> > >
> > > > I'm working on a report that could potentially require 13 or so datasets in
> > > > order to get the specific fields that I need for each section of the report.
> > > > The SQL table is structured as follows:
> > > >
> > > > select
> > > > year,
> > > > branch,
> > > > measure,
> > > > jan,
> > > > feb,
> > > > mar
> > > > from tblBPM_BP
> > > >
> > > > I was trying to bring all of the measures in on one dataset, but I need to
> > > > be able to further filter the data for each section of the report (i.e. Sales
> > > > & headcount). Is there a better technique than using a dataset for each
> > > > section of the report?
> > > >

Report Layout

I have a page with a List of about 12 fields with text labels.
Something like this:
Label1
Field1
Label2
Field2
Label3
Field3
Label4
Field4
IS there any way to scale this so that if, for example, Label3/Field3 are
empty, I can move Label4/Field up? Right now, it leaves a big blank line in
the report.
Any help on this would be greatly appreciated!
Chris KyleTry adding this in the visibility / hidden property, for each row pair
=IIF(IsNothing(Field!Field1.Value), True, False)
Kaisa M. Lindahl Lervik
"Chris Kye" <pixelboy@.yourdomain.com> wrote in message
news:2239d6e237054d6ea161b45bc23e60aa@.ureader.com...
>I have a page with a List of about 12 fields with text labels.
> Something like this:
> Label1
> Field1
> Label2
> Field2
> Label3
> Field3
> Label4
> Field4
> IS there any way to scale this so that if, for example, Label3/Field3 are
> empty, I can move Label4/Field up? Right now, it leaves a big blank line
> in
> the report.
> Any help on this would be greatly appreciated!
> Chris Kyle

Report in Calendar/schedule layout

Is it possible to produce a report which is displayed as a calendar, similar to outlook?

im using rs2000 with no option of an upgrade to 2005

any help would be appreciated!

Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.

If anyone knows, it is appreciated.

|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||

I am trying to do something similar, but am having a problem.

Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.

For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?

Thanks,

Bob

|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||

I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.

In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.

Hope that helps.

|||

Thanks for the replies.

The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.

Thanks for the ideas, Bob

|||I think you can work around the text split issue with a rectangle in your table cell.|||

Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?

gisinnovations@.gmail.com

Report in Calendar/schedule layout

Is it possible to produce a report which is displayed as a calendar, similar to outlook?

im using rs2000 with no option of an upgrade to 2005

any help would be appreciated!

Unless you don′t use any pre-page which sends the parameters to the reportsserver for rendering the report with the specified paramters, there is no way. You can′t change the parameter collection in SQL Server 2000.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

What about for SQL 2005? I need to display a report that is grouped by date in calendar format with totals appearing in the date boxes. I'm guessing I can figure out a way to do this in a Matrix, but it will be very cumbersome and prone to error I'm guessing.

If anyone knows, it is appreciated.

|||Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running.|||

I am trying to do something similar, but am having a problem.

Time is down the left hand side (the rows), and a room is each column. The problem is when rooms have overlapping times.

For example, room A is scheduled 1:00 - 2:00, and room B is 1:30 - 2:30. How do you avoid a line going through room A at 1:30?

Thanks,

Bob

|||You could try using a 3rd part component such as Dundas Calendar for Reporting Services.|||

I would recommend using the smallest increment of time as your separator. In the case above 30 minutes. In this way, you have the flexibility to have different rooms per half-hour, but you can also have the same room show at 1:00 and 1:30 to cover the 1 - 2 slot.

In this last case, to remove the line between 1:00-1:30 and 1:30-2:00 I am guessing you could use an expression on the BorderStyle for the Top. I haven't looked in detail at this, but I would think you could evaluate if the previous half-hour was occupied for this room and turn off the boundry. I don't know how easy this would be to accomplish, but it is worth looking at.

Hope that helps.

|||

Thanks for the replies.

The "smallest increment" methodology of csi_hugh is actually what I was trying. Using an expression for the borderstyles (top,bottom)does work to make the consecutive cells in the column look like one. The problem I have is that the increments are actually only 5 minutes, and the text for a classroom event can be rather long. The text has to either fit in one actual cell, or be split up programmatically amongst consecutive cells.

Thanks for the ideas, Bob

|||I think you can work around the text split issue with a rectangle in your table cell.|||

Does anyone having an example of one of these reports they have worked out?I tried doing this in a matrix but I am having a lot of trouble.The column grouping is room number and then I have rows for each time interval.I can access only one record per room which means I can only fill in one time interval.Any suggestions?

gisinnovations@.gmail.com