Displaying The SP Script Using QA

Oct 21, 2006

Hi do u know what the shortcut or the code command to diplay an SP code in QA.
Instead of right clicking the SP in QA and clicking "Script object to New window as Create" is there a command or a shortcut that I can type using keyboard
Thank you

View 5 Replies


ADVERTISEMENT

Looping Through Stored Procedure Inside Another Stored Procedure And Displaying The Category And Then Displaying 1 Item In Each Category

Sep 21, 2006

I used to do this with classic asp but I'm not sure how to do it with .net.Basically I would take a table of Categories, Then I would loop through those.  Within each loop I would call another stored procedure to get each item in that Category. I'll try to explain, Lets say category 2 has a player Reggie Bush and a player Drew Brees, and category 5 has Michael Vick, but the other categories have no items.Just for an example.. Category Table: ID   Category1      Saints2      Falcons3      Bucaneers4      Chargers5      FalconsPlayer Table:ID    CategoryID   Player                 News                                Player Last Updated1            1           Reggie Bush       Poetry in motion                                9/21/20062            1           Drew Brees         What shoulder injury?                        9/18/20063            5           Michael Vick       Break a leg, seriously.                       9/20/2006 Basically I would need to display on a page:SaintsReggie BushPoetry in MotionFalconsMichael VickBreak a leg, seriously.So that the Drew Brees update doesnt display, only the Reggie Bush one, which is the latest.I have my stored procedures put together to do this.  I just don't know how to loop through and display it on a page.  Right now I have two datareaders in the code behind but ideally something like this, I would think the code  would go on the page itself, around the html.

View 1 Replies View Related

Displaying 0 In Int

Apr 25, 2007

This is what I'm trying to do:

If String AB06 is then I need to get AB05; if it is AB11 I need to get AB10.

My select statement looks like this:

select 'AB'+(cast(substring(period,3,2) as int)-1) from table.

Result is AB6. But I want AB06 (ABzero6)


But when I do this, I'm getting AB6 instead of AB06. Can someone please tell me how to have '0' in front of 6? I guess when I cast it as integer, it is ignoring the leading 0.


Thanks.

View 4 Replies View Related

Displaying % In Value

Oct 27, 2006

Hi

I am calculating percentage using expression. I want to display % at the end of the result.

If I use P1 or P0 somehow it multiplies the result with 100 I guess.

Here is what my calculated value is

15.384515

and I want to display 15.38%

Using P1 or P0 I am getting 1,538.5%

How can I get the desired result?

Any help would be appreciated.

Regards

Amit

View 5 Replies View Related

Displaying

May 7, 2008

Hi there

I got the following returned simple dataset as follow:






Code Snippet

ReportViewType; Category; Name; Units; Price;
LIST_VIEW; FRUITS; Apple; 1; $10
LIST_VIEW; FRUITS; Banana; 2; $11
LIST_VIEW; CARS; Corolla; 8; $100
LIST_VIEW; CARS; BMW; 10; $200

I've managed to grouped by Category field nicely and added extra calculated column for handling to total plus as well as Total for each group plus added a new row for TOTAL in the TABLE and returned as follow:





Code Snippet

FRUITS
Apple; 1; $10; $10
Banana; 2; $11; $22
TOTAL FRUITS; $32

CARS
Corolla; 8; $100; $800
BMW; 10; $200; $2000
TOTAL CARS: $3000


TOTAL: $3032

Now I want to put another extra row underneath TOTAL for handling the calculated but the business rule is only for displaying from the first group for instance:






Code Snippet

TOTAL: $3032



Calculated Average per fruits: $1010.67 ($3032 / 3 UNITS).

3 UNITS is coming from Units for Apple and Banana.

I don't know if I can do this cause i did try to use





Code Snippet

=SUM(IIF(Fields!Category.value = "FRUITS", Fields!Units.Value, 0))
But it's successfully compiled but the report result error (#Error) on that field only. Any ideas?

I thought a simple like this can be handled quite easily instead of creating a new report view type in the the same dataset to handle this particular extra line.

Waiting your comment/feedback.





View 4 Replies View Related

Displaying Results Of Map

Feb 16, 2008

I am trying to create a user permission system that is stored in a database.  What is the best table structure for accomplishing this?   How could I display the permissions in a grid?  Currently I have a users table and a permissions table.  I created a map between the two.  However, I don't see how this allows me to display a grid.  All my "columns" for permissions are actually rows from the permissions table. So ideally my grid would look something like this. User | P1 | P2 | P3 |A      | T   |  F  |  T  |B      | T   |  T  |  T  |Thanks for any help.  I am relatively new to SQL so please explain gently. 

View 2 Replies View Related

Displaying Images

Mar 16, 2006

Hi,
I am a new VWD user and have been trying to set up a website that allows 1 user to upload images into to SQL Express database and then display them with  a variety of other fields.
I have searched the forums, several books and many ASP "training" websites to find out how to do this. Every website seems to teach how to display a list of employees or show photo gallery, but none explains how to upload an image, save it in the appropriate field(s) in the database, and then display it when requested in a Datagrid or Details View using VWD and SQL Express 2005
Can any one give me directions to a solution, or send me a simple solution to this?
The best example of what I need is is a real estate listing, wherethe property for sale has 8 to 10 descriptive fields and 1 to 3 images that are displayed.
Any help would be appreciated.
Spacecaetrg.

View 4 Replies View Related

Reports Not Displaying

Jun 18, 2003

I have built an ADP for an internal project. The rpoblem I'm having is that one computer is not displaying reports. No matter who the user is it will not show the reports. I thought it might be a software issue/conflict, so I changed out the hardrive and started with a clean OS with only MS Office installed on it. I have also made sure that the users have access rights to SQL along with all sprocs used in the reports. But I'm still having the same problem. There are four other computers in the office that use the application and all work fine. If anyone has any ideas or suggestions I would be glad to hear them.

View 6 Replies View Related

Getting MAX Value And Displaying Record

Dec 2, 2004

Hi all,

I basically want to display the single row that has the highest 'jobid' using a SP. I was playing with MAX(jobid) but getting errors about no group by, etc. Where do I begin with this?


SELECT Purchord, JobNo, Descr, customer, jobid
FROM Jobs

View 4 Replies View Related

Tables Not Displaying In SQL

Dec 30, 2003

I am hoping someone can help me on this. I have lost the ability to see tables in one database. I can see views and have full access rights on this database. I was trying to install OLAP Analysis on my PC and suddenly I lost this capability on one of the databases I access. Any thoughts? I have looked at everything I can find trying to fix this. Have re-installed and even cleared my user and re-added. It is something on my PC alone since it also affects anyone who signs on to my box.

View 14 Replies View Related

List Box Is Not Displaying

Mar 30, 2004

I have a list box getting a filtered recordset from a stored procedure using ADO calling in VB6.
The recordset returns the two records with correct values. The problem is it is not displaying in the list box. Why? I tried using .additem property but it is not available in Access 2000. Can anyone help me with this?

Function ..
Dim rs_get_defect_desc As New ADODB.Recordset, lot_n as integer
Set lot_n = 4051

Rs_get_defect_desc.Open "EXEC spGet_desc_defect @lot_n=" & lot_n, CurrentProject.Connection
Do While Not rs_get_defect_desc.EOF

lstbox.RowSource = rs_get_defect_desc(0) & " " & rs_get_defect_desc(1)
rs_get_defect_desc.MoveNext

Loop

View 1 Replies View Related

Displaying Columns Twice

May 9, 2008

Hello All,

I have a little problem. Here is the scenario:

I got two tables Asset and Personnel

Personnel has FirstName, LastName,and username which is unique.

Asset table stores all information related to an asset and the username to whom the asset is assigned and the POC username.

The tables look like this:

Personnel Table
FirstName, Last Name, UserName
John, Doe, jdoe
Bill, Smith, bsmith

Asset Table
POCUserName, AssigneeUserName
jdoe,bsmith

My problem arises when I want to display First Name and Last Name for both the POCusername and the AssigneeUserName since FirstName and LastName columns exists once in the Personnel table. How can I display the columns twice. Lets say POCFirstName, POCLastName, AssigneeFirstName, and AssigneeLastName. Or this is something that can't be done.

The query below only display the Assignee info. Of course, I need to something else to display the POC info as well...don't where to go from here...

select tblPersonnel.FirstName, tblPersonnel.LastName, tblAsset.AssigneeUserName, tblAsset.POCUserName
from tblVendor, tblAsset, tblPersonnel
where and tblPersonnel.UserName = tblAsset.AssigneeUserName
and tblAsset.POCUserName in(select tblPersonnel.UserName from tblAsset, tblPersonnel
where tblPersonnel.UserName= tblAsset.POCUserName)

Any help is greatly appreciated

~
N

View 3 Replies View Related

Counting And Displaying

Jun 8, 2007

I need to add up the number of people who joined this month and compare that number to the number of people who joined last month and display the results in a report:

FirstName..LastName.....StartedDate
Randy......Simpson......5/4/2007 10:00:00 PM
Steve......Rowe.........5/2/2007 10:00:00 PM
Eric.......Dickerson....5/4/2007 10:00:00 PM
Gloria.....Sanches......5/1/2007 12:00:29 AM
Andres.....Marcelino....5/1/2007 12:06:31 AM
katie......ryan.........6/4/2007 12:08:35 AM
Denise.....River........6/4/2007 12:27:14 AM
Kellog.....Stover.......6/5/2007 12:37:20 AM
Glenn......Sanders......6/1/2007 12:42:40 AM

View 15 Replies View Related

Displaying A Table

Jul 23, 2005

I'm not sure how to go about this and need some help.I've got a data extract rather than a properly structure table in SQL.It looks something like below:Name: Item:John BallJohn RacketPaul BallJim GloveJim BallWhat sort of script can I run that will return each name once and thenthe Items in as many columns needed to list them all?I.e. so that it will look likeName: Item1 Item2John Ball RacketPaul BallJim Glove BallRegards,Ciarán

View 1 Replies View Related

ToolTip Not Displaying

Jun 28, 2007

What am I missing on the tooltip. I have entered a very simple if statement based on a parameter. Why will it not display with I run the report?



I have entered the simple formula in the tooltip under the fields textbox propeties. What am I missing.

=iif(Parameters!ExcelExport.Value = False, "No", "Yes")

View 6 Replies View Related

Displaying Reports

Nov 6, 2007

Hi

I want to use a hosting service that has ssrs capability. I am using asp to generate a website that's data driven by sql 2005. I want to know if it's possible to display the reports I've created to anyone on the web site with the use of URLs to the report rdl. Can this be done on an asp page or does it have to be an aspx page (.net)? It seems like this would be a very common application of sql and report services. Thank you for any help you can give me.

Philip

View 1 Replies View Related

Most Charts Not Displaying

Feb 28, 2007

I've got a report with a table holding a subreport that contains a number of Dundas charts. Each of these charts displays A LOT of data.

Now... after deploying the report, only a few charts at the bottom of the report are displayed -- the rest display the Image-doesn't-exist icon (File image with red X across it). Can anyone tell me what's going on? My best guess is that this is a memory issue on the server side...

View 1 Replies View Related

Displaying Results Of MAP

Jan 8, 2008

I have two tables joined by a map. For example

Table1
[Ball, Frisbee, Kite]

Table2
[Red, Green, Blue]

MAP
[Ball:Green, Ball:Blue, Kite:Red]

I want to return a table that shows each toy and what colors it is available in.
Column1 - Toys | Column2 - Comma separated list of colors
Ball - Green, Blue
Kite - Red
Frisbee -

I have absolutely no idea how to do this even after googling all morning. Please help if you can. There must be a way to do this!

View 4 Replies View Related

Textbox Value Not Displaying

Mar 7, 2008



I'm having an issue where the Textbox in a RS Report (1 page) is not showing up. I have 4 reports all of which are basically the same except 1 or 2 different wordings however on all of them they are not showing up using http://localhost/reports . If i'm in Visual Studio and click on preview report I see everything just fine. But when I view online (pdf, html, excel) it does not show. The footer however shows up fine on all of them. Does anyone have a fix?

PS: The wierd thing is that on Production they are working but on the Test server they are not and nothing has changed. Both servers are running the same version of SQL 2005. I need to re-deploy the reports coming soon with changes but I am afraid that Production will stop working then.

-Chris

View 1 Replies View Related

Displaying Xml With Xslt In RS

Sep 10, 2007



Hi,

I've got an xml and an xslt - I want to get that into reporting services. Right now I have a link to the xml file in a 'report', which will open it correctly and format with the xslt. I'd like it to display without going to an external link.

I know how to use an xml datasource, but I need the xslt applied, since it has some nice formatting in it - so i don't think that will work.

I'm trying to report on the results of a scripted ms baseline security analyzer of several servers - the style sheet lets you drill down and has links to the base reports.

Thanks for your help.

View 4 Replies View Related

Displaying A Value Only Once In A Table

Jan 8, 2008

Hi,

I have a table with a row to display the count of all records with a specified specialty. The count is displaying the correct value, however the row is being displayed 20 times as there are 20 records.

I would like this row to only be displayed once. I'd appreciate being pointed in the right direction as to how to do this.

Thanks,
John

View 14 Replies View Related

Displaying Remainders

Apr 12, 2007

I need to show the whole number and remainder each as wole numbers. I have been trying to use modulo on the advice from a friend, but I don't understand this function.



More of an exlpanition: I am working with inventory and shipping quantities. If a pallet consists of 9 cases, and I have an order for 20 cases, I need to display in a report 2 pallets and 2 cases. These numbers can be in the same column or different columns...at this point I just need to be able to display the numbers.



Is there any way to do this? Any help would be appreciated.



-Thanks



P.S.

I posted this in the general forums before I realized I was there...not sure how to move posts, so I double-posted....sorry.

View 5 Replies View Related

Displaying Data - Question

Aug 7, 2006

Dont laugh;
How do I create a simple sqlcommand in C# that shows data. I have the code for VB but I a missing something in the converstion. I know SQL but I dont get the simple steps of displaying data. I have got all of the Visual Basic stuff down I just need help with doing it by hand in C#.
or point my to a URL so that I can get  the code.
Thanks

View 1 Replies View Related

Inserting Records And Displaying Them

Oct 26, 2006

Before I start driving myself nuts, I'd like to make sure my approach is correct.I want to create a simple job posting board.I have a text boxes for company name, email, job title, and job description, and a submit button.I created a table in my database called "JobPostings", with columns called "CoName", "CoEmail", "JobTitle", and "JobDesc"When someone fills out the fields and clicks submit, it will insert the new records.So,1. Is this the correct approach so far?2. What is the best way to display the job listings? A grid view?3. At submit time, how can I include that day's date?4. How can I get the records in the database to delete after 90 days?Thanks.

View 1 Replies View Related

Displaying Messages To Users

Oct 26, 2006

Hello, I need some help coming up with a good concept for returning stored procedure messages to a user. Here is my setup: Stored Proc:@ReturnCode  INT - OUT@ReturnDetails VARCHAR(150) - OUT If my stored procedure returns a value of less than 1 for the @ReturnCode I want to display the error message in @ReturnDetails, Now I have a DAL that returns back the @ReturnCode to the codebehind ( via a function ) but how can i display the @ReturnDetails to the user, I would like to use a javascript alert, I know how to display the message but my question is what is the best design for returning the message to the user? I was thinking about passing in the caller when i instantiate my DAL, but I don't really like that idea, My other idea was have my function return a string like "-1|Invalid Password" and parsing it but don't like that either. Also is there a way to find out the page caller from my DAL? That would help a lot. Your ideas are greatly appreciated. 

View 1 Replies View Related

Displaying Some Predefined No. Of Rows

Mar 25, 2007

hi,i wanted to know if there is any sql statement that enables the query to display say first '10' rows only.Eg: suppose SELECT * from Location; returns 25 rows and i want only 10 rows in that to be displayed. How can this be done? Help please. 

View 1 Replies View Related

Displaying One Data Record

Jun 30, 2007

Hi all, this is a very basic question of diplaying a data. on my aspx page I have datasource that will return only ONE record.
  <asp:SqlDataSource ID="sdsCategoryName" runat="server" ConnectionString="<%$ ConnectionStrings:KaruselaConnectionString %>"        SelectCommand="SELECT Title FROM tbh_Categories WHERE CategoryID=@categoryID  ">        <SelectParameters>            <asp:QueryStringParameter DefaultValue="-1" Name="CategoryID" QueryStringField="id" Type="int32"/>        </SelectParameters>    </asp:SqlDataSource> 
on the server side I would like to manipulate the title of the page according to the data returned from the query:
 and on the behind code if (!this.IsPostBack && !string.IsNullOrEmpty(this.Request.QueryString["ID"]))
{
DataView dv2 = (DataView)sdsCategoryName.Select(arg);
this.Title = string.Format(this.Title, dv2.Table.Columns[0].ToString());
dv2.Dispose();
}
  of course it doesn't work. my question is this. do we really have to put the query datasource on the client side?and secondly, how can I view the recorsd I recieves from the query?Thanks for the help. 

View 1 Replies View Related

Urgent--default Value Is Not Displaying

Sep 24, 2007

i am using sql server 2000 . i have declared some default values on table but when i am tring to  insert value through asp.net page its showing blank value in the field .
please tell me what to do

View 1 Replies View Related

Need Help Displaying A Fraction As A Decimal

Oct 15, 2007

 Hi, If you execute the following query in TSQL: select 1/2 you will always get back zero.  I need a simple SQL statement that will return its  decimal equivalent (i.e. .5).   Can anyone give me a hint how to do this? Thanks  

View 3 Replies View Related

Displaying Images From SqlServer In ASP .NET

Jan 9, 2008

can any one help me with the complete code step by step i mean my table name is Image1 and feild name is picture , please let me know the code with my feild name and in my table i have only picture feild and i have stored in binary format , please help me

View 2 Replies View Related

Displaying My Querry Horizontally

Feb 22, 2008

Is there a way to display my querry horizontally? 

View 2 Replies View Related

Please Help Displaying Specific Data

Mar 10, 2008

Hi I have used the create user wizard to create a registration page my table stores the user details and user id. I am also using the login wizard to create a log in page . I now want to display the details of the currently logged in user usind details view and allow them to view and edit their details. where and how do i create the session varible anh how do I wtire the sql select statement say select first name from table1 where (the userid I stored earlier in a table when the user registered ) = (this should be the currently logged in user'id). I am a novice so I would appreciate code snippets
My code in asp page for the details looks like this
 asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="SqlDataSource1"
Height="50px" Width="125px">
<EditRowStyle BackColor="#CCFF99" />
<AlternatingRowStyle BackColor="#FFCCFF" />
</asp:DetailsView><asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="SELECT [FirstName], [LastName], [City], [Listing] FROM [UserDetails] WHERE ([UserId] = @UserId)">
</asp:SqlDataSource>
 
novice This shows no data when I test it. I have tried the folling in the .vb page no luck.
 Protected Sub DetailsView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles DetailsView1.DataBound
Dim UserId As Integer = Me.DetailsView1.DataItem("userID")Session("_UserID") = UserId
End Sub

View 5 Replies View Related

Counting And Displaying Groups

Apr 3, 2008

Lets suppose I have a db which looks like:District        FundVAE            AVAW           AVAE            BDC              CDC              ANYS            BMD             CVAW           AI would like a query which displays the following dynamically.   I don't know each unique member of the Fund field, they could be added by the end user. It might include M,J,S etc. I need the columns dynamically created.  I can do it statically if I know the distinct members of fund.  I would like to be able to do it dynamically. Any ideas?  The static version with multiple queries is at the end.District     Total       A         B      CVAE            2         1         1             VAW           2         2         DC              3         2                  1 NYS            1                    1                          MD              1                            1      
Query Name =GroupByDistSELECT     district, COUNT(district) AS dcountFROM         dbo.mydbGROUP BY districtQuery Name=DCountASELECT     district, COUNT(district) AS dcountFROM         dbo.mydbWHERE     (fund = N'A')GROUP BY district   
Query Name=DCountBSELECT     district, COUNT(district) AS dcountFROM         dbo.mydbWHERE     (fund = N'B')GROUP BY district    
Query Name=DCountCSELECT     district, COUNT(district) AS dcountFROM         dbo.mydbWHERE     (fund = N'C')GROUP BY district     
SELECT GroupByDist.district, GroupByDist.dcount AS Total, DCountA.dcount AS A, DCountB.dcount AS B, DCountC.dcount AS C From    GroupByDist LEFT OUTER JOIN                      DCountC ON GroupByDist.district = DCountC.district LEFT OUTER JOIN                      DCountB ON GroupByDist.district = DCountB.district LEFT OUTER JOIN                      DCountA ON GroupByDist.district = DCountA.district
 

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved