Pushing Recordset into MSRS

Hi experts,
Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to
create a separation between the report and the underlying data source? This
would help us to swap the data source without changing the reports.
Thanks,Hi,
In a short term you can create a custom dataset extension to get your ADO
recordset and "bind" it to the report. Accidentally, I have developed one
(http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B846
8707-56EF-4864-AC51-D83FC3273FE5 ). It allows you get an ADO.NET dataset
from somewhere (e.g. you BLL), pass it to the report as a report parameter
and expose it as a RS dataset. It also suports reporting off persisted as
XML files datasets.
In a long run, the next version of RS will include WinForm and ASP.NET
controls which will work in both connected and disconnected mode. The later
will support binding to ADO.NET datasets.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in message
news:BCDCCDFE-9AEE-4FDF-9C24-1C420F8943B4@.microsoft.com...
> Hi experts,
> Can we push an ADO recordset into MSRS (instead of MSRS pulling the data)
to
> create a separation between the report and the underlying data source?
This
> would help us to swap the data source without changing the reports.
> Thanks,
>

Pulling values from code behind

In my code behind file I have this function:

1public void getAllSystems()2 {3 MTConnection con = MTConnection.CreateConnection(new Credential(new Context("ClearQuest - Boise","Version 2.0", Micron.Application.Context.Environments.Production),"DSSPROD", Credential.DataSourceTypes.MSSQL, Credential.DataSourceProviders.Odbc));45string sqltest =" select T1.dbid,T12.systemname AS 'ParentSystem',T1.systemname AS 'SupportSystem',T1.systemstate,T1.features,T3.name,T4.stakeholder," +6" T4.fldcolumn_1,T1.systemwebpage,T1.description from ( ( ( ( ( ( ( ( CQ_ADMIN.micronsystem T1 INNER JOIN" +7" CQ_ADMIN.microngroup T6 ON T1.primarysupportgroup = T6.dbid ) INNER JOIN CQ_ADMIN.securitygroups T7 ON T1.secuirtygroup" +8" = T7.dbid ) LEFT OUTER JOIN CQ_ADMIN.parent_child_links T12mm ON T1.dbid = T12mm.child_dbid and 16778862 =" +9" T12mm.child_fielddef_id ) LEFT OUTER JOIN CQ_ADMIN.micronsystem T12 ON T12mm.parent_dbid = T12.dbid )" +10" LEFT OUTER JOIN CQ_ADMIN.parent_child_links T3mm ON T1.dbid = T3mm.parent_dbid and 16804095 =" +11" T3mm.parent_fielddef_id ) LEFT OUTER JOIN CQ_ADMIN.feature_1 T3 ON T3mm.child_dbid = T3.dbid ) LEFT OUTER" +12" JOIN CQ_ADMIN.parent_child_links T4mm ON T3.dbid = T4mm.parent_dbid and 16804263 = T4mm.parent_fielddef_id )" +13" LEFT OUTER JOIN CQ_ADMIN.stakeholder T4 ON T4mm.child_dbid = T4.dbid ) where T1.dbid <> 0 and ((T6.abbreviation =" +14" 'Test ES Eng Software' and T1.systemstate = 'Active')) and ((T7.dbid in (select parent_dbid from" +15" CQ_ADMIN.parent_child_links where parent_fielddef_id = 16778767 and child_dbid in (select child_dbid from" +16" CQ_ADMIN.parent_child_links where parent_fielddef_id = 16777328 and parent_dbid = 33664106)and T12.systemname IS NOT" +17" NULL ))) order by T3.name ASC,T1.systemname ASC";1819 System.Data.DataSet ds = con.ExecuteDataset(CommandType.Text, sqltest);2021foreach (DataRow drCQin ds.Tables[0].Rows)22 {23string parent_system = drCQ["ParentSystem"].ToString();24string child_system = drCQ["SupportSystem"].ToString();25//Response.Write(child_system + "<B><I>'S PARENT IS</I></B> " + parent_system + "<BR />");26 }27 }I would like to pull the values of parent_system and child_system into my main page but I don't know how to do that. Is it even possible?

Thanks,

Xana.

If there are mulitple records returned in your result set, then simply bind your returned DataSet to a GridView. I'm assuming you just want to display you data correct?

|||

No, I just need to pass the two strings, and all of thier values, to the main page. I am trying to construct a JavaScript array based on the two strings but I need to pass all of the values before I can do that. I already know how to use ASP values and variables in JavaScript but I don't know how to pull the value into the main page for use.

|||

How about loading the results into two different HiddenField controls whcih you can then use later from your JavaScript routines.

|||

How would I seperate them out into two hiddenfields.

The reason I ask is that with what I am trying to do each child_system has a parent_system that it belongs too. I would lIke to create an associative array out of the two strings. Plus in total the for each loop that they are in returns 90 + results.

Even if I were to create the array in the code behind ( which I don't know how to do (in C#) ) I would still need to pull the array into the main page.

|||

You can't. I misunderstood what you were wanting to do. I'd have to think about a solution.

|||

Is there any way at all to pull the values into the main page?

|||

Can you at all utilize the ClientScriptManager.RegisterArrayDeclartion method?

http://msdn2.microsoft.com/en-us/library/system.web.ui.clientscriptmanager.registerarraydeclaration.aspx

|||

How exactly would that script help me? And how would I use it exactly. I am looking at it but not really understanding it.

|||

To be honest, I'm not exactly sure. It's just a way to create a JavaScript array from code. The only problem is that the method excepts a string for its ArrayValue field instead of an array of some sort, so creating the parameter itself would be a pain. If I can think of any other ideas, I'll let you know.

|||

If I print out the variables into hidden fields with the names being the parent system and the values being the child system would it be possible to, by using a javascript function, call all of the values of the hidden fields?

An example would be there is a drop down menu with the parent systems. Say the user chose TEST_ESENG_SOFTWARE from the menu. TEST_ESENG_SOFTWARE had three child systems, TEST_ONE, TEST_TWO, TEST_THREE ( not using real names ).

With the onchange event for the first drop down menu I could call the function that gets the values from the hidden form fields that have the name TEST_ESENG_SOFTWARE, and then use them to populate a second drop down menu.

Is the above senerio at all possible?? If it is how would I do it?

|||

That would be tough to do when the number of items in your data would vary. I'm not a JavaScript person by any means so I don't know how you'd extract values from a series of controls. Is your whole purpose for wanting this in JavaScript for performance? If so, might I suggest using an AJAX cascading drop-down list.

|||

The reason for doing this in JavaScript is to avoid using postbacks because clearquest can get quite slow with return large sets of results. I know a method exists that gets the elements it is: getElementsByName() but I do not know exactly how to use it to return the actual values.

Do you know anyone who could help us on this forum? If so please give me a name as I can send them a message. If not, oh well I can try to find something online that can help me more. Your suggestions have been extremely helpful.

|||

I wish I knew someone who could help you more, but I don't. It really sounds like you might benefit from using AJAX. Regardless, good luck.

pulling unique records from this query

Hi guys, need your help! (sorry this is quite long)
I've got a table of Projects which I'm using with an asp:Repeater to display
a list of the projects. Here's the sql...
SELECT ProjectID, ProjectName, ProjectClient, DartsContact, LeadArtist,
Projects.AreaOfWork, AreaOfDoncaster, StartDate, EndDate, Running,
WorkAreas.AreaofWork AS AOWName, WorkAreas.RelatesTo AS AOWRelates FROM
Projects, WorkAreas
WHERE (NOT Running=0) AND (Projects.AreaOfWork LIKE '%' + WorkAreas.AOWCode
+ '%') AND (Deleted = 0) ORDER BY ProjectName ASC
As you can hopefully see, I'm using two tables to pull the data together.
It worked fine, until we made a change to the way the data is stored. The
Projects.AreaOfWork field now contains multiple AOWCodes seperated by a
delimiter. So now, whenever I run this query, I get more than 1 line for eac
h
project where there are multiple values in AreaOfWork. So, if I have a
project...
ProjectID, ProjectName, AreaOfWork
1, Test Proj 1, EDU
2, Test Proj 2, EDU|COM
I get 2 lines for Test Project 2, each with a unique AreaOfWork (one with
EDU, one with COM).
2 things... I need to stop it returning multiple records for the same
project when theres more than one AreaOfWork, but I also need to return the
entire AreaOfWork string, because I still need access to those.
Any help would be greatly appreciated.
Cheers
Danwhy have you chosen to store your data like that (delimited) - it
breaks with normalisation, and is the main reason your having problems.
surely it would be easier if you had a separate table like
tblProjWorkAreas(ProjectID, AreaOfWork). Is there are reason for not
doing this?|||I see your point mate. Time constraints are the main reason for this.. it's
an addition to a project that's been running for a couple of years (the
having multiples instead of one).
Is there a way to get the query to work!?
"Will" wrote:

> why have you chosen to store your data like that (delimited) - it
> breaks with normalisation, and is the main reason your having problems.
> surely it would be easier if you had a separate table like
> tblProjWorkAreas(ProjectID, AreaOfWork). Is there are reason for not
> doing this?
>|||actually, further to this... I *think* i can do half of what I want to do in
code, if I can get it to just select unique records... :)
"Will" wrote:

> why have you chosen to store your data like that (delimited) - it
> breaks with normalisation, and is the main reason your having problems.
> surely it would be easier if you had a separate table like
> tblProjWorkAreas(ProjectID, AreaOfWork). Is there are reason for not
> doing this?
>|||depends on what you want out. If we take your example where you have
EDU|COM, what output would you want - the area of work columns x2?
could you post a fuller example in terms of data from both tables, and
what you'd like your query to result in.|||Hi Dan,
Thanks for using MSDN Managed Newsgroup Support.
As Will mentioned, it is not a good idea to store your data like that.
So I want to know why you use the WorkAreas.AreaofWork and
WorkAreas.Relates in the query. If you want to unique the only Project in
this query, I think you may need to exclude the WorkAreas Table.
Also, you may provide me the result of the query now if you have 2
AreaOfWork in the Project Table.
I need to know the exactly different of these 2 records.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you both for your help. I managed to get this to work using a differen
t
method, so no need to concern yourselves anymore :) I do appreciate that
using a third table would be a much better solution, and may consider that
for future redevlopment.
In answer to your question Wei, the reason for showing the AOW fields is
simply to show which Areas of Work a Project belongs to. WorkAreas.Relates i
s
a field that allows us to have inherited Areas of Work in the table, like so
.
aowcode aowname relates_to
1 Education null
2 Adult Ed 1
3 Preschool 1
etc.
Again, thank you both for your help today!
Cheers
Dan
"Wei Lu" wrote:

> Hi Dan,
> Thanks for using MSDN Managed Newsgroup Support.
> As Will mentioned, it is not a good idea to store your data like that.
> So I want to know why you use the WorkAreas.AreaofWork and
> WorkAreas.Relates in the query. If you want to unique the only Project in
> this query, I think you may need to exclude the WorkAreas Table.
> Also, you may provide me the result of the query now if you have 2
> AreaOfWork in the Project Table.
> I need to know the exactly different of these 2 records.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>

Pulling trans logs from one server to anthother

I know this can be done using a bat file, but am having issues finding any
documentation.
I need to connect to a mapped drive and move trans log backups from on
server to another server so they can be applied.
Any help would be greatly appreciated.
Thanks in advance
SusanI recommend using VBScript and the Windoes Scripting Host.
here is some documentation:
[url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/ur
l]
It will allow you to create more robust scripts with error handling and
logging capabilities. Here are some examples:
[url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[/u
rl]
Search for the Scripting.FileSystemObject to get code samples.
I used it in the past with very good results. In fact, I have production
systems that depend on scripts I wrote and they still perform as intended.
"SBAUER" wrote:

> I know this can be done using a bat file, but am having issues finding any
> documentation.
> I need to connect to a mapped drive and move trans log backups from on
> server to another server so they can be applied.
> Any help would be greatly appreciated.
> Thanks in advance
> Susan
>|||Thanks Edgardo,
However, my knowledge of VB scripting is very limited.
I'm trying to map a drive and just copy the files over using bat.
I'm sure the way you suggested is the best, but I'm under a time crunch and
don't have time for a learning curve.
"Edgardo Valdez, MCSD, MCDBA" wrote:
> I recommend using VBScript and the Windoes Scripting Host.
> here is some documentation:
> [url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/
url]
> It will allow you to create more robust scripts with error handling and
> logging capabilities. Here are some examples:
> [url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[
/url]
> Search for the Scripting.FileSystemObject to get code samples.
> I used it in the past with very good results. In fact, I have production
> systems that depend on scripts I wrote and they still perform as intended.
> "SBAUER" wrote:
>|||In that case, you can use xcopy

>xcopy /?
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]
source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only
attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.
The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
Example:
C:>xcopy E:\SQLData\*.trn \\remoteserver\C$\SQLBackups
"SBAUER" wrote:
> Thanks Edgardo,
> However, my knowledge of VB scripting is very limited.
> I'm trying to map a drive and just copy the files over using bat.
> I'm sure the way you suggested is the best, but I'm under a time crunch an
d
> don't have time for a learning curve.
>
> "Edgardo Valdez, MCSD, MCDBA" wrote:
>sql

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonaldYou can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL
but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_
www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the d
b? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonald
You can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer (I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the db? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonaldYou can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL
but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_
www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the d
b? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling stored Procs from a remote db

Hi all -
I am trying to rebuild a website abandoned by the builder and an SQLServer
(I think 2k) db is used under it at the host. I can get at the db by using
Access/ODBC with a URL but the migration facility seems only to let me get
at the tables.
There are about half a dozen SPs referred to in the ASP code ( eg EXEC
sp_www) and I want to get hold of the code as I am not sure at all what they
are doing.
How do I get the code for each SP and store it in the local copy of the db?
Can I just replicate the db and move the replica to a local area?
Any advice on this gratefully (!) receive
Thanks
Jim McDonald
You can get the source code of a stored procedure using sp_helptext.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jim McDonald" <jim@.missile.demon.co.uk> wrote in message
news:ct7q5g$n7j$1$8302bc10@.news.demon.co.uk...
> Hi all -
> I am trying to rebuild a website abandoned by the builder and an SQLServer (I think 2k) db is used
> under it at the host. I can get at the db by using Access/ODBC with a URL but the migration
> facility seems only to let me get at the tables.
> There are about half a dozen SPs referred to in the ASP code ( eg EXEC sp_www) and I want to get
> hold of the code as I am not sure at all what they are doing.
> How do I get the code for each SP and store it in the local copy of the db? Can I just replicate
> the db and move the replica to a local area?
> Any advice on this gratefully (!) receive
> Thanks
> Jim McDonald
>

Pulling SQL Server information in C#

I'm looking to pull information such as uptime, ip, status, db name, etc from my sql server database to display on a form. I'd like to get more detailed if I could, such as current load on database, threads, etc. Does anyone know if this is possible using
C#?
Hi Chris,
Most of these are retrieved via the @.@. variables. For a full list look in
BOL
Select @.@.CPU_BUSY
You may also want to look at sp_monitor
sp_monitor
I hope this helps
Greg O
Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
Document all your databases now.
http://www.ag-software.com/ags_scribe_index.aspx
Crosstab queries from SQL Server.
http://www.ag-software.com/xp_ags_crosstab.aspx
Edit Extended Properties as easy as can be.
http://www.ag-software.com/ags_SSEPE_index.aspx
"Chris Stewart" <CompiledMonkey@.comcast.net> wrote in message
news:6D0351C3-76E2-4901-A269-630E89EAC66A@.microsoft.com...
> I'm looking to pull information such as uptime, ip, status, db name, etc
from my sql server database to display on a form. I'd like to get more
detailed if I could, such as current load on database, threads, etc. Does
anyone know if this is possible using C#?
|||Just to add - of course you can catch this info in C#. Stored procedures
give you rowsets and you can use DataReader to catch it; scalar values can
be caught as output parameters of the Command object.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in
message news:uMFMbRyKEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Hi Chris,
> Most of these are retrieved via the @.@. variables. For a full list look in
> BOL
> Select @.@.CPU_BUSY
> You may also want to look at sp_monitor
> sp_monitor
>
> --
> I hope this helps
> --
> Greg O
> Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
> Document all your databases now.
> http://www.ag-software.com/ags_scribe_index.aspx
> Crosstab queries from SQL Server.
> http://www.ag-software.com/xp_ags_crosstab.aspx
> Edit Extended Properties as easy as can be.
> http://www.ag-software.com/ags_SSEPE_index.aspx
>
> "Chris Stewart" <CompiledMonkey@.comcast.net> wrote in message
> news:6D0351C3-76E2-4901-A269-630E89EAC66A@.microsoft.com...
> from my sql server database to display on a form. I'd like to get more
> detailed if I could, such as current load on database, threads, etc. Does
> anyone know if this is possible using C#?
>

Pulling SQL Server information in C#

I'm looking to pull information such as uptime, ip, status, db name, etc from my sql server database to display on a form. I'd like to get more detailed if I could, such as current load on database, threads, etc. Does anyone know if this is possible using C#?Hi Chris,
Most of these are retrieved via the @.@. variables. For a full list look in
BOL
Select @.@.CPU_BUSY
You may also want to look at sp_monitor
sp_monitor
I hope this helps
--
Greg O
Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
Document all your databases now.
http://www.ag-software.com/ags_scribe_index.aspx
Crosstab queries from SQL Server.
http://www.ag-software.com/xp_ags_crosstab.aspx
Edit Extended Properties as easy as can be.
http://www.ag-software.com/ags_SSEPE_index.aspx
"Chris Stewart" <CompiledMonkey@.comcast.net> wrote in message
news:6D0351C3-76E2-4901-A269-630E89EAC66A@.microsoft.com...
> I'm looking to pull information such as uptime, ip, status, db name, etc
from my sql server database to display on a form. I'd like to get more
detailed if I could, such as current load on database, threads, etc. Does
anyone know if this is possible using C#?|||Just to add - of course you can catch this info in C#. Stored procedures
give you rowsets and you can use DataReader to catch it; scalar values can
be caught as output parameters of the Command object.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in
message news:uMFMbRyKEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Hi Chris,
> Most of these are retrieved via the @.@. variables. For a full list look in
> BOL
> Select @.@.CPU_BUSY
> You may also want to look at sp_monitor
> sp_monitor
>
> --
> I hope this helps
> --
> Greg O
> Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
> Document all your databases now.
> http://www.ag-software.com/ags_scribe_index.aspx
> Crosstab queries from SQL Server.
> http://www.ag-software.com/xp_ags_crosstab.aspx
> Edit Extended Properties as easy as can be.
> http://www.ag-software.com/ags_SSEPE_index.aspx
>
> "Chris Stewart" <CompiledMonkey@.comcast.net> wrote in message
> news:6D0351C3-76E2-4901-A269-630E89EAC66A@.microsoft.com...
> > I'm looking to pull information such as uptime, ip, status, db name, etc
> from my sql server database to display on a form. I'd like to get more
> detailed if I could, such as current load on database, threads, etc. Does
> anyone know if this is possible using C#?
>

Pulling SQL Server information in C#

I'm looking to pull information such as uptime, ip, status, db name, etc fro
m my sql server database to display on a form. I'd like to get more detailed
if I could, such as current load on database, threads, etc. Does anyone kno
w if this is possible using
C#?Hi Chris,
Most of these are retrieved via the @.@. variables. For a full list look in
BOL
Select @.@.CPU_BUSY
You may also want to look at sp_monitor
sp_monitor
I hope this helps
--
Greg O
Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
Document all your databases now.
http://www.ag-software.com/ags_scribe_index.aspx
Crosstab queries from SQL Server.
http://www.ag-software.com/xp_ags_crosstab.aspx
Edit Extended Properties as easy as can be.
http://www.ag-software.com/ags_SSEPE_index.aspx
"Chris Stewart" <CompiledMonkey@.comcast.net> wrote in message
news:6D0351C3-76E2-4901-A269-630E89EAC66A@.microsoft.com...
> I'm looking to pull information such as uptime, ip, status, db name, etc
from my sql server database to display on a form. I'd like to get more
detailed if I could, such as current load on database, threads, etc. Does
anyone know if this is possible using C#?|||Just to add - of course you can catch this info in C#. Stored procedures
give you rowsets and you can use DataReader to catch it; scalar values can
be caught as output parameters of the Command object.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in
message news:uMFMbRyKEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Hi Chris,
> Most of these are retrieved via the @.@. variables. For a full list look in
> BOL
> Select @.@.CPU_BUSY
> You may also want to look at sp_monitor
> sp_monitor
>
> --
> I hope this helps
> --
> Greg O
> Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
> Document all your databases now.
> http://www.ag-software.com/ags_scribe_index.aspx
> Crosstab queries from SQL Server.
> http://www.ag-software.com/xp_ags_crosstab.aspx
> Edit Extended Properties as easy as can be.
> http://www.ag-software.com/ags_SSEPE_index.aspx
>
> "Chris Stewart" <CompiledMonkey@.comcast.net> wrote in message
> news:6D0351C3-76E2-4901-A269-630E89EAC66A@.microsoft.com...
> from my sql server database to display on a form. I'd like to get more
> detailed if I could, such as current load on database, threads, etc. Does
> anyone know if this is possible using C#?
>

Pulling SQL Server data from Unix

How can I pull data from a MSSQL server in UNIX. Do I need an entry in
.odbc.ini, or other client tools to run a select on a table.
is this even possible
pls let me know
ThanksSee this old post.
7dc3ba3fd9e90c" target="_blank">http://groups.google.co.in/group/co...
7dc3ba3fd9e90c
Thanks
Hari
SQL Server MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:041F3647-E106-493A-8EDF-C0A2D83EEB87@.microsoft.com...
> How can I pull data from a MSSQL server in UNIX. Do I need an entry in
> .odbc.ini, or other client tools to run a select on a table.
> is this even possible
> pls let me know
> Thanks
>

Pulling SQL Server data from Unix

How can I pull data from a MSSQL server in UNIX. Do I need an entry in
.odbc.ini, or other client tools to run a select on a table.
is this even possible
pls let me know
ThanksSee this old post.
http://groups.google.co.in/group/comp.databases.ms-sqlserver/browse_thread/thread/218b790b3b3cffbf/5c7dc3ba3fd9e90c?q=accessing+sql+server+from+UNIX&rnum=1&hl=en#5c7dc3ba3fd9e90c
Thanks
Hari
SQL Server MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:041F3647-E106-493A-8EDF-C0A2D83EEB87@.microsoft.com...
> How can I pull data from a MSSQL server in UNIX. Do I need an entry in
> .odbc.ini, or other client tools to run a select on a table.
> is this even possible
> pls let me know
> Thanks
>

Pulling SQL Server data from Unix

How can I pull data from a MSSQL server in UNIX. Do I need an entry in
..odbc.ini, or other client tools to run a select on a table.
is this even possible
pls let me know
Thanks
See this old post.
http://groups.google.co.in/group/com...7dc3ba3fd9e90c
Thanks
Hari
SQL Server MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:041F3647-E106-493A-8EDF-C0A2D83EEB87@.microsoft.com...
> How can I pull data from a MSSQL server in UNIX. Do I need an entry in
> .odbc.ini, or other client tools to run a select on a table.
> is this even possible
> pls let me know
> Thanks
>

pulling single lines from a DB

hi im making a page where i want a single line at a time to be pulled from my MS Database, basically at the moment i have a list of questions, but the page is displaying all the questions from my database, i only want it to pull out 1 and then if the user clicks the true button then it goes to another page and displays another question?

Any ideas

Regards,

JoeHi Joe,

Are you want to retrieve any 1 question from DB randomly?
FYI:http://www.datawebcontrols.com/faqs/Data/ReturningDataInRandomOrder.shtml

Regards,

Pulling RS Report into online application

I've got an online application (written in Cold Fusion) that I would like to
be able to pull in a report generated in RS. Currently, I can call the
report directly from the application using an HTTP "get", pass in the url
string with "rs:Format=PDF", save the resulting PDF file on my server, then
render that PDF file in my cold fusion application.
What I would LIKE to do is render the report in HTML format in my
application. The problem is, the report has a couple of graphs in it, and
the resulting HTML that is generated does not know where to find the graph
images.
Is there anyway to capture the resulting HTML that is generated from the
Report Server in such a way that it can be run in another online web
application (running on the same server as the RS), and yet be able to
correctly fetch the generated graphical images?
I hope this makes sense.
TIA,
BrianYour cold fusion app should be the same as viewing the report directly in
the browser itself unless I'm mistaken. Where does it think the graphic
images are? RS puts the img src to be the GUID of the image from the Report
Server. I'm just wondering where your web page thinks the image exists.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> I've got an online application (written in Cold Fusion) that I would like
to
> be able to pull in a report generated in RS. Currently, I can call the
> report directly from the application using an HTTP "get", pass in the url
> string with "rs:Format=PDF", save the resulting PDF file on my server,
then
> render that PDF file in my cold fusion application.
> What I would LIKE to do is render the report in HTML format in my
> application. The problem is, the report has a couple of graphs in it, and
> the resulting HTML that is generated does not know where to find the graph
> images.
> Is there anyway to capture the resulting HTML that is generated from the
> Report Server in such a way that it can be run in another online web
> application (running on the same server as the RS), and yet be able to
> correctly fetch the generated graphical images?
> I hope this makes sense.
> TIA,
> Brian
>|||Thanks for your response Tom.
Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
report by the RS. Embedded in the HTML is the following <img> tag which is
trying to load the graph:
<IMG
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
=C_4_S&rs:ChartImg="/>
When my application calls the HTML page, it is unable to load this image.
This is kind of a strange situation because i'm trying to load the graphical
image that the RS generated when i initially called the report a few seconds
ago using CFHTTP. The problem is, that report was called with certain
parameters causing that particular instance of the report to be generated
with that particular instance of the graph.
What I'm trying to do here might not be possible.
Brian
"Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Your cold fusion app should be the same as viewing the report directly in
> the browser itself unless I'm mistaken. Where does it think the graphic
> images are? RS puts the img src to be the GUID of the image from the
Report
> Server. I'm just wondering where your web page thinks the image exists.
> Tom
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > I've got an online application (written in Cold Fusion) that I would
like
> to
> > be able to pull in a report generated in RS. Currently, I can call the
> > report directly from the application using an HTTP "get", pass in the
url
> > string with "rs:Format=PDF", save the resulting PDF file on my server,
> then
> > render that PDF file in my cold fusion application.
> >
> > What I would LIKE to do is render the report in HTML format in my
> > application. The problem is, the report has a couple of graphs in it,
and
> > the resulting HTML that is generated does not know where to find the
graph
> > images.
> >
> > Is there anyway to capture the resulting HTML that is generated from the
> > Report Server in such a way that it can be run in another online web
> > application (running on the same server as the RS), and yet be able to
> > correctly fetch the generated graphical images?
> >
> > I hope this makes sense.
> >
> > TIA,
> >
> > Brian
> >
> >
>|||I don't know that much about CF so as you say, it may not be possible since
it may be a level of indirection that CF applies to the get. One other
option that you could possibly do is create an IFRAME in your CF app that
links directly to your report via the URL.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response Tom.
> Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> report by the RS. Embedded in the HTML is the following <img> tag which is
> trying to load the graph:
> <IMG
>
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> =C_4_S&rs:ChartImg="/>
> When my application calls the HTML page, it is unable to load this image.
> This is kind of a strange situation because i'm trying to load the
graphical
> image that the RS generated when i initially called the report a few
seconds
> ago using CFHTTP. The problem is, that report was called with certain
> parameters causing that particular instance of the report to be generated
> with that particular instance of the graph.
> What I'm trying to do here might not be possible.
> Brian
> "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > Your cold fusion app should be the same as viewing the report directly
in
> > the browser itself unless I'm mistaken. Where does it think the graphic
> > images are? RS puts the img src to be the GUID of the image from the
> Report
> > Server. I'm just wondering where your web page thinks the image exists.
> >
> > Tom
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > I've got an online application (written in Cold Fusion) that I would
> like
> > to
> > > be able to pull in a report generated in RS. Currently, I can call the
> > > report directly from the application using an HTTP "get", pass in the
> url
> > > string with "rs:Format=PDF", save the resulting PDF file on my server,
> > then
> > > render that PDF file in my cold fusion application.
> > >
> > > What I would LIKE to do is render the report in HTML format in my
> > > application. The problem is, the report has a couple of graphs in it,
> and
> > > the resulting HTML that is generated does not know where to find the
> graph
> > > images.
> > >
> > > Is there anyway to capture the resulting HTML that is generated from
the
> > > Report Server in such a way that it can be run in another online web
> > > application (running on the same server as the RS), and yet be able to
> > > correctly fetch the generated graphical images?
> > >
> > > I hope this makes sense.
> > >
> > > TIA,
> > >
> > > Brian
> > >
> > >
> >
> >
>|||Ok, i researched IFRAMES. I used the following line to pull my report into
the browser:
<IFRAME scrolling="Yes" frameborder="0" height="100%" width="100%"
NAME="Frame1" src="http://pics.10026.com/?src=pathToMyReportWithParameters" ALLOWTRANSPARENCY="true">
The browser rendered my report, even displayed the little spinning
"Generating Report". But alas, the graphs are still missing. Any ideas?
"Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
news:%23liwlz6XEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I don't know that much about CF so as you say, it may not be possible
since
> it may be a level of indirection that CF applies to the get. One other
> option that you could possibly do is create an IFRAME in your CF app that
> links directly to your report via the URL.
> Tom
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> > Thanks for your response Tom.
> >
> > Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> > report by the RS. Embedded in the HTML is the following <img> tag which
is
> > trying to load the graph:
> >
> > <IMG
> >
>
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> > =C_4_S&rs:ChartImg="/>
> >
> > When my application calls the HTML page, it is unable to load this
image.
> > This is kind of a strange situation because i'm trying to load the
> graphical
> > image that the RS generated when i initially called the report a few
> seconds
> > ago using CFHTTP. The problem is, that report was called with certain
> > parameters causing that particular instance of the report to be
generated
> > with that particular instance of the graph.
> >
> > What I'm trying to do here might not be possible.
> >
> > Brian
> >
> > "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> > news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > > Your cold fusion app should be the same as viewing the report directly
> in
> > > the browser itself unless I'm mistaken. Where does it think the
graphic
> > > images are? RS puts the img src to be the GUID of the image from the
> > Report
> > > Server. I'm just wondering where your web page thinks the image
exists.
> > >
> > > Tom
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > >
> > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > > I've got an online application (written in Cold Fusion) that I would
> > like
> > > to
> > > > be able to pull in a report generated in RS. Currently, I can call
the
> > > > report directly from the application using an HTTP "get", pass in
the
> > url
> > > > string with "rs:Format=PDF", save the resulting PDF file on my
server,
> > > then
> > > > render that PDF file in my cold fusion application.
> > > >
> > > > What I would LIKE to do is render the report in HTML format in my
> > > > application. The problem is, the report has a couple of graphs in
it,
> > and
> > > > the resulting HTML that is generated does not know where to find the
> > graph
> > > > images.
> > > >
> > > > Is there anyway to capture the resulting HTML that is generated from
> the
> > > > Report Server in such a way that it can be run in another online web
> > > > application (running on the same server as the RS), and yet be able
to
> > > > correctly fetch the generated graphical images?
> > > >
> > > > I hope this makes sense.
> > > >
> > > > TIA,
> > > >
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>|||As I said in a previous post, I too cannot get images out a HTML.
I'm using the web service to spit out the HTML which I stream out to the user.
The IMG_SRC has someting in it similar to what you report, which doesn't result in an image coming out.
Matt
"G" wrote:
> Ok, i researched IFRAMES. I used the following line to pull my report into
> the browser:
> <IFRAME scrolling="Yes" frameborder="0" height="100%" width="100%"
> NAME="Frame1" src="http://pics.10026.com/?src=pathToMyReportWithParameters" ALLOWTRANSPARENCY="true">
> The browser rendered my report, even displayed the little spinning
> "Generating Report". But alas, the graphs are still missing. Any ideas?
>
> "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> news:%23liwlz6XEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > I don't know that much about CF so as you say, it may not be possible
> since
> > it may be a level of indirection that CF applies to the get. One other
> > option that you could possibly do is create an IFRAME in your CF app that
> > links directly to your report via the URL.
> >
> > Tom
> >
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > Thanks for your response Tom.
> > >
> > > Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> > > report by the RS. Embedded in the HTML is the following <img> tag which
> is
> > > trying to load the graph:
> > >
> > > <IMG
> > >
> >
> src="http://pics.10026.com/?src=pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> > > =C_4_S&rs:ChartImg="/>
> > >
> > > When my application calls the HTML page, it is unable to load this
> image.
> > > This is kind of a strange situation because i'm trying to load the
> > graphical
> > > image that the RS generated when i initially called the report a few
> > seconds
> > > ago using CFHTTP. The problem is, that report was called with certain
> > > parameters causing that particular instance of the report to be
> generated
> > > with that particular instance of the graph.
> > >
> > > What I'm trying to do here might not be possible.
> > >
> > > Brian
> > >
> > > "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> > > news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > > > Your cold fusion app should be the same as viewing the report directly
> > in
> > > > the browser itself unless I'm mistaken. Where does it think the
> graphic
> > > > images are? RS puts the img src to be the GUID of the image from the
> > > Report
> > > > Server. I'm just wondering where your web page thinks the image
> exists.
> > > >
> > > > Tom
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > >
> > > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > > > I've got an online application (written in Cold Fusion) that I would
> > > like
> > > > to
> > > > > be able to pull in a report generated in RS. Currently, I can call
> the
> > > > > report directly from the application using an HTTP "get", pass in
> the
> > > url
> > > > > string with "rs:Format=PDF", save the resulting PDF file on my
> server,
> > > > then
> > > > > render that PDF file in my cold fusion application.
> > > > >
> > > > > What I would LIKE to do is render the report in HTML format in my
> > > > > application. The problem is, the report has a couple of graphs in
> it,
> > > and
> > > > > the resulting HTML that is generated does not know where to find the
> > > graph
> > > > > images.
> > > > >
> > > > > Is there anyway to capture the resulting HTML that is generated from
> > the
> > > > > Report Server in such a way that it can be run in another online web
> > > > > application (running on the same server as the RS), and yet be able
> to
> > > > > correctly fetch the generated graphical images?
> > > > >
> > > > > I hope this makes sense.
> > > > >
> > > > > TIA,
> > > > >
> > > > > Brian
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>|||Take a look at this sample from books online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_49f6.asp
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response Tom.
> Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> report by the RS. Embedded in the HTML is the following <img> tag which is
> trying to load the graph:
> <IMG
>
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> =C_4_S&rs:ChartImg="/>
> When my application calls the HTML page, it is unable to load this image.
> This is kind of a strange situation because i'm trying to load the
graphical
> image that the RS generated when i initially called the report a few
seconds
> ago using CFHTTP. The problem is, that report was called with certain
> parameters causing that particular instance of the report to be generated
> with that particular instance of the graph.
> What I'm trying to do here might not be possible.
> Brian
> "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > Your cold fusion app should be the same as viewing the report directly
in
> > the browser itself unless I'm mistaken. Where does it think the graphic
> > images are? RS puts the img src to be the GUID of the image from the
> Report
> > Server. I'm just wondering where your web page thinks the image exists.
> >
> > Tom
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > I've got an online application (written in Cold Fusion) that I would
> like
> > to
> > > be able to pull in a report generated in RS. Currently, I can call the
> > > report directly from the application using an HTTP "get", pass in the
> url
> > > string with "rs:Format=PDF", save the resulting PDF file on my server,
> > then
> > > render that PDF file in my cold fusion application.
> > >
> > > What I would LIKE to do is render the report in HTML format in my
> > > application. The problem is, the report has a couple of graphs in it,
> and
> > > the resulting HTML that is generated does not know where to find the
> graph
> > > images.
> > >
> > > Is there anyway to capture the resulting HTML that is generated from
the
> > > Report Server in such a way that it can be run in another online web
> > > application (running on the same server as the RS), and yet be able to
> > > correctly fetch the generated graphical images?
> > >
> > > I hope this makes sense.
> > >
> > > TIA,
> > >
> > > Brian
> > >
> > >
> >
> >
>|||Yes, you are responsible to managing the images. Since the end user is not
talking directly to the Report Server, the server doesn't know when the
session is no longer valid.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt P" <MattP@.discussions.microsoft.com> wrote in message
news:32316ADD-BD93-496A-9261-D6D92C96EDC4@.microsoft.com...
> Thanks. After much fiddling with paths I managed to solve the problem.
> Things I had to do additionally/differently to the BOL online article
> were:
> - pass in the same parameters as to the Render method
> - path in a full path in the StreamRoot parameter.
> EG \\the-host-name\Collaborators\BXYZDevtMain\ManagementReports\
> The help is most unclear in this respect. To my readin git meant that
> that was where the images are being read from on the report server. No -
> its the path on the web server to where I am to have copied the images in
> the manner indicated by the BOL code. And unless it's in a format I've
> shown above it's completely ignored, and the full 'gibberish' URL put as
> the IMG SRC - with all the parameters etc.
>
> Am I responsible for deleting the image files after a certain time?
> thanks
> Matt
>
> "Tudor Trufinescu (MSFT)" wrote:
>> Take a look at this sample from books online
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_49f6.asp
>> --
>> Tudor Trufinescu
>> Dev Lead
>> Sql Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "G" <brian.grant@.si-intl-kc.com> wrote in message
>> news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
>> > Thanks for your response Tom.
>> >
>> > Using the <CFHTTP> "get", i'm able to capture the HTML generated for
>> > the
>> > report by the RS. Embedded in the HTML is the following <img> tag which
>> > is
>> > trying to load the graph:
>> >
>> > <IMG
>> >
>> src="http://pics.10026.com/?src=pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
>> > =C_4_S&rs:ChartImg="/>
>> >
>> > When my application calls the HTML page, it is unable to load this
>> > image.
>> > This is kind of a strange situation because i'm trying to load the
>> graphical
>> > image that the RS generated when i initially called the report a few
>> seconds
>> > ago using CFHTTP. The problem is, that report was called with certain
>> > parameters causing that particular instance of the report to be
>> > generated
>> > with that particular instance of the graph.
>> >
>> > What I'm trying to do here might not be possible.
>> >
>> > Brian
>> >
>> > "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
>> > news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
>> > > Your cold fusion app should be the same as viewing the report
>> > > directly
>> in
>> > > the browser itself unless I'm mistaken. Where does it think the
>> > > graphic
>> > > images are? RS puts the img src to be the GUID of the image from the
>> > Report
>> > > Server. I'm just wondering where your web page thinks the image
>> > > exists.
>> > >
>> > > Tom
>> > >
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > >
>> > >
>> > >
>> > > "G" <brian.grant@.si-intl-kc.com> wrote in message
>> > > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
>> > > > I've got an online application (written in Cold Fusion) that I
>> > > > would
>> > like
>> > > to
>> > > > be able to pull in a report generated in RS. Currently, I can call
>> > > > the
>> > > > report directly from the application using an HTTP "get", pass in
>> > > > the
>> > url
>> > > > string with "rs:Format=PDF", save the resulting PDF file on my
>> > > > server,
>> > > then
>> > > > render that PDF file in my cold fusion application.
>> > > >
>> > > > What I would LIKE to do is render the report in HTML format in my
>> > > > application. The problem is, the report has a couple of graphs in
>> > > > it,
>> > and
>> > > > the resulting HTML that is generated does not know where to find
>> > > > the
>> > graph
>> > > > images.
>> > > >
>> > > > Is there anyway to capture the resulting HTML that is generated
>> > > > from
>> the
>> > > > Report Server in such a way that it can be run in another online
>> > > > web
>> > > > application (running on the same server as the RS), and yet be able
>> > > > to
>> > > > correctly fetch the generated graphical images?
>> > > >
>> > > > I hope this makes sense.
>> > > >
>> > > > TIA,
>> > > >
>> > > > Brian
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>

Pulling row values from a dataset using embedded code?

I am trying to figure out a way to pull the values of one of my report
columns once the report has been rendered to create a comma separated list of
those values to pass as a paramater to another report. I figure i will have
to do this in the code part of RS. Can anyone help me with the proper
functions and syntax to walk through the rows returned by my report and pull
the values from the column I need.
I imagine it would look like this
function GetItemList()
Dim rtnstr As String
Dim x As Interger
Set rtnstr = ""
for x = 0 to (RowNumber("DatasetName")-1)
rtnstr = rtnstr & DatasetName(x).ColumnName.Value & ","
next
return rtnstr
end function
What I am stuck on is how to pull the values from the column in the
particular dataset I need and also how to determine the Scope of the dataset
to know how long th loop needs to run for.
ThanksOut of the box, you can only base a report on the following data sources: SQL
Server, Oracle, OLE DB and ODBC. The data output by a report does not fall
into one of these categories; in other words, there is no data processing
extension that allows you to read data from one report into another report.
You should re-design your solution. What about writing a stored procedure
that writes the data to a second table, appending commas as required to
create the csv format you want? You could then report off this second table?
Charles Kangai, MCDBA, MCT
"jordang" wrote:
> I am trying to figure out a way to pull the values of one of my report
> columns once the report has been rendered to create a comma separated list of
> those values to pass as a paramater to another report. I figure i will have
> to do this in the code part of RS. Can anyone help me with the proper
> functions and syntax to walk through the rows returned by my report and pull
> the values from the column I need.
> I imagine it would look like this
> function GetItemList()
> Dim rtnstr As String
> Dim x As Interger
> Set rtnstr = ""
> for x = 0 to (RowNumber("DatasetName")-1)
> rtnstr = rtnstr & DatasetName(x).ColumnName.Value & ","
> next
> return rtnstr
> end function
> What I am stuck on is how to pull the values from the column in the
> particular dataset I need and also how to determine the Scope of the dataset
> to know how long th loop needs to run for.
> Thanks|||Hi Charles
My Report is already driven by a stored procedure, however, there are local
filters the user can apply to the report through the report viewer as well.
So As far as the stored proc generates the dataset, I'm good to handle those
results and create the list i need. The problem is when the user applies a
filter that is specific to that report and thus not sent back to the stored
proc. I was hoping there was a way I could avoid rewriting my stored proc to
include all my report parameters, or furthermore, writing another stored proc
to generate my list.
Thanks for your help.
"Charles Kangai" wrote:
> Out of the box, you can only base a report on the following data sources: SQL
> Server, Oracle, OLE DB and ODBC. The data output by a report does not fall
> into one of these categories; in other words, there is no data processing
> extension that allows you to read data from one report into another report.
> You should re-design your solution. What about writing a stored procedure
> that writes the data to a second table, appending commas as required to
> create the csv format you want? You could then report off this second table?
> Charles Kangai, MCDBA, MCT
>
> "jordang" wrote:
> > I am trying to figure out a way to pull the values of one of my report
> > columns once the report has been rendered to create a comma separated list of
> > those values to pass as a paramater to another report. I figure i will have
> > to do this in the code part of RS. Can anyone help me with the proper
> > functions and syntax to walk through the rows returned by my report and pull
> > the values from the column I need.
> >
> > I imagine it would look like this
> >
> > function GetItemList()
> > Dim rtnstr As String
> > Dim x As Interger
> > Set rtnstr = ""
> > for x = 0 to (RowNumber("DatasetName")-1)
> > rtnstr = rtnstr & DatasetName(x).ColumnName.Value & ","
> > next
> > return rtnstr
> > end function
> >
> > What I am stuck on is how to pull the values from the column in the
> > particular dataset I need and also how to determine the Scope of the dataset
> > to know how long th loop needs to run for.
> >
> > Thanks

Pulling reports from Reporting server

I have reports posted to my server and need to edit them. My issue is the original rdl has been "misplaced". I do not have a model built for this server so I cannot use the built in report builder. Is there a way to "download" from the reporting server?Yes. Using Report Manager, If you click on the "properties" of the report and go to the "general" tab, there is an "edit" button right below "Report Definition". This should prompt an edit/save dialog box that will let you download the report if you have the appropriate permissions.

Pulling Random Distinct Percentage

Having trouble coming up with a fast and efficient sproc for this.
Thanks in advance for any help!
tblRecords
record_id (int) [key]
location_id (int)
owned_by_id (int) [default = 0]
is_complete (int) [default = 0]
date_entered (datetime) [default = getDate()]
date_completed (datetime)
I'm trying to populate a Datagrid with ((Total - total completed -
total owned) * 7%) of random non-complete records and all owned records
within a given date range for each site sorted by date_entered.
I figure I'll need to create a temp table holding all the totals
(total, total completed & total owned) for each site (using distinct
and count). And then for each row (or site) loop through the math
shown above and then select random top X where is_complete = 0 AND
owned_by_id = 0 AND date_entered BETWEEN startDate AND stopDate.
Then SELECT WHERE is_complete = 0 AND owned_by_id <> 0 AND date_enteed
BETWEEN startDate AND stopDate. Then somehow merge the result... then
merge again with the looping table. Once complete sort table by
date_entered and return. I'm not sure if that is the best/easiest way
to do this... so I'm wondering if someone else knows a better way, and
can provide an example, as my SQL skills are not up to par for this.
Thanks again!
~GregHi
Check out http://www.aspfaq.com/etiquette.asp?id=5006 on how to post DDL and
sample data. Also posting the required resultset from your data would be
helpful.
If your is_completed column can only have values of 0 or 1 then you could do
something like:
SELECT location_id, owned_by_id, SUM(is_complete) as Completed,
SUM(1-is_complete)AS incomplete, COUNT(*) AS total
FROM tblRecords
GROUP BY location_id, owned_by_id
to get the number completed. You will need to add the date constriction in a
WHERE CLAUSE. If you can have other values you can do something like:
SELECT location_id, owned_by_id, SUM(CASE WHEN is_complete = 1 THEN 1 ELSE 0
END) as Completed, SUM(CASE WHEN is_complete = 0 THEN 1 ELSE 0 END)AS
incomplete, COUNT(*) AS total
FROM tblRecords
GROUP BY location_id, owned_by_id
It is not clear if your owned_by_id is actually an is_owned binary value!.
You could use this query in a view or derived table instead of using a
temporary table.
HTH
John
"Bac2Day1" <Bac2Day1@.gmail.com> wrote in message
news:1136405669.374006.39790@.g44g2000cwa.googlegroups.com...

> Having trouble coming up with a fast and efficient sproc for this.
> Thanks in advance for any help!
> tblRecords
> record_id (int) [key]
> location_id (int)
> owned_by_id (int) [default = 0]
> is_complete (int) [default = 0]
> date_entered (datetime) [default = getDate()]
> date_completed (datetime)
> I'm trying to populate a Datagrid with ((Total - total completed -
> total owned) * 7%) of random non-complete records and all owned records
> within a given date range for each site sorted by date_entered.
> I figure I'll need to create a temp table holding all the totals
> (total, total completed & total owned) for each site (using distinct
> and count). And then for each row (or site) loop through the math
> shown above and then select random top X where is_complete = 0 AND
> owned_by_id = 0 AND date_entered BETWEEN startDate AND stopDate.
> Then SELECT WHERE is_complete = 0 AND owned_by_id <> 0 AND date_enteed
> BETWEEN startDate AND stopDate. Then somehow merge the result... then
> merge again with the looping table. Once complete sort table by
> date_entered and return. I'm not sure if that is the best/easiest way
> to do this... so I'm wondering if someone else knows a better way, and
> can provide an example, as my SQL skills are not up to par for this.
> Thanks again!
> ~Greg
>

pulling progress data

I'm trying to pull data from about 30 progress databases using DTS and
scheduling the jobs to run monthly. I'd like to pull data between
specific dates, but for some reason, I can't figure out how to filter
the data on the progress side.

I want to run a query that will pull all data from
prior-month/8/current-year
and
current-month/15/current-year

I'll also have to account for when it's january, make it december of
the year before.

Any ideas?
thanks,
M@.Well, I figured out part of it...

WHERE ("create-date" >
to_char(CONCAT(CONCAT(to_char("MONTH"(add_months("sysdate"(), - 1))),
'/8/'), LTRIM(to_char("YEAR"("sysdate"())),
' '))))

This whole nasty mess would give you 5/8/2006 if you ran it in June of
2006.

Now I have to figure out the other part of this mess is what the hell
happens when it's January :)

M@.

mattcushing@.gmail.com wrote:
> I'm trying to pull data from about 30 progress databases using DTS and
> scheduling the jobs to run monthly. I'd like to pull data between
> specific dates, but for some reason, I can't figure out how to filter
> the data on the progress side.
> I want to run a query that will pull all data from
> prior-month/8/current-year
> and
> current-month/15/current-year
> I'll also have to account for when it's january, make it december of
> the year before.
> Any ideas?
> thanks,
> M@.