Crystal Report Asking for Database Authentication each time when I view Page.

Hi , i am creating crystal report with asp.net it is working showing data but  data is of two page its is take round trip action but report is not show 
until again i click on show button in this it is not propersly showing that data is how. 

<br />
    <asp:Button ID="btnShow" runat="server" OnClick="btnShow_Click" Text="Show Report" />
    &nbsp;
  <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true"
        DisplayGroupTree="False" EnableDatabaseLogonPrompt="False" />

 CrystalReportViewer1.ReportSource = null;
        SqlCommand cmd = new SqlCommand(strcmd, c.con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        ReportDocument doc = new ReportDocument();
        doc.Load(AppDomain.CurrentDomain.BaseDirectory + "\\rptQuotation.rpt");
        doc.SetDataSource(ds.Tables[0]);

        // login info
        SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);

        TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
        TableLogOnInfo crtableLogoninfo = new Tabl

Hi,

i have one problem in crystal reports

i want print  group details ,for each group it should print in new page.

some thing like this

2-999-9999-1234

Transaction Number                Date                           Amount                           Remarks

   1111                                   10/1/2007                    300.00                                 JE999

   2222               &nb

I only have 1 user that cannot see reports. I even did a gotomeeting and we clicked refresh serveral times and we get the Report Execution Session died.

Every other user works on VPN. The rest of the wqeb site also works fine.

Does any have some pointers on find a resolution for this user. He is windows authenticated and using a VPN. ( I have 1 user out of at least 50 have worked fine with a report viewer over VPN.

Ideas appreciated. 

Hi, whenever I load an aspx page in vwde2008, I get the message in the subject of this post.  After I click Ok on that, I get a dialog box, Unable to Connect to the ASP.Net development center.  What can I do to troubleshoot?

I am using Windows XP SP3, vwde2008 with SP1, on a HP desktop.  Also using Office 2003 if that is relevant at all.

Thanks, Justin

Hi ...

I have used the above method to configure my crystal report ...

Its working fine , But i have huge number of data in database ....

So , it take long time to load the report ...

So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.

Plz help me with this issue  ...

Also , Plz explain me abt index legend in crystal report.

We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..

We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.

thanks.

  
            strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"        
  
            getStaticRecordSet(strSqual)   
            'get the new transaction_id out for just inserted alarm   
            strSqual = "select max(transaction_id) as transaction_id from trans"  
            set rst = getStaticRecordSet(strSqual)