|
SoftArtisans have a product which allows you to generate report definitions from a Word document.
More information can be found here[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Well, I don't have the authority to purchase that software, so is there any tips on layout and formatting of a rdlc file? I've messed around with it a bit and when I go to view it in the report viewer, all of my layout is a skewed, but when I export it to a pdf file it looks okay even though now I have a blank page after the main report. Sometimes it will even make my text boxes break to the next page.
|
|
|
|
|
Are any warnings being generated by Visual Studio when you test your reports? Common problems include overlapping items in reports which may not be a problem when rendering to PDF but will be when rendering to HTML.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Well, let's say that I've drawn two rectangles in the report which will hold some text boxes in each. When I design the report I will place one rectangle on top of the other with no space between. When I go and view it in the report viewer on my site I see a space between both rectangles and one may be larger than the other (even though I made them both the same size in the design mode).
When I go and export it to pdf, the space may be gone but now the rectangles will stretch beyond the width of the page thus making it run over to a second page.
Obviously I'm a noob when it comes to rdlc files.
|
|
|
|
|
Hi
can any1 point me to some good articles possibly javascript on having a count down control on a page. I want it to count down for 5 mins from when the page starts
any help would be great!
thanks
|
|
|
|
|
Starbucks closed, not Google.
only two letters away from being an asset
|
|
|
|
|
what a weird answer, care to explain oh witty one???
or perhaps you should just leave the forum..
|
|
|
|
|
|
Starbucks closed for a few hours to conduct training for its staff. Google remained available, so there is no excuse for not using it.
only two letters away from being an asset
|
|
|
|
|
Hi, I read another thread on this topic, but it didn't seem to help me. What I'm trying to do is raise an event (that handles an exception) on a page if an exception is thrown on a class that it calls. My code is below:
** default.aspx **
Partial Public Class _Default
Inherits System.Web.UI.Page
Private WithEvents clsGenerateForm As SAF.GenerateForm.GenerateForm
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Private Sub Wizard1_NextButtonClick(ByVal s As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles Wizard1.NextButtonClick
If Wizard1.ActiveStepIndex = 1 Then
If RadioButton1.Checked Then
Wizard1.ActiveStepIndex = 2
Else
Wizard1.ActiveStepIndex = 3
End If
End If
End Sub
Sub HandleError() Handles clsGenerateForm.peHandleDatabaseException
pnlWiz.Visible = False
pnlError.Visible = True
End Sub
Protected Sub lbtnTest_Click(ByVal sender As Object, ByVal e As EventArgs) Handles lbtnTest.Click
Dim clsGenerateForm As New SAF.GenerateForm.GenerateForm()
pnlWiz.Visible = False
pnlComplete.Visible = True
End Sub
** extract from the GenerateForm class **
Namespace SAF.GenerateForm
Public Class GenerateForm
Inherits SAF.Abstract.DBAbstract
Private Sub CreateNewForm()
Dim cmd As SqlCommand
Dim dtr As SqlDataReader
cmd = New SqlCommand("SAF_Form_Create", connSql)
cmd.CommandType = CommandType.StoredProcedure
Try
connSql.Open()
dtr = cmd.ExecuteReader
dtr.Read()
_formID = dtr("FormID")
Catch ex As Exception
ExceptionThrown(ex.ToString)
Finally
If connSql.State = ConnectionState.Open Then
connSql.Close()
End If
End Try
End Sub
Sub New()
CreateNewForm()
End Sub
End Class
End Namespace
** SAF.Abstract.DBAbstract class **
Namespace SAF.Abstract
Public MustInherit Class DBAbstract
Public Event peHandleDatabaseException()
Protected connSql As SqlConnection = New SqlConnection(PUBLIC_MSSQL_CONNSTRING)
Protected Sub ExceptionThrown(ByVal strException As String)
Dim clsErrorLog As New SAF.ErrorLog.ErrorLog(strException)
Dim clsErrorEmail As New SAF.Email.ErrorEmail(strException)
RaiseEvent peHandleDatabaseException()
End Sub
End Class
End Namespace
The problem I'm having is that, while the event on the abstract class is being raised, it is not triggering it's handler on default.aspx.
If anyone is able to help, I'd appreciate it as I've been tearing my hair out for days now!
|
|
|
|
|
Hi
I have an asp.net timer
<asp:Timer ID="Timer1" runat="server" Interval="1000">
</asp:Timer>
however when i show it on a page i get the error
The control with ID 'Timer1' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.
but i have the script manager on the page already at the top of the page
really strange, any clues would be great?
thankyou
|
|
|
|
|
a-+s-+p-+ wrote: but i have the script manager on the page already at the top of the page
Is it within the form tag?
only two letters away from being an asset
|
|
|
|
|
yeah it is e.g.
<asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server">
<atlas:scriptmanager id="ScriptManager1" runat="server">
<asp:timer id="Timer1" runat="server" interval="1000">
|
|
|
|
|
It is recommended that the scriptmanager be placed on the master page, not in the content page.
only two letters away from being an asset
|
|
|
|
|
I have written the following code in my aspx & asmx file. But AutoCompleteExtender doesn't seems work at all.
ASMX File:
using System;
using System.Web;
using System.Collections.Generic;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Web.Script.Services;
/// <summary>
/// Summary description for AutoComplete
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class AutoComplete : System.Web.Services.WebService {
public AutoComplete () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public static string[] GetCompletionList(string prefixText, int count)
{
string sql = String.Format("select companyName from customers where companyname like @companyname + '%'");
List<string> companyList = new List<string>();
using (SqlConnection connection = new SqlConnection("Data Source=fe-sql1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=dataformat"))
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
command.Parameters.AddWithValue("@companyname", prefixText);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
companyList.Add(reader.GetString(0));
}
}
}
return companyList.ToArray();
}
}
Here is the ASPX file code:
;
<asp:scriptmanager id="ScriptManager1" runat="server">
br mode="hold" />
<cc1:autocompleteextender runat="server">
BehaviorID="AutoCompleteEx"
ID="autoComplete1"
TargetControlID="myTextBox"
ServicePath="AutoComplete.asmx"
ServiceMethod="GetCompletionList"
MinimumPrefixLength="2"
CompletionInterval="1000"
EnableCaching="true"
CompletionSetCount="20">;
modified on Wednesday, February 27, 2008 9:57 AM
|
|
|
|
|
I am trying to develop a concept for my back-office system so that I can define the work that needs to be done. I am not a programmer so please be gentle with me!
I have an MS SQLExpress database sitting behind my (VB.Net2) my website. The database has a table into which orders go when customers buy online.
What I want to do is to have a copy of this table on my local server and use a web service to feed the local database from the website database.
I already have a web service which takes data from the local database up to the web database. Thus my assumption that a web service would be the best way to bring data down.
So my idea is that as soon as the website database receives a new record it initiates the web service which sends the record down to the local databse. But can the website database trigger the sending down of data when a new record is added to a table?
Simple in theory but is this feasible in practice?
Thanks in anticipation.
Chris
|
|
|
|
|
A webservice does not push, it pulls. So, the web service needs to be on the machine that is recieving the data not sending it.
You can write triggers in your DB, and you can run .NET code in SQL Server 2005, so I don't see why this should be a problem.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
cbjroms wrote: copy of this table on my local server and use a web service to feed the local database from the website database.
Are these two databases on the same server? SQL2005 does have support for creating http endpoints, though it isn't for a novice. There is also an option to use Service Brokers to communicate between the databases, but again it isn't a novice skill.
cbjroms wrote: I am not a programmer so please be gentle with me!
No offensive, but maybe you should leave this to professionals.
only two letters away from being an asset
|
|
|
|
|
If you just want a copy, why not just have the database back itself up to the local server periodically?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
How can I clear the history of a browser page by using scripts or programming
Gopinath.R
|
|
|
|
|
Use the following script for the same in your first page:
<script type="text/javascript" language="javascript">
javascript:window.history.forward(1);
</script>
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
Dear all,
i have one table named ContactPerson in which there is one column named "PersonImg" which has a datatype - image and it stores image(.gif, .jpeg) in binary format.
I have inserted data into one XML file, but i m not able to read that image data from XML file in .aspx page.
Needed yr help. Any suggestion is welcome.
Thanks in advance
Regards,
Rana k.j.
|
|
|
|
|
The data should be in a CDATA tag, and then you get it out using normal XML methods, and build the image by passing the data via a stream to it's constructor. Of course, you won't be able to display an image that's not on your file system, unless you have a custom page extension and custom handler defined which reads this data and passes it down to the client, in this case, you'd just pass the data out of the CDATA tag. Now, a CDATA section that contains binary data, would need to be uuencoded, or similar, to make all the data appear as text. So, it would have to be converted back to a byte stream of pure data at the other end.
Where is the XML coming from ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
window.location.replace(URL)only works in IE. I need it to be worked in both the IE and Firefox... Could you help me
Advance thanks for ur help
Gopinath.R
modified on Wednesday, February 27, 2008 7:41 AM
|
|
|
|
|
Try this function
function Redirect(URL)
{
if (window.location.replace)
window.location.replace(URL)
else
window.location.href=URL
}
*jaans
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
