does anyone know what Runtime DLLs are required to make the CRViewer work properly. I have registered crview.dll. crxdrt.dll and added in whatever didn't do the job on the dependecny walker. I seem to get an invalid tlv error every time I print the report. But if I install crystal XI on to a dev box and print the report through VB it works fine. So it is not the report. nor is it the VB but it is the Runtimes. From that box i Generated an install file for that project and installed on a fresh box and I still get the error. So i tried making a dependency file and again I get the same error.
Does anyone Know the required dependencies for Crystal XI. What am I missing?
Much Appreciated.
RicoWhen faced this problem, i created installer using VS. VS checked the
dependencies, so i could deploy my application without installing CR
at client side.|||I did that It did not solve the problem...
Did you do this with CR XI?|||I did that It did not solve the problem...
Did you do this with CR XI?
No, I did with CR 10.
One more question: Did you put CR deployment *.msm file into your
deployment project? You need to download from CR home page to
deploy them.
Henky|||I will look into that. If anyone has any other things to try let me know..
Rico|||If it is .net you can search -->
http://support.businessobjects.com/communitycs/technicalpapers/crxi_net_deployment.pdf.asp
If it is VS6 then -->
http://support.businessobjects.com/communitycs/technicalpapers/rdcxi_deployment.pdf.asp
Showing posts with label properly. Show all posts
Showing posts with label properly. Show all posts
Sunday, March 25, 2012
Tuesday, March 20, 2012
Crystal Reports 8 application mapping issue...
When running CR 8 with IIS 4, there were no problems.
Our developers installed IIS 5 and then installed CR 8 but the installation failed to properly setup application mapping so that when you click a link to an .RPT file, you get the actual file without it being processed into a webpage by IIS.
I know I can custom config IIS with extension and executable path to use the proper .rpt and .cri dll's, but I was wondering if there was an explanation for the problem?
Does CR 8 have compatibility problems with IIS 5? or is it something else?
Thanx,
CWTurns out it's not the mapping... everything should be configured to work right but still not converting .rpt to html...
any ideas at all?
Our developers installed IIS 5 and then installed CR 8 but the installation failed to properly setup application mapping so that when you click a link to an .RPT file, you get the actual file without it being processed into a webpage by IIS.
I know I can custom config IIS with extension and executable path to use the proper .rpt and .cri dll's, but I was wondering if there was an explanation for the problem?
Does CR 8 have compatibility problems with IIS 5? or is it something else?
Thanx,
CWTurns out it's not the mapping... everything should be configured to work right but still not converting .rpt to html...
any ideas at all?
Thursday, February 16, 2012
Cross Tab function?
I have my data summed and groupd properly to send to Crystal for a cross
tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
fit with the total.
So is there a Cross Tab function that I have missed that will gen the
dataset form me?
TIAHow will doing the work in SQL Server instead of Crystal have any effect on
the amount of data you can fit on a piece of paper? This sounds like a font
size issue to me...
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||Sorry Stephen,
there's no such thing like a cross-tab function in SQL 2000 (it is in
2005) but you can create a cross-tab report by using CASE. There's a
good example in BOL, just search for cross-tab report
M|||Stephen,
Might look at:
http://support.microsoft.com/defaul...b;EN-US;q175574
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OGad6VB0FHA.2312@.TK2MSFTNGP14.phx.gbl...
> How will doing the work in SQL Server instead of Crystal have any effect
> on the amount of data you can fit on a piece of paper? This sounds like a
> font size issue to me...
Because Crystal determines all sizes for columns, and I can get them smaller
if I had all the rows preset in the dataset. If I controled it, I may be
able to make it happen.
tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
fit with the total.
So is there a Cross Tab function that I have missed that will gen the
dataset form me?
TIAHow will doing the work in SQL Server instead of Crystal have any effect on
the amount of data you can fit on a piece of paper? This sounds like a font
size issue to me...
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||Sorry Stephen,
there's no such thing like a cross-tab function in SQL 2000 (it is in
2005) but you can create a cross-tab report by using CASE. There's a
good example in BOL, just search for cross-tab report
M|||Stephen,
Might look at:
http://support.microsoft.com/defaul...b;EN-US;q175574
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OGad6VB0FHA.2312@.TK2MSFTNGP14.phx.gbl...
> How will doing the work in SQL Server instead of Crystal have any effect
> on the amount of data you can fit on a piece of paper? This sounds like a
> font size issue to me...
Because Crystal determines all sizes for columns, and I can get them smaller
if I had all the rows preset in the dataset. If I controled it, I may be
able to make it happen.
Cross Server Communication Issue
We are having a problem getting the security to properly authenticate
cross-server logins where the user is logged in using windows
authentication. We are currently running SQL Server on a W2K3 cluster in a
W2K3 domain. There are actually four servers, two physical, the cluster
virtual server, and the SQL virtual server. We'll call them SQL1P
(primary), SQL1F (failover), SQL (cluster virtual server), and SQLV(SQL
virtual server). All servers have been set up for delegation in AD for
kerberos, and the sql service account has all of the proper permissions.
The problem now is that cross server communication with the other SQL
servers (not in the cluster) will work using standard SQL accounts, but not
using windows authentication. Has anyone else had this problem and if so
how did you resolve it? Thanks in advance for your answers.
What error are you getting when you try to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||This is the query that is being run:
select * from odewhsevprod.master.dbo.sysdatabases
Here is the error we are receiving:
Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:4H#0BElTEHA.3328@.cpmsftngxa10.phx.gbl...
> What error are you getting when you try to connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||We fixed the issue. We basically went in and reset the SPN's on the server
names and the sqlservice account as well as the mscs account, and now it
works fine.
"-DB" <server.team@.ode.state.or.us> wrote in message
news:eMYaAFjTEHA.2944@.tk2msftngp13.phx.gbl...
> We are having a problem getting the security to properly authenticate
> cross-server logins where the user is logged in using windows
> authentication. We are currently running SQL Server on a W2K3 cluster in
a
> W2K3 domain. There are actually four servers, two physical, the cluster
> virtual server, and the SQL virtual server. We'll call them SQL1P
> (primary), SQL1F (failover), SQL (cluster virtual server), and SQLV(SQL
> virtual server). All servers have been set up for delegation in AD for
> kerberos, and the sql service account has all of the proper permissions.
> The problem now is that cross server communication with the other SQL
> servers (not in the cluster) will work using standard SQL accounts, but
not
> using windows authentication. Has anyone else had this problem and if so
> how did you resolve it? Thanks in advance for your answers.
>
cross-server logins where the user is logged in using windows
authentication. We are currently running SQL Server on a W2K3 cluster in a
W2K3 domain. There are actually four servers, two physical, the cluster
virtual server, and the SQL virtual server. We'll call them SQL1P
(primary), SQL1F (failover), SQL (cluster virtual server), and SQLV(SQL
virtual server). All servers have been set up for delegation in AD for
kerberos, and the sql service account has all of the proper permissions.
The problem now is that cross server communication with the other SQL
servers (not in the cluster) will work using standard SQL accounts, but not
using windows authentication. Has anyone else had this problem and if so
how did you resolve it? Thanks in advance for your answers.
What error are you getting when you try to connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||This is the query that is being run:
select * from odewhsevprod.master.dbo.sysdatabases
Here is the error we are receiving:
Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:4H#0BElTEHA.3328@.cpmsftngxa10.phx.gbl...
> What error are you getting when you try to connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||We fixed the issue. We basically went in and reset the SPN's on the server
names and the sqlservice account as well as the mscs account, and now it
works fine.
"-DB" <server.team@.ode.state.or.us> wrote in message
news:eMYaAFjTEHA.2944@.tk2msftngp13.phx.gbl...
> We are having a problem getting the security to properly authenticate
> cross-server logins where the user is logged in using windows
> authentication. We are currently running SQL Server on a W2K3 cluster in
a
> W2K3 domain. There are actually four servers, two physical, the cluster
> virtual server, and the SQL virtual server. We'll call them SQL1P
> (primary), SQL1F (failover), SQL (cluster virtual server), and SQLV(SQL
> virtual server). All servers have been set up for delegation in AD for
> kerberos, and the sql service account has all of the proper permissions.
> The problem now is that cross server communication with the other SQL
> servers (not in the cluster) will work using standard SQL accounts, but
not
> using windows authentication. Has anyone else had this problem and if so
> how did you resolve it? Thanks in advance for your answers.
>
Labels:
authenticatecross-server,
communication,
cross,
database,
logged,
logins,
microsoft,
mysql,
oracle,
properly,
security,
server,
sql,
user,
windowsauthentication
Subscribe to:
Comments (Atom)