MS SQL Server :: How To Show ChartFX Reports In ReportServer And How To Show Tooltips For Reports Using Chart Properties

How To Show Duplicates In Reports
I'm trying to create a report in Sql Server 2005 Reporting Services where it will display duplicates rows in the reports. I'm unable to find the property that enables this. I would need something like HideDuplicates = false, but that is not the way it is intended to be used. If HideDuplicates is left blank, it seems to still hide duplicate values if the preceding row matches.

The report is a crosstab type, so we are using a Matrix for the report item. I'll illustrate with a simple example:

This is what we currently get:

Catagory
Class
Detail

Type 1
A
Item 1

B
Item 2

Item 3

Type 2
A
Item 4

B
Item 5

This is what we want:

Catagory
Class
Detail

Type 1
A
Item 1

Type 1
B
Item 2

Type 1
B
Item 3

Type 2
A
Item 4

Type 2
B
Item 5

I'm sure its something simple, but we just cant seem to find the solution,

Thanks

Darin

View Replies ! View Related

Show More Than Two Reports In Report Viewer

Hello Reporting Gurus:

I am viewing 3 reports on one report viewer every report has different size .it is showing all right on printer but one report displays two report pages on report viewer from 2nd page.i am adjusting the report sizes on selection of reports.

Select Case str_CallReportOption

Case "PrivacyLegislation" ''Calling Privacy Legislation Report

Me.rptClientCompliance.Width = New Unit(21.5, UnitType.Cm)

Me.rptClientCompliance.Height = New Unit(29, UnitType.Cm)

rptClientCompliance.ServerReport.ReportPath = "/WinfundReport/PrivacyLeg"

Case "Person" ''Calling Persons Only Report

Me.rptClientCompliance.Width = New Unit(21.5, UnitType.Cm)

Me.rptClientCompliance.Height = New Unit(57, UnitType.Cm)

rptClientCompliance.ServerReport.ReportPath = "/WinfundReport/KYC_Person"

Case "Company" ''Calling Companies Only Report

Me.rptClientCompliance.Width = New Unit(21.5, UnitType.Cm)

Me.rptClientCompliance.Height = New Unit(57, UnitType.Cm)

rptClientCompliance.ServerReport.ReportPath = "/WinfundReport/KYC_Company"

End Select

I apreciate ur respone.

Ramzan

View Replies ! View Related

Tool Tips Do Not Show On Reports
What could be the reason that tool tips do not show when they are moused over on a report. I have checked the HTML (IE 6 & 7) and Report Viewer. We are running SP2 on the reporting service server. I am using the tool tips in the details of a report and in the table headings.

View Replies ! View Related

Show/Hide Details And Sub-Reports
We were having a standards meeting today at my company and we talked about the show/hide details button in the UI. We hide reports all the time because they are sub-reports and aren't meant to be run on their own. If we can't hide the "Show Details" button and we can't ban the user with security from running the sub-report because they need to run the Main report which runs the sub-report, then what do we do?

I'd think we have the have the ability to to hide things, or least a creative way to hide them; but I don't want to deploy sub-reports to wierd places just to get around this.

The following posts reference this topic, but didn't address it; yet raise this question.

Thoughts?

Keith

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=950457&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=204599&SiteID=1

p.s. Just my own two cents, it would seem like a nice feature to be able to hide the "show details" button because there are advantages to hiding things.

View Replies ! View Related

How To Show 2 Or More Multy Row Reports On In One Report
I have two seperate reports that have parameter clientkey in common. I want to show on one report these 2..first the one, then the 2nd below it. I've tried jsut using 2 tables but they overlap. I'm now trying a subreport, but I'm not sure how to do this or even if it is the right method.

View Replies ! View Related

Report To Show Last Time All SQL Reports Were Run
I was curious to know if there is a way to create a report that will show when the last time all reports on our server were run. We have a lot of reports on our server made by multiple people that may or may not be in use anymore and we're trying to clean this up a bit. I am currently running SQL Server 2000. I realize there is a history that each report has and I'm wondering if it's possible to pull from that if it is stored somewhere that is accessible. Any help or direction would be much appreciated as I am not even sure where to start.....

View Replies ! View Related

Can I Show History In Reports Via Previous Snapshots Of The Same Report?
I have a report that runs monthly and they want to see the previous 2 months of data. This data is stored no place other than the snapshot of the same report for the previous 2 months. Is there any way I can display the last 2 snapshots/history withing my report? Thanks.

View Replies ! View Related

Show/hide A Field Based On The Logged In User In Reports
Hi,

I have some sensitive and non-sensitive info/fields in one of my reports. Is there a way to hide/show the info based on the logged in user? or do I have to create separte reports for each type of info like one for sensitive and another one for non-sensitive info.

Thanks inadvace for your help!

View Replies ! View Related

Programatically Show/hide Group Headers/footers In Reports
I have a report that has three levels of grouping including headers (containing titles) and footers (containing summary values). I would like to programatically show/hide these header/footer sections based on a Show/Hide paramter. Is that possible? Currently I work around the problem by just having two physical reports (one with the header/footers, one without)

View Replies ! View Related

&&"reports&&" Option Does Not Show Up In The Context Menu

I have a a microsoft sql server installed on my xp::
9.00.3042.00 SP2 Developer Edition

not being able to get the "reports" option (for customer reports) in the context menu (rightclicking on a database name) does it have to do with the version of the sql server I am running?

I have been told otherwise and I have reinstalled sp2 twice..

any help will be appreciated.
I do have bunch of report definition language files that I would like to use in custom reports, but... story goes on.

thx

JohnE

View Replies ! View Related

Line Chart To Show Trend In Matrix
Hello,

I have a matrix that shows the current and last year's period turnover rate. Sort of like this:

Turnover
Prior Year Turnover

Director
2%
1%

Manager
4%
2%

Associate
3%
5%

The report has a parameter where I can select the period to see the data. That all works fine.

What I want to do is add a chart that shows the trend of each group (Director, Manager, Associate) into the matrix. I am able to add the chart into a new column on the matrix and link it to the current row, but since the matrix is only showing a single period, not a year's worth, it doesn't show the trend.

I tried adding a new dataset for the chart and that works - if the chart is outside the matrix. Once I put the chart into the matrix (and change the dataset it is refering to) it still only shows one period of data.

If there a way I can have the chart in the matrix and still show a trend (over many periods) even though the matrix is only displaying a single period?

Thank you for the help.

-Gumbatman

p.s. I know this seems strange in the sense of "why don't you just have a chart outside the matrix?" The answer to that is there is much more data then can be shown clearly.

View Replies ! View Related

Chart Doe Snot Show X-axis Values
Hi,
In SSRS 2005, I do not see why the dates on the x-axis of the chart do not get shown.
I have checked that there is indeed data and the graph does get drawn on the chart.

Any thoughts please?

View Replies ! View Related

Enterprise Manager Hangs Trying To Show TEMPDB Properties
Hi there -

I am trying to look at TEMPDB properties in Enterprise Manager but it just hangs forever. I can look at props for all other databases on that server OK. The server is working OK but users reporting performance problems.

Also, how to increase the size of TEMPDB in T-SQL - I can see it is approx 200MB plus 300MB for the transaction log at the moment.

(Microsoft Windows 2003 Std Edition SP1, SQL Server 2000 Std Edition SP3)

Thanks for helping,

Michael

View Replies ! View Related

Can Not Access Localhost/ReportServer Or Reports
hi all,

I installed ReportServer with success I think, and I'm able to deploy my Report Model in BIDS (it says "success")..

But now, when I try to go to http://localhost/ReportServer, I get the error below:
The permissions granted to user 'EVO610IUSR_EVO610' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

I really tried everything; I granted full permissions to the folder below for IUSR_EV0610, but it still says the same error.
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer

Is this not the correct solution?
Any other things that I don't know?

Thanks

View Replies ! View Related

Problem: I Can't Get Reports From Http://myserver/ReportServer
Hello all,

I'm using SQL Server 2005 SP 2 with Reporting services and MS dynamic CRM 3.0.
During the installation of CRM, a lot of Reports are deployed to the ReportServer.
I can connect to the ReportServer over http://myserver/ReportServer, can walk through the folders and select the wanted Report, but I only get the header of the Report without the Action Icons and Data!

If I use http://myserver/Reports, the selected Reports works very well.

Has anybody an idea what is happen?

View Replies ! View Related

Access Denied To ReportServer And Reports, Works Locally But Fails Remotely

I am getting the error:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

when I attempt to connect to Reports or ReportServer from my desktop, but it works normally when I login with the same userid and run it directly on the server, using IE. It is prompting me for a login 2 or 3 times before failing.

My configuration is:

Report Server system:

Windows Server 2003 R2 SP2 - 32bit

SQL Server 2005 Reporting Services Enterprise Edition
Windows & Web Service run as a domain account
Database connection is using domain account - not in db_owner, but in RSExec roles
Database is on another server, and is Native, not SharePoint integrated
Reports & ReportServer are in a separate application pool
Reporting Services had SP2 installed before it was configured
The Rport Server is a VM

Database server

Windows Server 2003 R2 SP2 - x64
SQL Server 2005 Enterprise Edition 64bit
Version 9.00.3200.00

The Report Manager was not working at all, and I discovered that there was no entry in the .Net Framework version on the APS.Net tab in properties for the Reports virtual directory. I am not seeing any errors or anything unusual in the Event log or in the ReportServer log files.

FrontPage 2002 extensions were installed, and then removed. I noticed that this installed a SharePoint virtual directory, and that disappeared when I removed FrontPage extensions.

The domain group my userid is in is in the local Administrators group on the ReportServer system, and I have added this group as a System Administrator and Content Manager through the report Manager.

I would greatly appreciate any suggestions.

Thanks,
Bill

View Replies ! View Related

Totals In Chart Reports
How can I put Totals (i.e. YTD in a column chart?), I have the data categorized in Q1, Q2, Q3... and I would like to add an extra column with the total of the year.

View Replies ! View Related

How To Display %'s In The Bar Chart Reports
Hello,

i am working on charts where i collect data for different age groups for two locations.

now i am displaying data having agegroup in the category field and location in the series field. and count on the top.

the problem is i am trying to display %s instead of the count of the people.

like for 2 bars for age group 18-20 should be like (35% , 65%)

any ideas???

View Replies ! View Related

Accessing The MDX Dimension Properties In Reports
Hi

I have the following MDX query in my report.

SELECT {

[Measures].[Required Count],

[Measures].[Available Count]

}

ON COLUMNS, NON EMPTY

{ (

[Date].[Date].[Date].ALLMEMBERS *

[Software].[Vendor - Software].[Software].ALLMEMBERS *

[Software].[__FKID].[__FKID].ALLMEMBERS *

[OrgUnit].[OrgUnit Hierarchy].ALLMEMBERS

) }

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME, [OrgUnit].[OrgUnit Hierarchy].__FKID

ON ROWS FROM [cube]

All works fine, but I can't find a way to access DIMENTION PROPERTIES ([OrgUnit].[OrgUnit Hierarchy].__FKID in my example) from the report.
When I run this query in the SQL Management Studio, I don't get additional column for it. But I can access it as custom properties of the OrgUnit cell.

Is there any way to show such properties in SSRS report?

Thanks

Alex

View Replies ! View Related

Using Parameters To Link Between Chart Reports
I have one report "Incident Summary" which has a Report Parameter called DimPoolPool using ParameterValue for Value Field and ParameterCaptionIndented for Label field. The default value is [Dim Pool].[Pool].[All]

From another chart report I want to be able to click on a column to make open the Incident Summary report parameterized by "Pool". So I got to properties of the chart > Data > Values > Edit > Action > Jump to report > Parameter, and here I enter DimPoolPool = Fields!Pool.Value.

It seems to me that this should be picking up [Dim Pool].[Pool].&[poolname] and entering that into the parameters of Incident Summary report. However instead the Incident Summary opens with blank parameter waiting for user to enter.

How do you format parameters correctly between reports?

View Replies ! View Related

URGENT: REPORTS Not Working In SQL Report Srvr && Crystal Reports (moved Server)

Reports not working at all:
Need to move full ASp.Net application(VS.Net 2003) /SQL Server 2000 DB to another machine. The Web application & its SQL Database is successfully moved and functioning but am unable to access any of the reports from within it. The

reports are in: A) SQL server report server & B) Crystal reports

For A)-SQL SRVR-RPT SRVR: Installed SQL Server2005 Express version- with reporting srvr (advance mgt). The report server is working well- from IIS i can open both http://..reports and http://...reportserver links without error.
But when i click on a link in the ASP.Net application it gives error: /HRNE_REPORTS/rpt_employees does not exist( rsitemnotfound) .
1.In http://..reports configration I have made a folder HRNET_REPORTS. But how do i put the individual reports? There is no .RDL file in the application folder only .aspx files for the reports exist.

2.Do i need to restore the two reporting server databases from the old machine to the new one and have this new 2005 reporting server use these 2 databases instead? If YES - then i hope sql express' reporting server will be able to point to the OLD (sql 2000) database (restored with replace option)??

For B)- CRYSTAL REPORTS: Have not installed anything special on the new machine.
The reports give some key problem (Crystal decisions...key..)- I can tell u later the exact error.
Since i dont have VS.Net and crystal reports 9 softwares but i think i can have 'Busines Objects XI software' - Will installing the latest 'Business Objects- Crystal reports' solve this??NEW MACHINE: windows XP-professional(so could'nt install sql 2000).; SQL express 2005

View Replies ! View Related

Execute Reports And Deliver Them When Data Is Refreshed In The Tables The Reports Point To
I wonder there is a way to activate the reports' execution and delivery when the data in a table has been updated in reporting services. I could not see subscription can make it. Can snapshot do it? If so, how to set it up? Thanks!

View Replies ! View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options
Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490

Hal9000

View Replies ! View Related

Reports Usage Frequency For All The Existing Reports On SSRS 2000
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.

Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?

I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.

Any help is appreciated

View Replies ! View Related

Remove All Reports ( Not Data Sources) From Reports Server
Hi does anyone know how to do the above with out going through reportserver url?

Preferably by using a cmd tool ? such rs.exe

or through the backend in the reportserver DB?

Thanks

Dave

View Replies ! View Related

Multiple Reports From One RS Execution Not Delivering All Reports
I have a RSS file that creates a history snapshot of a report with different parameters. I run the report twice and see two separate snapshots when I browse to the folder on the RS server. However, while I receive 2 delivery emails, the link and attached PDF are of the same report.

Here's my script:

Code Snippet

Public Sub Main()

Try

  Dim aParms As New System.Collections.HashTable()
  Dim oDate As DateTime = DateTime.Today.AddDays(-1)

  aParms.Add("BeginDate", oDate.ToShortDateString)
  aParms.Add("EndDate", oDate.ToShortDateString)
  aParms.Add("Status", "3")
  Run_Report("IDIRRpt06", aParms)

  aParms("Status") = "1"
  Run_Report("IDIRRpt06", aParms)

Catch ex As Exception
  Console.WriteLine(ex.Message.ToString)
  Throw ex
End Try

End Sub

Private Sub Run_Report(ByVal vReport, ByVal vParms)

Try

  Dim sReport As String = "/Test/Enterprise/Claims/Claims Support/IDIR/" & vReport

  '-- Create array for ReportParameter
  Dim sParms() As ReportParameter
  sParms = rs.GetReportParameters(sReport, Nothing, False, Nothing, Nothing)

  If Not (sParms Is Nothing) Then
   Console.WriteLine("Report: " & vReport)
   Dim rp As ReportParameter
   For Each rp In sParms
    ReDim rp.DefaultValues(0)
    If vParms.ContainsKey(rp.Name) Then
     rp.DefaultValues(0) = vParms(rp.Name)
     Console.WriteLine(" Parm: {0} = {1}", rp.Name, vParms(rp.Name))
    End If
   Next rp
   rp = Nothing
  End If

  rs.Credentials = System.Net.CredentialCache.DefaultCredentials
  rs.SetReportParameters (sReport, sParms)
  rs.UpdateReportExecutionSnapshot(sReport)

  Console.WriteLine("Successful report generation")
  Console.WriteLine("")

Catch ex As Exception
  Console.WriteLine(ex.Message.ToString)
  Throw ex
End Try

End Sub

I'd obviously like each report delivered. Is there a problem with how I am scripting? Is there a method that "flushes" the report so that it forces delivery?

View Replies ! View Related

Printing Reports Using Reports Services 2005
Hi,

Does anyone have a inkling why a report published to a share directory
would behave as follows:

If exported to .pdf and then printed - always works.

If printed from the report viewer control panel using the print icon

sometimes it works and sometimes it prints without the headings and skips data
the data skip pattern varies.

on large (big) reports often will just not print more than a certain amount of pages.

On some reports if you place the report into the view layout using the report viewer control before printing then and then print - it will print all of the report.

I have looked and looked but cannot seem to locate any info on this.

Thanks

Linda

View Replies ! View Related

Converting Crystal Reports To SSRS Reports

My issue is with converting multi-value parameters:

In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).

As an example:

I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".

With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127

This will only return results within those ranges.

Does anyone know if SSRS provides this kind of functionality?

Thanks,

Patrick Conway

View Replies ! View Related

Migration Of SQL Reports 2000 To SQL Reports 2005
Hi Friends,

Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...

Could anyone explain me. How it works.

Thanks
sqlferns

View Replies ! View Related

Anyone Have Reports On Reports? (Things That Go Beyond The Samples)
Hi all,

I'd like to get a report on the reports that are deployed.

It would tell me things like this:

Report Name

                            DataSourceName

                            Connection String

                            Stored Procedures Called

                            Views/Tables Used         (Probably can't be shown if its calling a stored procedure)

                            Modified date

                            Modified Last by

                            Folder it is stored under in Report ManagerFolder it is stored under in Report Manager

Can this be done? Does anyone have it?

Are there any user created updates or changes to the samples that MSFT has written?

Keith

View Replies ! View Related

Date Diffrent Between &&"reports&&" && &&"reportserver&&"
I have a problem with the dates and "datetime" picker in my report (sqlserver 2005 sp2).

My reginal settings on the server are: "hebrew" - "Isreal".

I have a report with a datetime picker.

If I'm opening the report from: http://myserver/REPORTSERVER and I'm writting in the datepicker textbox the value "01/04/2008", and then click on the calander icon it opens on the on the 4th of january 2008.

If I'm opening the report from: http://myserver/REPORTS and I'm writting in the datepicker textbox the value "01/04/2008", and then click on the calander icon it opens on the on the 1th of april 2008.

Does anybody know this bug and how to wotk with it?

Thanks.

View Replies ! View Related

Copy Reports From Other Users &&"my Reports&&" Folder
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.

The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.

Is there a way to do this?

Thanks for your help.

View Replies ! View Related

Reports About The Reports Usage
Hi,

We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?

With regards,

Constantijn Enders

View Replies ! View Related

Set Chart Properties
Hi,

I have a chart that is created in SSRS with the size property set to '15cm, 8.5cm', I want to set the height based on a parameter that is passed to the chart ( so that it fits onto a 1 page report it is fed through to), I have tried putting =Code.SetChartHeight() in the height property but it brings up an error saying it needs to be in a format like '8.5cm'. The SetChartHeight() function just returns the height parameter + 5.

Does anyone know how I can do this?

Many thanks in advance

View Replies ! View Related

Chart Properties - Date On X Axis

Hi!
In SSRS2005 I made an chart,
but on x-axis I only want date-part (if possible ISO-format yyyy-mm-dd).

The resulting chart shows date AND time-part. How to avoid this?

thanks.

View Replies ! View Related

Can Someone Show Me How.....
I'm beginner in asp.net. Can someone show me how to create coding for this page..
i have to create my own login page and database. I'm using sql sever 2005 for database. can someone show me how to make connection with my login button and my database? please....i'm really need help from you all guys.

View Replies ! View Related

Show Only The Five First...
Hi!!

I have a bar chart and the data are agrupped by Folders (Category groups) and by FileType (Series Groups)... I want to show only the 5 folders with the biggest amount of files... how i could do it?

All suggestions will be wellcome... Thx!!

View Replies ! View Related

Show Different Value
In Reports Service SQL 2005

my Fields Value is A, but I list table to show Value is B.

How do it.

Thanks

View Replies ! View Related

Can You Show Me A Better Way?

I need to flag old records and new records with 1 and 0 respectively... can anyone show me how to do it without having to create a temp table? this is what i've got so far...

create table #tempLRM
([Key] varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS null,
[Start Date] datetime null);

insert into #tempLRM
select [key], min([start date])
from ReportDataLRM
group by [key];

update ReportDataLRM
set multi = 0
from #tempLRM t
where ReportDataLRM.[key]= t.[key]
and ReportDataLRM.[start date] = t.[start date];

update ReportDataLRM
set multi = 1
where multi is null;

select * from ReportDataLRM

View Replies ! View Related

Show More Then One Image
Hello!
I'm trying to show one large image and up to five small images. I can not get this to work. The five small images is in a repeater, the big picture is not in the repeater. I Think I just paste the code so you can look at it, i think that is better than me trying to explain moore:) I thougth I could use one of the events of the repeater and bind the large image when the page loads but I dont know what to use SqlDataSourceStatusEventArgs or what? I hope you all aunderstand whatI mean.<table style="background-color: #E4F9DF; margin: 10px 0px 0px 0px; border: 1px solid green;width: 545px; border-collapse: collapse;"><tr><td class="BoldText" colspan="2" style="border-bottom: 1px solid green; background-color: #b0eda2; text-align: center;">Bilder</td></tr><tr><td style="text-align:center"><asp:Image ID="Image1" Width="530px" runat="server" /></td></tr><tr><td> <asp:Repeater ID="Repeater1" OnItemCommand="imgBtnChangePic_Click" DataSourceID="sqlGetAdPics" runat="server"><ItemTemplate> The images will not appear, the shown like the path is wrong.<asp:ImageButton ID="ImageButton1" CommandName="changePic" ImageUrl='graphics/Advertise/<%#Eval("advertisePic")%>' CommandArgument='<%#Eval("advertisePic") %>' runat="server"/></ItemTemplate></asp:Repeater></td> </tr></table>
Here is the code behind
protected void Page_Load(object sender, EventArgs e){// this works, but I have to get the mage from the database...Image Image1 = (Image)DetailsView1.FindControl("Image1");Image1.ImageUrl = "graphics/Advertise/sadel2.jpg"; }protected void sqlGetAdDetails_Selected(object sender, SqlDataSourceStatusEventArgs e){if (e.Exception != null)lblError.Text = e.Exception.Message.ToString(); }protected void imgBtnChangePic_Click(object sender, RepeaterCommandEventArgs e){// This method is working.if (e.CommandName == "changePic" && Page.IsPostBack){Image Image1 = (Image)DetailsView1.FindControl("Image1");Image1.ImageUrl = "graphics/Advertise/" + e.CommandArgument.ToString();}}

View Replies ! View Related

How To Show A Stored PDF
New to asp and have no idea what I'm doing wrong here. I just want to open a pdf that I have stored in a table and show it on the page. Here is my code. I keep getting the System.NullReferenceException was unhandled by user code.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:smithsdaConnectionStringtest %>"
ProviderName="<%$ ConnectionStrings:smithsdaConnectionStringtest.ProviderName %>"
SelectCommand="SELECT * FROM [correspondence] WHERE ([facilitiesID] = ?)">
<SelectParameters>
<asp:QueryStringParameter Name="facilitiesID" QueryStringField="DACorr" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

<script runat="server">Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim ScanDoc As New DataViewDim arg As New DataSourceSelectArguments
ScanDoc = SqlDataSource1.Select(arg)
Dim ScanLet(1) As ByteScanLet(0) = CByte(ScanDoc(0)("Letter"))

If ScanDoc IsNot "" Then
Response.Buffer = True
Response.Clear()
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.BinaryWrite(ScanLet)
Response.End()
End IfEnd Sub
</script
Any Help greatly appreciated.

View Replies ! View Related

It Will Not Show The Data From The DB
is have this code, and i know that i have a record with the ID=1 but it will not show the data from the record..<asp:Content ID="Main" ContentPlaceHolderID="ContentPlaceHolderMain" Runat="Server">
<asp:FormView ID="form1" runat="server" DataSourceID="SqlDataSource1"></asp:FormView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnStrAccess %>"
SelectCommand="SELECT [MainID], [MainText] FROM [SiteText] WHERE ([MainID] = ?)" ProviderName="<%$ ConnectionStrings:ConnStrAccess.ProviderName %>">
<SelectParameters>
<asp:SessionParameter DefaultValue="1" Name="SiteMainID" Type="Int32" />
</SelectParameters>

</asp:SqlDataSource>
</asp:Content> Why can't it show the record !??

View Replies ! View Related

Can't Get Decimal To Show Up!
Hey...I've been cracking head about this one all day, and I'm sure it'san easy answer, but here goes:I have a column entitled Sequ which is defined as a Decimal withPrecision 10 and Scale 5. In an ASP.NET page, I'm performing acalculation which is inserted into the Sequ column. I'm doing aresponse.write, which enables me to see that the numbers are in factbeing calculated correctly complete with a string of numbers after thedecimal, but when I pull the numbers out to use on the page or accessthe table, Sequ lists all numbers as integers. I'm using a storedprocedure in which I'm declaring the @calc parameter (the calculatedvalue which is being inserted) as a Decimal -- I don't know what I'mdoing wrong. Help appreciated...thanks.Erik

View Replies ! View Related

Show Tables
how to show all tables in current database ?

View Replies ! View Related

Login Name Does Not Show?
Hello,

When I create new Database User the login name input does not show on the list and in the "login name " when checking the Properties of the name. Why this behavior?
the previous user created a while ago are showing name and login name .
permissions and rights are the same for between different users having the two different behaviors.

When I created the new database user I input e.g.:
Login Name: AD<<User Name>>
Name : "First Name"

Thanks,
Dom

View Replies ! View Related

Show Table
HI

I have created a stored procedure in SQL Server which outputs all records in a table.
How can I execute that procedure in access please? ( show that table in access?)

View Replies ! View Related

Backups (Don't Show As Job)
When I set up a DailyBackup using the Backup Wizard it doesn't show in the SQL Agent jobs or in the Database maintainance plan. Is this correct??

Many Thanks
Darren

View Replies ! View Related

Can't Get Db To Show Up On Webpage???
husband built web site, hosted by 1and1, husband can't help right now and 1and 1 won't. I can't get the connection string correct and need some advise.
This is the info 1and1 gave me for my db.

Database Name db212583089
User Name xxxxxxxxxxxxxxxx
Password xxxxxxxxxxx
Host Name mssql02.1and1.com
Description jamm
Status
My bd is uploaded to their server and should connect with the global.asa page, this is what I have as a connection right now and it's not working
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection
Application("Database1_ConnectionString" = "PROVIDER=SQLOLEDB;DATASOURCE=msssql02.1and1.com;DATABASE=db212583089;UID=dbo212583089;PWD=xDBXzNTt"
Application("Database1_ConnectionTimeout") = 15
Application("Database1_CommandTimeout") = 30

this is the error i get on my website when i try to access my db.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/JAMMDatabase.asp, line 131

This is the code on line 131, some before and some after:
strProvider=Application("Database1_ConnectionString")

set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider(line 131)

set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn

right now I am totally lost with all this, if someone can help would really appreciate it, thanks, debi

if you need more info just let me know

View Replies ! View Related