In the console, when right clicking on a table name...then selecting 'open table', the toolbar at the top of the page is not displaying. This is the graphical bar with the 'SQL' button that lets you filter the results.
How do I get the toolbar back, is it a setting?
Thanks!
Carl
Hi,
When I am trying to view the report using 'URL Access', on one particular machine, all items in toolbar is shown on separate lines. It almost looks like the report viewing area and toolbar width is shrunk. I have same installation on 4 different servers but only one server is giving problem.
OS - XP
SQL Server - 2005
Not much help available on wen.Only a couple of posts with similar problem.
Thanks for any and all help.
-Alpa.
Hello -
I am trying to find out whether the Toolbar is available when using the Reporting Services Web Service interface.
Right now, I am using the Web Service to render a report, but the Toolbar does not appear. I have set the <Toolbar> element in the DeviceInfo string to true.
thanks
- will
I have just installed my server with server2003 enterprise edition, everything is working fine. However, after I make it online for awhile, I found a weird thing on the tool bar just beside the clock. There are 2 hidden icons, when I move the pointer to these 2 icons, it shows the IP address of my server. Just wanna know if there is anything wrong with that.
Thanks!
tom
I work with multiple servers and I have system administrator rights on all server. My question is, why on some server when I click on a database it shows the General, Table & Index, Space Allocated tool bar, than if I go to a different server, click a database it does not show? I would like to see this toolbar on all my servers when I click a database.
Thanks Reggie
Good day everyone...
I created a simple report in SQL Server 2005 Reporting Services. Its about getting the sales from specific date and store. My parameters are date and storename, the report works fine as I view it in the reportserver. But, when we incorporate the report in a custom webpage using a reportviewer, the parameter toolbar occupies half the space, now that's my problem. Is there anyway I can create a custom Toolbar in Visual Studio so I can just set the parameter property to hidden so the default parameter toolbar wont show?
Thanks in advance guys... c",)
I see how I can turn the toolbar on and off with:
ex:
http://server/reportserver?/SampleReports/ReportName&rs:Command=Render&rc:toolbar=false
but this turns off the entire toolbar.
Is there a way to customize which options within the toolbar to keep and which ones to eliminate?
How is the Query Designer toolbar enabled?
Clicking Query, Dsign Query in Editor opens a Query designer in a model window that does not use the query tool bar. Oening a New Query pane does not enable it.
The nly way I have found to activate the query tool bar is to:
1. Right click a table then click open table.
2. Stop retreving data. (if it is a large table)
Now the Query Designer toolbar is enabled.
What is the correct way to enable the Query Designer toolbar?
Hi All,
1. Whether I'm working on in Layout, Data or Preview (Reporting Services 2005) for any report
the toolbars I select disappear when I click on close. In Tools, Customize, I have check marks by: Formatting, Query designer, Layou,Build and Standard among a few others. I tried the reset button but no help as well.
What am I missing? Should they be visible and not grayed out?
2. Also, Is there an easy way to tell what verion/service pack level SQl server 2005 and of MSSRS 2005 I am running?
Thanks in Advance !
>Scott
I have installed VS community edition 2013 on a widows 7 PC. When I try to create a ssis package the ssis tool bar comes up empty.It just says "loading" on the panel .
View 2 Replies View RelatedWe have a reportviewer on a webpage to display a report.
All works perfectly until the users interact with the web page. i.e. expand/collapse or sort sections of the report. When the page is re-drawn the reportviewer toolbar (or parameter area if used) is hidden behind the webpage's titlebar.
Has anyone else had this problem ?
Is there a solution ?
Please help.
Is there a way to have the Report Manager show the header/toolbar in the collapsed state instead of full screen by default? (i.e. the top of the report starts with "New Subscription" instead of "SQL Server Reporting Services")
These are Report Server reports, and I need to show several reports in one view (I'm using T-dog ibrowse to do this in a Powerpoint slide show). It looks cluttered to have the headers show repeatedly.
I need to hide the toolbar on report. my client accessing the report on Reportmanager URL.
I have tried this way ; passed the parameters to My report manger URL :Â &rc:Toolbar=false,But it's not working. I am using Visualstudio 2010.or another quetion Can I make Parameter is to be Read only !
When I open a new query or a file that is not under source control, I get a tool bar like the first image below.
When I open a query from a TFS project (second image), the toolbar is not available, and I cannot find a way to turn it on.
How to control this feature?
Hi,
anyone has any idea how to make the parameters toolbar to be automatically hidden when the report is first being accessed and subsequently to show the parameters when clicked on the arrows ? I have some users who complained that the parameters list is too long, so they wish to hide it first when accessing the report. I know there's this called rc: Parameters=false but this will permanently hide the toolbar which i don't want.
By the way, i am using sql 2000 reporting services
Have an ASP page using AJAX - have embedded the latest Microsoft Report Viewer control. The page access various SSRS reports. The application works fine for most users, but in certain cases, the toolbar wraps and occupies about ten lines - using about half of the visible area. Users affected by the problem are using IE7 and IE8. When the toolbar is distorted like this, the buttons (Page, Export, etc) also seem inop. The problem does not seem to be related to the RDL; either all the reports work or none of the reports work.
View 2 Replies View RelatedI have a reportviewer on a master page in a VS2008 ASP.NET application. When I originally created the page, I did not use a master page. When I moved the code to a master page, the Toolbar is 6 line long instead of 1. Each of the individual components of the ReportViewer toolbar is placed on it's own line. (i.e Navagation, Print, Zoom, Etc.) The same control worked correctly on it's own page.
View 2 Replies View RelatedHi,
I€™m hoping someone might be able to help me.
I have a Development Machine running Windows XP Professional SP2, with SQL Server 2005 including Reporting Services. I am developing an ASP.NET application using VS 2005, and am including Server Side Reports from SQL Server. Everything is working well, except when viewing the Reports.
The Reports when viewed from Reporting Services€™ Report Manager or from within the ASP.NET application only display the first page of the report, displaying the total number of pages as 0. As well, most of the functions on the report toolbar appear to be disabled. This occurs for any report viewed, even sample reports such as the Adventure Works Samples.
The problem only occurs when viewed from within Internet Explorer on the Development Machine. To overcome the problem, I have upgraded SQLServer to SP2, and removed and reinstalled Internet Explorer, but it made no difference. It appears to be related to the rsClientPrint ActiveX addon which should have been installed when the print icon was first selected. It appears not to have installed properly, but up to that point everything worked OK. Selecting the Print icon (or any other icon) since nothing happens. I€™m guessing here, but I suspect that the rsClientPrint addon needs to be reinstalled, but I don€™t know how to go about it. It is not listed within IE addon (where it is on other machines connecting to the Development Machine), nor is it listed within the €œC:WindowsDownloaded Program Files€?. But it is not being downloaded when the Print Icon is selected. I have checked all the Security settings for the environment to ensure that ActiveX programs are downloaded, and everything appears to be in order.
Would anyone be familiar with this problem or have any suggestions on how to go about resolving it? Any help would be appreciated as it is causing significant problems. Strange though, the reports appear fine when viewed from within the Server Manager.
Hy everybody.
I have recently installed from scratch RS 2003 on a WIN2003 SRV and got that the problem that the administrator cannot access or even see the regular administration toolbar and links at the Report Manager, such as Site Configuration, Upload New File, the common 'Contents | Properties ' tab, among other stuff. The only options available are 'Home', 'My Subscriptions' and 'Help', in the right superior link bar. I find this behaviour very strange, since the RS comes right out of the box configured with full access to administrator, but right now I CAN'T do any administration task on the RS Server.
Another strange behaviours I've found:
- The few links that appear redirect to the internal ip address of the server.
- When you call the '/ReportServer/ReportingService.asmx' it returns an XML document, not the usual browsing interface.
There's some information about the server configuration I think it might help:
- IIS is running more than one website, and the RS server is not installed on the Default WebSite, wich is stopped.
- SharePoint Services is running in the server, but not in the DefaultWebSite.
- The security settings of the virtual directory of the Report Manager are configured to use Windows Authentication and are NOT configured to use anonymous authentication.
- The server is published to the Internet.
There's some stuff that I tried and for now didn't worked:
- Create the virtual directories in other websites.
- Switch the attributes of the 'impersonate' attribute in Web.config file between true and false.
- Enable anonymous authentication and use the administrator account to impersonate.
- The steps described in the help article 'Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services'
- Reinstalling the RS product.
I really hope you guys can help me with this.
Thanks in advance.
JC
Hi,
I wouls like to have a custom button called "Set" in the report toolbar in addition to the "View Report" button. I am aware of the fact that the look and feel of the existing controls on the toolbar can be customised or can be hidden using HtmlViewer.css. Is there any code which I can tweak to add buttons or images on the report toolbar?
Thanks
Deepti
Hi all,
I am trying to build a reportviewer so that I could use reporting services (due to company's security policy).
I am getting a VERY weird error here.
Before I get on ahead, here is the scenario.
I had created a rdl that will give a certain report based on two parameters. At the moment, I didn't assign the parameters to any default values since i don't want the report to start running. These two parameters are run based on stored procedures to get the starting date and an ending date.
I had tried to view this report on Report Manager and it works.
I had set the parameters this way. NOTE: ReportingServer is the disgused name of the reportserver I am using for privacy purposes
Code Snippet
Dim rs As New ReportingServer.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
'Render arguments
Dim results() As Byte
Dim format As String = "HTML4.0"
Dim historyID As String = Nothing
'PDF Rendering extensions don't have any useful DeviceInfo settings
'the toolbar shown below only affects HTML rendering
Dim devInfo As String = "<DeviceInfo><HTMLFragment>True</HTMLFragment><JavaScript>True</JavaScript><Toolbar>True</Toolbar><Parameters>True</Parameters></DeviceInfo>"
Dim credentials() As ReportingServer.DataSourceCredentials = New ReportingServer.DataSourceCredentials() {}
Dim showHideToggle As String = ""
Dim encoding As String = ""
Dim mimeType As String = ""
Dim warnings() As ReportingServer.Warning = New ReportingServer.Warning(0) {}
Dim reportHistoryParameters() As ReportingServer.ParameterValue = New ReportingServer.ParameterValue() {}
Dim streamIDs() As String = Nothing
Dim sh As ReportingServer.SessionHeader = New ReportingServer.SessionHeader
rs.SessionHeaderValue = sh
But when I started building this reportviewer.aspx, it gives me this error on the following line:-
Code Snippet
results = rs.Render(ReportPath, format, historyID, devInfo, Parameters, credentials, _
showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)
with the error
{"This report requires a default or user-defined value for the report parameter 'start_date'. To run or subscribe to this report, you must provide a parameter value. --> This report requires a default or user-defined value for the report parameter 'start_date'. To run or subscribe to this report, you must provide a parameter value. --> This report requires a default or user-defined value for the report parameter 'start_date'. To run or subscribe to this report, you must provide a parameter value."}
this is occuring on the line where it needs to render the report.
As simple as it is, i tried the following:-
NOTE: some variables has been changed to protect some identity.
Code Snippet
Dim ReportRenderer As New RenderSQLReports
Dim Parameters As int.rrd.sqlreporting_test.ParameterValue() = Nothing
ReportRenderer.RenderReport(Parameters, "/Folder/reportname", "pdffilename.pdf")
What I don't get is that i made sure that it doesn't have any default values.
So I went into this scenario and tried teh following:-
Code Snippet
Dim ReportRenderer As New RenderSQLReports
Dim Parameters() As Reportingservices.ParameterValue = New Reportingservices.ParameterValue(1) {}
Parameters(0) = New Reportingservices.ParameterValue
Parameters(0).Label = "start_date"
Parameters(0).Name = "start_date"
Parameters(0).Value = "10/1/1999 12:00:00 AM"
Parameters(1) = New Reportingservices.ParameterValue
Parameters(1).Label = "end_date"
Parameters(1).Name = "end_date"
Parameters(1).Value = "11/1/1999 12:00:00 AM"
ReportRenderer.RenderReport(Parameters, "/Folder/reportname", "pdffilename.pdf")
And this is what happens. It blows up on this line again. with this error.
Code Snippet
results = rs.Render(ReportPath, format, historyID, devInfo, Parameters, credentials, _
showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)
With the errors
{"Default value or value provided for the report parameter 'start_date' is not a valid value. --> Default value or value provided for the report parameter 'start_date' is not a valid value. --> Default value or value provided for the report parameter 'start_date' is not a valid value."}
This is probably occuring because the date I had provided is not found in the list of dates. I really don't want to default a date at the moment, to allow the user to select a date.
So I finally gave it a date...... a valid date.
Code Snippet
Dim ReportRenderer As New RenderSQLReports
Dim Parameters() As Reportingservices.ParameterValue = New Reportingservices.ParameterValue(1) {}
Parameters(0) = New Reportingservices.ParameterValue
Parameters(0).Label = "start_date"
Parameters(0).Name = "start_date"
Parameters(0).Value = "10/1/2004 12:00:00 AM"
Parameters(1) = New Reportingservices.ParameterValue
Parameters(1).Label = "end_date"
Parameters(1).Name = "end_date"
Parameters(1).Value = "11/1/2004 12:00:00 AM"
ReportRenderer.RenderReport(Parameters, "/Folder/reportname", "pdffilename.pdf")
LO and behold, it works BUT . now i get this error in the aspx code.
Runtime error has occured.
Microsoft JScript runtime error: 'Report' is undefined
on this weird line:- (that was generated automatically)
</script><script language="javascript" type="text/javascript" src="?rs:Command=Get&rc:GetImage=8.00.1038.00Report.js">
</script><script language="javascript" type="text/javascript">
<!--
function OnLoadReport()
{
var pageHits = null;
var rep = new Report(1, 16, pageHits, false, docMapIds); <-where error is occuring.
if (parent != self) parent.OnLoadReport(rep);
}
//-->
</script>
It did show the report, but I don't understand why it is still getting an error here. Moreover, I didn't even get the HTMLViewer too even when I had assigned the devinfo....
Really need some help here, as this is quite urgent.... I am at a loss at this, and maybe that there is an option that I am not seeing or something I am missing. please help .
Bernard-So close yet so far, How cruel are the software bugs-
Hi all,
Not sure what's going on here...
I had reports using the HTML Viewer working in RS 2000. The servers were both O/S Windows 2000, SQL Server 2000, IIS 5.0, Reporting Services 2000) The default toolbar and parameters area were formatted and looked fine.
We just migrated to new servers with Windows 2003 Server, SQL Server 2005, IIS 6.0, Reporting Services 2005. I have the reports working fine...except the toolbar and parameters areas look as if there is no formatting at all...as if the style sheet isn't being applied (not even the default one --see below).
Although I don't think this is necessary....I tried the following to resolve the issue....
Updated the RSReportServer.config file.
Driveletter:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config
Checked that the HtmlViewer.css file was in the ...ReportServerStyles folder.
Added the following line between the
<Configuration>.......</Configuration> tags in the RSReportServer.config file.
<HTMLViewerStyleSheet>HtmlViewer</HTMLViewerStyleSheet>
Find
|
Next
Select a format XML file with report data CSV (comma delimited) TIFF file Acrobat (PDF) file Web archive Excel
Export
I can't find anyone else having this issue...any ideas?
Hope someone can help...thanks for looking....
Leslie
Is there any way to get the report toolbar using SOAP Api  in SSRS reporting.
View 6 Replies View RelatedHi i have a sorted procedure that create a @temp table that return strNomObjet,strNomDescripteur,strReponse,Percentage
I need to calculate the Percentage for strReponse for each strNomDescripteur. strReponse can be = to A,B,C, or D
To calculate the Percentage i have no problem my is that something it possible that a certain strNomDescripteur that will have only A,B and D and there no C i need to put 0%.
Here what i have
DECLARE @Temp table
(
strLastName varchar(50),
strFirstName varchar(50),
strReponse char(10),
strNomObjet nvarchar(200),
strDescripteurOrdre char(10),
strNomDescripteur nvarchar(200),
strObjetOrdre char(10)
)
INSERT INTO @Temp
Select te.stdlastn,te.stdfirstn,COALESCE(NULLIF(REPLACE(tr.T3,'*',''),' '),REPLACE(tr.T2,'*','')),tob.Nom,tob.Affichage,td.Nom,td.Affichage
fromBulletin.dbo.tblEleves as te
INNER JOIN Bulletin.dbo.tblBulletin as tb ON te.stdnumber=tb.NoEtud
INNER JOIN Bulletin.dbo.tblNomBull as tnb ON tb.NoBull=tnb.ID
INNER JOIN Bulletin.dbo.tblSection as ts ON ts.ID_Bull = tnb.ID
INNER JOIN Bulletin.dbo.tblObjetas tob ON tob.ID_Sec = ts.ID
INNER JOIN Bulletin.dbo.tblDescripteur as td ON td.ID_Obj = tob.ID
INNER JOIN Bulletin.dbo.tblReponse as tr ON tr.ID = tb.ID
whereintActif = 1 and
tb.NoBull not like '%EdPhy%'
and tnb.Nom not like '%EdPhy%'
and tnb.Date = '2006-2007'
and te.STDGRADeID = 3
and te.schoolid = '1202'
and ts.Nom = 'MATHÉMATIQUES'
and tr.[Desc] = td.ID
and tr.T2 <> 'NULL'
and tr.T3 <> 'NULL'
and (tr.T2 <> '' OR tr.T3 <> '')
ORDER BY tob.Affichage,td.Affichage
SELECT t1.strNomObjet,t1.strNomDescripteur,t1.strReponse,
t1.ReponseCount * 100.0/t2.PersonCount AS Percentage
FROM
(
SELECT strNomObjet,strNomDescripteur,strReponse,count(*) AS ReponseCount FROM @Temp
GROUP BY strNomObjet,strNomDescripteur,strReponse)t1
INNER JOIN (SELECT strNomObjet,strNomDescripteur,count(*) AS PersonCount FROM @Temp
GROUP BY strNomObjet,strNomDescripteur)t2
ON t2.strNomObjet=t1.strNomObjet
AND t2.strNomDescripteur=t1.strNomDescripteur
This will give this result :
As you can see it always A,B,C,D A,B,C,D
Except for "FORMES utilise les transformations géométriques pour" it only A,B,C there no D.
So is there a way that i could insert D = 0
So if i don't find any A,B,C or D for certain strNomDescripteur put that letter = 0
Thanks for your help in advance!!
FORMES utilise la mesure pour résoudre des problèmesA 47.222222222222
FORMES utilise la mesure pour résoudre des problèmesB 38.888888888888
FORMES utilise la mesure pour résoudre des problèmesC 8.333333333333
FORMES utilise la mesure pour résoudre des problèmesD 5.555555555555
FORMES utilise les figures géométriques pour résoudre A 61.111111111111
FORMES utilise les figures géométriques pour résoudre B 25.000000000000
FORMES utilise les figures géométriques pour résoudre C 11.111111111111
FORMES utilise les figures géométriques pour résoudre D 2.777777777777
FORMES utilise les transformations géométriques pour A 62.857142857142
FORMES utilise les transformations géométriques pour B 28.571428571428
FORMES ET ESPACE (géométrie)utilise les transformatC 8.571428571428
NOMBRE ET OPÉRATIONSdémontre une compréhension A 69.444444444444
NOMBRE ET OPÉRATIONSdémontre une compréhension B 16.666666666666
NOMBRE ET OPÉRATIONSdémontre une compréhension C 5.555555555555
NOMBRE ET OPÉRATIONSdémontre une compréhension D 8.333333333333
Hello all,I hope someone can help me; if got a value in a cell (040 1234567),when I run a queryin the Analyser I got as respons only 40 1234567, so missing the zero(0) not the whole number is displayed. When I run a query on a cellwith value 1234567 I received the number 1234567 and that's oke. TheData Type of the Column is Char.Thanks,Marko
View 6 Replies View RelatedWhy is is in SSMSE or through code in VB.NET when running a query on a linked server that is an Excel spreadsheet is the first row not returned?
My spreadsheet has 320 rows with no column headings.
My select query within SSMSE returns only 319, the first row is ommitted, I beleive treated as a column heading.
If I insert a row at the very beginnning and enter any jibberish this row is ommitted and I get all my data.
Now I dont really want to have to tell my users that to get the import function of my app to work correctly they have to do this?
Is there a way to configure it to not treat first row as headings?
Thanks
When I log in to Windows (XP Pro SP2), I get the following message displayed in the Application Event Viewer.
"The ASP.NET DLL (Path: C:WINDOWSMicrosoft.NETFrameworkv2.0.40607aspnet_isapi.dll) (Version:2.0.40607.0) is missing"
The message is quite correct in its assertion that the file is not where it says it is. There is a copy of the noted DLL however, in C:WINDOWSMicrosoft.NETFrameworkv2.0.50727 and in C:WINDOWSMicrosoft.NETFrameworkv1.1.4322
Why is the Report Server looking for that particular version? Why can't it point at the later version?
I'm trying to access some files on a file server in CLR code and I have to impersonate the windows login to get permission. I am using the classic example of SqlContext and i can see that after calling the impersonate method it changes. I always get false from the System.IO Direcotry and File functions to see if there are any files or even if the directory exists. The permissions are correct on the file share and the batch submission is using the correct login.
Directory.Exists ALWAYS returns false.
Slimmed down code
WindowsImpersonationContext OriginalContext = null;
WindowsIdentity CallerIdentiy = SqlContext.WindowsIdentity;
try
{
OriginalContext = CallerIdentiy.Impersonate();
bDirectoryExists = Directory.Exists(@sSourceDir);
finally
{ OriginalContext.Undo(); }
Any ideas????
hi,
I am using time series algorithm.and my prediction query is like this
SELECT PredictTimeSeries([Performance]) FROM [Stud_Model]
The output is like this
Date Perf
9/11/2006 90
10/11/2006 92
11/11/2006 93
12/11/2006 -- (no prediction)
1/11/2007 --(no prediction)
I dnt know why there is no prediction after certail date?
Thanks,
Karthik
When I sign on to my computer I get this message, MSVCR70.dll can not be found try to reinstall it this may fix the problem, BUT CAN'T find the dll that is missing to reinstall it, HOW DO I FIX THIS please HELPPPPPPPPP!!!!!!
View 6 Replies View RelatedI have a normal nvarchar(50) field in a table that has a single comma in it but when i read it using OleDbDataReader the comma gets removed.
any ideas what i am doing wrong ?
many thanks
Hi guys
need some help, someone has given me some code to help me filter a gridview by the surname field by the selected letter of a dropdown list.
My code is below, however if i select a letter from the dropdown and click the button i get an error, can someone take a look please. <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<script runat="server">
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim dset As New Data.DataSet
Dim dview As New Data.DataView
dview.Table = dset.Tables("modelRegistration1")
dview.RowFilter = "surname LIKE" + surnameFilter.SelectedValue.ToString() + " % "
GridView1.DataSource = dview
GridView1.DataBind()
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table>
<tr>
<td style="width: 100px">
Surname Filter:</td>
<td style="width: 100px">
<asp:DropDownList ID="surnameFilter" runat="server" AppendDataBoundItems="True">
<asp:ListItem> - Please Select -</asp:ListItem>
<asp:ListItem Value="A">A</asp:ListItem>
<asp:ListItem Value="B">B</asp:ListItem>
<asp:ListItem Value="C">C</asp:ListItem>
<asp:ListItem Value="D">D</asp:ListItem>
<asp:ListItem Value="E">E</asp:ListItem>
<asp:ListItem Value="F">F</asp:ListItem>
<asp:ListItem Value="G">G</asp:ListItem>
<asp:ListItem Value="H">H</asp:ListItem>
<asp:ListItem Value="I">I</asp:ListItem>
<asp:ListItem Value="J">J</asp:ListItem>
<asp:ListItem Value="K">K</asp:ListItem>
<asp:ListItem Value="L">L</asp:ListItem>
<asp:ListItem Value="M">M</asp:ListItem>
<asp:ListItem Value="N">N</asp:ListItem>
<asp:ListItem Value="O">O</asp:ListItem>
<asp:ListItem Value="P">P</asp:ListItem>
<asp:ListItem Value="Q">Q</asp:ListItem>
<asp:ListItem Value="R">R</asp:ListItem>
<asp:ListItem Value="S">S</asp:ListItem>
<asp:ListItem Value="T">T</asp:ListItem>
<asp:ListItem Value="U">U</asp:ListItem>
<asp:ListItem Value="V">V</asp:ListItem>
<asp:ListItem Value="W">W</asp:ListItem>
<asp:ListItem Value="X">X</asp:ListItem>
<asp:ListItem Value="Y">Y</asp:ListItem>
<asp:ListItem Value="Z">Z</asp:ListItem>
</asp:DropDownList></td>
<td style="width: 100px">
<asp:Button ID="Button1" runat="server" Text="Filter:" OnClick="Button1_Click" /></td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
</table>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="getModel" AllowPaging="True" EmptyDataText="N/A" PageSize="15">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="applicationDate" HeaderText="Sign Up Date" SortExpression="applicationDate" />
<asp:BoundField DataField="firstName" HeaderText="First Name" SortExpression="firstName" />
<asp:BoundField DataField="surname" HeaderText="Surname" SortExpression="surname" />
<asp:BoundField DataField="dateOfBirth" HeaderText="DOB" SortExpression="dateOfBirth" />
<asp:BoundField DataField="postcode" HeaderText="Post Code" SortExpression="postcode" />
<asp:TemplateField HeaderText="Male" SortExpression="isMale">
<ItemTemplate>
<asp:CheckBox ID="isMale" runat="server" Checked='<%# Eval("isMale") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Female" SortExpression="isFemale">
<ItemTemplate>
<asp:CheckBox ID="isFemale" runat="server" Checked='<%# Eval("isFemale") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="getModel" runat="server"
SelectMethod="GetDataBySurname" TypeName="KayKayDataTableAdapters.modelRegistration1TableAdapter">
</asp:ObjectDataSource>
</asp:Content>
error message is
Server Error in '/KayKay' Application.
Syntax error: Missing operand after 'LIKEC' operator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing operand after 'LIKEC' operator.Source Error:
Line 6: Dim dview As New Data.DataView
Line 7: dview.Table = dset.Tables("modelRegistration1")
Line 8: dview.RowFilter = "surname LIKE" + surnameFilter.SelectedValue.ToString() + " % "
Line 9: GridView1.DataSource = dview
Line 10: GridView1.DataBind()Source File: E:InetpubwwwrootKayKayAdminupdateModels.aspx Line: 8 Stack Trace:
[SyntaxErrorException: Syntax error: Missing operand after 'LIKEC' operator.]
System.Data.ExpressionParser.Parse() +3158
System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +109
System.Data.DataView.set_RowFilter(String value) +171
ASP.admin_updatemodels_aspx.Button1_Click(Object sender, EventArgs e) in E:InetpubwwwrootKayKayAdminupdateModels.aspx:8
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4921
Hi,
Recently I installed MSDE and then Analysis services and also applied SP3's for both...
However I have noticed that the FoodMart Database which was automatically installed previously with Analysis services is not installed. Is there any way to get that?
Many TIA.