Tuesday, March 27, 2012
grant total for hide duplicate...
ItemNo Area Barcode Total
1 J 12345 15
1 J 2222 15
in report, i use hide duplicate and displayed like:
ItemNo Area Barcode Total
1 J 12345 15
2222
total: 30
the problem is the total...what i wanted is 15 and no 30.i use
"=Round(sum(Fields!Total.Value,"ItemClass"),3),3" in that textbox expression.
what should i do to get the firgue what i wanted.....
i really appreciate your helps...thank a lot
--
thanksWhat you should do is to have 15 on both and the total is 30. instead if you
show just 15 and total 30, it is a kind of misleading...
so you can hide textbox wise all the values except total.
Amarnath
"kevintts" wrote:
> for my query in dataset after join few tables, i got following data:
> ItemNo Area Barcode Total
> 1 J 12345 15
> 1 J 2222 15
> in report, i use hide duplicate and displayed like:
> ItemNo Area Barcode Total
> 1 J 12345 15
> 2222
> total: 30
> the problem is the total...what i wanted is 15 and no 30.i use
> "=Round(sum(Fields!Total.Value,"ItemClass"),3),3" in that textbox expression.
> what should i do to get the firgue what i wanted.....
> i really appreciate your helps...thank a lot
> --
> thanks|||thanks Amarnath, but what i want is hide or minus the total and the total
become 15.
let say:
ItemNo Area Barcode Total
1 J 12345 15
1 J 2222 15
2 K 54321 20
i got:
ItemNo Area Barcode Total
1 J 12345 15
2222
2 K 54321 20
total: 50
what i wanted:
ItemNo Area Barcode Total
1 J 12345 15
2222
2 K 54321 20
total: 35
The value for '2222' still in the group. any thing wrong with the
exspression"=Round(sum(Fields!Total.Value,"ItemClass"),3),3"?
thanks a lot...
"Amarnath" wrote:
> What you should do is to have 15 on both and the total is 30. instead if you
> show just 15 and total 30, it is a kind of misleading...
> so you can hide textbox wise all the values except total.
> Amarnath
>
> "kevintts" wrote:
> > for my query in dataset after join few tables, i got following data:
> > ItemNo Area Barcode Total
> > 1 J 12345 15
> > 1 J 2222 15
> >
> > in report, i use hide duplicate and displayed like:
> > ItemNo Area Barcode Total
> > 1 J 12345 15
> > 2222
> > total: 30
> >
> > the problem is the total...what i wanted is 15 and no 30.i use
> > "=Round(sum(Fields!Total.Value,"ItemClass"),3),3" in that textbox expression.
> >
> > what should i do to get the firgue what i wanted.....
> > i really appreciate your helps...thank a lot
> >
> > --
> > thanks|||Expression is ok but since the text box is hidden, but the value exists so it
sums up.
If possible can you get this through query. e.g the values not present
should be null. in your case '2222' should have Total as Null. so when you
sum it sums up exactly.
Amarnath
"RE: grant total for hide duplicate..." wrote:
> thanks Amarnath, but what i want is hide or minus the total and the total
> become 15.
> let say:
> ItemNo Area Barcode Total
> 1 J 12345 15
> 1 J 2222 15
> 2 K 54321 20
> i got:
> ItemNo Area Barcode Total
> 1 J 12345 15
> 2222
> 2 K 54321 20
> total: 50
> what i wanted:
> ItemNo Area Barcode Total
> 1 J 12345 15
> 2222
> 2 K 54321 20
> total: 35
> The value for '2222' still in the group. any thing wrong with the
> exspression"=Round(sum(Fields!Total.Value,"ItemClass"),3),3"?
> thanks a lot...
> "Amarnath" wrote:
> > What you should do is to have 15 on both and the total is 30. instead if you
> > show just 15 and total 30, it is a kind of misleading...
> >
> > so you can hide textbox wise all the values except total.
> >
> > Amarnath
> >
> >
> > "kevintts" wrote:
> >
> > > for my query in dataset after join few tables, i got following data:
> > > ItemNo Area Barcode Total
> > > 1 J 12345 15
> > > 1 J 2222 15
> > >
> > > in report, i use hide duplicate and displayed like:
> > > ItemNo Area Barcode Total
> > > 1 J 12345 15
> > > 2222
> > > total: 30
> > >
> > > the problem is the total...what i wanted is 15 and no 30.i use
> > > "=Round(sum(Fields!Total.Value,"ItemClass"),3),3" in that textbox expression.
> > >
> > > what should i do to get the firgue what i wanted.....
> > > i really appreciate your helps...thank a lot
> > >
> > > --
> > > thanks
Friday, March 23, 2012
Grant Database Access
I am setting up report services after I installed the report server add-ins
on sharepoint 2007.
at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.
at second step, Grant Database Access,
I put ssrsdev1 for server name (default instance) and then click OK and then
I put the user name (a member of local admin group on ssrsdev1) and password,
but I always got errors says:
Unable to log on with the given username and password.
what wrong here? what should I check? I am sure the user and password is
right and I can log on to ssrsdev1 physically with admin right without any
problem.
thanks for any thought on this.
zwp
Is SharePoint 2007 also installed on ssrsdev1?
If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?
thanx,
Prash
we installed sharepoint 2007 bianry on ssrsdev1 (report server with sp2). and the user is a domain user and a member of local admin group. Actually, the report server, sql server and sharepoint all run under domain user (also a member of local admin group). When we tried to use user name domain\user and we got a error says: the group name can't find; when we use user or user@.domain.com to connect, we got the error I posted before. We tried to reinstall the sharepoint 2007 and still got same problem.
Thanks in advance for your help.
D.
|||In you care you should use <domain_name>\<user> format.
In any case, in "Grant Database Access" we essentially try to add the Reporting Services service accounts to the WSS_WPG windows group. The WSS_WPG windows group should have been created when you installed SharePoint.
Can you verfy whether ssrsdev1 has a WSS_WPG windows group?
thanx,
Prash
the windows group are on both report servers (ssrsdev1 and it also is the content database server for sharepoint server) and sharepoint server (spserver). I have manually added the user account into this grouop in both server, but I still get the same error.
Actually, I installed and running everything (report server and its services, sql server, and sharepoint, etc.) with the same domain user which is a member of local admin group on both boxes, therefore, the user should have access to everything, but I don’t understand why I am still have the problem with ‘grant database access’. Is it a bug?
BTW, we use sharepoing 2007 and sp2 December 2006 CTP.
Thanks,
zwp
|||I just posted a message. Sorry it was my bad. I might mistype something. It works now.
However, when I go to next step:
Set server defaults
I got error message:
Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.
I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?
BTW, in sp2 BOL, it says: Verify the installation
use this address:
http://example-server-name:8081/reportserver
the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else
thanks again.
zwp.
|||http://example-server-name:<port>/reportserver
example-server-name = the server on which Report Server is installed
<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.
Hope this helps.
thanx,
Prash
could someone let me know how to find user :'sharepoint\system' since I can't find it in computer manager. I bet it is a system account used by sharepoint but how to set the permission to it. I got following
The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation. > The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation.
when I at screen:
Reporting Services Server Defaults
thanks.
|||Generally you should open another thread for a different issue.
In any case, are you able to upload / view reports in other SharePoint web sites?
Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?
thanx,
Prash
Hi,
I've experienced the same problem.
In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:
The group name could not be found
In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul
My SQL server 2005 with SP 2 is installed in another server.
Any advice?
Paul
|||The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.
HTH
Prash
|||
Thanks.
Actually, I can setup the SharePoint Integration in a single-box (MOSS+SQL). So, as you said, WSS_WPG is in the same machine. However, as my SQL server is installed in another server. What can I do? (I did create a group called WSS_WPG manually in the SQL server, but still failed)
Any idea?
Paul
|||Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.
For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.
HTH
Prash
Grant Database Access
I am setting up report services after I installed the report server add-ins
on sharepoint 2007.
at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.
at second step, Grant Database Access,
I put ssrsdev1 for server name (default instance) and then click OK and then
I put the user name (a member of local admin group on ssrsdev1) and password,
but I always got errors says:
Unable to log on with the given username and password.
what wrong here? what should I check? I am sure the user and password is
right and I can log on to ssrsdev1 physically with admin right without any
problem.
thanks for any thought on this.
zwp
Is SharePoint 2007 also installed on ssrsdev1?
If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?
thanx,
Prash
we installed sharepoint 2007 bianry on ssrsdev1 (report server with sp2). and the user is a domain user and a member of local admin group. Actually, the report server, sql server and sharepoint all run under domain user (also a member of local admin group). When we tried to use user name domain\user and we got a error says: the group name can't find; when we use user or user@.domain.com to connect, we got the error I posted before. We tried to reinstall the sharepoint 2007 and still got same problem.
Thanks in advance for your help.
D.
|||In you care you should use <domain_name>\<user> format.
In any case, in "Grant Database Access" we essentially try to add the Reporting Services service accounts to the WSS_WPG windows group. The WSS_WPG windows group should have been created when you installed SharePoint.
Can you verfy whether ssrsdev1 has a WSS_WPG windows group?
thanx,
Prash
the windows group are on both report servers (ssrsdev1 and it also is the content database server for sharepoint server) and sharepoint server (spserver). I have manually added the user account into this grouop in both server, but I still get the same error.
Actually, I installed and running everything (report server and its services, sql server, and sharepoint, etc.) with the same domain user which is a member of local admin group on both boxes, therefore, the user should have access to everything, but I don’t understand why I am still have the problem with ‘grant database access’. Is it a bug?
BTW, we use sharepoing 2007 and sp2 December 2006 CTP.
Thanks,
zwp
|||I just posted a message. Sorry it was my bad. I might mistype something. It works now.
However, when I go to next step:
Set server defaults
I got error message:
Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.
I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?
BTW, in sp2 BOL, it says: Verify the installation
use this address:
http://example-server-name:8081/reportserver
the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else
thanks again.
zwp.
|||http://example-server-name:<port>/reportserver
example-server-name = the server on which Report Server is installed
<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.
Hope this helps.
thanx,
Prash
could someone let me know how to find user :'sharepoint\system' since I can't find it in computer manager. I bet it is a system account used by sharepoint but how to set the permission to it. I got following
The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation. > The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation.
when I at screen:
Reporting Services Server Defaults
thanks.
|||Generally you should open another thread for a different issue.
In any case, are you able to upload / view reports in other SharePoint web sites?
Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?
thanx,
Prash
Hi,
I've experienced the same problem.
In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:
The group name could not be found
In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul
My SQL server 2005 with SP 2 is installed in another server.
Any advice?
Paul
|||The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.
HTH
Prash
|||
Thanks.
Actually, I can setup the SharePoint Integration in a single-box (MOSS+SQL). So, as you said, WSS_WPG is in the same machine. However, as my SQL server is installed in another server. What can I do? (I did create a group called WSS_WPG manually in the SQL server, but still failed)
Any idea?
Paul
|||Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.
For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.
HTH
Prash
Wednesday, March 21, 2012
Grand totals page
We have a report that includes a list that expands down to 17 inches to accomodate two pages for a report and this list is grouped on a particular location. Each report is grouped by State. So in each state there can be many locations that report various items that comprimse two pages.
Now, what we need is a "state grand total" page and I am wondering about the best way to go about doing this. We do not want to create a new report with a separate stored proc that returns grand totals. What we would like is to do a running total or something like that. I could then include this on a subreport, but I need it to be the last page. For some reason, I thought there was a Report Footer section, but I only see Page Footer.
I hope I made myself clear enough and not being too confusing and I many thanks for any helpful information.
guyinkalamazoo3 wrote:
We do not want to create a new report with a separate stored proc that returns grand totals.
This is how I handle it. The auto total feature in RS is horrific IMO.
Grand Totals in Report Footer?
my report footer. But if I add a field to the footer:
=Fields!Period_MonthToDate_Measures_B.Value
The footer shows the total of only the first item in the highest level
group. If I use a sum function:
=Sum(Fields!Period_MonthToDate_Measures_B.Value)
The total is five times the actual total, I guess due to the fact that
I have five levels.
How do I show the correct report total?
Thanks,
BurtBurt - I have been looking for an answer to a similar question - It would
strongly appear that MS didn't include this type of feature in this
release...and that is a kind way of putting it.
-KB
"Burt" <burt_5920@.yahoo.com> wrote in message
news:19e5f39f.0407271554.6cc831f0@.posting.google.com...
> I have a table report with five groups and want to add grand totals to
> my report footer. But if I add a field to the footer:
> =Fields!Period_MonthToDate_Measures_B.Value
> The footer shows the total of only the first item in the highest level
> group. If I use a sum function:
> =Sum(Fields!Period_MonthToDate_Measures_B.Value)
> The total is five times the actual total, I guess due to the fact that
> I have five levels.
> How do I show the correct report total?
> Thanks,
> Burt|||i had the same problem and i solved it with the runningvalue
did u try using RunningValue'
Grand Total of an iif expression
utilization totals based on the username. Some users have a Utilization = 100% for only 12 or 17 hours and other have a Utilization = 100% for 40
hours. At the group level, I can calculate the utilization with the
following formula...
=iif ( Fields!zUserID.Value ="USER1 ",
(Sum( Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
Fields!zQtyBilled.Value , "GroupUserName")) / 12 ,
iif ( Fields!zUserID.Value ="USER2 ", (Sum(
Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
Fields!zQtyBilled.Value , "GroupUserName")) / 17 , (Sum(
Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
Fields!zQtyBilled.Value , "GroupUserName")) / 40 ))
However, my issue is how do I get a grand total of this utilization on the
report footer. I cannot sum () this formula in the report footer. I receive
an error becuase of the "GroupUserName" parameter.
Is there a way to use the sum () function in the Report Footer and just
reference the name of the textbox in the group footer and it's corresponding
value that has already been calculated for each group?I probably do not understand your question very well, but you might try to
simply do the sum without regard to the groupings ( simply take out the
groups) and do the sum for the entire data set...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Jack Bender" wrote:
> I have a report grouped on the user. The report calculates various
> utilization totals based on the username. Some users have a Utilization => 100% for only 12 or 17 hours and other have a Utilization = 100% for 40
> hours. At the group level, I can calculate the utilization with the
> following formula...
> =iif ( Fields!zUserID.Value ="USER1 ",
> (Sum( Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
> Fields!zQtyBilled.Value , "GroupUserName")) / 12 ,
> iif ( Fields!zUserID.Value ="USER2 ", (Sum(
> Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
> Fields!zQtyBilled.Value , "GroupUserName")) / 17 , (Sum(
> Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
> Fields!zQtyBilled.Value , "GroupUserName")) / 40 ))
> However, my issue is how do I get a grand total of this utilization on the
> report footer. I cannot sum () this formula in the report footer. I receive
> an error becuase of the "GroupUserName" parameter.
> Is there a way to use the sum () function in the Report Footer and just
> reference the name of the textbox in the group footer and it's corresponding
> value that has already been calculated for each group?
>|||The issue here is that I need a conditional total and percentage calculation
based on the users that billed time in the report. If User 1 and/or User 2
are in the report, then they have different criterias for utilization
calcualtons than everyone else. All other users are based on 40 hours a
week. I determine this already at the group footer, so it would be much
easier just to grand total the cell value of the group footer then to
re-engineer the formula for the report footer.
"Wayne Snyder" wrote:
> I probably do not understand your question very well, but you might try to
> simply do the sum without regard to the groupings ( simply take out the
> groups) and do the sum for the entire data set...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Jack Bender" wrote:
> > I have a report grouped on the user. The report calculates various
> > utilization totals based on the username. Some users have a Utilization => > 100% for only 12 or 17 hours and other have a Utilization = 100% for 40
> > hours. At the group level, I can calculate the utilization with the
> > following formula...
> >
> > =iif ( Fields!zUserID.Value ="USER1 ",
> > (Sum( Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
> > Fields!zQtyBilled.Value , "GroupUserName")) / 12 ,
> >
> > iif ( Fields!zUserID.Value ="USER2 ", (Sum(
> > Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
> > Fields!zQtyBilled.Value , "GroupUserName")) / 17 , (Sum(
> > Fields!zBillingWorkQty.Value , "GroupUserName") + Sum(
> > Fields!zQtyBilled.Value , "GroupUserName")) / 40 ))
> >
> > However, my issue is how do I get a grand total of this utilization on the
> > report footer. I cannot sum () this formula in the report footer. I receive
> > an error becuase of the "GroupUserName" parameter.
> >
> > Is there a way to use the sum () function in the Report Footer and just
> > reference the name of the textbox in the group footer and it's corresponding
> > value that has already been calculated for each group?
> >
> >
Grand Total in Matrixes
I am working on matrix report that uses 3 matrixes like below.
In Grand Total matrix, I want to sum matrix 1 and matrix2 subtotals and
display as Grand Total. I had a difficulty to find out the expression for
this(how to reference the subtotals in matrixes?)?
Can we do this or any limitations?
Matrix 1:
Week1 Week2
Sub Total 10 20
Matrix 2:
Week1 Week2
Sub Total 15 25
Grand Total
Week1 Week2
Grand Total 25 45
Any pointers in this regard is appreciated
Thanks
BhaskarOn Nov 16, 5:08 pm, Bhaskar <Bhas...@.discussions.microsoft.com> wrote:
> Hi,
> I am working on matrix report that uses 3 matrixes like below.
> In Grand Total matrix, I want to sum matrix 1 and matrix2 subtotals and
> display as Grand Total. I had a difficulty to find out the expression for
> this(how to reference the subtotals in matrixes?)?
> Can we do this or any limitations?
> Matrix 1:
> Week1 Week2
> Sub Total 10 20
> Matrix 2:
> Week1 Week2
> Sub Total 15 25
> Grand Total
> Week1 Week2
> Grand Total 25 45
> Any pointers in this regard is appreciated
> Thanks
> Bhaskar
Since you have multiple columns that have subtotals, you most likely
will want to sum the subtotals together as part of another report
dataset (via a separate stored procedure/query). If there was only one
subtotal column per matrix, you might have been able to reference
aggregates via an expression similar to this.
=Sum(Fields!Week1.Value, "dsMatrix1") + Sum(Fields!Week1.Value,
"dsMatrix2")
Where dsMatrix1 and dsMatrix2 are the example dataset names used for
Matrix1 and Matrix2 respectively.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique. yeah.. i tried to avoid another query or sp to get the grand
total.
looks like there is no other way. :)
Bhaskar
"EMartinez" wrote:
> On Nov 16, 5:08 pm, Bhaskar <Bhas...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I am working on matrix report that uses 3 matrixes like below.
> >
> > In Grand Total matrix, I want to sum matrix 1 and matrix2 subtotals and
> > display as Grand Total. I had a difficulty to find out the expression for
> > this(how to reference the subtotals in matrixes?)?
> > Can we do this or any limitations?
> >
> > Matrix 1:
> >
> > Week1 Week2
> > Sub Total 10 20
> >
> > Matrix 2:
> > Week1 Week2
> > Sub Total 15 25
> >
> > Grand Total
> >
> > Week1 Week2
> > Grand Total 25 45
> >
> > Any pointers in this regard is appreciated
> >
> > Thanks
> > Bhaskar
>
> Since you have multiple columns that have subtotals, you most likely
> will want to sum the subtotals together as part of another report
> dataset (via a separate stored procedure/query). If there was only one
> subtotal column per matrix, you might have been able to reference
> aggregates via an expression similar to this.
> =Sum(Fields!Week1.Value, "dsMatrix1") + Sum(Fields!Week1.Value,
> "dsMatrix2")
> Where dsMatrix1 and dsMatrix2 are the example dataset names used for
> Matrix1 and Matrix2 respectively.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Grand Total for field problem
Hello,
In my SRS report, I have a field called "Alternate" where I need to check to find out if my picklist value = 2. This works out just great.
I have created a variable called "Total_Alternate". I don't seem to be able to get the right Grand Total here by using the code below
(1) Value in expression field for textbox9 - gives right total in this field for each group
=SUM(IIF(Fields!new_rpcstatus.value=2, CInt(Fields!Total_Alternate.value), 0))
(2) Value in Table Footer for the above field - doesn't give me the right number
=(Fields!Total_Alternate.Value)
What am I doing wrong?
If you want
number then
=Count(Fields!Total_Alternate.Value)
or if you want sum of these then
=Sum(Fields!Total_Alternate.Value)
sqlGrabbing CURRENT Parameter Data
(Parameters!SRNumber.Value), it grabs the data from when the "View Report"
button was originally pressed. My goal is to allow someone to punch in new
data into a parameter and without having to re-run the report, be able to use
that for an action. Any ideas? Example of what I am attempting to do below.
= "mailto:" + Fields!SOURCE_EMAIL.Value + "?subject=SR #"
+Parameters!SRNumber.Value + " has been assigned to you"...
(SRNumber is a blank parameter which isn't actually used in any of my
queries, but rather just there for this purpose)On Dec 12, 5:25 pm, Peetaah <Peet...@.discussions.microsoft.com> wrote:
> So it looks like when you add an expression which grabs a parameter value
> (Parameters!SRNumber.Value), it grabs the data from when the "View Report"
> button was originally pressed. My goal is to allow someone to punch in new
> data into a parameter and without having to re-run the report, be able to use
> that for an action. Any ideas? Example of what I am attempting to do below.
> = "mailto:" + Fields!SOURCE_EMAIL.Value + "?subject=SR #"
> +Parameters!SRNumber.Value + " has been assigned to you"...
> (SRNumber is a blank parameter which isn't actually used in any of my
> queries, but rather just there for this purpose)
This is a long shot, but you could try using javascript. Normally, the
last value selected before the View Report button is selected is shown
in an expression based on a parameter. Sorry that I could not be of
further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, that is what I was thinking too-- just hoping there was a secret call
I could make to get the current value :)
"EMartinez" wrote:
> On Dec 12, 5:25 pm, Peetaah <Peet...@.discussions.microsoft.com> wrote:
> > So it looks like when you add an expression which grabs a parameter value
> > (Parameters!SRNumber.Value), it grabs the data from when the "View Report"
> > button was originally pressed. My goal is to allow someone to punch in new
> > data into a parameter and without having to re-run the report, be able to use
> > that for an action. Any ideas? Example of what I am attempting to do below.
> >
> > = "mailto:" + Fields!SOURCE_EMAIL.Value + "?subject=SR #"
> > +Parameters!SRNumber.Value + " has been assigned to you"...
> > (SRNumber is a blank parameter which isn't actually used in any of my
> > queries, but rather just there for this purpose)
>
> This is a long shot, but you could try using javascript. Normally, the
> last value selected before the View Report button is selected is shown
> in an expression based on a parameter. Sorry that I could not be of
> further assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Dec 12, 10:21 pm, Peetaah <Peet...@.discussions.microsoft.com>
wrote:
> Thanks, that is what I was thinking too-- just hoping there was a secret call
> I could make to get the current value :)
> "EMartinez" wrote:
> > On Dec 12, 5:25 pm, Peetaah <Peet...@.discussions.microsoft.com> wrote:
> > > So it looks like when you add an expression which grabs a parameter value
> > > (Parameters!SRNumber.Value), it grabs the data from when the "View Report"
> > > button was originally pressed. My goal is to allow someone to punch in new
> > > data into a parameter and without having to re-run the report, be able to use
> > > that for an action. Any ideas? Example of what I am attempting to do below.
> > > = "mailto:" + Fields!SOURCE_EMAIL.Value + "?subject=SR #"
> > > +Parameters!SRNumber.Value + " has been assigned to you"...
> > > (SRNumber is a blank parameter which isn't actually used in any of my
> > > queries, but rather just there for this purpose)
> > This is a long shot, but you could try using javascript. Normally, the
> > last value selected before the View Report button is selected is shown
> > in an expression based on a parameter. Sorry that I could not be of
> > further assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Grab hand and magnifing glass?
report that is native to Adobe PDF viewer? It makes it much more intuitive
for the end user to grab the page to scroll up/down or click with the
magnifying glass to zoom in/out. Please don't tell me this isn't
available... Without those basic features, the report looks pretty darn
cheap.What format are you rendering? If you are rendering in PDF then the PDF
viewer is being used and those things should be available. Otherwise, the
answer is no.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:284CE966-B4C3-451D-8C34-BBFFCAF753B3@.microsoft.com...
> Is there anyway to display the familiar grab hand and magnifying glass on
> the
> report that is native to Adobe PDF viewer? It makes it much more
> intuitive
> for the end user to grab the page to scroll up/down or click with the
> magnifying glass to zoom in/out. Please don't tell me this isn't
> available... Without those basic features, the report looks pretty darn
> cheap.
Gr
I pass in a field called delivery date
i want the report in 3 sections
Overdue, Today and future
however i am as yet able to find a way to have these 3 logical groupings
thanks frankI need it to know what todays date is.
i did have it working howver for each date it put in the heading|||>>I need it to know what todays date is.
Use currentdate in the formaulasql
Monday, March 19, 2012
Got HTML tags in my source, but need the text only on my Report..
does anybody know how i can convince SRS to not show things like <DIV> , etc. ? Any Property of a Field or so ?
if not
2. Question :
Any Idea of how to do this in .NET programmatically ? There must be such a function !
HTML in -> Text out
Any hint would be appreciated !
best
regards
Robin
Try this: Right-click on the whitespace around the report and click on 'Properties' and then the Code tab.
In that spot put this function:
public shared function StripHTML(strInput as string) as string
Return System.Text.RegularExpressions.Regex.Replace(strInput, "<[^>]*>", "", System.Text.RegularExpressions.RegexOptions.IgnoreCase)
end function
For the textbox or whatever make the expression say '=Code.StripHTML(Fields!DivTag.Value)'
This will strip anything surrounded by '<' and '>'
Let me know if this works
Slick - I like!
Got an error when applying Template to the Report
I produced a report in Crystal V9,the report which i got was WITHOUT template.
The Report i generated was the Statndard report.
Now i want to apply template for this report.
For this i clicked on the "Template Expert Button", selected the "Block(Blue)"[Pre Defined Template] and clicked on OK Button
Now i got an error saying "Could Not Apply Template to Document"
How to Handle this error
I want to apply the template for the report.If you are using chart or if the page is too large or small, you may get this problem
Google Maps
Services?
Thank you,
Alain Quesnel
alainsansspam@.logiquel.comOn Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> Has anybody tried to display a Google Map inside a report using Reporting
> Services?
> Thank you,
> Alain Quesnel
> alainsanss...@.logiquel.com
You could add a textbox control to the report and give it a string
value and set it to a Google Maps URL (via: right-click the textbox
contol -> select Properties -> Navigation -> Jump to URL:). Hope this
is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'm already doing that, thanks. It's fine for a pdf file or for viewing the
report online. But once it's printed, thank link is no longer useful. I was
hoping to do something similar to a Windows app or a web page that has a
Google map frame in it.
Thanks,
Alain Quesnel
alainsansspam@.logiquel.com
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1183083791.675971.61680@.k79g2000hse.googlegroups.com...
> On Jun 26, 9:43 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
> wrote:
>> Has anybody tried to display a Google Map inside a report using Reporting
>> Services?
>> Thank you,
>> Alain Quesnel
>> alainsanss...@.logiquel.com
>
> You could add a textbox control to the report and give it a string
> value and set it to a Google Maps URL (via: right-click the textbox
> contol -> select Properties -> Navigation -> Jump to URL:). Hope this
> is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Friday, March 9, 2012
good matrix tutorial
Hello,
I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:
http://msdn2.microsoft.com/en-us/library/ms157334.aspx
Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.
With regard to your Out of Memory error... how many rows are being returned from your DataSet?
If you have any specific questions, feel free to post them here.
-Chris
|||I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.
I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).
Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.
good matrix tutorial
Hello,
I don't know of any third party tutorials specifically, but have you seen the Books Online topic about Matrices?:
http://msdn2.microsoft.com/en-us/library/ms157334.aspx
Also, the AdventureWorks sample report "Company Sales" has a simple example of a matrix with nested toggleable groups on both rows and columns.
With regard to your Out of Memory error... how many rows are being returned from your DataSet?
If you have any specific questions, feel free to post them here.
-Chris
|||I'm experiencing this out of memory error too: I have one database which I can connect to, which gives me around 300 rows, and that's fine. However, another database which returns around 6000 rows throws an out of memory exception when I try to run the report.
I'm guessing that a matrix report has to load all the data in to an internal list, and this is causing the problem. Seems a bit of a weakness to me though: for my application, most of our clients are likely to produce a large number of rows for this report, so I'll have to come up with another solution (or a different report).
Does anyone know if there is any way to change the memory available to the report? It would be nice to have an idea of how much is required, too.
Wednesday, March 7, 2012
Going crazy
I have a report with a couple sub reports. The sub reports seem to want to
spread to the complete width of the report plus more causing multiple pages
to be used (for the information that is pushed off the right edge).
I have tried to use tables, rectangles etc. but i cannot get the contents of
the report from spreading. It appears the rectangle works for the report but
the sub reports spread out as much as possible.
I have tried putting the sub reports in rectanges, grids and still have the
problem
I am using vs.net 2005 and sql 2005
Help please.Two things matter here. The design of the subreport and where you put the
subreport on the page. Run the subreport by itself, how big is it? Look at
the layout properties of the subreport.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dave" <dave@.discussions.microsoft.com> wrote in message
news:39888271-A207-4302-843F-16B1CA1E6B74@.microsoft.com...
> Ok, what is the secret, I give.
> I have a report with a couple sub reports. The sub reports seem to want
> to
> spread to the complete width of the report plus more causing multiple
> pages
> to be used (for the information that is pushed off the right edge).
> I have tried to use tables, rectangles etc. but i cannot get the contents
> of
> the report from spreading. It appears the rectangle works for the report
> but
> the sub reports spread out as much as possible.
> I have tried putting the sub reports in rectanges, grids and still have
> the
> problem
> I am using vs.net 2005 and sql 2005
> Help please.
>
Going back after "jump to report"
I jumped from one report to enter (useing the "jump to report"
option).
How can I go back to the first report?
I tried with the "backspace" button and I tried useing
"javascript:history(-1)".
ThanksAre you talking about the development environement or deployed to the
server? Because the normal IE back button works when deployed to the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nicknack" <roezohar@.gmail.com> wrote in message
news:ed6b57e2-aa78-481b-93c8-05e30f2a21cd@.d27g2000prf.googlegroups.com...
> Hi,
> I jumped from one report to enter (useing the "jump to report"
> option).
> How can I go back to the first report?
> I tried with the "backspace" button and I tried useing
> "javascript:history(-1)".
> Thanks
>|||Hi Bruce,
Sorry for not giving enough details.
I've deployed the report to my sql server.
The report is in a window that was opened with javascript with no
toolbar.
I've tried hitting the "backspace" button but it doesn't response.
Whan I try to right clivk the report with my mouse I see that the
"back" option in the popup menu is in gray.
Can it be because I have SP1 on my server?
Is that the problem?
Did you heared about a problem like that?
Thank for your help.
On 6 =D7=93=D7=A6=D7=9E=D7=91=D7=A8, 17:13, "Bruce L-C [MVP]" <bruce_lcNOS.=..@.hotmail.com>
wrote:
> Are you talking about the development environement or deployed to the
> server? Because the normal IE back button works when deployed to the serve=r.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "nicknack" <roezo...@.gmail.com> wrote in message
> news:ed6b57e2-aa78-481b-93c8-05e30f2a21cd@.d27g2000prf.googlegroups.com...
> > Hi,
> > I jumped from one report to enter (useing the "jump to report"
> > option).
> > How can I go back to the first report?
> > I tried with the "backspace" button and I tried useing
> > "javascript:history(-1)".
> > Thanks|||So you hosting this from your own website? This is not using Report Manager
(the portal that ships with RS)?
Also, I am a little confused. When you say jump to report. What that means
is you have a report, then in that report you put an action on a textbox or
a cell in the table object (I then make the text blue and underlined so the
user knows to click on it). Is that what you are doing?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nicknack" <roezohar@.gmail.com> wrote in message
news:0c3555c3-d6b1-41dc-b21a-3276030918cd@.a39g2000pre.googlegroups.com...
Hi Bruce,
Sorry for not giving enough details.
I've deployed the report to my sql server.
The report is in a window that was opened with javascript with no
toolbar.
I've tried hitting the "backspace" button but it doesn't response.
Whan I try to right clivk the report with my mouse I see that the
"back" option in the popup menu is in gray.
Can it be because I have SP1 on my server?
Is that the problem?
Did you heared about a problem like that?
Thank for your help.
On 6 '?, 17:13, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Are you talking about the development environement or deployed to the
> server? Because the normal IE back button works when deployed to the
> server.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "nicknack" <roezo...@.gmail.com> wrote in message
> news:ed6b57e2-aa78-481b-93c8-05e30f2a21cd@.d27g2000prf.googlegroups.com...
> > Hi,
> > I jumped from one report to enter (useing the "jump to report"
> > option).
> > How can I go back to the first report?
> > I tried with the "backspace" button and I tried useing
> > "javascript:history(-1)".
> > Thanks|||Hi,
I have an aspx page with a link to my report (which is on my sql
server).
the link open in a new internt explorer window.
Yes, thats what I do with the "jump to rport". I have a table cell
eith an action define that use the "jump to report" option" and get
another report name.
after I'm going to the second report, I want to go back to the first
one.
For some reason all the "back" options are not working.
Hope I made my self more clear.
Any way, I'm not sure I'll be near my pc for the next two days so I
hope to reply to user next answer on sunday.
Thanks for your help.
On 6 =D7=93=D7=A6=D7=9E=D7=91=D7=A8, 18:17, "Bruce L-C [MVP]" <bruce_lcNOS.=..@.hotmail.com>
wrote:
> So you hosting this from your own website? This is not using Report Manage=r
> (the portal that ships with RS)?
> Also, I am a little confused. When you say jump to report. What that means=
> is you have a report, then in that report you put an action on a textbox o=r
> a cell in the table object (I then make the text blue and underlined so th=e
> user knows to click on it). Is that what you are doing?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "nicknack" <roezo...@.gmail.com> wrote in message
> news:0c3555c3-d6b1-41dc-b21a-3276030918cd@.a39g2000pre.googlegroups.com...
> Hi Bruce,
> Sorry for not giving enough details.
> I've deployed the report to my sql server.
> The report is in a window that was opened with javascript with no
> toolbar.
> I've tried hitting the "backspace" button but it doesn't response.
> Whan I try to right clivk the report with my mouse I see that the
> "back" option in the popup menu is in gray.
> Can it be because I have SP1 on my server?
> Is that the problem?
> Did you heared about a problem like that?
> Thank for your help.
> On 6 '?, 17:13, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
> > Are you talking about the development environement or deployed to the
> > server? Because the normal IE back button works when deployed to the
> > server.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "nicknack" <roezo...@.gmail.com> wrote in message
> >news:ed6b57e2-aa78-481b-93c8-05e30f2a21cd@.d27g2000prf.googlegroups.com...=
> > > Hi,
> > > I jumped from one report to enter (useing the "jump to report"
> > > option).
> > > How can I go back to the first report?
> > > I tried with the "backspace" button and I tried useing
> > > "javascript:history(-1)".
> > > Thanks|||My guess is there is something specific to how you are initially opening the
report. That the way you are doing this is preventing the back button from
working. If you try the same report from Report Manager my bet is you will
see that everything works as it should. Try the following as a test. Instead
of opening a report try opening up another website that has a link to click
on. And see if the back button works from you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nicknack" <roezohar@.gmail.com> wrote in message
news:54347394-a645-4f05-a22b-1a3e31db25da@.e25g2000prg.googlegroups.com...
Hi,
I have an aspx page with a link to my report (which is on my sql
server).
the link open in a new internt explorer window.
Yes, thats what I do with the "jump to rport". I have a table cell
eith an action define that use the "jump to report" option" and get
another report name.
after I'm going to the second report, I want to go back to the first
one.
For some reason all the "back" options are not working.
Hope I made my self more clear.
Any way, I'm not sure I'll be near my pc for the next two days so I
hope to reply to user next answer on sunday.
Thanks for your help.
On 6 '?, 18:17, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> So you hosting this from your own website? This is not using Report
> Manager
> (the portal that ships with RS)?
> Also, I am a little confused. When you say jump to report. What that means
> is you have a report, then in that report you put an action on a textbox
> or
> a cell in the table object (I then make the text blue and underlined so
> the
> user knows to click on it). Is that what you are doing?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "nicknack" <roezo...@.gmail.com> wrote in message
> news:0c3555c3-d6b1-41dc-b21a-3276030918cd@.a39g2000pre.googlegroups.com...
> Hi Bruce,
> Sorry for not giving enough details.
> I've deployed the report to my sql server.
> The report is in a window that was opened with javascript with no
> toolbar.
> I've tried hitting the "backspace" button but it doesn't response.
> Whan I try to right clivk the report with my mouse I see that the
> "back" option in the popup menu is in gray.
> Can it be because I have SP1 on my server?
> Is that the problem?
> Did you heared about a problem like that?
> Thank for your help.
> On 6 '?, 17:13, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
> > Are you talking about the development environement or deployed to the
> > server? Because the normal IE back button works when deployed to the
> > server.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "nicknack" <roezo...@.gmail.com> wrote in message
> >news:ed6b57e2-aa78-481b-93c8-05e30f2a21cd@.d27g2000prf.googlegroups.com...
> > > Hi,
> > > I jumped from one report to enter (useing the "jump to report"
> > > option).
> > > How can I go back to the first report?
> > > I tried with the "backspace" button and I tried useing
> > > "javascript:history(-1)".
> > > Thanks
Sunday, February 26, 2012
Globals.Referrer?
We need to setup a report so that it only runs if the referrer is a certain
URL. This is so that end users cannot directly navigate to the report (or
if they know the URL, plop it into the address bar and navigate there).
Instead, we'd like the report to check if they're coming from a particular
application and run ONLY if it sees that it's coming from that application.
Any ideas?
Any help would be greatly appreciated!
Benjamin PierceI would
Try to write some code to override the on_init method of the report and
check for the referrer
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:uWIxXNyWFHA.3240@.TK2MSFTNGP10.phx.gbl...
> Regards,
> We need to setup a report so that it only runs if the referrer is a
> certain
> URL. This is so that end users cannot directly navigate to the report (or
> if they know the URL, plop it into the address bar and navigate there).
> Instead, we'd like the report to check if they're coming from a particular
> application and run ONLY if it sees that it's coming from that
> application.
> Any ideas?
> Any help would be greatly appreciated!
>
> Benjamin Pierce
>|||Is the On_Imit method part of SQL 2005 Reporting Services? I wasn't aware
of report methods in SQL 2000.
Let me know.
Thanks!
Ben
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%237pUQr4WFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I would
> Try to write some code to override the on_init method of the report and
> check for the referrer
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:uWIxXNyWFHA.3240@.TK2MSFTNGP10.phx.gbl...
> > Regards,
> >
> > We need to setup a report so that it only runs if the referrer is a
> > certain
> > URL. This is so that end users cannot directly navigate to the report
(or
> > if they know the URL, plop it into the address bar and navigate there).
> > Instead, we'd like the report to check if they're coming from a
particular
> > application and run ONLY if it sees that it's coming from that
> > application.
> >
> > Any ideas?
> >
> > Any help would be greatly appreciated!
> >
> >
> > Benjamin Pierce
> >
> >
>
Globals!ReportName behaves differently when SSRS integrated with M
for the report title. In Development and on SSRS stand alone the value for
Globals!ReportName is in mixed case and the file extension is omitted. When
the report is published to a MOSS server integrated with SSRS the value for
Globals!ReportName is all in lower case and the file extension is included.
Is there any reason for this change in behavior and is there a way I can put
back the mixed case and omit the file extension?I just noticed this is also affecting the root level of the Document Map with
one exception. The case is all in lower case but the file extension is
omitted when rendered on MOSS. It works fine on SSRS.
"Ben Holcombe" wrote:
> I have a report where I use Globals!ReportName in the header of the report
> for the report title. In Development and on SSRS stand alone the value for
> Globals!ReportName is in mixed case and the file extension is omitted. When
> the report is published to a MOSS server integrated with SSRS the value for
> Globals!ReportName is all in lower case and the file extension is included.
> Is there any reason for this change in behavior and is there a way I can put
> back the mixed case and omit the file extension?