Posts by vinayak.v

hi..
i'm facing a new problem in ssrs reports ...

i have hosted an asp.net application which is running fine in XP..
but when i open the application in UBANTU OS application is working
fine but reports in kannada are not displaying
it is displaying some russian character .. same problem when i
export to PDF it is displaying some russian character..

In windows XP prof3 Kannada reprots are working fine..

but in ubantu OS it is not displaying the fonts..

what to do... ? help me....

yes u got it right its an asp hosting..
i have two folders publish and release folder..
i want to give to the hoster for hosting..

now what is the process to give the publish release
folder to the hosters..

what steps we need to take..

thanks for replying..

sorry for one more stupid Question

There are two teams hosting team and development team

developers build the software and related document before release

they have the code and document.

now what is the process to that builded project to the hosters i.e hosting department..

means... what are the steps that we should keep in mind

before we give the project to the hosters.....??

hi...
i have released one application..

now i have to maintain the document for the released application..

which is the best method to write the information
such as in word,or pdf or excel or
is there any way to keep the document..?

so that every one should know that the new release
application is released .. and they should be updated

i've hosted the previous application and now i have
release the modules in that application ..

now i have inform all the user that we have
released new modules with etc etc features ..

which is the best way to inform the user about newly released application..?

hi..
i'm using ssrs 2008 enterprice edition..
i want to send a report as email..
to my gmail address.. i want to schedule a report so that it can
deliver daily to my gmail address..

how to send the report to my gmail address..
i dont know anything about smtp server activation and services
and also in configuration of reporting services..
i dont know how to configure email settings..

please help me..
can anyone provide a step by step datails
for the above requirment..

hi...

i have one application..
when i run that application the data is shown correctly and
also with proper alignment..

i have hosted that application..
but in hosted application the report header size is
reduced and the bank name and the narration
values are same..(those should be separate)

the problem occur only in hosted application....

check the attachment for image..
please help me... i am totally confused...

help me.....

hi..
i'm trying to retrieve the data from database using ssis package..
database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production
database..

now what i want is to retrieve the data for each four hours..
i.e i want to execute the package for every 4 hrs..

now what i did is i have taken a database transfer task and from the
source i.e production database i want to transfer to my database
which works fine..

but what is the problem here is for every 4 hrs whole DB is replaced in my system
i've given overwrite TRUE..

Here user enter the data into database for every 4 hour is minimum 10 MB of data..
instead for replacing the whole database for every 4 hrs is there any
solution that what user enter data into database only that much amount of data should be append into my system..

Is it possible.. how to do it..

hi... everybody sorry for my stupid question..

i've three options for creating the reports

1)crystal reports for asp.net application using crystal report viewer or silverlite application using silverlite report viewer..

2)ssrs reports for asp.net application using microsoft report viewer or silverlite application using silverlite report viewer..

3)report sharp shooter for asp.net application using report manager preview or silverlite application using report manager..

i'm really confused which one to choose..

the main requirment for me is the report should be fast accessible in server as our application is big..

the report should be fast viewed and take the print at the client side... and also load should be less at serverside..

please can anybody help me which one to prefer...

hi... to all..

i've written the code in expression field...

=format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00")

the code is for printing the number in this format(12,23,23,34,123.00)

now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas

are printed.. i dont want to print the extra commas.. how the word length is there that much it

should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...

i've tried by removing some of the #'s but it is for fixed number..

please help me...

hi....

in which version of sql server i can get the below two option...

1) performance tools

2)database tuning advisor..

please send me the download site...

hi..... to all....

i'm new to silverlight ...

my doubt is.... for ssrs reports there's an BIDS( bussiness intellegent development studio) ..

now i want to design reports in silverlight reporting services is there any development studio for

silverlight reporting services.... if yes please give me the download site... i want to download...

please help me....

hi...... to all

i have one problem in executing the ssrs reports..

i've developed one project for that project there are some SSRS reports which are deployed

in path ( "http://localhost/reports/") it is working fine...

when i run through the project and press F5 ( i.e execute) the reports

are displaying correct with full of content in that...

now i want to host that project.. so i've created one virtual folder named as proj in IIS7..

and i've assigned the project to that..

when i execute from IE7 and type the path http://localhost/proj then the main page is displayed

and when i click the button print then it is showing the empyt report with only the toolbar above

no content are there in reports ...

but when the run the project i.e F5 then the report is displayed with full of content...

what is the problem here.. please help me...

hi....

i've developed on ssrs report which displays the number
in words i.e in million and billion..

i want it in crores ,lakhs,thousands,hundreds,rupees and paise..

can any one modifiy the code below..

which is in reports properties->code tab..
the below is my code which is of million and billion dollars and cents....

SHARED suffixes AS String() ={"Thousand ", "Million ", "Billion ", "Trillion ","Quadrillion ", "Quintillion ", "Sextillion "}

SHARED units AS String() ={"","One ", "Two ", "Three ", "Four ", "Five ","Six ", "Seven ", "Eight ", "Nine "}

SHARED tens AS String() ={"Twenty ", "Thirty ", "Forty ", "Fifty ", "Sixty ","Seventy ", "Eighty ", "Ninety "}

SHARED digits AS String() ={"Ten ","Eleven ", "Twelve ", "Thirteen ", "Fourteen ","Fifteen ", "Sixteen ", "Seventeen ", "Eighteen ", "Nineteen"}

SHARED expr AS NEW System.Text.RegularExpressions.Regex("^-?\d+(\.\d{2})?$",System.Text.RegularExpressions.RegexOptions.None)

Public Function ExpandPrice(Price AS Double, Optional pSeparator AS String = ",") AS String 

Dim pPrice As String 
pPrice = FORMAT(Price,"##############.00")

Dim temp AS New System.Text.StringBuilder() 
If Not expr.IsMatch(pPrice) Then 
 ' temp.Append(pPrice) or whatever you want to do here 
Else 
 Dim parts AS String() = pPrice.Split(pSeparator) 
 Dim dollars AS String = parts(0) 
 Dim cents AS String = parts(1) 
If CDbl(dollars) > 1 Then 
 temp.Append(ExpandIntegerNumber(dollars) & "Dollars ") 
If CInt(cents) > 0 Then 
 temp.Append("And ") 
End If

ElseIf CDbl(dollars) = 0 Then 
 temp.Append(ExpandIntegerNumber(dollars) & "Zero Dollars ")

If CInt(cents) >= 0 Then 
 temp.Append("And ") 
End If

ElseIf CDbl(dollars) = 1 Then

temp.Append(ExpandIntegerNumber(dollars) & "Dollar " )

End If

If CDbl(cents) > …

hi....

The code is about place the comma's (,) i.e separator between numbers
in this format (12,21,21,123) it works good..

but when there's a decimal point such as 12345.58 it will show as 12,346..
it will round up the values.. ( which i dont want that .. i want as it value to be printed )

and one more problem if there five digit with two decimal i.e(12345.00) it will show correct
i.e (12,345.00) but if i there four digit with two decimal i.e(1234.00 ) it will show this #error

Public Function FormatIndian(ByVal Amount As decimal) As String  
Dim strAmount As String
Dim strGrpsArr() As String
Dim lngPos As Long
Dim lngIndex As Long

   strAmount = Format$(Amount, "#")
   If Len(strAmount) < 4 Then
      FormatIndian = strAmount
   Else
      lngIndex = (Len(strAmount) - 2) \ 2
      ReDim strGrpsArr(lngIndex)
     
      strGrpsArr(lngIndex) = Mid$(strAmount, Len(strAmount) - 2)
     
      lngPos = Len(strAmount) - 4:  lngIndex = lngIndex - 1
      Do
         strGrpsArr(lngIndex) = Mid$(strAmount, lngPos, 2)
         lngPos = lngPos - 2:       lngIndex = lngIndex - 1
         If lngPos = 0 Then strGrpsArr(0) = Left$(strAmount, 1)
      Loop Until lngPos <= 0
     
      FormatIndian = Join(strGrpsArr, ",")
      Erase strGrpsArr
   End If
        Return  FormatIndian 
End Function

please modify the code .. the code is in ssrs report properties->code tab..
help me...

hi... to all..
i've developed one ssrs report in "sql server 2008 express with advance services"...

The virtual folder is not there in IIS .. ok it works fine ..

i.e http://mysystemname:8080/reportserver_sqlexpress it works good...

but the same thing i want to execute in another system .. with my system ip..
i.e http://my ip:8080/reportserver_sqlexpress the logon promt is appearing with uname and password..
i'm giving here my system uname and password..
after pressing ok..
the following error is displayed..

Reporting service error
The permissions granted to user 'mysystemname\Guest' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

what to do...

please help me....

hi.... to all..

i'm using sql server 2008 express with advance edition with BIDS...

i've developed one report in that employee salary..

i want to print the salary in the format (12,34,56,78,91,01,11,233.89)

and i want to print in words

such as (" ninty nine crores fifty one lakhs fourty nine thousand four hundred and fourty five rupees and seventy nine paise ")

i.e in crores and lakhs (indian currency format)...

please help me....

hi...

i'm using sql server 2008 with advance services

the below error is of reporting services..

"The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)"

when i'm trying to host appliction.. the above error is occured..

it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host application

the above error is displayed.

please help me....

hi... everybody...

i've designed one crystal report to display the total number in indian
currency format which works good...
following is my code.

numbervar RmVal:=0; 
numbervar Amt:=0; 
numbervar pAmt:=0; 
stringvar InWords :=" ";
numbervar totalAmt;
totalAmt:=Sum ({employee.salary});
Amt := totalAmt;


if Amt > 10000000 then RmVal := truncate(Amt/10000000); 
if Amt = 10000000 then RmVal := 1;

   if RmVal = 1 then 
        InWords := InWords + " " + towords(RmVal,0) + " crore" 
   else 
        if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + " crores";


    Amt := Amt - Rmval * 10000000;



    if Amt > 100000 then RmVal := truncate(Amt/100000); 
    if Amt <= 100000 then RmVal := 1;
    

    if RmVal = 1 then 
        InWords := InWords + " " + towords(RmVal,0) + " lakh"
    Else
        If RmVal > 1 then InWords := InWords + " " + ToWords(RmVal,0) + " Lakhs";
 


        Amt := Amt - Rmval * 100000;
 

 



if Amt > 1000 then RmVal := truncate(Amt/1000);
if Amt = 1000 then Rmval := 1;

if RmVal =1 then 
Inwords := InWords + " " + towords(RmVal,0) + "Thousand"
Else
if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + "thousand ";
Amt := Amt - RmVal * 1000;
        



if Amt > 0 then InWords := InWords + "  " + towords(truncate(Amt),0);

        pAmt := (Amt - truncate(Amt)) * 100;

        if pAmt > 0 then 
            InWords := InWords + " and " + towords(pAmt,0) + " paisa only" 
        else 
            InWords :=InWords + " rupees only";

        UPPERCASE(InWords)

if i give 2,13,45,000 display in words as (TWO CRORES THIRTEEN LAKHS FORTY-FIVETHOUSAND RUPEES ONLY ) which is correct...

but when i give 2,00,45,000 it will display wrong value
i.e(TWO CRORES ONE LAKH ONETHOUSAND RUPEES ONLY )

i want here to be printed as (TWO CRORES FORTY-FIVE THOUSAND RUPEES ONLY ) which i want...

please help me...

hi....

i've created one ssrs report it works good im my system..

i.e http://localhost/reportserver$sqlexpress

but how should i execute in different system...

if i enter the system name then it is showing page cannot be displayed..

i.e http://sys1/reportserver$sqlexspress (page cannot be found)

please help me..

hi... to all
the following code is to deploy the reports programatically...

i've one problem ..
by using the filestream it takes more time to load the reports..
hence burden on server..
is there any option or any solution to make less burden on server....

one more thing the records are converting to bytes hence getting late to load..

code.ReportingService20051.Warning[] warnings;
FileStream stream = File.OpenRead("E:\\Rptsubcharts\\charts\\charts\\samp.rdl");
reportDefinition = new Byte[stream.Length];
stream.Read(reportDefinition, 0, (int)stream.Length);

stream.Close();

warnings = (code.ReportingService20051.Warning[])rs.CreateReport(reportPath.Remove
(reportPath.Length - 4, 4), @"/test1", true, reportDefinition, null);

please help me...

hi....

as u all know about ssrs reports...

now i'm using the crystal reports
and i want to go through ssrs reports

can anyone answer the following question.
1)what is the need of ssrs...
2)and why we should use ssrs..,
3)what are the advantages
4)what are the disadvantages
5)how it will on work webapplication..
6)how much loadtime it will take by server
7)whether it is a lightweight application or heavyweight..
8)what the problem that we face in future..

please help me it'll be very helpfull for me

hi... to all
i've created ssrs reports local following is my code..

public void source(string tbname,string Rptname)
    {
        ReportViewer1.Visible = true;
        string myQuery = "select * from " + tbname;
        SqlConnection myConnection = new SqlConnection(ConnectionString);
        SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
        myCommand.Connection.Open();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        DataSet dt = new DataSet();
        da.Fill(dt);


        //ReportParameter[] p = new ReportParameter[1];
        //p[1] = new ReportParameter("@p_dno", "5");
        //this.ReportViewer1.LocalReport.SetParameters(p);
        //DataSet dt = new DataSet();
        //dt = p;
        ReportViewer1.LocalReport.ReportPath = Rptname + ".rdlc" ;
        ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
       ReportDataSource datasource = new ReportDataSource("employeeDataSet_" + tbname , dt.Tables[0]);
        ReportViewer1.LocalReport.DataSources.Clear();
        ReportViewer1.LocalReport.DataSources.Add(datasource);

    }

now it works good..
as i expected...

but i want to pass the datasource connection string from here is there any
way to pass the datasource programatically....

Hi everybody..

i've created one SSRS in that i've connected to the database having four fields..

now want i want is to calculate the salary page by page and at the last grand

total..

i've kept one extra column in table and kept one running field and made it as

hidden. i've taken one textbox and placed in page footer with the

expression="PAGE RECORD TOTAL="& Last(reportitems("Subtotal1").Value)

where subtotal1 is a running field and i'm taking the last value of that.. and printing in

page footer..

Now my problem is when i run the report the value will be present but when

i click on preview or take the print the value will be disappeared..

please help me..

And when i make the running field hidden=false then it will display while printing also..

i dont want to show the running field i want to hide it..

i've created the report with the following link

http://community.dynamics.com/blogs/navteam/archive/2010/03/17/transfooter-and-transheader-functionality-in-rdlc-40-ssrs-41-reports.aspx

please help me

if i use the cryRpt.exporttodisk then it will save to the disk..
i dont want to save the file i want to use the buffer and
i want to take the print..
the following is my code.. in windows form

ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("E:\\Report1\\over\\CrystalReport1.rpt");
ExportOptions CrExportOptions ;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
//MemoryStream oStream; // using System.IO
// oStream = (MemoryStream)
cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
CrDiskFileDestinationOptions.DiskFileName = (oStream.ToString()); 
CrExportOptions = cryRpt.ExportOptions;
{
 CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
 CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
 CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
 CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cryRpt.Export();
}

Good morning everybody...

the following code works well in .aspx page that is in
web application..
now the same thing i want to do in windows form application.. can anybody help me..

The code is for without saving the pdf file take a print..
it works well in .aspx page

ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("E:\\Report1\\over\\CrystalReport1.rpt");
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("E:\\Report1\\over\\CrystalReport1.rpt");
MemoryStream oStream; // using System.IO
oStream = (MemoryStream)
cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();

In windows form the Response .clear or response.buffer is not supported
error is missing namespace or directive is displaying...

hi ...

i've created one crystal report in windows form and one crystalreportviewer ..

the following is my code..

in form1.cs file

try
{
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net-informations.pdf";
CrExportOptions = cryRpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cryRpt.Export();
}
the above code is saving the file into pdf into specified path..

but i dont want to save a file i should get direct print preview and

have a option to print ..

As we do in web application using crystal report viewer clicking print

and report will be opened in pdf.. and the click print..

i want the same function as we do in web application...

i'm writing code in c#.net

hope the above explaination will be understood clearly..

hi...

i've two crystal reports one is in D: drive name employee.rpt with 5 textobject

and another report is in E: drive name employee.rpt with 15 textobject...

now i want to write a program to overwrite the D drives report with E drives reports

i.e i want to replace the 5 textobject with 15 textobject..

overwriting the reports while it is executing ..

is there any code for it please help me..

its urgent..

hi..
i've created one crystal report. and one global resource file ..
in crystal report there's one text object with id Text1.
and i want to take the values of resource file i've got it
CrystalDecisions.CrystalReports.Engine.TextObject Dtemp1 =

((CrystalDecisions.CrystalReports.Engine.TextObject)myreport.ReportDefinition.Sections["section1"].ReportObjects["Text1"]);
Dtemp1.Text = Resources.Resource.ResourceManager.GetString("Dsec1");

it is showing the correct value want i want but when i give print it is disappearing..
how to solve this

please help me..

but i'm working in windows form application.
response option is not there...

hi..
i've created a crystal report and one crystal report viewer in windows form.
i've two form form1 and form2 in form2 i've kept one button called print.
when i press this button it should print the document into .pdf format.
without using the crystal report viewers print button.
please help me

hi..

i've one crystal report.

i want the report header as "employee database".

i dont want to right click->insert and goto text object and insert.

i've one aspx page and aspx.cs page also.

now i want the "employee database" header to be printed from .cs file.

i dont want to pass by parameter also..

i.e is there any option in .cs file

something like

ReportDocument myreport = new ReportDocument();

myreport.Load(MapPath("~/" + "emp.rpt"));

myReport.Reportheader="Employee database";

i hope u have understood this.

only thing is from .cs file i want to print the header as employee database.

i dont want by passing parameter also...

please help....

ReportDocumentsasd myreport = new ReportDocument();myreport.Load(MapPath("~/" + "emp.rpt"));

hi..

i want to override the connection string of crystal reports..

is there any way that i use the connection string as shared datasource.

MY PROBLEM BEGINS:

i've 50 reports with the connection string vsspl-005\sqlexoress

but i've changed my connection string vsspl-002\sqlexpress.

there is only one way that i dont want to do i.e individually change the connection string of each crystal report

using database experts..

is there any way that the connection string should be assigned as shared datasource..

or any other way..

Please please help me i'm trying this since from one week..

inform me whether it is possible or not.

if possible send me the code..

if not.. then reason please.

i'm fedup of this..

Please can anyone help me how to convert number to words in Indian format in Crystal Reports. eg. I want to convert Rs.25,12,545 as Rupees Twenty Five Lakhs Twelve thousand five hundred and fourty five only. The towords function converts into millions and billions and i want the result in Lakhs and crores. Thanks in advance.

hi.. to all

i've connected my crystal report to my database using database

experts. now my problem is i want to display the total no of records..

in each page .. i.e in database there are 50 records when i execute..

it takes two page to print..

now in first page there are 30 records and in second page there are 20..

i want to display the value 30 at the end of page and 20 at the end of page.

i.e how much the page contains the records that much it should print in page footer

please help me its urgent...

hi.. i'm using the database on live ..

i may do hosting on different system and ip is changed..

please help me the below code runs well when i remove the ispostback condition..

but when i keep that when page is loaded it works well but when i give print the database is

displayed which i've connected to the report using database experts...

please i want to overwrite the connection string when i press print button also ..

please can u add that code and make modification i dont know were to add that code.

the following is my code which is in page load

public partial class _Default : System.Web.UI.Page
{
string connections = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;
// private TableLogOnInfo LogInfo = new TableLogOnInfo();
ReportDocument myreport = new ReportDocument();
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
string myQuery = "select * from employee";

SqlConnection myConnection = new SqlConnection(connections);
SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
myCommand.Connection.Open();

SqlDataAdapter da = new SqlDataAdapter(myCommand);
DataSet dt = new DataSet();
da.Fill(dt);
DataTable td = dt.Tables[0];
myreport.Load(MapPath("~/" + "emp.rpt"));
// myreport.Database.Tables[0].ApplyLogOnInfo(LogInfo);

myreport.Database.Tables[0].SetDataSource(td);
CrystalReportViewer1.ReportSource = myreport;
Logininfo();

//int count = Convert.ToInt32(dt.Tables[0].Rows.Count);
myConnection.Close();
}

}

hi.. i'm using the database on live ..

i may do hosting on different system and ip is changed..

please help me …

emp database(connection string vsspl-005\sqlexpress)employee database(connection string vsspl-002\sqlexpress)
runtime employee database
when i give print button emp database

the above 4 fig display the problem..

please help me.. since i'm trying from last 4 days

i've one crystal report which is connected to the database using database expert and connection string is

vsspl-005\sqlexpress and i want to override the connection string to vsspl-002\sqlexpress..

i've writen the connection string in webconfig file it is working well..

for example. the report is connected to the emp database using database experts..

and the overriding string is connected to the employee database in webconfig file..

when i run it is displaying correct employee database..

but when i give print it is diaplaying the logon prompt with server name same vsspl-005 emp database.

and in the pdf it is printing the eml database. i want the employee database in the pdf and print..

please help me..

i want to override the connection string both the time while its running and when i give print command in pdf also..

please can any one help me...

Error 2 'System.Web.HttpApplicationState' does not contain a definition for 'startuppath' and no extension method 'startuppath' accepting a first argument of type 'System.Web.HttpApplicationState' could be found (are you missing a using directive or an assembly reference?) E:\Report1\global\Default.aspx.cs 77 36 E:\Report1\global\

please help me..
i want to override the connection string of crystal reports which was connected by the database experts..
now i want to override with with new connection string .. the above error is diaplaying..
the following is my code if there is any mistake please correct me...
its urgent please help me....

the code is..

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data.OleDb;
using CrystalDecisions.Enterprise;


public partial class _Default : System.Web.UI.Page
{
    string connections = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;
    private TableLogOnInfo LogInfo = new TableLogOnInfo();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

         

          }


    }



    private void SetLogonInfo()
    {
        try
        {
            LogInfo.ConnectionInfo.ServerName = "";
            LogInfo.ConnectionInfo.UserID = "";
            LogInfo.ConnectionInfo.Password = "";
            LogInfo.ConnectionInfo.DatabaseName = "";
        }
        catch (Exception e)
        {
            
        }
    }
    //private void setDBLOGONforREPORT(ConnectionInfo myconnectioninfo)
    //{
    //    TableLogOnInfos mytableloginfos = new TableLogOnInfos();
    //    mytableloginfos = CrystalReportViewer1.LogOnInfo;
    //    foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
    //    {
    //        myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
    //    }

    //}

      protected void btn_emp_Click(object sender, EventArgs e)
    {
        // string connections = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;
        // string connections = "Data Source=VSSPL-002\\SQLEXPRESS;Initial Catalog=employee;Integrated Security=True";
        string myQuery = "select * from employee";
        SqlConnection …

hi...

i've 50 crystal reports which is connected to the database directly without using any dataset..

and the connection string is vsspl-002\\sqlexpress..

now my problem is i've shifted the database to another location..

and my connection string is vsspl-008\\sqlexpress..

now i dont want to change the connection string for each report individually..

is there any solution that to change only once and it apply to all the reports...

please help me it urgent....

hi...to all
i've designed an report for the employee database..
i want to display the total no of records in each page.. how to do this..
consider there are 100 records..
for eg.. if in a single page there are 50 records it should display 50 records..
and if that database continues in next page then it should display remaining total no records..

hi...
i want to work on different formulas and apply to the crystal reports..
and i also want to to work on sqlexpression option.. these two fields are in field explorer..can anbody give me some site or web address so that i
could work on them..

hi to all.
i've created one aspx page in that i've added a new item called dataset.
i've taken the employee table..
form the database.
i've added a new item crystal reports to it.. i've dragged some of the field from the dataset..
now i want to write the code to connect to the database and fill the dataset which i've created and it should display the
report with the help of crystalviewer is aspx page.. now my problem is while executing the code.
it is asking login name,servername,passward,database name..
i've not given any login name and passward to my sqlserver database what to do.. following is my code. in page load..

protected void Page_Load(object sender, EventArgs e)
    {
        ConnectionInfo cr = new ConnectionInfo();
        cr.ServerName = "VSSPL-002\\SQLEXPRESS";
        cr.DatabaseName = "employee";
        cr.UserID = "abcd";
        cr.Password = "abcd";
        string connectionSting = "Data Source=VSSPL-002\\SQLEXPRESS;Initial Catalog=employee;Integrated Security=True";

        string myQuery = "select * from employee";

        SqlConnection myConnection = new SqlConnection(connectionSting);

        SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
        myCommand.Connection.Open();


        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        DataSet dt = new DataSet();

        DataSet  rp = new DataSet ();
        da.Fill(dt);
        ReportDocument myrd = new ReportDocument();
        myrd.Load(@"E:\Report1\emp2\CrystalReport1.rpt");
        myrd.SetDataSource(dt);

        CrystalReportViewer1.ReportSource = myrd;
        CrystalReportViewer1.DataBind();

        //int count = Convert.ToInt32(dt.Tables[0].Rows.Count);
        myConnection.Close();



    }