Does SQL Server 2005 Workgroup edition support scheduling report?

Hello,

In the feature list of workgroup edition, it says Reporting services is included.

After I finally installed it, the reporting service is there as expected. But what is missing is the subscription tab in the report manager. Then I went to Reporting service Configuration Manager, and I saw emailing setting is there (which indicates scheudling and emailling is supported), then I setup valid sender email address and SMTP server, but the Subscription tab is still missing.

Could anyone (from microsoft) tell me whether emailling and scheduling are supported in Workgroup edition or not?

Thanks a lot!

Details about available RS features per edition can be found here: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

Subscriptions are available for Standard Edition and Enterprise Editions. Data-driven subscriptions are Enterprise Edition only.

-- Robert

sql

Does RS2005 check for SQL Injections on it's parameters?

Dear Anyone,

One of the common usage of report parameters in reporting services is having a free form text. One of the common ways of bringing data to RS is by using stored procs -- usually taking inputs from report parameters.

Does RS2005 have safeguards for SQL Injections and other hacking problems?

Thanks,

Joseph

RS uses the .Net SqlClient classes for building its queries. These classes guard against SQL injections issues.sql

Does RS use the MS FullText Search Engine?

Not sure what this question means, but I am being asked this by our
Technology Department.
Somehow the SQL Server instance where the Report Server databases were got
dettached. They were able to re-enable it, but they cannot restart this
engine because of a corrupt configuration file.
They are asking me whether they should keep researching and trying to fix
this file or they can just remove the engine from the cluster.
Thanks!
Ray G.The FullText search engine is not used by RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RayG" <RayG@.discussions.microsoft.com> wrote in message
news:44515EB2-37F2-4073-B085-023B8051A788@.microsoft.com...
> Not sure what this question means, but I am being asked this by our
> Technology Department.
> Somehow the SQL Server instance where the Report Server databases were got
> dettached. They were able to re-enable it, but they cannot restart this
> engine because of a corrupt configuration file.
> They are asking me whether they should keep researching and trying to fix
> this file or they can just remove the engine from the cluster.
> Thanks!
> Ray G.

Does RS support to change the report size automatically?-URGENT!!!

I will use MSRS to create reports in a .Net Smart Client project later.

For some kinds of report, there are some customized columns which may be displayed or not. I design these reports like this: first create all the columns, then set the "Visibility-Hidden" property of those customized columns using expression which including some report parameters.Thus, these customized columns can be displayed or hidden by setting the value of the report parameters at the runtime. But another problem emerged.The size of report backgroud can not changed automatically along with the length of DataTable.So if there are some columns be hidden, there will be some margin on the right of the report and the Title of report was still in the center of the original report,not changed to the center of the new one. Due to the "Size " property of report and the "Size"&"Location"properties of textbox does not support expression.

Is there any one can give me some solution?

I am not sure whether the current version of MSRS support such kind of requirement?If not,will the MSRS final release comes out on November 7 support it?

Thanks!

Hi!

I also have this problem! I am building subreports that are getting more and more generic, but now I have noticed that the (optionally) hidden rows in the subreport's table is showing up as blank space on the main report. That makes this useful way of making the subreports nothing more than useless.

I have found no way to set the size of the subreport "background" or rectangle smaller than the designed area.

The reporting services seems more and more tied down to me. It has to have much more abilities than it currently has to survive. At the moment automation of Word seems much more flexible, but is client based. Still, in many situations the current RS will not deliver enough to fulfill the requirements. I hope this will change soon.

/Michael

|||The report never shrinks the size of the body so hiding a bunch of columns won't help your report. If you want a title to span the items in a table, put it in the table header, similar to how this matrix report was done: http://blogs.msdn.com/bwelcker/archive/2005/05/11/416720.aspx.|||But I am using a "table" as a way of displaying different checkboxes and texts, as a form, and sometimes one or more of the rows in these (generic) subreports are not to be used and I hide them (that's what makes it more generic).

I am not using it to show a list of information but as a way of showing a dynamic one-page form.

When I hide a row it shows up as approximately half a row of blank space on the main report. In this case the Visiblity setting is useless since there is too much space between subreports on the main report.

Does RS support to change the report size automatically?-URGENT!!!

I will use MSRS to create reports in a .Net Smart Client project later.

For some kinds of report, there are some customized columns which may be displayed or not. I design these reports like this: first create all the columns, then set the "Visibility-Hidden" property of those customized columns using expression which including some report parameters.Thus, these customized columns can be displayed or hidden by setting the value of the report parameters at the runtime. But another problem emerged.The size of report backgroud can not changed automatically along with the length of DataTable.So if there are some columns be hidden, there will be some margin on the right of the report and the Title of report was still in the center of the original report,not changed to the center of the new one. Due to the "Size " property of report and the "Size"&"Location"properties of textbox does not support expression.

Is there any one can give me some solution?

I am not sure whether the current version of MSRS support such kind of requirement?If not,will the MSRS final release comes out on November 7 support it?

Thanks!

Hi!

I also have this problem! I am building subreports that are getting more and more generic, but now I have noticed that the (optionally) hidden rows in the subreport's table is showing up as blank space on the main report. That makes this useful way of making the subreports nothing more than useless.

I have found no way to set the size of the subreport "background" or rectangle smaller than the designed area.

The reporting services seems more and more tied down to me. It has to have much more abilities than it currently has to survive. At the moment automation of Word seems much more flexible, but is client based. Still, in many situations the current RS will not deliver enough to fulfill the requirements. I hope this will change soon.

/Michael

|||The report never shrinks the size of the body so hiding a bunch of columns won't help your report. If you want a title to span the items in a table, put it in the table header, similar to how this matrix report was done: http://blogs.msdn.com/bwelcker/archive/2005/05/11/416720.aspx.|||But I am using a "table" as a way of displaying different checkboxes and texts, as a form, and sometimes one or more of the rows in these (generic) subreports are not to be used and I hide them (that's what makes it more generic).

I am not using it to show a list of information but as a way of showing a dynamic one-page form.

When I hide a row it shows up as approximately half a row of blank space on the main report. In this case the Visiblity setting is useless since there is too much space between subreports on the main report.sql

does RS have the mode "push" & "pull" ?

Hi, everyone,

When i use the crystal report, there have a option "push" & "pull" .

Does report in the SQL Server reporting Services have the same option ?
Thank you!With Reporting Services, you can subscribe to reports and also generate on-demand and data-driven reports. Is this the push and pull functionality you are looking for?|||

Not. In crystal report , use push mode need get the data by user not by the crystal report, the fill the data into the report. So this mode can improve the performance.

If there is large data in the database , use pull mode wil very slowly.

Thank you for your reply.

|||

Hi, does anyone knows how to this? I also need to push the data to the report because I have this scenario, I have to display a report on the changed data of the user (not yet being saved in the database). How could this be done in the reporting services?

Thanks a lot in advance and more power.

does RS have the mode "push" & "pull" ?

Hi, everyone,

When i use the crystal report, there have a option "push" & "pull" .

Does report in the SQL Server reporting Services have the same option ?
Thank you!
With Reporting Services, you can subscribe to reports and also generate on-demand and data-driven reports. Is this the push and pull functionality you are looking for?|||

Not. In crystal report , use push mode need get the data by user not by the crystal report, the fill the data into the report. So this mode can improve the performance.

If there is large data in the database , use pull mode wil very slowly.

Thank you for your reply.

|||

Hi, does anyone knows how to this? I also need to push the data to the report because I have this scenario, I have to display a report on the changed data of the user (not yet being saved in the database). How could this be done in the reporting services?

Thanks a lot in advance and more power.

Does RS contain a Report Header section?

Hello,
I can see how to add a page header to a report in Reporting Services. But
is there a Report Header section? What I need to do is to display a reoprt
title on the Report Header, then force a new page after the Report Header
section and list my data. How can something like this be accomplished using
Reporting Services?
Thanks,
RichWe use a rectangle on the first page and put our intro page there, then
check the page break after property.
Steve MunLeeuw
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> Hello,
> I can see how to add a page header to a report in Reporting Services. But
> is there a Report Header section? What I need to do is to display a
> reoprt
> title on the Report Header, then force a new page after the Report Header
> section and list my data. How can something like this be accomplished
> using
> Reporting Services?
> Thanks,
> Rich|||Thank you (again). It is starting to make sense.
Rich
"Steve MunLeeuw" wrote:
> We use a rectangle on the first page and put our intro page there, then
> check the page break after property.
> Steve MunLeeuw
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> > Hello,
> >
> > I can see how to add a page header to a report in Reporting Services. But
> > is there a Report Header section? What I need to do is to display a
> > reoprt
> > title on the Report Header, then force a new page after the Report Header
> > section and list my data. How can something like this be accomplished
> > using
> > Reporting Services?
> >
> > Thanks,
> > Rich
>
>|||Forgot to ask -- so I add a rectangle - I am guessing to the detail
section, then I place a page break there. I have placed 5 textboxes in a
list control. This report prints labels (real pain to set the column widths
a row spacings just right). I don't want to upset the spacings of the
textboxes because it took me a long time (and a lot of tree killing and ink
usage) to get the spacings just right in the detail section.
May I ask where I place the rectangle?
And to stretch this inch to a mile, I was just told that the labels have to
be all in uppercase. In my winform app there is a textbox property for
charactercasing. I did not see that in the RDL. I looked at the Globals
collection but nothing caught my attention for forcing upper case. I could
force upper case at the datasource level, but is there a way to specify/force
character casing at the Report Textbox level? How to do that?
Thank you for your help and patience. I really appreciate it.
Thanks,
Rich
"Steve MunLeeuw" wrote:
> We use a rectangle on the first page and put our intro page there, then
> check the page break after property.
> Steve MunLeeuw
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> > Hello,
> >
> > I can see how to add a page header to a report in Reporting Services. But
> > is there a Report Header section? What I need to do is to display a
> > reoprt
> > title on the Report Header, then force a new page after the Report Header
> > section and list my data. How can something like this be accomplished
> > using
> > Reporting Services?
> >
> > Thanks,
> > Rich
>
>|||I think you would want the report header rectangle at the begining of the
report body. I see your point on the layout, nothing comes to mind...you
can have a zero height, but then it would be pretty darn hard to add your
textbox layout.
Here's what I'd try:
Make a backup copy, or use source control
Note the top property of the topmost item in the body
Cut everything in the body
Add two rectangles
Paste everything into the second rectangle
Use the up/down arrows with everything selected in the rectangle so you get
the same top spot noted before
set the page break property on the first rectangle
For the uppercase you have access to quite a bit.
try:
System.String.ToUpper(field!myField.Value)
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> Forgot to ask -- so I add a rectangle - I am guessing to the detail
> section, then I place a page break there. I have placed 5 textboxes in a
> list control. This report prints labels (real pain to set the column
> widths
> a row spacings just right). I don't want to upset the spacings of the
> textboxes because it took me a long time (and a lot of tree killing and
> ink
> usage) to get the spacings just right in the detail section.
> May I ask where I place the rectangle?
> And to stretch this inch to a mile, I was just told that the labels have
> to
> be all in uppercase. In my winform app there is a textbox property for
> charactercasing. I did not see that in the RDL. I looked at the Globals
> collection but nothing caught my attention for forcing upper case. I
> could
> force upper case at the datasource level, but is there a way to
> specify/force
> character casing at the Report Textbox level? How to do that?
> Thank you for your help and patience. I really appreciate it.
> Thanks,
> Rich
> "Steve MunLeeuw" wrote:
>> We use a rectangle on the first page and put our intro page there, then
>> check the page break after property.
>> Steve MunLeeuw
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
>> > Hello,
>> >
>> > I can see how to add a page header to a report in Reporting Services.
>> > But
>> > is there a Report Header section? What I need to do is to display a
>> > reoprt
>> > title on the Report Header, then force a new page after the Report
>> > Header
>> > section and list my data. How can something like this be accomplished
>> > using
>> > Reporting Services?
>> >
>> > Thanks,
>> > Rich
>>|||Cool. You actually gave me another idea (BTW, right after I begged for help
on ucase, I did in search for uppercase and discover ucase
(field!myfld.Value).toupper and your method - well, at least I got
charactercasing covered :).
Anyway, my idea for the title page was to place the rectangle/control
(actually a textbox which will take a param because the title will change
based on selections) on top of the other textboxes. On the first page, the
data textboxes are not visible, then after the first page, the title textbox
is not visible but the data textboxes are visible. Does this sound possible?
I am thinking I could set the pagebreak on the rectangle and have an
expression to control the visibility of the controls. Any comments
appreciated if this is doable or not.
Thanks again,
Rich
"Steve MunLeeuw" wrote:
> I think you would want the report header rectangle at the begining of the
> report body. I see your point on the layout, nothing comes to mind...you
> can have a zero height, but then it would be pretty darn hard to add your
> textbox layout.
> Here's what I'd try:
> Make a backup copy, or use source control
> Note the top property of the topmost item in the body
> Cut everything in the body
> Add two rectangles
> Paste everything into the second rectangle
> Use the up/down arrows with everything selected in the rectangle so you get
> the same top spot noted before
> set the page break property on the first rectangle
> For the uppercase you have access to quite a bit.
> try:
> System.String.ToUpper(field!myField.Value)
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
> > section, then I place a page break there. I have placed 5 textboxes in a
> > list control. This report prints labels (real pain to set the column
> > widths
> > a row spacings just right). I don't want to upset the spacings of the
> > textboxes because it took me a long time (and a lot of tree killing and
> > ink
> > usage) to get the spacings just right in the detail section.
> >
> > May I ask where I place the rectangle?
> >
> > And to stretch this inch to a mile, I was just told that the labels have
> > to
> > be all in uppercase. In my winform app there is a textbox property for
> > charactercasing. I did not see that in the RDL. I looked at the Globals
> > collection but nothing caught my attention for forcing upper case. I
> > could
> > force upper case at the datasource level, but is there a way to
> > specify/force
> > character casing at the Report Textbox level? How to do that?
> >
> > Thank you for your help and patience. I really appreciate it.
> >
> > Thanks,
> > Rich
> >
> > "Steve MunLeeuw" wrote:
> >
> >> We use a rectangle on the first page and put our intro page there, then
> >> check the page break after property.
> >>
> >> Steve MunLeeuw
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> >> > Hello,
> >> >
> >> > I can see how to add a page header to a report in Reporting Services.
> >> > But
> >> > is there a Report Header section? What I need to do is to display a
> >> > reoprt
> >> > title on the Report Header, then force a new page after the Report
> >> > Header
> >> > section and list my data. How can something like this be accomplished
> >> > using
> >> > Reporting Services?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||I wouldn't do that, the text overlap will result in a compile warning and
cause layout problems in html format.
Steve MunLeeuw
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:2CC85597-4934-4E07-B5FE-FD3DF1211985@.microsoft.com...
> Cool. You actually gave me another idea (BTW, right after I begged for
> help
> on ucase, I did in search for uppercase and discover ucase
> (field!myfld.Value).toupper and your method - well, at least I got
> charactercasing covered :).
> Anyway, my idea for the title page was to place the rectangle/control
> (actually a textbox which will take a param because the title will change
> based on selections) on top of the other textboxes. On the first page,
> the
> data textboxes are not visible, then after the first page, the title
> textbox
> is not visible but the data textboxes are visible. Does this sound
> possible?
> I am thinking I could set the pagebreak on the rectangle and have an
> expression to control the visibility of the controls. Any comments
> appreciated if this is doable or not.
> Thanks again,
> Rich
> "Steve MunLeeuw" wrote:
>> I think you would want the report header rectangle at the begining of the
>> report body. I see your point on the layout, nothing comes to mind...you
>> can have a zero height, but then it would be pretty darn hard to add your
>> textbox layout.
>> Here's what I'd try:
>> Make a backup copy, or use source control
>> Note the top property of the topmost item in the body
>> Cut everything in the body
>> Add two rectangles
>> Paste everything into the second rectangle
>> Use the up/down arrows with everything selected in the rectangle so you
>> get
>> the same top spot noted before
>> set the page break property on the first rectangle
>> For the uppercase you have access to quite a bit.
>> try:
>> System.String.ToUpper(field!myField.Value)
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
>> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
>> > section, then I place a page break there. I have placed 5 textboxes
>> > in a
>> > list control. This report prints labels (real pain to set the column
>> > widths
>> > a row spacings just right). I don't want to upset the spacings of the
>> > textboxes because it took me a long time (and a lot of tree killing and
>> > ink
>> > usage) to get the spacings just right in the detail section.
>> >
>> > May I ask where I place the rectangle?
>> >
>> > And to stretch this inch to a mile, I was just told that the labels
>> > have
>> > to
>> > be all in uppercase. In my winform app there is a textbox property for
>> > charactercasing. I did not see that in the RDL. I looked at the
>> > Globals
>> > collection but nothing caught my attention for forcing upper case. I
>> > could
>> > force upper case at the datasource level, but is there a way to
>> > specify/force
>> > character casing at the Report Textbox level? How to do that?
>> >
>> > Thank you for your help and patience. I really appreciate it.
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Steve MunLeeuw" wrote:
>> >
>> >> We use a rectangle on the first page and put our intro page there,
>> >> then
>> >> check the page break after property.
>> >>
>> >> Steve MunLeeuw
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I can see how to add a page header to a report in Reporting
>> >> > Services.
>> >> > But
>> >> > is there a Report Header section? What I need to do is to display a
>> >> > reoprt
>> >> > title on the Report Header, then force a new page after the Report
>> >> > Header
>> >> > section and list my data. How can something like this be
>> >> > accomplished
>> >> > using
>> >> > Reporting Services?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Back in the office. So I will try your previous suggestion and hope for the
best.
Thank you again for your help.
Rich
"Steve MunLeeuw" wrote:
> I wouldn't do that, the text overlap will result in a compile warning and
> cause layout problems in html format.
> Steve MunLeeuw
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:2CC85597-4934-4E07-B5FE-FD3DF1211985@.microsoft.com...
> > Cool. You actually gave me another idea (BTW, right after I begged for
> > help
> > on ucase, I did in search for uppercase and discover ucase
> > (field!myfld.Value).toupper and your method - well, at least I got
> > charactercasing covered :).
> >
> > Anyway, my idea for the title page was to place the rectangle/control
> > (actually a textbox which will take a param because the title will change
> > based on selections) on top of the other textboxes. On the first page,
> > the
> > data textboxes are not visible, then after the first page, the title
> > textbox
> > is not visible but the data textboxes are visible. Does this sound
> > possible?
> >
> > I am thinking I could set the pagebreak on the rectangle and have an
> > expression to control the visibility of the controls. Any comments
> > appreciated if this is doable or not.
> >
> > Thanks again,
> > Rich
> >
> > "Steve MunLeeuw" wrote:
> >
> >> I think you would want the report header rectangle at the begining of the
> >> report body. I see your point on the layout, nothing comes to mind...you
> >> can have a zero height, but then it would be pretty darn hard to add your
> >> textbox layout.
> >>
> >> Here's what I'd try:
> >> Make a backup copy, or use source control
> >> Note the top property of the topmost item in the body
> >> Cut everything in the body
> >> Add two rectangles
> >> Paste everything into the second rectangle
> >> Use the up/down arrows with everything selected in the rectangle so you
> >> get
> >> the same top spot noted before
> >> set the page break property on the first rectangle
> >>
> >> For the uppercase you have access to quite a bit.
> >> try:
> >> System.String.ToUpper(field!myField.Value)
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> >> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
> >> > section, then I place a page break there. I have placed 5 textboxes
> >> > in a
> >> > list control. This report prints labels (real pain to set the column
> >> > widths
> >> > a row spacings just right). I don't want to upset the spacings of the
> >> > textboxes because it took me a long time (and a lot of tree killing and
> >> > ink
> >> > usage) to get the spacings just right in the detail section.
> >> >
> >> > May I ask where I place the rectangle?
> >> >
> >> > And to stretch this inch to a mile, I was just told that the labels
> >> > have
> >> > to
> >> > be all in uppercase. In my winform app there is a textbox property for
> >> > charactercasing. I did not see that in the RDL. I looked at the
> >> > Globals
> >> > collection but nothing caught my attention for forcing upper case. I
> >> > could
> >> > force upper case at the datasource level, but is there a way to
> >> > specify/force
> >> > character casing at the Report Textbox level? How to do that?
> >> >
> >> > Thank you for your help and patience. I really appreciate it.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Steve MunLeeuw" wrote:
> >> >
> >> >> We use a rectangle on the first page and put our intro page there,
> >> >> then
> >> >> check the page break after property.
> >> >>
> >> >> Steve MunLeeuw
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> >> >> > Hello,
> >> >> >
> >> >> > I can see how to add a page header to a report in Reporting
> >> >> > Services.
> >> >> > But
> >> >> > is there a Report Header section? What I need to do is to display a
> >> >> > reoprt
> >> >> > title on the Report Header, then force a new page after the Report
> >> >> > Header
> >> >> > section and list my data. How can something like this be
> >> >> > accomplished
> >> >> > using
> >> >> > Reporting Services?
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||>Here's what I'd try:
>Make a backup copy, or use source control
>Note the top property of the topmost item in the body
>Cut everything in the body
>Add two rectangles
>Paste everything into the second rectangle
>Use the up/down arrows with everything selected in the rectangle so you get
>the same top spot noted before
>set the page break property on the first rectangle
I am not quite sure what you mean about using the up/down arrows. Do you
mean the up/down arrow keys? The textboxes are located inside a list
control. The list control and the topmost textbox are at the very top of the
body position 0,0.
So I added the 2 rectangles and have copied the contents of the list control
(and all the textboxes inside the list control) to the 2nd rectangle.
Anyway, as I expected, I am having some issues with the layout. The
pagebreak for the first rectangle/title page didn't really break the page.
The data page is starting on the same page as the title page. I guess I will
have to experiment a little bit. Suggestions appreciated.
Thanks,
Rich
"Steve MunLeeuw" wrote:
> I think you would want the report header rectangle at the begining of the
> report body. I see your point on the layout, nothing comes to mind...you
> can have a zero height, but then it would be pretty darn hard to add your
> textbox layout.
> Here's what I'd try:
> Make a backup copy, or use source control
> Note the top property of the topmost item in the body
> Cut everything in the body
> Add two rectangles
> Paste everything into the second rectangle
> Use the up/down arrows with everything selected in the rectangle so you get
> the same top spot noted before
> set the page break property on the first rectangle
> For the uppercase you have access to quite a bit.
> try:
> System.String.ToUpper(field!myField.Value)
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
> > section, then I place a page break there. I have placed 5 textboxes in a
> > list control. This report prints labels (real pain to set the column
> > widths
> > a row spacings just right). I don't want to upset the spacings of the
> > textboxes because it took me a long time (and a lot of tree killing and
> > ink
> > usage) to get the spacings just right in the detail section.
> >
> > May I ask where I place the rectangle?
> >
> > And to stretch this inch to a mile, I was just told that the labels have
> > to
> > be all in uppercase. In my winform app there is a textbox property for
> > charactercasing. I did not see that in the RDL. I looked at the Globals
> > collection but nothing caught my attention for forcing upper case. I
> > could
> > force upper case at the datasource level, but is there a way to
> > specify/force
> > character casing at the Report Textbox level? How to do that?
> >
> > Thank you for your help and patience. I really appreciate it.
> >
> > Thanks,
> > Rich
> >
> > "Steve MunLeeuw" wrote:
> >
> >> We use a rectangle on the first page and put our intro page there, then
> >> check the page break after property.
> >>
> >> Steve MunLeeuw
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> >> > Hello,
> >> >
> >> > I can see how to add a page header to a report in Reporting Services.
> >> > But
> >> > is there a Report Header section? What I need to do is to display a
> >> > reoprt
> >> > title on the Report Header, then force a new page after the Report
> >> > Header
> >> > section and list my data. How can something like this be accomplished
> >> > using
> >> > Reporting Services?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>

Does Reporting Services allow you to select a dataset dynamically?

I have a remote report ...
I need to call one of two stored procedures depending on which parameters were passed to the report. (Both stored procedures return the same fields.)
Does SQL Reporting Services allow you to switch the dataset or stored procedure name dynamically? If so, where do I put the logic? Right now I have it working with one stored procedure.
I'm thinking that I should just make one stored procedure that takes all parameters and calls one of the other two stored procedures. Do I have any options besides this?

Thanks in advance!
Your query can be expression-based, e.g.; =Iif(Parameters!SomeParameterValue = 0, "EXEC sp1 1<parameter list>", EXEC sp2 1<parameter list>"). Alternatively, if the sp choice can be based on a configuration convention, you can use the Report Server web.config file to store the config value. The later case is demonstrated by the DynamicConnection report in this download. The report uses a dynamic connection string but the same approach can be applied to the query.|||That worked. Thanks!
sql

Does reporting service support Chinese?

My report has some chinese. It can be display by IE, but when I export it
as PDF, the chinese words are displayed by "'?" in PDF file.
I don't know how to handle it.I have the same problem.
The Chinese characters show very well in HTML. However, when I export it to
PDF, all of these Chinese characters show as question mark -- ? even I use
Chinese version of Acrobat Reader.
Is it a reporting service bug?
Regards,
AndyZ
"°Ë´óɽÈË" <zhoushaofeng@.hotmail.com> дÈëÓʼþ
news:%23tsMrF1XEHA.2812@.TK2MSFTNGP11.phx.gbl...
> My report has some chinese. It can be display by IE, but when I export it
> as PDF, the chinese words are displayed by "'?" in PDF file.
> I don't know how to handle it.
>|||Update to SP1, it is working fine now.
But I am very sad that when I upgrade to SP1, PDF is OK and E-mail in worng
code(GB2312, it should be UTF-8)
Tony
"Andy Zhang" <A@.A> wrote in message
news:eJPJRw2XEHA.4008@.TK2MSFTNGP09.phx.gbl...
> I have the same problem.
> The Chinese characters show very well in HTML. However, when I export it
to
> PDF, all of these Chinese characters show as question mark -- ? even I use
> Chinese version of Acrobat Reader.
> Is it a reporting service bug?
> Regards,
> AndyZ
> "°Ë´óɽÈË" <zhoushaofeng@.hotmail.com> дÈëÓʼþ
> news:%23tsMrF1XEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > My report has some chinese. It can be display by IE, but when I export
it
> > as PDF, the chinese words are displayed by "'?" in PDF file.
> > I don't know how to handle it.
> >
> >
>|||You will need to use a FontFamily that is localized. The default FontFamily,
Arial, does not support Chinese characters.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"°Ë´óɽÈË" <zhoushaofeng@.hotmail.com> wrote in message
news:%23tsMrF1XEHA.2812@.TK2MSFTNGP11.phx.gbl...
> My report has some chinese. It can be display by IE, but when I export it
> as PDF, the chinese words are displayed by "'?" in PDF file.
> I don't know how to handle it.
>

Does report support this parameters: ...&rs:Format=HTML4.0&rc:Parameters=false&ChainID:isN

hi,
I am working on some report page which will be access via URL.
And I found some old reports URL look like this:
...&rs:Format=HTML4.0&rc:Parameters=false&UserID:isNull=True...
What does the UserID:IsNull=True means? Is this right format for
SSRS2005?
ThanksIt means you have a parameter defined for your report called UserID and
you're setting its value to null via the URL.
Andy Potter|||Oh, ic, Thanks

Does report support this parameters: ...&rs:Format=HTML4.0&rc:Parameters=false&Chain

hi,
I am working on some report page which will be access via URL.
And I found some old reports URL look like this:
....&rs:Format=HTML4.0&rc:Parameters=false&UserID:isNull=True....

What does the UserID:IsNull=True means? Is this right format for SSRS2005?

Thanks

The UserID:IsNull=True notation is special syntax that allows you to pass null values as report parameters. In this case, you're passing null to the UserID parameter. For more info, see Books Online here:

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

Here's all the info about URL access with Reporting Services:

http://msdn2.microsoft.com/en-us/library/ms153586(en-us,SQL.90).aspx

Best,
Chris

Does Report Builder support Analysis Services Databases?

The webcast on Report Builder mentioned that you can run reports that were
created in Report Designer in Report Builder. Is it possible?There are two questions in your post.
1. Does Report Builder support Analysis Services Databases?Yes, with
Analysis Services 2005. You can automatically generate the model from an
SSAS 2005 cube in the Management Studio.
2. Is it possible to open reports that were created in the Report Designer
in the Report Builder? Sort of. Some Report Designer features are not
supported in the Report Builder since the Report Designer is more advanced.
I am not aware about a document that lists all of these features. The
reverse should be OK -- you shoudl be able to open Report Builder reports in
the Report Designer.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:41DCA968-5E67-4D8B-B66A-3E9A83E5E214@.microsoft.com...
> The webcast on Report Builder mentioned that you can run reports that were
> created in Report Designer in Report Builder. Is it possible?|||Hi,
Thanks for the info.
I am not able to open a Report Builder report iN Report Designer. When I go
to the preview screen of the report (.rdl), it throws an error that it cannot
find the Model. I guess we need to change the rdl definition to open it
properly. Do you have any idea how to correct the information and open Report
Builder report in Report Designer.
"Teo Lachev [MVP]" wrote:
> There are two questions in your post.
> 1. Does Report Builder support Analysis Services Databases?Yes, with
> Analysis Services 2005. You can automatically generate the model from an
> SSAS 2005 cube in the Management Studio.
> 2. Is it possible to open reports that were created in the Report Designer
> in the Report Builder? Sort of. Some Report Designer features are not
> supported in the Report Builder since the Report Designer is more advanced.
> I am not aware about a document that lists all of these features. The
> reverse should be OK -- you shoudl be able to open Report Builder reports in
> the Report Designer.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
> news:41DCA968-5E67-4D8B-B66A-3E9A83E5E214@.microsoft.com...
> > The webcast on Report Builder mentioned that you can run reports that were
> > created in Report Designer in Report Builder. Is it possible?
>
>|||1. Save the ad hoc report as a file.
2. Open it in your RS project.You shoudl be able to see its layout but not
to preview it.
3. Add a data source based on the Report Server Model. extension with a
connection string, such as
server=http://localhost/reportserver;datasource=/<Folder>/<your model name>
4. Link the report dataset to that data source.
Now you should be able to preview the report.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:5D591912-0FD8-4812-A44F-8CB3FE312C84@.microsoft.com...
> Hi,
> Thanks for the info.
> I am not able to open a Report Builder report iN Report Designer. When I
> go
> to the preview screen of the report (.rdl), it throws an error that it
> cannot
> find the Model. I guess we need to change the rdl definition to open it
> properly. Do you have any idea how to correct the information and open
> Report
> Builder report in Report Designer.
>
> "Teo Lachev [MVP]" wrote:
>> There are two questions in your post.
>> 1. Does Report Builder support Analysis Services Databases?Yes, with
>> Analysis Services 2005. You can automatically generate the model from an
>> SSAS 2005 cube in the Management Studio.
>> 2. Is it possible to open reports that were created in the Report
>> Designer
>> in the Report Builder? Sort of. Some Report Designer features are not
>> supported in the Report Builder since the Report Designer is more
>> advanced.
>> I am not aware about a document that lists all of these features. The
>> reverse should be OK -- you shoudl be able to open Report Builder reports
>> in
>> the Report Designer.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
>> news:41DCA968-5E67-4D8B-B66A-3E9A83E5E214@.microsoft.com...
>> > The webcast on Report Builder mentioned that you can run reports that
>> > were
>> > created in Report Designer in Report Builder. Is it possible?
>>|||You need to create a data source that uses the Report Server Model extension
with a connection string sth like:
server=http://localhost/reportserver;datasource=/<Folder where model is
located>/<model name>
Next, you need to bind the report dataset to that data source.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
news:5D591912-0FD8-4812-A44F-8CB3FE312C84@.microsoft.com...
> Hi,
> Thanks for the info.
> I am not able to open a Report Builder report iN Report Designer. When I
> go
> to the preview screen of the report (.rdl), it throws an error that it
> cannot
> find the Model. I guess we need to change the rdl definition to open it
> properly. Do you have any idea how to correct the information and open
> Report
> Builder report in Report Designer.
>
> "Teo Lachev [MVP]" wrote:
>> There are two questions in your post.
>> 1. Does Report Builder support Analysis Services Databases?Yes, with
>> Analysis Services 2005. You can automatically generate the model from an
>> SSAS 2005 cube in the Management Studio.
>> 2. Is it possible to open reports that were created in the Report
>> Designer
>> in the Report Builder? Sort of. Some Report Designer features are not
>> supported in the Report Builder since the Report Designer is more
>> advanced.
>> I am not aware about a document that lists all of these features. The
>> reverse should be OK -- you shoudl be able to open Report Builder reports
>> in
>> the Report Designer.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
>> news:41DCA968-5E67-4D8B-B66A-3E9A83E5E214@.microsoft.com...
>> > The webcast on Report Builder mentioned that you can run reports that
>> > were
>> > created in Report Designer in Report Builder. Is it possible?
>>|||Hi
> 1. Does Report Builder support Analysis Services Databases?Yes, with
> Analysis Services 2005. You can automatically generate the model from an
> SSAS 2005 cube in the Management Studio.
Where is that option located?
Thanks,
Andrés
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:e3zEGJs5FHA.2776@.TK2MSFTNGP15.phx.gbl...
> There are two questions in your post.
> 1. Does Report Builder support Analysis Services Databases?Yes, with
> Analysis Services 2005. You can automatically generate the model from an
> SSAS 2005 cube in the Management Studio.
> 2. Is it possible to open reports that were created in the Report
> Designer in the Report Builder? Sort of. Some Report Designer features are
> not supported in the Report Builder since the Report Designer is more
> advanced. I am not aware about a document that lists all of these
> features. The reverse should be OK -- you shoudl be able to open Report
> Builder reports in the Report Designer.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
> news:41DCA968-5E67-4D8B-B66A-3E9A83E5E214@.microsoft.com...
>> The webcast on Report Builder mentioned that you can run reports that
>> were
>> created in Report Designer in Report Builder. Is it possible?
>|||In the SQL Server Management Studio, connect to your RS instance. Then,
right-click on a data source that points to SSAS 2005 and select Generate
Model.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Andres" <andres.fontan@.alcuadrado.com> wrote in message
news:u1pSfXW8FHA.3504@.TK2MSFTNGP11.phx.gbl...
> Hi
>> 1. Does Report Builder support Analysis Services Databases?Yes, with
>> Analysis Services 2005. You can automatically generate the model from an
>> SSAS 2005 cube in the Management Studio.
> Where is that option located?
> Thanks,
> Andrés
>
>
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:e3zEGJs5FHA.2776@.TK2MSFTNGP15.phx.gbl...
>> There are two questions in your post.
>> 1. Does Report Builder support Analysis Services Databases?Yes, with
>> Analysis Services 2005. You can automatically generate the model from an
>> SSAS 2005 cube in the Management Studio.
>> 2. Is it possible to open reports that were created in the Report
>> Designer in the Report Builder? Sort of. Some Report Designer features
>> are not supported in the Report Builder since the Report Designer is more
>> advanced. I am not aware about a document that lists all of these
>> features. The reverse should be OK -- you shoudl be able to open Report
>> Builder reports in the Report Designer.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Dan Krish" <DanKrish@.discussions.microsoft.com> wrote in message
>> news:41DCA968-5E67-4D8B-B66A-3E9A83E5E214@.microsoft.com...
>> The webcast on Report Builder mentioned that you can run reports that
>> were
>> created in Report Designer in Report Builder. Is it possible?
>>
>sql

Does Report Builder have exposed APIs just like Reporting Services?

Dear Anyone,

Does Report Builder have exposed APIs just like Reporting Services?

The reason I asked is that we would like to customize Report Builder to some extent to fit to our client's specific requirements.

Can anyone shed a light on this?

Thanks,
JosephIf you are asking about the Report Builder client, then no, you can't change it. If you are looking for APIs for publishing models, generating models, executeing queries, or setting model item security, then those APIs are there.|||

Where is this API found? Can I reference these in a .net project? Any links on more info for this?

Thanks for all your help.

Marvin

Does Report Builder have exposed APIs just like Reporting Services?

Dear Anyone,

Does Report Builder have exposed APIs just like Reporting Services?

The reason I asked is that we would like to customize Report Builder to some extent to fit to our client's specific requirements.

Can anyone shed a light on this?

Thanks,
JosephIf you are asking about the Report Builder client, then no, you can't change it. If you are looking for APIs for publishing models, generating models, executeing queries, or setting model item security, then those APIs are there.|||

Where is this API found? Can I reference these in a .net project? Any links on more info for this?

Thanks for all your help.

Marvin

Does Report Builder have exposed APIs just like Reporting Services?

Dear Anyone,

Does Report Builder have exposed APIs just like Reporting Services?

The reason I asked is that we would like to customize Report Builder to some extent to fit to our client's specific requirements.

Can anyone shed a light on this?

Thanks,
JosephIf you are asking about the Report Builder client, then no, you can't change it. If you are looking for APIs for publishing models, generating models, executeing queries, or setting model item security, then those APIs are there.|||

Where is this API found? Can I reference these in a .net project? Any links on more info for this?

Thanks for all your help.

Marvin

Does Report 2005 work with VS.Net 2003

Does anyone know if Report Services 2005 work with Visual Studio 2003?
Thanks,
JimNo it does not. It is based on the 2.0 framework while VS 2003 uses the 1.1
framework.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:B45A2196-4CF4-4053-91FE-96E1373E4BB1@.microsoft.com...
> Does anyone know if Report Services 2005 work with Visual Studio 2003?
> Thanks,
> Jim|||If I install .Net Framework 2.0 can I use VS 2003 to develop using SSRS2005
API or are there any other build dependencies( like new features in C# )
that force me to use VS 2005 ?
thanks,Ravi
"Bruce L-C [MVP]" wrote:
> No it does not. It is based on the 2.0 framework while VS 2003 uses the 1.1
> framework.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:B45A2196-4CF4-4053-91FE-96E1373E4BB1@.microsoft.com...
> > Does anyone know if Report Services 2005 work with Visual Studio 2003?
> > Thanks,
> > Jim
>
>|||VS 2003 does not work with 2.0 framework as far as I know. Regardless, VS
2005 requires VS 2005 codebase. By that I mean, if you have VS 2005 it will
integrate with it, otherwise RS 2005 ships with a version of VS 2005 for
developing reports.
Since it comes with everything needed to develop reports (unlike RS 2000
that required you have some version of VS) then there is really no need or
reason that I can see that whether it works with VS 2005 is an issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ravi" <Ravi@.discussions.microsoft.com> wrote in message
news:629F6531-23A5-4ECF-BA78-8ABF639F26A6@.microsoft.com...
> If I install .Net Framework 2.0 can I use VS 2003 to develop using
> SSRS2005
> API or are there any other build dependencies( like new features in C# )
> that force me to use VS 2005 ?
> thanks,Ravi
> "Bruce L-C [MVP]" wrote:
>> No it does not. It is based on the 2.0 framework while VS 2003 uses the
>> 1.1
>> framework.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:B45A2196-4CF4-4053-91FE-96E1373E4BB1@.microsoft.com...
>> > Does anyone know if Report Services 2005 work with Visual Studio 2003?
>> > Thanks,
>> > Jim
>>|||Thanks for the response.
I did realized that installing SSRS 2005 installs Business Intelligence
Development Studio which allows creation of models and reports using Report
Designer. However, if I need to write custom code using C# that uses SSRS
2005 API such as ReportingServices2005( for things like executing the report
programmatically), I still need the C# compiler and the rest of the Visual
Studio features that are not part of Business Intelligence Dev Studio.
My queston was, can I do the above with VS 2003( with .net Framework 2.0
installed ) or do I need VS 2005 ?
thanks for your time,
Ravi
"Bruce L-C [MVP]" wrote:
> VS 2003 does not work with 2.0 framework as far as I know. Regardless, VS
> 2005 requires VS 2005 codebase. By that I mean, if you have VS 2005 it will
> integrate with it, otherwise RS 2005 ships with a version of VS 2005 for
> developing reports.
> Since it comes with everything needed to develop reports (unlike RS 2000
> that required you have some version of VS) then there is really no need or
> reason that I can see that whether it works with VS 2005 is an issue.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ravi" <Ravi@.discussions.microsoft.com> wrote in message
> news:629F6531-23A5-4ECF-BA78-8ABF639F26A6@.microsoft.com...
> > If I install .Net Framework 2.0 can I use VS 2003 to develop using
> > SSRS2005
> > API or are there any other build dependencies( like new features in C# )
> > that force me to use VS 2005 ?
> >
> > thanks,Ravi
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No it does not. It is based on the 2.0 framework while VS 2003 uses the
> >> 1.1
> >> framework.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> news:B45A2196-4CF4-4053-91FE-96E1373E4BB1@.microsoft.com...
> >> > Does anyone know if Report Services 2005 work with Visual Studio 2003?
> >> > Thanks,
> >> > Jim
> >>
> >>
> >>
>
>|||I am referring to these requiremens:
http://msdn2.microsoft.com/en-us/library/ms153578(en-US,SQL.90).aspx
"Ravi" wrote:
> Thanks for the response.
> I did realized that installing SSRS 2005 installs Business Intelligence
> Development Studio which allows creation of models and reports using Report
> Designer. However, if I need to write custom code using C# that uses SSRS
> 2005 API such as ReportingServices2005( for things like executing the report
> programmatically), I still need the C# compiler and the rest of the Visual
> Studio features that are not part of Business Intelligence Dev Studio.
> My queston was, can I do the above with VS 2003( with .net Framework 2.0
> installed ) or do I need VS 2005 ?
> thanks for your time,
> Ravi
> "Bruce L-C [MVP]" wrote:
> > VS 2003 does not work with 2.0 framework as far as I know. Regardless, VS
> > 2005 requires VS 2005 codebase. By that I mean, if you have VS 2005 it will
> > integrate with it, otherwise RS 2005 ships with a version of VS 2005 for
> > developing reports.
> >
> > Since it comes with everything needed to develop reports (unlike RS 2000
> > that required you have some version of VS) then there is really no need or
> > reason that I can see that whether it works with VS 2005 is an issue.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Ravi" <Ravi@.discussions.microsoft.com> wrote in message
> > news:629F6531-23A5-4ECF-BA78-8ABF639F26A6@.microsoft.com...
> > > If I install .Net Framework 2.0 can I use VS 2003 to develop using
> > > SSRS2005
> > > API or are there any other build dependencies( like new features in C# )
> > > that force me to use VS 2005 ?
> > >
> > > thanks,Ravi
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> No it does not. It is based on the 2.0 framework while VS 2003 uses the
> > >> 1.1
> > >> framework.
> > >>
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > >> news:B45A2196-4CF4-4053-91FE-96E1373E4BB1@.microsoft.com...
> > >> > Does anyone know if Report Services 2005 work with Visual Studio 2003?
> > >> > Thanks,
> > >> > Jim
> > >>
> > >>
> > >>
> >
> >
> >|||RS 2005 supports both the 2000 web services api and the 2005 web services
api. I don't think it should make any difference if you are developing this
in VS 2003 or VS 2005. Web services know nothing about what you are calling
the web services from and you can do web services from either environment.
Note you are calling a web service, you are not creating a web service.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ravi" <Ravi@.discussions.microsoft.com> wrote in message
news:F6E4063A-DB69-471E-AAA6-C70FF80362B6@.microsoft.com...
>I am referring to these requiremens:
> http://msdn2.microsoft.com/en-us/library/ms153578(en-US,SQL.90).aspx
> "Ravi" wrote:
>> Thanks for the response.
>> I did realized that installing SSRS 2005 installs Business Intelligence
>> Development Studio which allows creation of models and reports using
>> Report
>> Designer. However, if I need to write custom code using C# that uses
>> SSRS
>> 2005 API such as ReportingServices2005( for things like executing the
>> report
>> programmatically), I still need the C# compiler and the rest of the
>> Visual
>> Studio features that are not part of Business Intelligence Dev Studio.
>> My queston was, can I do the above with VS 2003( with .net Framework 2.0
>> installed ) or do I need VS 2005 ?
>> thanks for your time,
>> Ravi
>> "Bruce L-C [MVP]" wrote:
>> > VS 2003 does not work with 2.0 framework as far as I know. Regardless,
>> > VS
>> > 2005 requires VS 2005 codebase. By that I mean, if you have VS 2005 it
>> > will
>> > integrate with it, otherwise RS 2005 ships with a version of VS 2005
>> > for
>> > developing reports.
>> >
>> > Since it comes with everything needed to develop reports (unlike RS
>> > 2000
>> > that required you have some version of VS) then there is really no need
>> > or
>> > reason that I can see that whether it works with VS 2005 is an issue.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Ravi" <Ravi@.discussions.microsoft.com> wrote in message
>> > news:629F6531-23A5-4ECF-BA78-8ABF639F26A6@.microsoft.com...
>> > > If I install .Net Framework 2.0 can I use VS 2003 to develop using
>> > > SSRS2005
>> > > API or are there any other build dependencies( like new features in
>> > > C# )
>> > > that force me to use VS 2005 ?
>> > >
>> > > thanks,Ravi
>> > >
>> > > "Bruce L-C [MVP]" wrote:
>> > >
>> > >> No it does not. It is based on the 2.0 framework while VS 2003 uses
>> > >> the
>> > >> 1.1
>> > >> framework.
>> > >>
>> > >>
>> > >> --
>> > >> Bruce Loehle-Conger
>> > >> MVP SQL Server Reporting Services
>> > >>
>> > >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> > >> news:B45A2196-4CF4-4053-91FE-96E1373E4BB1@.microsoft.com...
>> > >> > Does anyone know if Report Services 2005 work with Visual Studio
>> > >> > 2003?
>> > >> > Thanks,
>> > >> > Jim
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >

Does Link in Subscription Point to Live or Snapshot?

This should be an easy one...

You get an email that contains a link to a report. The email was sent automatically as part of a subscription.

Does that link point to a snapshot that was taken when the report was run, or does clicking the link cause the report to re-run altogether?

Thanks,
Dan

Hello Dan,

The link will always point to the current report. For instance, if you have an email subscription that goes out at 6am daily, and today at 8am, you open the report from the link in today's and yesterday's email, they both will take you to the most current report.

As for if it will be re-run, that depends on how you have the execution on the report setup. Whether it is 'Always run this report with the most recent data' or 'Render this report from a report execution snapshot' will determine this.

Hope this helps.

Jarret

|||

Hi Jarret,

That's exactly what I needed to know.

Thanks so much!

Dan

does Level() do anything?

enclosed is the complete rdl for a report that has a table, contains groups
and calls the level function.
Returns the current level of depth in a recursive hierarchy. it looks like
the recursive part does not work?
what am I missing here?
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>1.25in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>14</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>group name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>13</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>12</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=level()</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="unique_name">
<Style>
<PaddingLeft>30pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>unique_name</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!unique_name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>= iif( Fields!unique_name.Value is Nothing,
"Null","Not Null")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=level()</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Width>6.83334in</Width>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="group_name">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Gray</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>group_name</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!group_name.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Gray</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Gray</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>textbox12</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=level()</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields!group_id.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="sub_group_name">
<Style>
<PaddingLeft>10pt</PaddingLeft>
<BackgroundColor>Silver</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>sub_group_name</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!sub_group_name.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Silver</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox17</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Silver</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox18</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=level()</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group2">
<GroupExpressions>
<GroupExpression>=Fields!sub_group_id.Value</GroupExpression>
</GroupExpressions>
<Parent>=Fields!group_id.Value</Parent>
</Grouping>
</TableGroup>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="family_name">
<Style>
<PaddingLeft>20pt</PaddingLeft>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>family_name</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!family_name.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox23</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>= iif(Fields!family_name.Value=Nothing,"Null","Not Null")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox24">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox24</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=level()</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table1_Group3">
<GroupExpressions>
<GroupExpression>=Fields!family_id.Value</GroupExpression>
</GroupExpressions>
<Parent>=Fields!sub_group_id.Value</Parent>
</Grouping>
<Visibility>
<Hidden>= iif(Fields!family_name.Value=Nothing,True,False)</Hidden>
</Visibility>
</TableGroup>
</TableGroups>
<TableColumns>
<TableColumn>
<Width>2.5in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>1.75in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="datasource">
<rd:DataSourceID>6f542575-d325-4bbe-8889-0ce5d6439aa6</rd:DataSourceID>
<DataSourceReference>datasource</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.95833in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="group_name">
<DataField>group_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="group_id">
<DataField>group_id</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="sub_group_name">
<DataField>sub_group_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="sub_group_id">
<DataField>sub_group_id</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="family_name">
<DataField>family_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="family_id">
<DataField>family_id</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="unique_id">
<DataField>unique_id</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="unique_name">
<DataField>unique_name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>datasource</DataSourceName>
<CommandText>select 'group 1' as group_name, 1 as group_id, 'sub
group 1' as sub_group_name, 1 as sub_group_id, null as family_name, null as
family_id, null as unique_id, null as unique_name
union
select 'group 1' as group_name, 1 as group_id, 'sub group 1' as
sub_group_name, 1 as sub_group_id, 'family 1' as family_name, 1 as family_id,
1 as unique_id, '1' as unique_name
union
select 'group 1' as group_name, 1 as group_id, 'sub group 1' as
sub_group_name, 1 as sub_group_id, 'family 1' as family_name, 1 as family_id,
2 as unique_id, '2' as unique_name
union
select 'group 1' as group_name, 1 as group_id, 'sub group 2' as
sub_group_name, 2 as sub_group_id, 'family 2' as family_name, 2 as family_id,
3 as unique_id, '3' as unique_name
union
select 'group 2' as group_name, 2 as group_id, 'sub group 2' as
sub_group_name, 2 as sub_group_id, 'family 2' as family_name, 2 as family_id,
4 as unique_id, '4' as unique_name</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>eec2b812-624b-4368-8fcc-a696fe0d2f30</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>Level function is for recursive hierarchies, which are tables that link back
to themselves. If you create a table such as...
CategoryID CategoryParent
1 0
2 1
3 1
4 0
5 4
6 4
7 4
8 2
9 2
10 2
11 9
12 10
13 12
and set your query to be
Select t1.CategoryID, t2.CategoryID as Subordinates from Sometable t1 left
outer join Sometable t2 on t1.Categoryid = t2.CategoryParent
Then you could use the level function to tell you how far each category node
is nested.
"letuce dance" wrote:
> enclosed is the complete rdl for a report that has a table, contains groups
> and calls the level function.
> Returns the current level of depth in a recursive hierarchy. it looks like
> the recursive part does not work?
> what am I missing here?
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>1.25in</Height>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>14</ZIndex>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>group name</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox2">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>13</ZIndex>
> <rd:DefaultName>textbox2</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox3">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>12</ZIndex>
> <rd:DefaultName>textbox3</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=level()</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="unique_name">
> <Style>
> <PaddingLeft>30pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>unique_name</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!unique_name.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox5">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>textbox5</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>= iif( Fields!unique_name.Value is Nothing,
> "Null","Not Null")</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox6">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox6</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=level()</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <DataSetName>DataSet1</DataSetName>
> <Width>6.83334in</Width>
> <TableGroups>
> <TableGroup>
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="group_name">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>Gray</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>11</ZIndex>
> <rd:DefaultName>group_name</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=First(Fields!group_name.Value)</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox11">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>Gray</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>10</ZIndex>
> <rd:DefaultName>textbox11</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox12">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>Gray</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>9</ZIndex>
> <rd:DefaultName>textbox12</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=level()</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Grouping Name="table1_Group1">
> <GroupExpressions>
> <GroupExpression>=Fields!group_id.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> </TableGroup>
> <TableGroup>
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="sub_group_name">
> <Style>
> <PaddingLeft>10pt</PaddingLeft>
> <BackgroundColor>Silver</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>8</ZIndex>
> <rd:DefaultName>sub_group_name</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=First(Fields!sub_group_name.Value)</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox17">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>Silver</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>7</ZIndex>
> <rd:DefaultName>textbox17</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox18">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>Silver</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>6</ZIndex>
> <rd:DefaultName>textbox18</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=level()</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Grouping Name="table1_Group2">
> <GroupExpressions>
> <GroupExpression>=Fields!sub_group_id.Value</GroupExpression>
> </GroupExpressions>
> <Parent>=Fields!group_id.Value</Parent>
> </Grouping>
> </TableGroup>
> <TableGroup>
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="family_name">
> <Style>
> <PaddingLeft>20pt</PaddingLeft>
> <BackgroundColor>Gainsboro</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>family_name</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=First(Fields!family_name.Value)</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox23">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BackgroundColor>Gainsboro</BackgroundColor>
> <PaddingBottom>2pt</PaddingBottom>|||ya I think I provided that example? an example that shows level() does not
work?
"Jace" wrote:
> Level function is for recursive hierarchies, which are tables that link back
> to themselves. If you create a table such as...
> CategoryID CategoryParent
> 1 0
> 2 1
> 3 1
> 4 0
> 5 4
> 6 4
> 7 4
> 8 2
> 9 2
> 10 2
> 11 9
> 12 10
> 13 12
> and set your query to be
> Select t1.CategoryID, t2.CategoryID as Subordinates from Sometable t1 left
> outer join Sometable t2 on t1.Categoryid = t2.CategoryParent
> Then you could use the level function to tell you how far each category node
> is nested.
>
> "letuce dance" wrote:
> > enclosed is the complete rdl for a report that has a table, contains groups
> > and calls the level function.
> >
> > Returns the current level of depth in a recursive hierarchy. it looks like
> > the recursive part does not work?
> >
> > what am I missing here?
> >
> > <?xml version="1.0" encoding="utf-8"?>
> > <Report
> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
> > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > <RightMargin>1in</RightMargin>
> > <Body>
> > <ReportItems>
> > <Table Name="table1">
> > <Height>1.25in</Height>
> > <Style />
> > <Header>
> > <TableRows>
> > <TableRow>
> > <Height>0.25in</Height>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox1">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>14</ZIndex>
> > <rd:DefaultName>textbox1</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>group name</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox2">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>13</ZIndex>
> > <rd:DefaultName>textbox2</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox3">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>12</ZIndex>
> > <rd:DefaultName>textbox3</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=level()</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > </TableRow>
> > </TableRows>
> > </Header>
> > <Details>
> > <TableRows>
> > <TableRow>
> > <Height>0.25in</Height>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="unique_name">
> > <Style>
> > <PaddingLeft>30pt</PaddingLeft>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>2</ZIndex>
> > <rd:DefaultName>unique_name</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=Fields!unique_name.Value</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox5">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>1</ZIndex>
> > <rd:DefaultName>textbox5</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>= iif( Fields!unique_name.Value is Nothing,
> > "Null","Not Null")</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox6">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <rd:DefaultName>textbox6</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=level()</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > </TableRow>
> > </TableRows>
> > </Details>
> > <DataSetName>DataSet1</DataSetName>
> > <Width>6.83334in</Width>
> > <TableGroups>
> > <TableGroup>
> > <Header>
> > <TableRows>
> > <TableRow>
> > <Height>0.25in</Height>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="group_name">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <BackgroundColor>Gray</BackgroundColor>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>11</ZIndex>
> > <rd:DefaultName>group_name</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=First(Fields!group_name.Value)</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox11">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <BackgroundColor>Gray</BackgroundColor>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>10</ZIndex>
> > <rd:DefaultName>textbox11</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox12">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <BackgroundColor>Gray</BackgroundColor>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>9</ZIndex>
> > <rd:DefaultName>textbox12</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=level()</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > </TableRow>
> > </TableRows>
> > </Header>
> > <Grouping Name="table1_Group1">
> > <GroupExpressions>
> > <GroupExpression>=Fields!group_id.Value</GroupExpression>
> > </GroupExpressions>
> > </Grouping>
> > </TableGroup>
> > <TableGroup>
> > <Header>
> > <TableRows>
> > <TableRow>
> > <Height>0.25in</Height>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="sub_group_name">
> > <Style>
> > <PaddingLeft>10pt</PaddingLeft>
> > <BackgroundColor>Silver</BackgroundColor>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>8</ZIndex>
> > <rd:DefaultName>sub_group_name</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=First(Fields!sub_group_name.Value)</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox17">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <BackgroundColor>Silver</BackgroundColor>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>7</ZIndex>
> > <rd:DefaultName>textbox17</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox18">
> > <Style>
> > <PaddingLeft>2pt</PaddingLeft>
> > <BackgroundColor>Silver</BackgroundColor>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingTop>2pt</PaddingTop>
> > <PaddingRight>2pt</PaddingRight>
> > </Style>
> > <ZIndex>6</ZIndex>
> > <rd:DefaultName>textbox18</rd:DefaultName>
> > <CanGrow>true</CanGrow>
> > <Value>=level()</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > </TableRow>
> > </TableRows>
> > </Header>
> > <Grouping Name="table1_Group2">
> > <GroupExpressions>
> > <GroupExpression>=Fields!sub_group_id.Value</GroupExpression>
> > </GroupExpressions>
> > <Parent>=Fields!group_id.Value</Parent>
> > </Grouping>
> > </TableGroup>
> > <TableGroup>
> > <Header>|||What query in your example is joined back to itself? I didnt see one. I
believe you have to have this for the level function to work.
"letuce dance" wrote:
> ya I think I provided that example? an example that shows level() does not
> work?
> "Jace" wrote:
> > Level function is for recursive hierarchies, which are tables that link back
> > to themselves. If you create a table such as...
> >
> > CategoryID CategoryParent
> > 1 0
> > 2 1
> > 3 1
> > 4 0
> > 5 4
> > 6 4
> > 7 4
> > 8 2
> > 9 2
> > 10 2
> > 11 9
> > 12 10
> > 13 12
> >
> > and set your query to be
> > Select t1.CategoryID, t2.CategoryID as Subordinates from Sometable t1 left
> > outer join Sometable t2 on t1.Categoryid = t2.CategoryParent
> >
> > Then you could use the level function to tell you how far each category node
> > is nested.
> >
> >
> > "letuce dance" wrote:
> >
> > > enclosed is the complete rdl for a report that has a table, contains groups
> > > and calls the level function.
> > >
> > > Returns the current level of depth in a recursive hierarchy. it looks like
> > > the recursive part does not work?
> > >
> > > what am I missing here?
> > >
> > > <?xml version="1.0" encoding="utf-8"?>
> > > <Report
> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > > <RightMargin>1in</RightMargin>
> > > <Body>
> > > <ReportItems>
> > > <Table Name="table1">
> > > <Height>1.25in</Height>
> > > <Style />
> > > <Header>
> > > <TableRows>
> > > <TableRow>
> > > <Height>0.25in</Height>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox1">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>14</ZIndex>
> > > <rd:DefaultName>textbox1</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>group name</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox2">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>13</ZIndex>
> > > <rd:DefaultName>textbox2</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox3">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>12</ZIndex>
> > > <rd:DefaultName>textbox3</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=level()</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > </TableRow>
> > > </TableRows>
> > > </Header>
> > > <Details>
> > > <TableRows>
> > > <TableRow>
> > > <Height>0.25in</Height>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="unique_name">
> > > <Style>
> > > <PaddingLeft>30pt</PaddingLeft>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>2</ZIndex>
> > > <rd:DefaultName>unique_name</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=Fields!unique_name.Value</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox5">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>1</ZIndex>
> > > <rd:DefaultName>textbox5</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>= iif( Fields!unique_name.Value is Nothing,
> > > "Null","Not Null")</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox6">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <rd:DefaultName>textbox6</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=level()</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > </TableRow>
> > > </TableRows>
> > > </Details>
> > > <DataSetName>DataSet1</DataSetName>
> > > <Width>6.83334in</Width>
> > > <TableGroups>
> > > <TableGroup>
> > > <Header>
> > > <TableRows>
> > > <TableRow>
> > > <Height>0.25in</Height>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="group_name">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <BackgroundColor>Gray</BackgroundColor>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>11</ZIndex>
> > > <rd:DefaultName>group_name</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=First(Fields!group_name.Value)</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox11">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <BackgroundColor>Gray</BackgroundColor>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>10</ZIndex>
> > > <rd:DefaultName>textbox11</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox12">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <BackgroundColor>Gray</BackgroundColor>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>9</ZIndex>
> > > <rd:DefaultName>textbox12</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=level()</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > </TableRow>
> > > </TableRows>
> > > </Header>
> > > <Grouping Name="table1_Group1">
> > > <GroupExpressions>
> > > <GroupExpression>=Fields!group_id.Value</GroupExpression>
> > > </GroupExpressions>
> > > </Grouping>
> > > </TableGroup>
> > > <TableGroup>
> > > <Header>
> > > <TableRows>
> > > <TableRow>
> > > <Height>0.25in</Height>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="sub_group_name">
> > > <Style>
> > > <PaddingLeft>10pt</PaddingLeft>
> > > <BackgroundColor>Silver</BackgroundColor>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>8</ZIndex>
> > > <rd:DefaultName>sub_group_name</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=First(Fields!sub_group_name.Value)</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox17">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <BackgroundColor>Silver</BackgroundColor>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>7</ZIndex>
> > > <rd:DefaultName>textbox17</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox18">
> > > <Style>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <BackgroundColor>Silver</BackgroundColor>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingTop>2pt</PaddingTop>
> > > <PaddingRight>2pt</PaddingRight>
> > > </Style>
> > > <ZIndex>6</ZIndex>
> > > <rd:DefaultName>textbox18</rd:DefaultName>
> > > <CanGrow>true</CanGrow>
> > > <Value>=level()</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > </TableRow>
> > > </TableRows>
> > > </Header>
> > > <Grouping Name="table1_Group2">
> > > <GroupExpressions>
> > > <GroupExpression>=Fields!sub_group_id.Value</GroupExpression>
> > > </GroupExpressions>