pop up requirement

how do we click on anything within the reports, pass the parameters to another reports and also make the drill thru report open in a new page

See this page for information on Report Interactivity, including jumping to other Reports or Urls, http://msdn2.microsoft.com/en-us/library/ms345258(sql.90).aspx

If you need to have the report open in a new window, then you will need to use the Jump to Url method using javascript, like the following,

=void(window.open('" & Globals!ReportServerUrl & "?/ReportName&rs:Command=Render&rs:Format=Html4.0&Parameter1=" & Fields!Field1.Value & "','_blank'))"

PolygonsCustomReportItem

Hi, Is it possible to modify the width of the Report item in the CRI? i.e:
public ChangeType Process()
{ this.m_CustomReportItem.Width = 0.5;
...
}
It doesn't seem to work, if anyone can help me.
Thank you,On Nov 27, 7:26 am, Jay <J...@.discussions.microsoft.com> wrote:
> Hi, Is it possible to modify the width of the Report item in the CRI? i.e:
> public ChangeType Process()
> { this.m_CustomReportItem.Width = 0.5;
> ...
> }
> It doesn't seem to work, if anyone can help me.
> Thank you,
In SSRS, I have not found any way to change the widge of the controls
dynamically. It appears that all of the controls have to have fixed
widths so the various Renderers known how to export them to .XLS, PDF,
etc.
I think you can only change the width of the ReportViewer object when
the ReportViewer is embedded in another application or web page, but
the objects in the Report RDL are fixed widths.
-- Scottsql

Polar Charting with Reporting Services

Does anyone know if you can do polar charting with Reporting Services? I have a need to report the polar coordinates of an element and show the polar chart of the data elements. If I can't do polar charting with Reporting Services, does anyone know of a third party product that I can utilize?

Thanks

KM

Dundas Chart controls allow polar charting (www.Dundas.com)

BobP

sql

Points to consider for Report Database.

Ok..ok, I'm trying to get some comment/ insight on what things to consider during developement of a
Reporting module with a Reporting Database. For those who had face problems, been doing something like this, maybe you like to share a tip or two.

Project:

Developing ASP/ ASP.NET applications through DNSless connection with either OLE or ADO drivers to a SQL Server Report Database. Users will login in the browser to view reports of their choice. Not using any OLAP cubes. It would simply be callling SPs and query the tables for data and displaying it in cuztomize HTML report formats. And of course with good indexing.

Project scope:

Enterprise/Factory scale -so to assume Reporting DB size easily over 50-70 GB.

QUESTIONS:

1. How many users can concurrently login to view reports? A rough estimate would be? Is there any unit of measurement to determine the number?

2. What are the best practices- in DB design and and on application development for this project case?

3. What are the hardware concerns/specs ( best/minimum recommendations)? Would network traffic play a role here?

Thanks in advance for sharing your comments.It depens on what kind of database is but anyway:

1. Quantity of users depends on database and application design (respond time, etc.)
2. Best way - to create datawarehouse
- denormalize tables (less joins)
- a lot of indexes
- access only by sp
- you could create a fake cubes (I did it - it works even better than MS cubes for my case)

3. Ask for more and get something better... ;)sql

Plzz help error failed to export crystal report

i ma trying to solve a problem for a couple of days and cannot get around it..I have installed the whole crystal report software on my development machine and have created a report.. and when i try to export it it gaves me failed to export error..if i try like html..it expots but for pdf and rtf it isn't..

on the other side i want to use this report in my vb application..for the time being since the crystal reports install all the files so i dont have to include runtime files for crystsal report to run with vb..i called the report and can export it in html but for pdf and other formats ..even i have enabled the enableexport button..it just doesnt do any thing..how ever when i try to do it manually..by code..pdf export it gives me the same error..failed to export..

i have reinstalled the whole things and this does not work can anyone plzz help meSearch for your solution here
http://support.businessobjects.com/

Plz Tell me what I did wrong...

I have a column in my crystal report(of VB.Net 2005),this column is a Balance where there's fo example '1000 C' or '1000D' in the page footer I want the sum of this column,since it's type is string because of the letters Cr and Db I created a formula,named SumBalance:

numberVar SumBalance;
SumBalance:=0;
whilereadingrecords;
if Right({StatOfAcc.Balance}, 1)="C" then
SumBalance=SumBalance-ToNumber(Left ({StatOfAcc.Balance},Length ({StatOfAcc.Balance})-2 ))
else
SumBalance= +ToNumber(Left ({StatOfAcc.Balance},Length ({StatOfAcc.Balance}) -2));

I had put this formula in the page footer it gave me False,and if I right click,
FormatObject,I find a tab Boolean,where did I specify that my formula is a boolean...Wher's my error...Plz Tell meI knew my wrong it's that I have to write
SumBalance := not SumBalance=

But this formula is not doing what I'm expecting to do,it give me the last Balance but I need the sum of all the line of the column Balance...|||You put the formula in the page footer, so it'll run once per page and it'll only work on the last record for the page.
If you move it to the detail section (where it should be to work on every record) you shouldn't reset SumBalance to 0 every time in the 2nd line, you should create a new formula for the page header to do this. You'll then need another formula for the page footer to display the balance.
Does a balance of 0 have either C or D after it?
Do you really want to subtract Credits and add Debits?
Your previous post said you had Cr or Db on the end of the balance, and this formula half says that too - you are checking the rightmost character for 'C' but then discarding the rightmost two characters to get the number.
And finally, what's the business logic in summing a balance field?

Plz help me In reports

Hi,Im Designed a Webpage .It consosts of a Button, whenever i click onButton report must generated.When the report is in my system reportgenerated successfully.when I try to access a report from othersystem.I cudnot able to access report.Can any1 hlp me inthis aspect.any procedure in order to access the report of other system.wht shudbe url for Reportserverurl and reportpath

With regards,

mahender

mahender,

Have you tried

http://server/reportserver/reportdirectory/reportname.rdl

Take note that

- "reportserver"is a virtual directory named during the reporting services install, so your could be something different, the default from memory is reprotserver

- I am assuming you created the directory the report resides in some replace "reportdirectory"with this

- you can pass any parameters thru this method also

- this is url access into reporting services, you can also utlise the web services to access your reports

If this doesnt work check out what type of security the other system uses. What user is your web app connecting as and does this user have access

An error msg would also be helpful

plz help me how to give reportname in Reportexecutionservice

Hi

Im trying to load a report using

Reportexecutionservice

like this

Reportexecutionservice.ExecutionInfo exinfo=res.LoadReport(reportname, null);

rptname consists of report which is present @. my server.How to give reportname inorder to load a report .im using reportingservice2005

plz do help me.

error im getting Unable to indentify the report.Plz tell what is path i should given in order to acces th report..

It needs to be the path to the report, not just the name. So if your report named "MyReport" is in a folder named "Reports", then the path would be "/MyReport/Reports".

|||

Hai,

thnx for reply.Well all reports r present in Server.i mean We had created couple of Report using Businessintelligence studio .we try to deploy reports @. our server.So how to access those reports

With regards,

mahender

|||Browse to http://servername/reports. That will show you the Report Manager application which will let you navigate around and find the path to the published reports. From code, you can accomplish this using the ListChildren() method.|||HI,
Thnx for once again .Ha u said to search the path from reportmanager.I open my server as
(10.150.100.184:100/report) I saw my reports deployed how abt path there r actually stored .i need to give actuall we give reportpathname as "reportdirectory\reportname" similary for Report @. my server how can i access is it like"\\10.150.142.186\reportdirectory\reportname".Im i right

Plz do replyme...

With regards,
mahender

plz help me how to give reportname in Reportexecutionservice

Hi

Im trying to load a report using

Reportexecutionservice

like this

Reportexecutionservice.ExecutionInfo exinfo=res.LoadReport(reportname, null);

rptname consists of report which is present @. my server.How to give reportname inorder to load a report .im using reportingservice2005

plz do help me.

error im getting Unable to indentify the report.Plz tell what is path i should given in order to acces th report..

It needs to be the path to the report, not just the name. So if your report named "MyReport" is in a folder named "Reports", then the path would be "/MyReport/Reports".

|||

Hai,

thnx for reply.Well all reports r present in Server.i mean We had created couple of Report using Businessintelligence studio .we try to deploy reports @. our server.So how to access those reports

With regards,

mahender

|||Browse to http://servername/reports. That will show you the Report Manager application which will let you navigate around and find the path to the published reports. From code, you can accomplish this using the ListChildren() method.|||HI,
Thnx for once again .Ha u said to search the path from reportmanager.I open my server as
(10.150.100.184:100/report) I saw my reports deployed how abt path there r actually stored .i need to give actuall we give reportpathname as "reportdirectory\reportname" similary for Report @. my server how can i access is it like"\\10.150.142.186\reportdirectory\reportname".Im i right

Plz do replyme...

With regards,
mahender

Plz Give The Solution Within Hour

I have two Same Databases on two different machine.i developed report at first machine.it run successfully.when i copy the report to other machine which has different name and open it, on refreshing ,its prompt for database connection then i change the name of server,database name ,user id and password then press ok.
Then
System Processing............
System Processing............
System Processing............
System Processing............
System Processing............
System Processing............
System Hanged
then I press Alt+Ctll+Delete
to abort the procceesCheck the ODBC source on both machines, if report runs on machine a, but not machine b, it could be the ODBC names are mis-matched.|||Bro. V361 i am using OLEDB(ADO) for database connection.

Actually problem is that i have developed report with my Server name for eg.DB02.BUT at client side DB02 is obviously unknown.when client open my report in crystal report and press F5 ,sometime it prompt for parameters,and sometime it hangs,when it prompt for parameter,i press ok then it ask for database connection ,I enter the configuration accordingly.after that.....Dont ask...

Prbolem is How to replace my Server Name with Clint Server Name...|||Open report, go to database, set databse location, you should see the current database connection at the top, browse too or create the new connection at the bottom. You will need to click on the table names at the
top, find the table name in the bottom connection and click update. You will need to do this for all tables involved as well as any subreports. As long as your report is not based on a command, this should help.|||Thanks for your reply.
My problem has been solved.Connection Timeout property was set to 0 which means crystal report never prompt for database configuration and keep searching for server name which causes computer to be hanged.

PLS! Help

Trying to take the result from a report on RS exported as XML via URLSyntax
Ex.
http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML
This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP to
get the data from server.
Sample:
-set xml=server.createObject("Microsoft.XMLHTTP")
-xml.open "GET", XMLURL, false
-xml.send
-xml.responseText
No problems so far, the document is there.
Is there anyone out there who can tell me how to use XSLT serverside
together with above XML.
best regards
Kjell BrandesKjell,
You can assign XSLT using the Data Output tab (Data Transform field) on the
report properties.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message news:e2gMQDtqEHA.556@.
tk2msftngp13.phx.gbl...
> Trying to take the result from a report on RS exported as XML via
URLSyntax
> Ex.
>
http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML
>
> This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP
to
> get the data from server.
> Sample:
> -set xml=server.createObject("Microsoft.XMLHTTP")
> -xml.open "GET", XMLURL, false
> -xml.send
> -xml.responseText
> No problems so far, the document is there.
> Is there anyone out there who can tell me how to use XSLT serverside
> together with above XML.
> best regards
> Kjell Brandes
>

pls help.......very urgent....

is there any possible way to have a page break each time a text field from the report changes.

i am using CR 8.5 and VB6

if possible can anyone who has the answer pls contact on msn mesenger....
amit_mash@.hotmail.com

PS: i am attaching a report i generated. i want to have a page break each time the value of the text field containing 'Blood Routine (CBC)' changes.The field you want to page break on first must be part of a sort group. Then the group header and footer will appear. In Format Section select the group and check page break before or after as needed.

Pls Help very urgent

Hi All,
I attached my report with this thread.Pls give me the solution for the following.
when i am selecting the specified record from the field the report shows all the records.
Pls give me the suggestion for the error
Bye
BalaSorry I don't understand your question. Please be more specific about what is wrong with your report, and what are you trying to achieve.|||use record selection formula.. the report u have attached doesnt have any record selection formula to filter records..

zeeshangodil@.hotmail.com

Pls Help Urgent

Hi all,
I have a transcript report which has 2 groups and details of that groups and it is using multiple column. In this students marks will be showing. My problem is even though the student took one subject or five subject i have to show five records into the details section of the report. If the student took only one subject the remaining 4 will be blank and into my table there is only the same no. of data which student took for the concerned term of study. so that it will looks like blocks according to each Term of the study. Now i am getting this as unorganized that is if there is only 2 records means there will be 2 records into the details section... so the format will not coming as blocks for each group...
So pls help to solve this problem
Thanks in advanceCreate stored procedure getting number as input parameter
If the number is 5 then select all five columns
If it is 4, select 4 columns ,etc

In the front end application
Give commands

Crrpt.DiscardSavedData
Crrpt.Database.verify

Pls Help me

MS team please help! I am running SRS SP1 (Version 8.00.878.00). I have a
report with this parameter in the Report Designer:
Name: DBName
Prompt: (blank)
Data Type: String
Allow Null Value: True
Allow blank Value: True
Available Values: Non-Queried (none)
Default Values: Non-Queried
value: dbname
I want to make this parameter hidden but expose it to the URL interface. So
I followed the SP1 instructions and published the report, then went to
Report Manager and checked the "Prompt User" checkbox then set the "Prompt
String" to blank.
This works fine. I can supply a parameter to the report via the URL, and the
user does not see the parameter to change its value.
However, then I add a second parameter to the report:
Name: Codes
Prompt: Codes:
Data Type: String
Allow Null Value: True
Allow blank Value: True
Available Values: Non-Queried (none)
Default Values: None
I deleted the report from the server in Report Manager, then published it
again from Visual Studio. I went back to Report Manager and again checked
the "Prompt User" and cleared the "Prompt String" for the parameter
"DBName". When I try to run the report and specify a value for the "DBName"
parameter on the URL I get the following error:
"A Runtime Error has occurred. Do you wish to debug?
Line: 80
Error: Object Required"
When I debug the error in MS Script Editor, it takes me to the following
code:
// Update the state of a nullable parameter.
function UpdateParam(nullChkBox)
{
// If the null checkbox itself is not enabled, don't change the state
// of the parameter controls. The null check box is disabled when
// a data driven parameter has outstanding dependencies
if (nullChkBox.disabled)
return;
It is failing on the if statement which means that nullChkBox is not an
object!!
I then tried going through all of the possible combinations of Default
Values, Allowing Null, etc. in the Report Manager for the "Codes" parameter.
The behaviour was consistent: If I check the "Prompt User" checkbox for the
"Codes" parameter at all then the report bombs! The same thing happens if I
change the order of hidden and prompted parameters. This would suggest that
there is a bug in SP1 handling reports containing a mix of hidden and
prompted parameters!!
I have seen this same script error reported in this news group on a July 2
article "Subject: Passing parameters via URL...", but I did not see a
satisfactory answer in Brian Welcker's (MSFT) reply as to why this error
message is appearing. It seems to me like a serious flaw in SQL Reporting
Services. Can anyone from the MS team help me with this one? As is often the
case, our implementation absolutely depends on this working!We used to have this same problem. I believe it has to do with page breaks
and is a bug solved in service pack 1. Down load this as soon as possible.
There are several great improvements and fixes in SP!.
"Raj Namachi" wrote:
> MS team please help! I am running SRS SP1 (Version 8.00.878.00). I have a
> report with this parameter in the Report Designer:
> Name: DBName
> Prompt: (blank)
> Data Type: String
> Allow Null Value: True
> Allow blank Value: True
> Available Values: Non-Queried (none)
> Default Values: Non-Queried
> value: dbname
>
> I want to make this parameter hidden but expose it to the URL interface. So
> I followed the SP1 instructions and published the report, then went to
> Report Manager and checked the "Prompt User" checkbox then set the "Prompt
> String" to blank.
> This works fine. I can supply a parameter to the report via the URL, and the
> user does not see the parameter to change its value.
> However, then I add a second parameter to the report:
> Name: Codes
> Prompt: Codes:
> Data Type: String
> Allow Null Value: True
> Allow blank Value: True
> Available Values: Non-Queried (none)
> Default Values: None
> I deleted the report from the server in Report Manager, then published it
> again from Visual Studio. I went back to Report Manager and again checked
> the "Prompt User" and cleared the "Prompt String" for the parameter
> "DBName". When I try to run the report and specify a value for the "DBName"
> parameter on the URL I get the following error:
> "A Runtime Error has occurred. Do you wish to debug?
> Line: 80
> Error: Object Required"
> When I debug the error in MS Script Editor, it takes me to the following
> code:
> // Update the state of a nullable parameter.
> function UpdateParam(nullChkBox)
> {
> // If the null checkbox itself is not enabled, don't change the state
> // of the parameter controls. The null check box is disabled when
> // a data driven parameter has outstanding dependencies
> if (nullChkBox.disabled)
> return;
> It is failing on the if statement which means that nullChkBox is not an
> object!!
> I then tried going through all of the possible combinations of Default
> Values, Allowing Null, etc. in the Report Manager for the "Codes" parameter.
> The behaviour was consistent: If I check the "Prompt User" checkbox for the
> "Codes" parameter at all then the report bombs! The same thing happens if I
> change the order of hidden and prompted parameters. This would suggest that
> there is a bug in SP1 handling reports containing a mix of hidden and
> prompted parameters!!
> I have seen this same script error reported in this news group on a July 2
> article "Subject: Passing parameters via URL...", but I did not see a
> satisfactory answer in Brian Welcker's (MSFT) reply as to why this error
> message is appearing. It seems to me like a serious flaw in SQL Reporting
> Services. Can anyone from the MS team help me with this one? As is often the
> case, our implementation absolutely depends on this working!
>|||Hi John Thanks for your help.I already installed service pack 1,still i am
facing the problem. :(
My problem is I have 10 parameters I like to show only 5 parameters in the
report but I like pass values to all parameters.when ever try to blank prompt
value i am getting javascript. if any one know work around pls let me know..
thanks
raj
"johnE" wrote:
> We used to have this same problem. I believe it has to do with page breaks
> and is a bug solved in service pack 1. Down load this as soon as possible.
> There are several great improvements and fixes in SP!.
> "Raj Namachi" wrote:
> > MS team please help! I am running SRS SP1 (Version 8.00.878.00). I have a
> > report with this parameter in the Report Designer:
> >
> > Name: DBName
> > Prompt: (blank)
> > Data Type: String
> > Allow Null Value: True
> > Allow blank Value: True
> > Available Values: Non-Queried (none)
> > Default Values: Non-Queried
> > value: dbname
> >
> >
> > I want to make this parameter hidden but expose it to the URL interface. So
> > I followed the SP1 instructions and published the report, then went to
> > Report Manager and checked the "Prompt User" checkbox then set the "Prompt
> > String" to blank.
> >
> > This works fine. I can supply a parameter to the report via the URL, and the
> > user does not see the parameter to change its value.
> >
> > However, then I add a second parameter to the report:
> >
> > Name: Codes
> > Prompt: Codes:
> > Data Type: String
> > Allow Null Value: True
> > Allow blank Value: True
> > Available Values: Non-Queried (none)
> > Default Values: None
> >
> > I deleted the report from the server in Report Manager, then published it
> > again from Visual Studio. I went back to Report Manager and again checked
> > the "Prompt User" and cleared the "Prompt String" for the parameter
> > "DBName". When I try to run the report and specify a value for the "DBName"
> > parameter on the URL I get the following error:
> >
> > "A Runtime Error has occurred. Do you wish to debug?
> > Line: 80
> > Error: Object Required"
> >
> > When I debug the error in MS Script Editor, it takes me to the following
> > code:
> >
> > // Update the state of a nullable parameter.
> > function UpdateParam(nullChkBox)
> > {
> > // If the null checkbox itself is not enabled, don't change the state
> > // of the parameter controls. The null check box is disabled when
> > // a data driven parameter has outstanding dependencies
> > if (nullChkBox.disabled)
> > return;
> >
> > It is failing on the if statement which means that nullChkBox is not an
> > object!!
> >
> > I then tried going through all of the possible combinations of Default
> > Values, Allowing Null, etc. in the Report Manager for the "Codes" parameter.
> > The behaviour was consistent: If I check the "Prompt User" checkbox for the
> > "Codes" parameter at all then the report bombs! The same thing happens if I
> > change the order of hidden and prompted parameters. This would suggest that
> > there is a bug in SP1 handling reports containing a mix of hidden and
> > prompted parameters!!
> >
> > I have seen this same script error reported in this news group on a July 2
> > article "Subject: Passing parameters via URL...", but I did not see a
> > satisfactory answer in Brian Welcker's (MSFT) reply as to why this error
> > message is appearing. It seems to me like a serious flaw in SQL Reporting
> > Services. Can anyone from the MS team help me with this one? As is often the
> > case, our implementation absolutely depends on this working!
> >|||The script bug is a known issue that is scheduled to be fixed in SP2. Do you
get the error if you actually specify a value for the Codes parameter?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:61398A3A-7376-413F-ABCA-99648F3A0989@.microsoft.com...
> Hi John Thanks for your help.I already installed service pack 1,still i am
> facing the problem. :(
> My problem is I have 10 parameters I like to show only 5 parameters in
> the
> report but I like pass values to all parameters.when ever try to blank
> prompt
> value i am getting javascript. if any one know work around pls let me
> know..
> thanks
> raj
> "johnE" wrote:
>> We used to have this same problem. I believe it has to do with page
>> breaks
>> and is a bug solved in service pack 1. Down load this as soon as
>> possible.
>> There are several great improvements and fixes in SP!.
>> "Raj Namachi" wrote:
>> > MS team please help! I am running SRS SP1 (Version 8.00.878.00). I have
>> > a
>> > report with this parameter in the Report Designer:
>> >
>> > Name: DBName
>> > Prompt: (blank)
>> > Data Type: String
>> > Allow Null Value: True
>> > Allow blank Value: True
>> > Available Values: Non-Queried (none)
>> > Default Values: Non-Queried
>> > value: dbname
>> >
>> >
>> > I want to make this parameter hidden but expose it to the URL
>> > interface. So
>> > I followed the SP1 instructions and published the report, then went to
>> > Report Manager and checked the "Prompt User" checkbox then set the
>> > "Prompt
>> > String" to blank.
>> >
>> > This works fine. I can supply a parameter to the report via the URL,
>> > and the
>> > user does not see the parameter to change its value.
>> >
>> > However, then I add a second parameter to the report:
>> >
>> > Name: Codes
>> > Prompt: Codes:
>> > Data Type: String
>> > Allow Null Value: True
>> > Allow blank Value: True
>> > Available Values: Non-Queried (none)
>> > Default Values: None
>> >
>> > I deleted the report from the server in Report Manager, then published
>> > it
>> > again from Visual Studio. I went back to Report Manager and again
>> > checked
>> > the "Prompt User" and cleared the "Prompt String" for the parameter
>> > "DBName". When I try to run the report and specify a value for the
>> > "DBName"
>> > parameter on the URL I get the following error:
>> >
>> > "A Runtime Error has occurred. Do you wish to debug?
>> > Line: 80
>> > Error: Object Required"
>> >
>> > When I debug the error in MS Script Editor, it takes me to the
>> > following
>> > code:
>> >
>> > // Update the state of a nullable parameter.
>> > function UpdateParam(nullChkBox)
>> > {
>> > // If the null checkbox itself is not enabled, don't change the state
>> > // of the parameter controls. The null check box is disabled when
>> > // a data driven parameter has outstanding dependencies
>> > if (nullChkBox.disabled)
>> > return;
>> >
>> > It is failing on the if statement which means that nullChkBox is not an
>> > object!!
>> >
>> > I then tried going through all of the possible combinations of Default
>> > Values, Allowing Null, etc. in the Report Manager for the "Codes"
>> > parameter.
>> > The behaviour was consistent: If I check the "Prompt User" checkbox for
>> > the
>> > "Codes" parameter at all then the report bombs! The same thing happens
>> > if I
>> > change the order of hidden and prompted parameters. This would suggest
>> > that
>> > there is a bug in SP1 handling reports containing a mix of hidden and
>> > prompted parameters!!
>> >
>> > I have seen this same script error reported in this news group on a
>> > July 2
>> > article "Subject: Passing parameters via URL...", but I did not see a
>> > satisfactory answer in Brian Welcker's (MSFT) reply as to why this
>> > error
>> > message is appearing. It seems to me like a serious flaw in SQL
>> > Reporting
>> > Services. Can anyone from the MS team help me with this one? As is
>> > often the
>> > case, our implementation absolutely depends on this working!
>> >

Pls Help : "Unable To Connect to Sql Server ..." from Crystal 8.0

Hi All,
I am using Crystal Report 8.0 to create report on MSDE 2000 sp3a , but
when I try to make connection Natively :
More Data Source->MiCrosoft SQL Server-> [Dialog opens]
then I type the ServerName, UserID and Password.
System hangs for a while, then I get this error :
"Unable To Connect to Sql server MyServer"
BUT IF I create system DSN (ODBC) then create the report,
it works.
Why can't I create report Natively on MSDE ?
Thank you very much for any help,
Krist
I'm not very familiar with Crystal Reports. However, since you can make an
ODBC connection, you can test if you are able to make OLEDB connections by
creating a UDL file connection. If the UDL file connection fails, then the
issue may be specific to the OLEDB driver for sql server (you want to
attempt to reinstall MDAC if that is the case).
Also, please see the KB articles below (available at
http://support.microsoft.com):
SAMPLE: How to Create a Data Link File with Windows 2000 - ID: 244659
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
Thanks,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Pls Help - no clues as to what field

I am running a report that is using a stored proc that has been changed. I
made the changes that I am aware of however there seems to be a field
somewhere in an expression that causes this error ... I cannot figure out how
to locate the field!
It doesnt tell me what expression or what field. The error occurs in report
preview and the text is this:
An error occurred during local report processing.
an unexpected error occurred in the report processing.
the expression referenced a non-existing field in the fields collection.Double check your SQL. If you have something that you have wrapped with a
function (ie. LTRIM(tbl.Field), this will not have a fields name. You
would need to do: LTRIM(tbl.Field) as FieldName
Hope that helps
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
>I am running a report that is using a stored proc that has been changed. I
> made the changes that I am aware of however there seems to be a field
> somewhere in an expression that causes this error ... I cannot figure out
> how
> to locate the field!
> It doesnt tell me what expression or what field. The error occurs in
> report
> preview and the text is this:
> An error occurred during local report processing.
> an unexpected error occurred in the report processing.
> the expression referenced a non-existing field in the fields collection.
>|||are you saying that I should check the stored procedure? I am not using sql.
I have verified that all the fields are coming back from the stored
procedure and exist in the fields collection so this is very strange.
"Chris" wrote:
> Double check your SQL. If you have something that you have wrapped with a
> function (ie. LTRIM(tbl.Field), this will not have a fields name. You
> would need to do: LTRIM(tbl.Field) as FieldName
> Hope that helps
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
> >I am running a report that is using a stored proc that has been changed. I
> > made the changes that I am aware of however there seems to be a field
> > somewhere in an expression that causes this error ... I cannot figure out
> > how
> > to locate the field!
> > It doesnt tell me what expression or what field. The error occurs in
> > report
> > preview and the text is this:
> >
> > An error occurred during local report processing.
> > an unexpected error occurred in the report processing.
> > the expression referenced a non-existing field in the fields collection.
> >
> >
>
>|||Yes, Check the syntax in the stored proc, if you want to post it, I'll look
at it as well.
I ran in to this same problem last week. I altered a stored proc and all of
a sudden I was getting this error, found that I had put an
ISNULL(tbl.FieldName, 0) and it came back to SQL Reports as an unknown
field. As soon as I made it ISNULL(tb.FIeldName,0) as 'CurrentValue' the
field was no longer a problem in SQL Reports.
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:7249105D-B46E-40BB-B468-DCC97C47A767@.microsoft.com...
> are you saying that I should check the stored procedure? I am not using
> sql.
> I have verified that all the fields are coming back from the stored
> procedure and exist in the fields collection so this is very strange.
> "Chris" wrote:
>> Double check your SQL. If you have something that you have wrapped with
>> a
>> function (ie. LTRIM(tbl.Field), this will not have a fields name. You
>> would need to do: LTRIM(tbl.Field) as FieldName
>> Hope that helps
>> "MJT" <MJT@.discussions.microsoft.com> wrote in message
>> news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
>> >I am running a report that is using a stored proc that has been changed.
>> >I
>> > made the changes that I am aware of however there seems to be a field
>> > somewhere in an expression that causes this error ... I cannot figure
>> > out
>> > how
>> > to locate the field!
>> > It doesnt tell me what expression or what field. The error occurs in
>> > report
>> > preview and the text is this:
>> >
>> > An error occurred during local report processing.
>> > an unexpected error occurred in the report processing.
>> > the expression referenced a non-existing field in the fields
>> > collection.
>> >
>> >
>>|||this may be a bit of an interesting dilemma. I will let you know the
outcome. I am combining 2 reports into one report. Each report seems to run
successfully one its own. When I put them together and run them ... I get
that error. The interesting part is that the 2 reports use the same stored
procedure however they return different result sets depending on the
parameter values sent. I have 2 separate datasets set up and 2 separate
tables set up to render the data so in theory this should work from what I
have read. I am wondering if I am running into an issue where it somehow
*thinks* a field is missing because it exists in one result set and not the
other? I am reworking this solution again ... step by step to see at what
point it fails. As of now I have each separate report working and I am about
to combiine them again. I will post again. Thanks for your help ... that is
still a possibility (the stored procs) and I will keep that in mind ... I
have to involve another group for that so I need to verifiy the point of
failure first.
"Chris" wrote:
> Yes, Check the syntax in the stored proc, if you want to post it, I'll look
> at it as well.
> I ran in to this same problem last week. I altered a stored proc and all of
> a sudden I was getting this error, found that I had put an
> ISNULL(tbl.FieldName, 0) and it came back to SQL Reports as an unknown
> field. As soon as I made it ISNULL(tb.FIeldName,0) as 'CurrentValue' the
> field was no longer a problem in SQL Reports.
>
>
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:7249105D-B46E-40BB-B468-DCC97C47A767@.microsoft.com...
> > are you saying that I should check the stored procedure? I am not using
> > sql.
> > I have verified that all the fields are coming back from the stored
> > procedure and exist in the fields collection so this is very strange.
> >
> > "Chris" wrote:
> >
> >> Double check your SQL. If you have something that you have wrapped with
> >> a
> >> function (ie. LTRIM(tbl.Field), this will not have a fields name. You
> >> would need to do: LTRIM(tbl.Field) as FieldName
> >>
> >> Hope that helps
> >>
> >> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> >> news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
> >> >I am running a report that is using a stored proc that has been changed.
> >> >I
> >> > made the changes that I am aware of however there seems to be a field
> >> > somewhere in an expression that causes this error ... I cannot figure
> >> > out
> >> > how
> >> > to locate the field!
> >> > It doesnt tell me what expression or what field. The error occurs in
> >> > report
> >> > preview and the text is this:
> >> >
> >> > An error occurred during local report processing.
> >> > an unexpected error occurred in the report processing.
> >> > the expression referenced a non-existing field in the fields
> >> > collection.
> >> >
> >> >
> >>
> >>
> >>
>
>|||what i will do is to re create the report layout from scratch since there is
no problem in stored procedure. it may be a reason that you wrongly copied
some expression from another report and it is difficult to point to the
expression where it occurs. There is no debugger for the expression code. if
you assemblie you can debug easily to find the syntax error in the code.
~Bava
"MJT" wrote:
> this may be a bit of an interesting dilemma. I will let you know the
> outcome. I am combining 2 reports into one report. Each report seems to run
> successfully one its own. When I put them together and run them ... I get
> that error. The interesting part is that the 2 reports use the same stored
> procedure however they return different result sets depending on the
> parameter values sent. I have 2 separate datasets set up and 2 separate
> tables set up to render the data so in theory this should work from what I
> have read. I am wondering if I am running into an issue where it somehow
> *thinks* a field is missing because it exists in one result set and not the
> other? I am reworking this solution again ... step by step to see at what
> point it fails. As of now I have each separate report working and I am about
> to combiine them again. I will post again. Thanks for your help ... that is
> still a possibility (the stored procs) and I will keep that in mind ... I
> have to involve another group for that so I need to verifiy the point of
> failure first.
> "Chris" wrote:
> > Yes, Check the syntax in the stored proc, if you want to post it, I'll look
> > at it as well.
> > I ran in to this same problem last week. I altered a stored proc and all of
> > a sudden I was getting this error, found that I had put an
> > ISNULL(tbl.FieldName, 0) and it came back to SQL Reports as an unknown
> > field. As soon as I made it ISNULL(tb.FIeldName,0) as 'CurrentValue' the
> > field was no longer a problem in SQL Reports.
> >
> >
> >
> >
> > "MJT" <MJT@.discussions.microsoft.com> wrote in message
> > news:7249105D-B46E-40BB-B468-DCC97C47A767@.microsoft.com...
> > > are you saying that I should check the stored procedure? I am not using
> > > sql.
> > > I have verified that all the fields are coming back from the stored
> > > procedure and exist in the fields collection so this is very strange.
> > >
> > > "Chris" wrote:
> > >
> > >> Double check your SQL. If you have something that you have wrapped with
> > >> a
> > >> function (ie. LTRIM(tbl.Field), this will not have a fields name. You
> > >> would need to do: LTRIM(tbl.Field) as FieldName
> > >>
> > >> Hope that helps
> > >>
> > >> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> > >> news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
> > >> >I am running a report that is using a stored proc that has been changed.
> > >> >I
> > >> > made the changes that I am aware of however there seems to be a field
> > >> > somewhere in an expression that causes this error ... I cannot figure
> > >> > out
> > >> > how
> > >> > to locate the field!
> > >> > It doesnt tell me what expression or what field. The error occurs in
> > >> > report
> > >> > preview and the text is this:
> > >> >
> > >> > An error occurred during local report processing.
> > >> > an unexpected error occurred in the report processing.
> > >> > the expression referenced a non-existing field in the fields
> > >> > collection.
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >|||thanks for your suggestion ... I would re-create from scratch but the report
is rather complicated so it would be best to try it this way first before
trying to reinvent the wheel. I still suspect it has something to do with
the fact that I am calling the same stored proc twice somehow although like I
said ... the result sets are feeding two different data regions.
"Bava Mani" wrote:
> what i will do is to re create the report layout from scratch since there is
> no problem in stored procedure. it may be a reason that you wrongly copied
> some expression from another report and it is difficult to point to the
> expression where it occurs. There is no debugger for the expression code. if
> you assemblie you can debug easily to find the syntax error in the code.
> ~Bava
> "MJT" wrote:
> > this may be a bit of an interesting dilemma. I will let you know the
> > outcome. I am combining 2 reports into one report. Each report seems to run
> > successfully one its own. When I put them together and run them ... I get
> > that error. The interesting part is that the 2 reports use the same stored
> > procedure however they return different result sets depending on the
> > parameter values sent. I have 2 separate datasets set up and 2 separate
> > tables set up to render the data so in theory this should work from what I
> > have read. I am wondering if I am running into an issue where it somehow
> > *thinks* a field is missing because it exists in one result set and not the
> > other? I am reworking this solution again ... step by step to see at what
> > point it fails. As of now I have each separate report working and I am about
> > to combiine them again. I will post again. Thanks for your help ... that is
> > still a possibility (the stored procs) and I will keep that in mind ... I
> > have to involve another group for that so I need to verifiy the point of
> > failure first.
> >
> > "Chris" wrote:
> >
> > > Yes, Check the syntax in the stored proc, if you want to post it, I'll look
> > > at it as well.
> > > I ran in to this same problem last week. I altered a stored proc and all of
> > > a sudden I was getting this error, found that I had put an
> > > ISNULL(tbl.FieldName, 0) and it came back to SQL Reports as an unknown
> > > field. As soon as I made it ISNULL(tb.FIeldName,0) as 'CurrentValue' the
> > > field was no longer a problem in SQL Reports.
> > >
> > >
> > >
> > >
> > > "MJT" <MJT@.discussions.microsoft.com> wrote in message
> > > news:7249105D-B46E-40BB-B468-DCC97C47A767@.microsoft.com...
> > > > are you saying that I should check the stored procedure? I am not using
> > > > sql.
> > > > I have verified that all the fields are coming back from the stored
> > > > procedure and exist in the fields collection so this is very strange.
> > > >
> > > > "Chris" wrote:
> > > >
> > > >> Double check your SQL. If you have something that you have wrapped with
> > > >> a
> > > >> function (ie. LTRIM(tbl.Field), this will not have a fields name. You
> > > >> would need to do: LTRIM(tbl.Field) as FieldName
> > > >>
> > > >> Hope that helps
> > > >>
> > > >> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> > > >> news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
> > > >> >I am running a report that is using a stored proc that has been changed.
> > > >> >I
> > > >> > made the changes that I am aware of however there seems to be a field
> > > >> > somewhere in an expression that causes this error ... I cannot figure
> > > >> > out
> > > >> > how
> > > >> > to locate the field!
> > > >> > It doesnt tell me what expression or what field. The error occurs in
> > > >> > report
> > > >> > preview and the text is this:
> > > >> >
> > > >> > An error occurred during local report processing.
> > > >> > an unexpected error occurred in the report processing.
> > > >> > the expression referenced a non-existing field in the fields
> > > >> > collection.
> > > >> >
> > > >> >
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >|||I have tried running the parts of the report separately and they work ... I
put them together and they dont ... I get the "expression referenced a
non-existing field in the fields collection" error message and report wont
run. Since both run separately I am not inclined to think it is stored proc.
Any more ideas?
"Chris" wrote:
> Yes, Check the syntax in the stored proc, if you want to post it, I'll look
> at it as well.
> I ran in to this same problem last week. I altered a stored proc and all of
> a sudden I was getting this error, found that I had put an
> ISNULL(tbl.FieldName, 0) and it came back to SQL Reports as an unknown
> field. As soon as I made it ISNULL(tb.FIeldName,0) as 'CurrentValue' the
> field was no longer a problem in SQL Reports.
>
>
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:7249105D-B46E-40BB-B468-DCC97C47A767@.microsoft.com...
> > are you saying that I should check the stored procedure? I am not using
> > sql.
> > I have verified that all the fields are coming back from the stored
> > procedure and exist in the fields collection so this is very strange.
> >
> > "Chris" wrote:
> >
> >> Double check your SQL. If you have something that you have wrapped with
> >> a
> >> function (ie. LTRIM(tbl.Field), this will not have a fields name. You
> >> would need to do: LTRIM(tbl.Field) as FieldName
> >>
> >> Hope that helps
> >>
> >> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> >> news:E98971F5-7FB1-47E9-BDCA-8EE206328488@.microsoft.com...
> >> >I am running a report that is using a stored proc that has been changed.
> >> >I
> >> > made the changes that I am aware of however there seems to be a field
> >> > somewhere in an expression that causes this error ... I cannot figure
> >> > out
> >> > how
> >> > to locate the field!
> >> > It doesnt tell me what expression or what field. The error occurs in
> >> > report
> >> > preview and the text is this:
> >> >
> >> > An error occurred during local report processing.
> >> > an unexpected error occurred in the report processing.
> >> > the expression referenced a non-existing field in the fields
> >> > collection.
> >> >
> >> >
> >>
> >>
> >>
>
>

PleaseMy orginal Post dissapeared

Hello,
I am new to CR and have a very interesting problem for my self. I am generating a report from Excel. Works very well except for one thing. The data consist of part numbers and there availability. here is an example of some of the part numbers "123456", "S8935" and "319525-11" The report display all of the part numbers that are "123456" but any part number with a letter or dash in it displays as a NULL value (blank) and does not group them either. Any help you could provide on this would be wonderful. Again keep in mind I am new to CR so I might need a little hand holding in your descriptions.

Thanks in advance
RobertIt sounds like you have the field setup as a number instead of as a string.|||Sorry...but how do I change that property of that field?|||How are you getting the data from Excel to the report?|||I am using Cyrstal Reports. I use the wizard to designate which fields I want to display and filter and group. It works fine except it will not group or display the actual part numbers that have the above mentioned criteria. It does have the associated data displayed with the blank or un grouped part numbers. Changing the field to a string makes total sense but I can not find a way to change the field properties to a string from a number.

thanks
For the reply

Robert|||is there someone that can help me? Maybe I can send the report to you with the excel file.

Please

Thanks Robert|||I tried to play around with Excel and Crystal and I could get all the Excel fields to display if they were all one type or the other (either all numbers or all strings). When I mixed them ( a few number and a few strings), it would only display the type that was at the top of the list. Maybe there's some way you can make all your data appear to Crystal as a string? Maybe it's a bug in Crystal Reports. Have you tried searching their website? Or searching www.google.com or another search engine?

Crystal's Website:
http://support.businessobjects.com/search/advsearch.asp

I'm sorry I'm not much help. Will you post the answer when you find it?|||I sure will post the answer when I find it. I do not want anyone to go through the same thing. I also noticed the same thing. If I sort differently it will change the format of the field to the first entry or first few to a string or number. I also noticed in the index the pane next to the preview window everything was decimaled. I was able to fix that but not get all the data. This is a huge bummer and I am not sure why this does this.

Thanks for your help

Robert

Please....tell me can it be done or not?

Can I set a URL in such a way that as soon as a report opens; it takes us to
a specified aspx page first?I'm not aware of any way to do this. What is it you are trying to
accomplish? Maybe there is some other way to do it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> Can I set a URL in such a way that as soon as a report opens; it takes us
to
> a specified aspx page first?
>|||If your goal is to authenticate the user, you can check out the Forms
Authentication example available from Microsoft. That auto-redirects users
who are not authenticated.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
> I'm not aware of any way to do this. What is it you are trying to
> accomplish? Maybe there is some other way to do it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RA" <rchaudhary-nospam@.storis.com> wrote in message
> news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> Can I set a URL in such a way that as soon as a report opens; it takes us
> to
>> a specified aspx page first?
>>
>|||Just like clicking a link, we can open a report; I want to open an html or
aspx page.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
> I'm not aware of any way to do this. What is it you are trying to
> accomplish? Maybe there is some other way to do it.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RA" <rchaudhary-nospam@.storis.com> wrote in message
> news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> Can I set a URL in such a way that as soon as a report opens; it takes us
> to
>> a specified aspx page first?
>>
>|||I still don't understand what you are trying to accomplish.
If you want to integrate an existing webpage then look at URL integration.
If you want to go from some report to a web page of your choosing then you
can do a jump to URL and go anywhere you want. It does not have to be a
report.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:utTuZ3OzEHA.3548@.TK2MSFTNGP09.phx.gbl...
> Just like clicking a link, we can open a report; I want to open an html or
> aspx page.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
> > I'm not aware of any way to do this. What is it you are trying to
> > accomplish? Maybe there is some other way to do it.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "RA" <rchaudhary-nospam@.storis.com> wrote in message
> > news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> >> Can I set a URL in such a way that as soon as a report opens; it takes
us
> > to
> >> a specified aspx page first?
> >>
> >>
> >
> >
>|||Try IIS "redirect" feature but don't know if it will work.
"RA" wrote:
> Can I set a URL in such a way that as soon as a report opens; it takes us to
> a specified aspx page first?
>
>|||Using Jump to URL, can a web page be opened in new window?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OgYaw7OzEHA.1400@.TK2MSFTNGP11.phx.gbl...
>I still don't understand what you are trying to accomplish.
> If you want to integrate an existing webpage then look at URL integration.
> If you want to go from some report to a web page of your choosing then you
> can do a jump to URL and go anywhere you want. It does not have to be a
> report.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RA" <rchaudhary-nospam@.storis.com> wrote in message
> news:utTuZ3OzEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> Just like clicking a link, we can open a report; I want to open an html
>> or
>> aspx page.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
>> > I'm not aware of any way to do this. What is it you are trying to
>> > accomplish? Maybe there is some other way to do it.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "RA" <rchaudhary-nospam@.storis.com> wrote in message
>> > news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >> Can I set a URL in such a way that as soon as a report opens; it takes
> us
>> > to
>> >> a specified aspx page first?
>> >>
>> >>
>> >
>> >
>>
>|||A report is not a web page. RS is a web application that retrieves the
appropriate RDL from the database, renders it and returns the data. I really
don't think that would work.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:F3CEA3E9-CDB9-4ABF-930B-BC2771B4CD07@.microsoft.com...
> Try IIS "redirect" feature but don't know if it will work.
>
> "RA" wrote:
> > Can I set a URL in such a way that as soon as a report opens; it takes
us to
> > a specified aspx page first?
> >
> >
> >|||Teo (the other MVP) just answered this in another thread. I didn't know the
answer but saw his.
= "javascript:window.open('http://www.google.com')"
Cool.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:OxqmrJPzEHA.2716@.TK2MSFTNGP14.phx.gbl...
> Using Jump to URL, can a web page be opened in new window?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OgYaw7OzEHA.1400@.TK2MSFTNGP11.phx.gbl...
>>I still don't understand what you are trying to accomplish.
>> If you want to integrate an existing webpage then look at URL
>> integration.
>> If you want to go from some report to a web page of your choosing then
>> you
>> can do a jump to URL and go anywhere you want. It does not have to be a
>> report.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RA" <rchaudhary-nospam@.storis.com> wrote in message
>> news:utTuZ3OzEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> Just like clicking a link, we can open a report; I want to open an html
>> or
>> aspx page.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e%23MQX1OzEHA.908@.TK2MSFTNGP11.phx.gbl...
>> > I'm not aware of any way to do this. What is it you are trying to
>> > accomplish? Maybe there is some other way to do it.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "RA" <rchaudhary-nospam@.storis.com> wrote in message
>> > news:%23to4cyOzEHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >> Can I set a URL in such a way that as soon as a report opens; it
>> >> takes
>> us
>> > to
>> >> a specified aspx page first?
>> >>
>> >>
>> >
>> >
>>
>>
>|||You could always build a web application that did whatever you want and then
ran a report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%237FEZLPzEHA.2656@.TK2MSFTNGP14.phx.gbl...
>A report is not a web page. RS is a web application that retrieves the
> appropriate RDL from the database, renders it and returns the data. I
> really
> don't think that would work.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
> news:F3CEA3E9-CDB9-4ABF-930B-BC2771B4CD07@.microsoft.com...
>> Try IIS "redirect" feature but don't know if it will work.
>>
>> "RA" wrote:
>> > Can I set a URL in such a way that as soon as a report opens; it takes
> us to
>> > a specified aspx page first?
>> >
>> >
>> >
>

PLEASE! count of groups

I have a report with one group level where I am hiding detail and only
showing group totals. This report is summarized/grouped by device (like a
system name) and I am trying to calc the total number of devices monitored
which would be equal to the number of groups I have on the report. I have
tried all the aggregate functions RowNumber(nothing) to count outer most
level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
what I want. If I were to code it ... I would have some counter that every
time I created a group footer then I would add 1 to the counter. It seems
that this should be something simple (and maybe it is!) but the expression I
am grouping on is a system name (so cant use THAT like a sum). I would do it
at the database level but I am using a stored procedure so cant modify the
sql. I tried to create (add) a field (as you would a calculated field or
database field) but got some error about out of bounds for array or
something. This is driving me nuts! please help!!!I got it to work finally. Now the problem is that I want to display the
device count in a textbox at the end of the report and I get an error trying
to reference the field I just created in the table portion of the report. In
the table (called table1 in the report) I entered the following expression
in the textbox I named DeviceCount
=CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
count of the devices being monitored and reported on ... which is goodness.
However ... I need to display that value in the textbox at the bottom of
the report.
I enter the following expression and get an error
="Total number of devices monitored for this Client:" +
(ReportItems!DeviceCount.Value, "table1")
"MJ Taft" wrote:
> I have a report with one group level where I am hiding detail and only
> showing group totals. This report is summarized/grouped by device (like a
> system name) and I am trying to calc the total number of devices monitored
> which would be equal to the number of groups I have on the report. I have
> tried all the aggregate functions RowNumber(nothing) to count outer most
> level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> what I want. If I were to code it ... I would have some counter that every
> time I created a group footer then I would add 1 to the counter. It seems
> that this should be something simple (and maybe it is!) but the expression I
> am grouping on is a system name (so cant use THAT like a sum). I would do it
> at the database level but I am using a stored procedure so cant modify the
> sql. I tried to create (add) a field (as you would a calculated field or
> database field) but got some error about out of bounds for array or
> something. This is driving me nuts! please help!!!|||Got this one figured out too. Added a footer to report and put it in there.
No problem referencing now using expression:
="Total number of devices monitored for this Client:" &
ReportItems!DeviceCount.Value
I would like to know if there is a way to reference it in the body of the
report without having to use the footer though. Thanks!
"MJ Taft" wrote:
> I got it to work finally. Now the problem is that I want to display the
> device count in a textbox at the end of the report and I get an error trying
> to reference the field I just created in the table portion of the report. In
> the table (called table1 in the report) I entered the following expression
> in the textbox I named DeviceCount
> =CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
> count of the devices being monitored and reported on ... which is goodness.
> However ... I need to display that value in the textbox at the bottom of
> the report.
> I enter the following expression and get an error
> ="Total number of devices monitored for this Client:" +
> (ReportItems!DeviceCount.Value, "table1")
> "MJ Taft" wrote:
> > I have a report with one group level where I am hiding detail and only
> > showing group totals. This report is summarized/grouped by device (like a
> > system name) and I am trying to calc the total number of devices monitored
> > which would be equal to the number of groups I have on the report. I have
> > tried all the aggregate functions RowNumber(nothing) to count outer most
> > level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> > what I want. If I were to code it ... I would have some counter that every
> > time I created a group footer then I would add 1 to the counter. It seems
> > that this should be something simple (and maybe it is!) but the expression I
> > am grouping on is a system name (so cant use THAT like a sum). I would do it
> > at the database level but I am using a stored procedure so cant modify the
> > sql. I tried to create (add) a field (as you would a calculated field or
> > database field) but got some error about out of bounds for array or
> > something. This is driving me nuts! please help!!!|||Doesn't it work fine when you use the footer of a table instead of the footer
of the report?
"MJ Taft" wrote:
> Got this one figured out too. Added a footer to report and put it in there.
> No problem referencing now using expression:
> ="Total number of devices monitored for this Client:" &
> ReportItems!DeviceCount.Value
> I would like to know if there is a way to reference it in the body of the
> report without having to use the footer though. Thanks!
> "MJ Taft" wrote:
> > I got it to work finally. Now the problem is that I want to display the
> > device count in a textbox at the end of the report and I get an error trying
> > to reference the field I just created in the table portion of the report. In
> > the table (called table1 in the report) I entered the following expression
> > in the textbox I named DeviceCount
> > =CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
> > count of the devices being monitored and reported on ... which is goodness.
> >
> > However ... I need to display that value in the textbox at the bottom of
> > the report.
> > I enter the following expression and get an error
> >
> > ="Total number of devices monitored for this Client:" +
> > (ReportItems!DeviceCount.Value, "table1")
> >
> > "MJ Taft" wrote:
> >
> > > I have a report with one group level where I am hiding detail and only
> > > showing group totals. This report is summarized/grouped by device (like a
> > > system name) and I am trying to calc the total number of devices monitored
> > > which would be equal to the number of groups I have on the report. I have
> > > tried all the aggregate functions RowNumber(nothing) to count outer most
> > > level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> > > what I want. If I were to code it ... I would have some counter that every
> > > time I created a group footer then I would add 1 to the counter. It seems
> > > that this should be something simple (and maybe it is!) but the expression I
> > > am grouping on is a system name (so cant use THAT like a sum). I would do it
> > > at the database level but I am using a stored procedure so cant modify the
> > > sql. I tried to create (add) a field (as you would a calculated field or
> > > database field) but got some error about out of bounds for array or
> > > something. This is driving me nuts! please help!!!|||I tried that and got this message:
The value expression for the textbox â'textbox7â' refers to the report item
â'DeviceCountâ'. Report item expressions can only refer to other report items
within the same grouping scope or a containing grouping scope.
"David Bienstock" wrote:
> Doesn't it work fine when you use the footer of a table instead of the footer
> of the report?
> "MJ Taft" wrote:
> > Got this one figured out too. Added a footer to report and put it in there.
> > No problem referencing now using expression:
> >
> > ="Total number of devices monitored for this Client:" &
> > ReportItems!DeviceCount.Value
> >
> > I would like to know if there is a way to reference it in the body of the
> > report without having to use the footer though. Thanks!
> >
> > "MJ Taft" wrote:
> >
> > > I got it to work finally. Now the problem is that I want to display the
> > > device count in a textbox at the end of the report and I get an error trying
> > > to reference the field I just created in the table portion of the report. In
> > > the table (called table1 in the report) I entered the following expression
> > > in the textbox I named DeviceCount
> > > =CountDistinct( Fields!Resource_Name.Value , "table1") which gives me a
> > > count of the devices being monitored and reported on ... which is goodness.
> > >
> > > However ... I need to display that value in the textbox at the bottom of
> > > the report.
> > > I enter the following expression and get an error
> > >
> > > ="Total number of devices monitored for this Client:" +
> > > (ReportItems!DeviceCount.Value, "table1")
> > >
> > > "MJ Taft" wrote:
> > >
> > > > I have a report with one group level where I am hiding detail and only
> > > > showing group totals. This report is summarized/grouped by device (like a
> > > > system name) and I am trying to calc the total number of devices monitored
> > > > which would be equal to the number of groups I have on the report. I have
> > > > tried all the aggregate functions RowNumber(nothing) to count outer most
> > > > level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> > > > what I want. If I were to code it ... I would have some counter that every
> > > > time I created a group footer then I would add 1 to the counter. It seems
> > > > that this should be something simple (and maybe it is!) but the expression I
> > > > am grouping on is a system name (so cant use THAT like a sum). I would do it
> > > > at the database level but I am using a stored procedure so cant modify the
> > > > sql. I tried to create (add) a field (as you would a calculated field or
> > > > database field) but got some error about out of bounds for array or
> > > > something. This is driving me nuts! please help!!!|||You need to put a countrows(groupname) in the group footer. First, you need
to assigne a name to your group, then use that name in the countrows function.
Best of luck!
"MJ Taft" wrote:
> I have a report with one group level where I am hiding detail and only
> showing group totals. This report is summarized/grouped by device (like a
> system name) and I am trying to calc the total number of devices monitored
> which would be equal to the number of groups I have on the report. I have
> tried all the aggregate functions RowNumber(nothing) to count outer most
> level, CountDistinct, RowCount, CountRows ... etc etc and nothing gives me
> what I want. If I were to code it ... I would have some counter that every
> time I created a group footer then I would add 1 to the counter. It seems
> that this should be something simple (and maybe it is!) but the expression I
> am grouping on is a system name (so cant use THAT like a sum). I would do it
> at the database level but I am using a stored procedure so cant modify the
> sql. I tried to create (add) a field (as you would a calculated field or
> database field) but got some error about out of bounds for array or
> something. This is driving me nuts! please help!!!