Report parameter multivalue

In the report parameter page, there is no way for me to set multivalue. But
report parameter has this property. So what is the usage and how can I set
it ?The MultiValue element is part of the RDL specification published in
2003/10. It was not implemented in V1 of Reporting Services. It will be
available in the next version. The MultiValue boolean flag determines if a
report parameter is a multi value parameter.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:525591E1-6383-4EBD-A37D-74E61BBA29A5@.microsoft.com...
> In the report parameter page, there is no way for me to set multivalue.
But
> report parameter has this property. So what is the usage and how can I
set
> it ?|||Thanks !!!
"Robert Bruckner [MSFT]" wrote:
> The MultiValue element is part of the RDL specification published in
> 2003/10. It was not implemented in V1 of Reporting Services. It will be
> available in the next version. The MultiValue boolean flag determines if a
> report parameter is a multi value parameter.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:525591E1-6383-4EBD-A37D-74E61BBA29A5@.microsoft.com...
> > In the report parameter page, there is no way for me to set multivalue.
> But
> > report parameter has this property. So what is the usage and how can I
> set
> > it ?
>
>

Report Pagination

When you view the report in Report Manager it shows that it is Page 1 of 1
but when I export it to PDF it actually has 437 pages. Which is fine...no
probs there but would like to know the reason that it says Page 1 of 1 rather
than the 437.
Any help would be greatly appreacited on this, as its baffling me.Hi Nat,
Reports can appear different when rendered in different formats. For
example, your report is displayed using HTML in Report Designer preview
mode versus PDF when exported. So it is this formatting in HTML that
can cause the page number issue you describe (HTML has no concept of
page numbers - the whole report is '1' page...)
Maybe these suggestions can help?
1) When you preview a report in report designer, you can press the
<print preview> button (<print layout> in RS2005 if I recall...) on the
preview pane toolbar to display the report with pages (as it would
print out). At least you'll know how many pages the report truly has
this way.
2) If your report has hard page breaks set, you'll see the pages
displayed in preview window automatically.
HTH
Matt A
Reporting Services Newsletter at www.reportarchitex.com
Nat Johnson wrote:
> When you view the report in Report Manager it shows that it is Page 1 of 1
> but when I export it to PDF it actually has 437 pages. Which is fine...no
> probs there but would like to know the reason that it says Page 1 of 1 rather
> than the 437.
> Any help would be greatly appreacited on this, as its baffling me.

Report Page Width with Dynamic columns through parameters

I found the following paragraph while searching on here:

************************************************************************
You could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.
************************************************************************

That is exactly my problem. I have lots of dynamic columns which causes the width of the report to be wide. Thus even though at run time the report only shows columns within a page, the report itself consists of a lot of white spaces after the selected columns. Does anyone know a solution to this? If not, I guess creating the rdl with code manually is the only way? Please advise. Thanks in advance.

- Will

I summarize your requirement that I have understood and based on that I given you my comment if my understanding is wrong then let me know.

Your requirement is to design a report in which columns are visible on some condition or dynamically. You have design the report and set the column property visible = ‘TRUE’ OR FALSE based on the condition. Let assume the problem is that when col1 is visible that time col2 is invisible due to this a white space is left in place of col2 and you want to remove that white space.

My comment:

Take the above scenario if col1 is visible and col2 is invisible and vice a versa then place the col2 over col1 so then col2 is visible then col1 will be invisible and if the col1 is visible then col2 is invisible. And you will not see any white pace in the report.

|||Hi mverma,

First let me thank you for replying to me. Let me clarify my requirements just to make sure what you are proposing would solve my problem.

I have a report, which at design time, would span 2 physical pages (17 inches), with each column being the same width.
Now, the columns' visibility is toggled by parameters passed to the report page during run time.

Now the problem.
Lets say for one of the report we pass in parameters to toggle on columns 1,3,5,7, so the total width would be 8.5 inches, which would fit exactly on one page. So when choosing to print, it would print one page with the 4 columns (with no spaces between the columns), and one blank page. The blank page is printed because, during design time, the report is set to be 17 inches wide, thus even only 8.5 inches of the report contains columns, the whole 17 inches are still printed.

You solution seems to solve the problem of white spaces in between columns that are visible and invisible, but my problem is that though all the columns are neatly next to each other, spaces are still accounted for the invisible columns are at the end of the table.

Now, if I misunderstood your solution and it actually does solve my problem, could you please provide more details or a link as to how to "stack" one column on top of another during runtime. Nevertheless, thanks again for your reply.

- Will

|||

I have another option suppose according to the passing parameter report generate value for 1,3,5,7 etc and for next parameter value it will generate report based on 2,4,6,8. Then you can take two table one is design for 1,3,5,7 and next one is designed used by 2,4,6,8 column when parameter passed for 1,3,5,7 then set visibile='true' for this table and set visibile= 'false' for another table that we don't want. Place table one over other so that you need not to worry about the white space.

Does this help you to achive your requirment ?

Regards

Manoj Verma.

|||Hi Manoj Verma,

Thanks for replying. I do not think your suggestion would work because my example was a watered downed one. Our actual need is a 40 columns dynamic report, where users can choose any of the 40 columns. Thanks again for your input.

- Will

Report Page Width with Dynamic columns through parameters

I found the following paragraph while searching on here:

************************************************************************
You could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.
************************************************************************

That is exactly my problem. I have lots of dynamic columns which causes the width of the report to be wide. Thus even though at run time the report only shows columns within a page, the report itself consists of a lot of white spaces after the selected columns. Does anyone know a solution to this? If not, I guess creating the rdl with code manually is the only way? Please advise. Thanks in advance.

- Will

I summarize your requirement that I have understood and based on that I given you my comment if my understanding is wrong then let me know.

Your requirement is to design a report in which columns are visible on some condition or dynamically. You have design the report and set the column property visible = ‘TRUE’ OR FALSE based on the condition. Let assume the problem is that when col1 is visible that time col2 is invisible due to this a white space is left in place of col2 and you want to remove that white space.

My comment:

Take the above scenario if col1 is visible and col2 is invisible and vice a versa then place the col2 over col1 so then col2 is visible then col1 will be invisible and if the col1 is visible then col2 is invisible. And you will not see any white pace in the report.

|||Hi mverma,

First let me thank you for replying to me. Let me clarify my requirements just to make sure what you are proposing would solve my problem.

I have a report, which at design time, would span 2 physical pages (17 inches), with each column being the same width.
Now, the columns' visibility is toggled by parameters passed to the report page during run time.

Now the problem.
Lets say for one of the report we pass in parameters to toggle on columns 1,3,5,7, so the total width would be 8.5 inches, which would fit exactly on one page. So when choosing to print, it would print one page with the 4 columns (with no spaces between the columns), and one blank page. The blank page is printed because, during design time, the report is set to be 17 inches wide, thus even only 8.5 inches of the report contains columns, the whole 17 inches are still printed.

You solution seems to solve the problem of white spaces in between columns that are visible and invisible, but my problem is that though all the columns are neatly next to each other, spaces are still accounted for the invisible columns are at the end of the table.

Now, if I misunderstood your solution and it actually does solve my problem, could you please provide more details or a link as to how to "stack" one column on top of another during runtime. Nevertheless, thanks again for your reply.

- Will

|||

I have another option suppose according to the passing parameter report generate value for 1,3,5,7 etc and for next parameter value it will generate report based on 2,4,6,8. Then you can take two table one is design for 1,3,5,7 and next one is designed used by 2,4,6,8 column when parameter passed for 1,3,5,7 then set visibile='true' for this table and set visibile= 'false' for another table that we don't want. Place table one over other so that you need not to worry about the white space.

Does this help you to achive your requirment ?

Regards

Manoj Verma.

|||Hi Manoj Verma,

Thanks for replying. I do not think your suggestion would work because my example was a watered downed one. Our actual need is a 40 columns dynamic report, where users can choose any of the 40 columns. Thanks again for your input.

- Will

sql

Report page size when printing

I use SQL Server 2005 Reporting Services. The clients use Internet Explorer 6 or higher on Windows XP.

When i access a report by ReportServer URL, the report viewer show me this report with my default parameters selected. If i choose "PDF" format and i click "Export", my report is perfect on printing.

My problem is the button print of the ReportViewer page, if i click on it, the printed report is very too large (on two page). I presume that some settings are wrong in my report, the maximum width of the content never exceed 31 cm, i want the report in LandScape.

There are my settings for this report :

InteractiveSize : 11in; 8,5in

Margins : 1,5cm; 1,5cm; 1,5cm; 1,5cm

PageSize : 35cm; 25cm

Where's the problem when i use the print button directly into the ReportViewer ? Internet Explorer ? The printer drivers or settings ? The report settings ?

Sorry for my english...

What happens when you set InteractiveWidth to 35cm and InteractiveHeight to 25cm? InteractiveHeight/Width are used to generate soft page breaks with HTML and Excel formats.|||Same problem, i have deleted the report before deploying again with the updated report (InteractiveWidth to 35cm and InteractiveHeight to 25cm) and the report stay on 2 page in width.|||At what width does the report break across pages? This usually happens when the report body width exceeds the page width minus (left and right margins).|||ok i will change the width and height of the page. It seem's to be 27.5 X 21.5 cm, so i will reduce the width and the content will fit on one page. Thanks.

Report Page Numbering ***Really Urgent****

I need to place on my report "Page # of #". How do I do this as Im unsure of
the number of pages my report will be.
Also have a problem with getting my header details for each report to show
on every page. Have a Name for report, then the start and end dates and a
logo. Haven't put them into actual Page Header Area as the start and end
date bit wont work that way. Any help is appreciated.Someone seemed to have a similar problem:
Find this group in google groups, search on "Data Header on every
page".
They are suggesting to use tables within lists.
HTH
Dom|||Thanks.
"Dom" wrote:
> Someone seemed to have a similar problem:
> Find this group in google groups, search on "Data Header on every
> page".
> They are suggesting to use tables within lists.
> HTH
> Dom
>|||Also, in VS.NET, you should see "page header" under the report menu,
try that to set a page header. You should be able to put in textboxes
for the name, dates, etc...
For your page number issue, add a textbox, edit its properties, and set
its value to ="Page " & Globals!PageNumber & " of " &
Globals!TotalPages
HTH
Dominique|||Super thanks
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Just to let you know what I have for a header. I have one txt box with Name
of Report, an Image Box with Company Logo and another txt box with the
following in it.
=First(Fields!DateFrom.Value, "DateRange") & "to " &
First(Fields!DateTo.Value, "DateRange")
Is this ok to have in a page header area of the report.
"Dom" wrote:
> Also, in VS.NET, you should see "page header" under the report menu,
> try that to set a page header. You should be able to put in textboxes
> for the name, dates, etc...
> For your page number issue, add a textbox, edit its properties, and set
> its value to ="Page " & Globals!PageNumber & " of " &
> Globals!TotalPages
> HTH
> Dominique
>|||Dear Nat:
Is this giving you an error?
If so, try putting it in the report header (at the top of the body)
Have a good night!

Report Page Issue?

I have a report that I developed. When I click the preview tab and see the
report it show's 1 page which is correct. When I click the "Print Preview"
button it shows the 1st page and 3 blank pages after? It also prints this
way.
Why is it doing this?
DavidMake sure that your report satisfies the condition specified below
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Ponnurangam
"Yoshi" <yoshi@.home.com> wrote in message
news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> I have a report that I developed. When I click the preview tab and see the
> report it show's 1 page which is correct. When I click the "Print Preview"
> button it shows the 1st page and 3 blank pages after? It also prints this
> way.
> Why is it doing this?
> David
>|||Ponnurangam,
I thought that was going to solve my problem but it didn't. Thanks for good
info. Do you have any other suggestions?
Thanks,
Davod
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> Make sure that your report satisfies the condition specified below
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> Body.Width
> Ponnurangam
> "Yoshi" <yoshi@.home.com> wrote in message
> news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> I have a report that I developed. When I click the preview tab and see
>> the
>> report it show's 1 page which is correct. When I click the "Print
>> Preview"
>> button it shows the 1st page and 3 blank pages after? It also prints
>> this
>> way.
>> Why is it doing this?
>> David
>>
>|||Hi
I have also had the same problem today and have worked out that the white
background with the dots is like the canvas, is the body width and must be
smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
Hope you get my meaning.
Fiona
"Yoshi" wrote:
> Ponnurangam,
> I thought that was going to solve my problem but it didn't. Thanks for good
> info. Do you have any other suggestions?
> Thanks,
> Davod
> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> > Make sure that your report satisfies the condition specified below
> >
> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> > Ponnurangam
> >
> > "Yoshi" <yoshi@.home.com> wrote in message
> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> >> I have a report that I developed. When I click the preview tab and see
> >> the
> >> report it show's 1 page which is correct. When I click the "Print
> >> Preview"
> >> button it shows the 1st page and 3 blank pages after? It also prints
> >> this
> >> way.
> >>
> >> Why is it doing this?
> >>
> >> David
> >>
> >>
> >
> >
>
>|||I finally understand what everyone is saying. Thank you so much!
David P.
"Fiona Harrison" <FionaHarrison@.discussions.microsoft.com> wrote in message
news:40621EF4-C726-4859-935F-53C239980B96@.microsoft.com...
> Hi
> I have also had the same problem today and have worked out that the white
> background with the dots is like the canvas, is the body width and must be
> smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
> Hope you get my meaning.
> Fiona
> "Yoshi" wrote:
>> Ponnurangam,
>> I thought that was going to solve my problem but it didn't. Thanks for
>> good
>> info. Do you have any other suggestions?
>> Thanks,
>> Davod
>> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
>> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
>> > Make sure that your report satisfies the condition specified below
>> >
>> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=>> > Body.Width
>> >
>> > Ponnurangam
>> >
>> > "Yoshi" <yoshi@.home.com> wrote in message
>> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> >> I have a report that I developed. When I click the preview tab and see
>> >> the
>> >> report it show's 1 page which is correct. When I click the "Print
>> >> Preview"
>> >> button it shows the 1st page and 3 blank pages after? It also prints
>> >> this
>> >> way.
>> >>
>> >> Why is it doing this?
>> >>
>> >> David
>> >>
>> >>
>> >
>> >
>>

Report page hanging in browser

Hi all,
using SQL2000 sp4
How can I see why a report is not loading in browser.
Just hangs with hour glass. not even the paremeter input fields are loading?
I haven't even clicked view report?
other reports are fine.
thanks,
gvOn Apr 26, 1:37 pm, "gv" <viator.ge...@.gmail.com> wrote:
> Hi all,
> using SQL2000 sp4
> How can I see why a report is not loading in browser.
> Just hangs with hour glass. not even the paremeter input fields are loading?
> I haven't even clicked view report?
> other reports are fine.
> thanks,
> gv
Do you have default(s) on your report parameter(s) set to query? It
sounds like the report parameter'(s) dataset/query is hanging. How
complex is the query for the report parameters? Also, make sure that
you do not have Auto-refresh set on the report (via Layout tab ->
Report drop-down -> Report Properties... -> General tab) or set too
frequently. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks! I will look at what you suggested.
gv
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1177639744.633440.121190@.n35g2000prd.googlegroups.com...
> On Apr 26, 1:37 pm, "gv" <viator.ge...@.gmail.com> wrote:
>> Hi all,
>> using SQL2000 sp4
>> How can I see why a report is not loading in browser.
>> Just hangs with hour glass. not even the paremeter input fields are
>> loading?
>> I haven't even clicked view report?
>> other reports are fine.
>> thanks,
>> gv
>
> Do you have default(s) on your report parameter(s) set to query? It
> sounds like the report parameter'(s) dataset/query is hanging. How
> complex is the query for the report parameters? Also, make sure that
> you do not have Auto-refresh set on the report (via Layout tab ->
> Report drop-down -> Report Properties... -> General tab) or set too
> frequently. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Report only showing a single record

I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
records in Table. However, the report only shows a single record/page. I
placed the fields on the report in the "Body". What am I missing here?Nevermind... Got it. It's the List item.
"Dan" wrote:
> I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
> records in Table. However, the report only shows a single record/page. I
> placed the fields on the report in the "Body". What am I missing here?|||When you place the fields on the blank layout surface you are not using any
of the controls that know about multiple rows. You need to place either a
table control or a list control and then drag and drop onto them.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:7F61EA6A-DB25-43FC-9117-84A2E7E037AA@.microsoft.com...
>I have a DataSet which is defined as "SELECT * FROM Table". There are MANY
> records in Table. However, the report only shows a single record/page. I
> placed the fields on the report in the "Body". What am I missing here?sql

Report only generates 1 page output

I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?

Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?

Thanks,
Albert

Report only generates 1 page output

I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?

Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?

Thanks,
Albert

report only displays one row

I added a report viewer, clicked create new report, and followed the wizards. My report only displays one row on one page. I can see all the rows if I preview contents on the data table adapter. There are no filters and no where clause in the SQL. What might the reason be that the report only shows one row? Thanks

HI,dmcdivitt:

Try to use a simple sql statement without any parameter and filter and following the Add New Report Wizard. If you still face to the same sitution, please feel free to post your question here for more discussion.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

I created a new report with a simple SQL statement and got the same result - one row on one page. No more. The table used has 1300 rows. No filters, no parameters, and no where clause was used anywhere.

|||

I will ask this in another forum. Nobody seems to read this one.

|||

HI,dmcdivitt:

I am sorry that i have came back home early and have not read your posts in time due to the different time region.

It is really weird. I hope you can send me your project to me and i will have a check with it.

Please use the simple query string and the common datatable(NORTHWIND).

Here is my address:sighlen@.sina.com

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Resolved. See threadhttp://forums.asp.net/t/1128061.aspx

Report not using pagination properly

I have a portrait report that has 1 table with 1 hidden group header (for the Page Header to reference fields from) and 36 detail rows. My problem is that pagination is not working properly. Depending on the length of data in the detail rows, the report tends to push majority of data on the next page(s) which leaves a lot of blank lines or blank page at the beginning of each group of data. I want the data to complete the first page before rolling over to the next page. That's why I have 36 individual detail rows instead of all the data in 1 detail row. I've tried adjusting the page length, but it doesn't seem to work all that well. I either get all the report on one page (which is fine when viewing online, but data is cut off when printing) or inadequate pagination. I do not have any white space at the bottom of the table and the page footer. Anyone have any ideas?

Thanks,

T

Have you tried setting KeepTogether=false on your table? The behavior your describing sounds like it's set to true, which would mean that if the table can't fit completely on the current page, but will fit on the next page, it will move the table to the next page.

You shouldn't need to specify the detail rows individually if you're populating from a data source!|||Yes, KeepTogether is false and yes I am using a shared data source and data is queried using Stored Procedure.|||Well it seems the problem lies within the Group Header row. I removed that row and pagination works properly now, but I lose the ability to call fields in my page header when the report spans more than one page.|||

Ok, I found a solution for showing Field values in Page Header even when the report spans more than one page(but you don't know at what point the report spans to the next page). It's a combination of several solutions:

1) Create hidden textbox(es) with the field value you're wanting on every line where the page might span to the next page.

textbox1

textbox2

textbox3

2) Create a function in code that will reference each hidden textbox(es) by name

Shared Function Header(reportItems as ReportItems) as string
Dim final as string
If ReportItems!textbox1.value <> "" Then
final = ReportItems!textbox1.value
Else If ReportItems!textbox2.value <> "" Then
final = ReportItems!textbox2.value
Else If ReportItems!textbox3.value <> "" Then
final = ReportItems!textbox3.value
End If
Return final
End Function

3) In Page Header call function, pass (ReportItems)

=Code.Header(ReportItems)

The reason for the function is because you can't reference multiple ReportItems in Page Header textbox, so you have to determine which hidden textbox has a value on that page and return that value to the calling Header textbox. Hope this helps....

sql

Report Never Renders

We are having a problem where a report never actually renders out to
the page. Just to clarify, the report itself does work, just not with
a larger recordset. For example, I can pull the report using a smaller
client and it returns 8k records. When I use a larger client with a
recordset of lets say 16k records it never actually makes it. When I
look at the log it shows the following:
TimeDataRetrieval = 271.18 secs
TimeProcessing = 17.31 secs
TimeRendering = 25.46 secs
And yes, I have resolved the milliseconds to seconds. So according to
the log, the page is rendered, but in reality it isn't. To add another
curious bit, yesterday I ran this report at roughly 3pm CST. When I
looked at the log, it showed the TimeStart as 2005-05-16 15:54:09.920.
And yes, I'm sure the server time and my system time are updated off
the same timeserver.
So now for my questions:
A) Is there some sort of caching of the data?
B) What would cause the page not to render even though the data is
there?
C) Could there be a disconnect between the ReportServer and IIS?
Possibly a timeout?
Any help would be greatly appreciated,
ScottPropwash,
Check out the report properties in Report Manager (the properties tab on the
web browser). There are caching properties there, I believe in the General
screen, that you might want to verify. Additionally, double check your data
source screen to make sure that everything looks okay there.
After hitting the properties tab above the browser, you can find the other
"tabs" to the left of the screen, below the tabs.
Hope that helps.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Propwash" wrote:
> We are having a problem where a report never actually renders out to
> the page. Just to clarify, the report itself does work, just not with
> a larger recordset. For example, I can pull the report using a smaller
> client and it returns 8k records. When I use a larger client with a
> recordset of lets say 16k records it never actually makes it. When I
> look at the log it shows the following:
> TimeDataRetrieval = 271.18 secs
> TimeProcessing = 17.31 secs
> TimeRendering = 25.46 secs
> And yes, I have resolved the milliseconds to seconds. So according to
> the log, the page is rendered, but in reality it isn't. To add another
> curious bit, yesterday I ran this report at roughly 3pm CST. When I
> looked at the log, it showed the TimeStart as 2005-05-16 15:54:09.920.
> And yes, I'm sure the server time and my system time are updated off
> the same timeserver.
> So now for my questions:
> A) Is there some sort of caching of the data?
> B) What would cause the page not to render even though the data is
> there?
> C) Could there be a disconnect between the ReportServer and IIS?
> Possibly a timeout?
> Any help would be greatly appreciated,
> Scott
>|||Propwash wrote:
> We are having a problem where a report never actually renders out to
> the page. Just to clarify, the report itself does work, just not with
> a larger recordset. For example, I can pull the report using a smaller
> client and it returns 8k records. When I use a larger client with a
> recordset of lets say 16k records it never actually makes it. When I
> look at the log it shows the following:
> TimeDataRetrieval = 271.18 secs
> TimeProcessing = 17.31 secs
> TimeRendering = 25.46 secs
> And yes, I have resolved the milliseconds to seconds. So according to
> the log, the page is rendered, but in reality it isn't. To add another
> curious bit, yesterday I ran this report at roughly 3pm CST. When I
> looked at the log, it showed the TimeStart as 2005-05-16 15:54:09.920.
> And yes, I'm sure the server time and my system time are updated off
> the same timeserver.
> So now for my questions:
> A) Is there some sort of caching of the data?
> B) What would cause the page not to render even though the data is
> there?
> C) Could there be a disconnect between the ReportServer and IIS?
> Possibly a timeout?
> Any help would be greatly appreciated,
> Scott
>
What service pack and what format. I had the same problem with Excel
files until I loaded Service Pack 2.sql

Report must be on one 'screen-page'

We are producing a Matrix report that we want to have on one page. The width of the height is unpredictable.

This report is never printed, only used for browsing of export to excel.

How can we achieve this, w've tried to play with the sizes but this is still 'hardcoded', and setting height and with to 400 makes DevStudio crash, over and over.

Any suggestions ....

With suggestions we mean, on the 'one' page, not for the crash .....

If this is Reporting Services 2005, you can set the Report.InteractiveHeight property to 0 which means unlimited height in interactive renderers (HTML, preview).

-- Robert

|||Works perfect, thx.|||

Hi anyone,

my problem is a bit simillar with harry but we are making a report and when viewing it, we still see one page even how long the report is, I had viewed the XML code and search fot the property Report.InteractiveHeight but I fouond nothing.

Can anyone help me with this? thanks a lot... we need to cut the report in pages.....God Speed

Report Margin modifications

Is it possible to change the margins of a report so that the left and right
margins are 0.1... thus utilizing more of the page?
Thanks.go to 'report' -> 'report properties' -> 'layout'
"ashvsaod" <ashvsaod@.hotmail.com> wrote in message
news:euftQMnfEHA.592@.TK2MSFTNGP11.phx.gbl...
> Is it possible to change the margins of a report so that the left and
right
> margins are 0.1... thus utilizing more of the page?
> Thanks.
>|||Thanks. Problem Solved.
"Daniel" <danielk@.adstream.com.au> wrote in message
news:uZ6mXCpfEHA.3964@.TK2MSFTNGP12.phx.gbl...
> go to 'report' -> 'report properties' -> 'layout'
>
> "ashvsaod" <ashvsaod@.hotmail.com> wrote in message
> news:euftQMnfEHA.592@.TK2MSFTNGP11.phx.gbl...
> > Is it possible to change the margins of a report so that the left and
> right
> > margins are 0.1... thus utilizing more of the page?
> >
> > Thanks.
> >
> >
>

Report manager shows a blank page

Hi all. My name is Guilherme and I'm a Braziliam software developer.

I've installed on my computer all the software required to work with MS SQL RS. I log on this computer using my domain user. and a few days ago i needed to change my password (network policy)

Now, when I open the adress http://localhost/reports on my computer, I can't see the installed reports, neither the configuration page.

What should I do?

Thanks in advance.

My guess is that you haven't set up any rights to root folder..

In Server Management Studio you can give your user administration access..

Report Manager Print does not respect page orientation or margins.

I have been experiencing a problem when viewing reports in IE (versions 6 and 7) in that the page orientation and margins set in the RDL are not passed to the print layout. I am using the one-time download print program for RS, not IE's print dialog.

As an example, I have a Landscape report with .25 margins all around. When I go to print, it is defaulted to Portrait with 1 inch margins all around.

Any help would be greatly appreciated.

-Nick

Started thread prematurely, answer in another thread. Apparently, linked reports do not retain the layout of the base report.

Report Manager Home page is incomplete

First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.

All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.

Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.

Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."

Some of the settings inside the Report Sever Config are as follows:

Windows Service Identity:

Service Acct: NT Authority\Network Service; Built-in Account: Network Service

Web Service Identity:

Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool

I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.

I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....

I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)

I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.

I had to add my user account and adin acct to the IIS user group

I had to install every IIS option, basic install leaves some out.

I think that was all.....good luck

|||

Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.

Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.

|||

I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.

The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.

Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.

/frustrated whining and moaning

|||

I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.

I don't know why Microsoft cannot install their own software on their own operating systems.

Report Manager Home page is incomplete

First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.

All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.

Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.

Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."

Some of the settings inside the Report Sever Config are as follows:

Windows Service Identity:

Service Acct: NT Authority\Network Service; Built-in Account: Network Service

Web Service Identity:

Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool

I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.

I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....

I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)

I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.

I had to add my user account and adin acct to the IIS user group

I had to install every IIS option, basic install leaves some out.

I think that was all.....good luck

|||

Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.

Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.

|||

I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.

The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.

Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.

/frustrated whining and moaning

|||

I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.

I don't know why Microsoft cannot install their own software on their own operating systems.