Hi,
I am new to crystal reports and at the moment I am trying to develop some basic reports from the standard tables ( Database - Pubs, Table - Authors )
Here's what I have done.
1. Create a new ASP.NET web application - webapp1.
2. Using solutions explorer - Add new Item - Crystal report, and called it auth_rep.rpt.
3. Using the Report Expert ( Standard ),I make a database selection as follows:
OLE DB (ADO) --> Microsoft OLE DB provider for SQL Server
Server: localhost
User ID: sa
Password:
Database: pubs
4. Next using the standard report expert I insert the table - authors, Add all Fields. And click finish.
5. Next in webform1.aspx, Uisng the Toolbox - web form, I add a CrystalReportViewer. In the DataBindings, I select the ReportSource under Bindable properties, and set the Custom Binding Expression to
c:\inetpubs\
As soon as I click OK, I get a report with all the fields set to some odd values -- like
au_id: white
au_lname: Monday
au_fname:
phone: Text
address:
city:
st:
zip:
co: False
I am clueless now !!!
Next, I do a SaveAll and then I try to do a view in browser for webform1.aspx, I get an error message: BC30196: Missing list separator.
Details are as follows:
Server Error in '/webapp1' Application.
--------------------------------------------------------------------------------
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30196: Missing comma list separator.
Source Error:
Line 12: <body MS_POSITIONING="GridLayout">
Line 13: <form id="Form1" method="post" runat="server">
Line 14: <CR:CrystalReportViewer id="CrystalReportViewer1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server" Width="1030px" Height="1073px" ReportSource="<%# C:\Inetpub\ %>">
Line 15: </CR:CrystalReportViewer>
Line 16: </form>
Source File: c:\inetpub\ Line: 14
Show Detailed Compiler Output:
C:\WINNT\system32> "c:\winnt\microsoft.net\framework\v1.0.2914\vbc.exe" /t:library /utf8output /R:"c:\winnt\microsoft.net\framework\v1.0.2914\temporary asp.net files\webapp1\70160efe\9a7ffd5e\nny2-lwq.dll" /R:"c:\winnt\assembly\gac\system.web\1.0.2411.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\winnt\assembly\gac\system\1.0.2411.0__b77a5c561934e089\system.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.reportsource\9.1.0.0__4f3430cff154c24c\crystaldecisions.reportsource.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.crystalreports.engine\9.1.0.0__4f3430cff154c24c\crystaldecisions.crystalreports.engine.dll" /R:"c:\winnt\assembly\gac\system.xml\1.0.2411.0__b77a5c561934e089\system.xml.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.shared\9.1.0.0__4f3430cff154c24c\crystaldecisions.shared.dll" /R:"c:\winnt\assembly\gac\system.web.services\1.0.2411.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.web\9.1.0.0__4f3430cff154c24c\crystaldecisions.web.dll" /R:"c:\winnt\assembly\gac\system.data\1.0.2411.0__b77a5c561934e089\system.data.dll" /R:"c:\winnt\microsoft.net\framework\v1.0.2914\temporary asp.net files\webapp1\70160efe\9a7ffd5e\assembly\downloaded2\0431813f\2498d397_4196c201\webapp1.dll" /R:"c:\winnt\assembly\gac\system.drawing\1.0.2411.0__b03f5f7f11d50a3a\system.drawing.dll" /out:"C:\WINNT\Microsoft.NET\Framework\v1.0.2914\Temporary ASP.NET Files\webapp1\70160efe\9a7ffd5e\z6vjkhmc.dll" /D
EBUG=1 /debug+ /win32resource:"C:\WINNT\Microsoft.NET\Framework\v1.0.2914\Temporary ASP.NET Files\webapp1\70160efe\9a7ffd5e\z6vjkhmc.res" "C:\WINNT\Microsoft.NET\Framework\v1.0.2914\Temporary ASP.NET Files\webapp1\70160efe\9a7ffd5e\z6vjkhmc.0.vb"
Microsoft (R) Visual Basic.NET Compiler version 7.00.9254
for Microsoft (R) .NET CLR version 1.00.2914.16
Copyright (C) Microsoft Corp 2001. All rights reserved.
c:\inetpub\ : error BC30196: Missing comma list separator.
target.ReportSource = CType(C:\Inetpub\~
c:\inetpub\ : error BC30451: The name 'C' is not declared.
target.ReportSource = CType(C:\Inetpub\~
c:\inetpub\ : error BC30035: Syntax error.
target.ReportSource = CType(C:\Inetpub\~
I have tried changing the path to C:\\Inetpub\\ and the error message is identical.
Next I try to enclose the path in double quotes
"C:\Inetpub\ and this time I get a message in the CrystalReportViewer - Use ReportSource or DataBindings property to specify a report source.
Not really sure what has to be done. Any suggestions ?
Thanks
I am new to crystal reports and at the moment I am trying to develop some basic reports from the standard tables ( Database - Pubs, Table - Authors )
Here's what I have done.
1. Create a new ASP.NET web application - webapp1.
2. Using solutions explorer - Add new Item - Crystal report, and called it auth_rep.rpt.
3. Using the Report Expert ( Standard ),I make a database selection as follows:
OLE DB (ADO) --> Microsoft OLE DB provider for SQL Server
Server: localhost
User ID: sa
Password:
Database: pubs
4. Next using the standard report expert I insert the table - authors, Add all Fields. And click finish.
5. Next in webform1.aspx, Uisng the Toolbox - web form, I add a CrystalReportViewer. In the DataBindings, I select the ReportSource under Bindable properties, and set the Custom Binding Expression to
c:\inetpubs\
As soon as I click OK, I get a report with all the fields set to some odd values -- like
au_id: white
au_lname: Monday
au_fname:
phone: Text
address:
city:
st:
zip:
co: False
I am clueless now !!!
Next, I do a SaveAll and then I try to do a view in browser for webform1.aspx, I get an error message: BC30196: Missing list separator.
Details are as follows:
Server Error in '/webapp1' Application.
--------------------------------------------------------------------------------
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30196: Missing comma list separator.
Source Error:
Line 12: <body MS_POSITIONING="GridLayout">
Line 13: <form id="Form1" method="post" runat="server">
Line 14: <CR:CrystalReportViewer id="CrystalReportViewer1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server" Width="1030px" Height="1073px" ReportSource="<%# C:\Inetpub\ %>">
Line 15: </CR:CrystalReportViewer>
Line 16: </form>
Source File: c:\inetpub\ Line: 14
Show Detailed Compiler Output:
C:\WINNT\system32> "c:\winnt\microsoft.net\framework\v1.0.2914\vbc.exe" /t:library /utf8output /R:"c:\winnt\microsoft.net\framework\v1.0.2914\temporary asp.net files\webapp1\70160efe\9a7ffd5e\nny2-lwq.dll" /R:"c:\winnt\assembly\gac\system.web\1.0.2411.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\winnt\assembly\gac\system\1.0.2411.0__b77a5c561934e089\system.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.reportsource\9.1.0.0__4f3430cff154c24c\crystaldecisions.reportsource.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.crystalreports.engine\9.1.0.0__4f3430cff154c24c\crystaldecisions.crystalreports.engine.dll" /R:"c:\winnt\assembly\gac\system.xml\1.0.2411.0__b77a5c561934e089\system.xml.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.shared\9.1.0.0__4f3430cff154c24c\crystaldecisions.shared.dll" /R:"c:\winnt\assembly\gac\system.web.services\1.0.2411.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\winnt\assembly\gac\crystaldecisions.web\9.1.0.0__4f3430cff154c24c\crystaldecisions.web.dll" /R:"c:\winnt\assembly\gac\system.data\1.0.2411.0__b77a5c561934e089\system.data.dll" /R:"c:\winnt\microsoft.net\framework\v1.0.2914\temporary asp.net files\webapp1\70160efe\9a7ffd5e\assembly\downloaded2\0431813f\2498d397_4196c201\webapp1.dll" /R:"c:\winnt\assembly\gac\system.drawing\1.0.2411.0__b03f5f7f11d50a3a\system.drawing.dll" /out:"C:\WINNT\Microsoft.NET\Framework\v1.0.2914\Temporary ASP.NET Files\webapp1\70160efe\9a7ffd5e\z6vjkhmc.dll" /D
EBUG=1 /debug+ /win32resource:"C:\WINNT\Microsoft.NET\Framework\v1.0.2914\Temporary ASP.NET Files\webapp1\70160efe\9a7ffd5e\z6vjkhmc.res" "C:\WINNT\Microsoft.NET\Framework\v1.0.2914\Temporary ASP.NET Files\webapp1\70160efe\9a7ffd5e\z6vjkhmc.0.vb" Microsoft (R) Visual Basic.NET Compiler version 7.00.9254
for Microsoft (R) .NET CLR version 1.00.2914.16
Copyright (C) Microsoft Corp 2001. All rights reserved.
c:\inetpub\ : error BC30196: Missing comma list separator.
target.ReportSource = CType(C:\Inetpub\~
c:\inetpub\ : error BC30451: The name 'C' is not declared.
target.ReportSource = CType(C:\Inetpub\~
c:\inetpub\ : error BC30035: Syntax error.
target.ReportSource = CType(C:\Inetpub\~
I have tried changing the path to C:\\Inetpub\\ and the error message is identical.
Next I try to enclose the path in double quotes
"C:\Inetpub\ and this time I get a message in the CrystalReportViewer - Use ReportSource or DataBindings property to specify a report source.
Not really sure what has to be done. Any suggestions ?
Thanks