I have created One DLL
Public Class MyClass
Public Function MyFunction
Try
...
...
Catch Ex As Exception
Throw Ex
End Try
End Function
End Class
Aspx file
Try
Call MyClass.MyFunction
Catch Ex As Exception
TextBox1.Ex.ToString()
End Try
In this...
Create View View_1
SELECT Field1,Field2 FROM Table1
CREATE View View_2 WITH SCHEMABINDING
SELECT Field1,Field2 FROM View_1
will not work as View_1 is not WITH SCHEMABINDING
It means all the PARENT VIEW to be WITH SCHEMABINDING
to CREATE Index on Views ??
Thanks
i have gone thru link, it is good.
I have nested index.
It mean if i want to particular view to be index then all the parent view to be WITH SCHEMABINDING
And if i have written SCRIPTS for Creating a DATABASE then it should be deleted in order
Waiting for your reply
Thanks for quick reply
can creating views will reduce the performance??
Can Nested view can reduce performance
What to do to have Greater Performance using Views
SQL Server 2000
ASP.NET
Thanks
creating a crystal report object is taking too much time to load
Class Level i have define variable as
Dim rpt As CrystalReport1
i have tried for Threading also
it is going in the procedure but not going after following statement
rpt = new Crystalreport1
Thanks
I have completed my graph report in localhost, i am getting that report ok
after this when i load this to our Project Server
When i view that graph report, i am not able to see that report only + sign is shoing like when we don't able to view Picture file
What is the solution ?
Thanks
how to write custom function in Crystal
Can u give me syntax of it,
Following function i have written in VB.NET, now i want this function in Crystal Report, so i can pass two date and i get No. Of Weeks
Function (GetNoOfWeeks(ByVal sdate As Date, ByVal edate As Date)
Dim w1, w2, i As...
Left hand side of Report there is option of
Field View
Formula
Groups
Etc.
but in ASP.NET Button for view all this is disabled i am not able to click on it that's why it is not possible to drag fields and drop on the report OR
Create New formula
I am using CRYSTAL REPORT 11, ASP.NET 1.1...
We have generated one report in CRYSTAL REPORT 11,
now same reports we need so we have saved with another name & use that report with the same format as 1st report
& with changing heading and all that
1st reports is working properly
but the problem in 2nd report (copied report)
at the time of...
I have data like
Array(0) = "Tgc_No"
Array(1) = "Tgc_Desc"
Array(2) = "Tgc_Quantity"
Array(3) = "Tgc_Rate"
Array(4) = "Tgc_Amount"
I want it to convert as follows
Dim Abc As string
Abc = "Tgc_No,Tgc_Desc,Tgc_Quantity,Tgc_Rate,Tgc_Amount"
Other than loop solutions i.e. direct functions is there...
if i go like this only heading will be having color,
and all four side of heading lable will have white color
i want whole heading section with particular color
In Cross tab for heading i want to put a background color
if i am doing color for Total Column & Cross Tab Column color is there only for label not for whole square box
Thanks
I am using CRYSTAL Report 11 & with ASP.NET 1.1
in Graph only inner part i.e. inside line of X & Y i want to put Background Color
I have selected Line Chart with markers as data Point
I want to put custom color for each line
Thanks in advance
Can you make me understand what actually MTS is use for
Example
I have Header Table ,Detail Table & I want to save in it so what is use of MTS in this / It is for anything else
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.