Hide Fields on Export

When I export to a file, say excel, I want certain textboxes to not show up.
How can I hide them on export?
bradSorry, this is not possible. You can only hide based on e.g. report
parameters.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"bradtm" <bradtm@.discussions.microsoft.com> wrote in message
news:9145ACFB-54E5-4BFC-82B4-0368B7AFA0FE@.microsoft.com...
> When I export to a file, say excel, I want certain textboxes to not show
> up.
> How can I hide them on export?
> brad|||Don't forget, though, if you use your own "export" button through a
custom interface, setting the rs:FORMAT=PDF or similar, you can set a
report parameter that can be referenced to show or hide selected fields.

Hide Certain reports from users

Hi All,
Is it any way to hide a particular report from listing in the report folder?
My actual problem is I deployed 2 reports in the report server and one of
them is a subreport. And I want the users should able to run only the main
report and not the subreport.
TIA,
SamuelIn report manager go to the properties page, the general sub tab there is a
check box for 'Hide in List View'. When a users browses to that folder in
the report manger (using list view, not detail view) then they will not see
that item.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:ui1uXhybEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> Is it any way to hide a particular report from listing in the report
folder?
> My actual problem is I deployed 2 reports in the report server and one of
> them is a subreport. And I want the users should able to run only the main
> report and not the subreport.
> TIA,
> Samuel
>|||Hi Daniel,
I already tried that option too. But I want to restrict the user in both
views. Is any way to hide reports in details view?
Or Can I deploy subreport in a different directory and refer it in the main
report?
Thanks,
Samuel
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23nz1AO0bEHA.2944@.TK2MSFTNGP11.phx.gbl...
> In report manager go to the properties page, the general sub tab there is
a
> check box for 'Hide in List View'. When a users browses to that folder in
> the report manger (using list view, not detail view) then they will not
see
> that item.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Samuel" <samuel@.photoninfotech.com> wrote in message
> news:ui1uXhybEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Hi All,
> >
> > Is it any way to hide a particular report from listing in the report
> folder?
> > My actual problem is I deployed 2 reports in the report server and one
of
> > them is a subreport. And I want the users should able to run only the
main
> > report and not the subreport.
> >
> > TIA,
> > Samuel
> >
> >
>|||I think you can put the subreport in a sub directory. However the directory
will still be visible to users. There is no way to completly hide the
report outside of using permissions, but then the users could not run the
report.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:ejH7Eu6bEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi Daniel,
> I already tried that option too. But I want to restrict the user in both
> views. Is any way to hide reports in details view?
> Or Can I deploy subreport in a different directory and refer it in the
main
> report?
> Thanks,
> Samuel
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23nz1AO0bEHA.2944@.TK2MSFTNGP11.phx.gbl...
> > In report manager go to the properties page, the general sub tab there
is
> a
> > check box for 'Hide in List View'. When a users browses to that folder
in
> > the report manger (using list view, not detail view) then they will not
> see
> > that item.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Samuel" <samuel@.photoninfotech.com> wrote in message
> > news:ui1uXhybEHA.384@.TK2MSFTNGP10.phx.gbl...
> > > Hi All,
> > >
> > > Is it any way to hide a particular report from listing in the report
> > folder?
> > > My actual problem is I deployed 2 reports in the report server and one
> of
> > > them is a subreport. And I want the users should able to run only the
> main
> > > report and not the subreport.
> > >
> > > TIA,
> > > Samuel
> > >
> > >
> >
> >
>

Hide Certain Parameters Dynamically

We have a number of reports which are used by both employees and
administrators with multiple parameters. In many of these reports we have
some parameters unique to the employees which we would like to automatically
set through URL access for our employees and either hide or set them as
read-only so an employee cannot view someone else's data. However, we want
to allow the administrators to change these values so they can view data from
any employee.
So, is there any way to dynamically hide a single parameter while still
showing the remaining ones, or to dynamically make a single parameter
read-only without creating a custom front end? I don't need to know how to
pass default values, just how to programmatically change what parameters are
hidden / read-only.
Thanks in advance.
DavidDavid,
It isn't possible to hide a parameter or make it readonly. A possible
solution for this problem is to create two new reports. One for the employees
and one for the administartors. Both reports get the proper parameters which
they may change. In both reports you include an subreport, the original one
with all parameters. Now you can link the parameters from the report to the
subreport. In teh case for the employees this meens that some parameters of
your original report will have an fixed value.
This solution will also prevent employees from 'trying' out the parameters
with URL Access.
Jan Pieter Posthuma
"David Siebert" wrote:
> We have a number of reports which are used by both employees and
> administrators with multiple parameters. In many of these reports we have
> some parameters unique to the employees which we would like to automatically
> set through URL access for our employees and either hide or set them as
> read-only so an employee cannot view someone else's data. However, we want
> to allow the administrators to change these values so they can view data from
> any employee.
> So, is there any way to dynamically hide a single parameter while still
> showing the remaining ones, or to dynamically make a single parameter
> read-only without creating a custom front end? I don't need to know how to
> pass default values, just how to programmatically change what parameters are
> hidden / read-only.
> Thanks in advance.
> David|||Thanks for the reply, I think I may have found a way that will work for our
needs using linked reports. I created a linked report to the original, and
hid any parameters that the employee does not need to change. It solves the
problem of having to maintain and edit 2 reports when changes are made, and
appears to have solved my issue with being able to change parameter settings
for the 2 separate versions.
"Jan Pieter Posthuma" wrote:
> David,
> It isn't possible to hide a parameter or make it readonly. A possible
> solution for this problem is to create two new reports. One for the employees
> and one for the administartors. Both reports get the proper parameters which
> they may change. In both reports you include an subreport, the original one
> with all parameters. Now you can link the parameters from the report to the
> subreport. In teh case for the employees this meens that some parameters of
> your original report will have an fixed value.
> This solution will also prevent employees from 'trying' out the parameters
> with URL Access.
> Jan Pieter Posthuma
> "David Siebert" wrote:
> > We have a number of reports which are used by both employees and
> > administrators with multiple parameters. In many of these reports we have
> > some parameters unique to the employees which we would like to automatically
> > set through URL access for our employees and either hide or set them as
> > read-only so an employee cannot view someone else's data. However, we want
> > to allow the administrators to change these values so they can view data from
> > any employee.
> >
> > So, is there any way to dynamically hide a single parameter while still
> > showing the remaining ones, or to dynamically make a single parameter
> > read-only without creating a custom front end? I don't need to know how to
> > pass default values, just how to programmatically change what parameters are
> > hidden / read-only.
> >
> > Thanks in advance.
> >
> > David

Hide an entire row if data in one firld is 0 or null

I want to be able to remove rows from the report if certain data in the row is 0. If a sales division has no sales for a district. there is no reason to show the district name or even to show an empty space for the row. I want to suppress the entire row without the user being able to see it or unhide it.

Is this possible?

You can accomplish this using filters. You can filter at the dataset, data region and grouping levels. You could also modify the SQL query to filter the data using the WHERE clause.

Here is more information on filter data in a Report.

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

Ian|||This will not work in the current context. There are multiple fields that get grouped at a division/region level

Hidden Subreport Executes Query

Using SRS 2000.
I have a subreport on my report that is only shown under certain conditions.
I have handled this successfully with the Hidden property.
I read somewhere that the hidden subreport would not execute, but if I
profile SQL server when I run the report the SQL is being executed.
Is there a way to suppress the SQL execution and speed up the report?I was unable to find an answer to this (could not find the original article
that set me down this path either). I devised a workaround that I will
post here in case anyone else is running into this.
For all the queries in my subreports, I add a NoExecute bit parameter. The
first thing I do in the query is then check to see If @.NoExectue = 1 I
SELECT a column list that is the same as my normal output, but all the
values are NULL and then return. This makes the query execute really fast
and minimizes the performance issue.
So for an example... If my query normally returns Name, Address, & Phone the
start of my query now looks like:
If @.NoExectue = 1
Begin
Select
NULL as Name,
NULL as Address,
NULL as Phone
Return
End
--Start the regular query here to return 'real' values.
"Joe L" <jjj@.lll.com> wrote in message
news:OW9f9ugdGHA.3484@.TK2MSFTNGP04.phx.gbl...
> Using SRS 2000.
> I have a subreport on my report that is only shown under certain
> conditions. I have handled this successfully with the Hidden property.
> I read somewhere that the hidden subreport would not execute, but if I
> profile SQL server when I run the report the SQL is being executed.
> Is there a way to suppress the SQL execution and speed up the report?
>

Hidden Items Still Taking Space on The Page

Hi everyone,
I have a report where I have a rectangle witha bunch of lists and
textboxes on it which I hide on a certain case. The problem is, its
still taking space on the report page when the report is generated. It
doesn't appear, but I get a big empty space...
Is there any way to let the other items move up a little bit so I don't
have a big gap on my report?
Note: I can't add it to another table since I have lists on the
rectangle...
Thank you,Anyone has any ideas about how to accomplish this by any chance? I am
pretty stuckk...|||Can you try turning "Can Shrink" to true so that when there is no data that
it will shrink to a smaller size and let everything else move up?
"Spartacus" wrote:
> Anyone has any ideas about how to accomplish this by any chance? I am
> pretty stuckk...
>|||If it possible on Image or Rectangle?
Image and Rectangle doesn't have CanShrink.
Any idea?
Thanks!
Angi
"KimB" <KimB@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:7DB5C4A0-0C88-4CE1-99A9-BB5BAE2E0F14@.microsoft.com...
> Can you try turning "Can Shrink" to true so that when there is no data
> that
> it will shrink to a smaller size and let everything else move up?
> "Spartacus" wrote:
>> Anyone has any ideas about how to accomplish this by any chance? I am
>> pretty stuckk...
>>

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

sql

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

HELP: problem with using xp_sendmail

below is code snippet (which im assuming is the cause of the problem) from a certain stored procedure

EXEC Master.dbo.xp_sendmail
@.dbuse = 'DanoneSSS',
@.recipients = 'xxx@.yyy.co.jp',
@.subject = 'mmm nnn',
@.message = @.parMessage,
@.query = 'SELECT CHECK_JS_CODE, CHECK_TYPE FROM T_CHECK_LOG WHERE CHECK_STATUS = 0 ORDER BY CHECK_ID',
@.attachments = 'ResultSet.txt',
@.attach_results = TRUE,
@.no_header = TRUE,
@.separator = '',
@.ansi_attachment = TRUE

as in my case, when i execute this particular stored procedure, SQL Server sends me the email AND with the necessary attachment

however, when i create a Job with "EXEC dbo.SOSOStoredProcedure," though the Job executes successfully, no EMAIL is sent to me.

the funny thing is, when i comment out the following lines

@.query = 'SELECT CHECK_JS_CODE, CHECK_TYPE FROM T_CHECK_LOG WHERE CHECK_STATUS = 0 ORDER BY CHECK_ID',
@.attachments = 'ResultSet.txt',
@.attach_results = TRUE,
@.no_header = TRUE,
@.separator = '',
@.ansi_attachment = TRUE

the Job executes successfully with an EMAIL being sent to me

does SQL Server's job CANNOT handle xp_sendmail that returns a RESULT set? or i may be mistaken somewhere...

thanks!Who is the owner of the job and what is the permission level ?|||Originally posted by rnealejr
Who is the owner of the job and what is the permission level ?

thanks for the reply...

but i did getting it working though...

by carefully reading through BO regarding xp_sendmail, it seems that in using xp_sendmail to send file attachments, the specific procedure must be defined in the master database. this is what i have done.

then, defined a permission level for the procedure's properties, and the specific entry in SQL Agent.

i may have gotten it working... but there still may be a gap in my understanding, and i would appreciate if anyone could check on this - Books Online could get so scarce in regards to explanations and examples.

again, thanks...|||the specific procedure must be defined in the master database

This is only done if the sa wants to conceal the behavior of xp_sendmail.
Which if that were the case you would have been unsuccessful regardless of where you ran the stored procedure.

then, defined a permission level for the procedure's properties, and the specific entry in SQL Agent.

Can you elaborate ?|||Alter the SP.
In the same sp, use exec master..xp_cmdshell 'isql "Your query" -o drive:\filename.txt etc'
Then remove the query portion from xp_sendmail.
Run the job again. It would work.|||I beleive (rightly or wrongly) that you are unable to run an open query within an xp_sendmail.

I am trying to run a stored procedure with an open query within it. wrapping it within an xp_sendmail.

Which fails.

Any sugestions on how to get this running.

Thanks