Hi,
I am using VS.NET2002, Cr 9.1.I created one Report in which i am using pie chart.The problem is that i am getting report on development m/c but when i am running same exe on client m/c it is showing all other text object except Chart (i.e date,page no etc.)
Do i need to put any particular dll or file related to chart on client m/c
any help will be appreciated.....
Regards,
RiteshHi,
I got the solution on other forum.I copied the file sscsdk80.dll to client m/c and it did the trick.........
Ritesh|||Thanks for sharing the solution :)
Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
reg exporting crystal reports to Excel format
Hi Babu,
I have created a report using crystal reports and the template has a field that is formatted with (PrintTime) and another field(File Creation Time). When i export this report to .doc file( using VC++ code) I can see the these fields properly. But when i export to .xls file I get ###### in these fields instead of the actual value. These "######" appear only for the time fields and not for the date fields. Also when the cell is formatted to hold a general value , the cell shows a long number.
Can you help as to what would have caused this problem and how i can rectify this?The "problem" you have is not really a problem, it's how Excel was designed to work.
Excel shows "####" when the column isn't wide enough to show the entire contents.
Excel treats dates as long numbers (probably the number of seconds from a certain date) and it's up to the user to make sure the Cell is formatted to display properly.
As for how to fix it, I'm not sure. You can try Crystal's website to see if you can find an article on formatting Excel Cells and Columns.
http://support.businessobjects.com/search/advsearch.asp|||I have increased the cell size and formatted it for showing time.
The ##### still exists. When i change the cell format to general(a long number) is displayed but in the time format these hashes appear|||You may may not be increasing the width of the column enough. In Excel, assuming that you have the date in cell A1, if you double-click the line that separates the column headers "A" and "B", Excel will automatically resize column "A" to fit the width of the longest Cell in the column. I'm not sure if it will help you in Crystal Reports, but in VB I can achieve this with the following line of code:
xlApp.ActiveSheet.Columns("A:A").EntireColumn.AutoFit|||Try printing Printtime and FileCreationDateTIme in different lines. Maybe it's a data issue. I hope there are no special characters in data. Also try displaying Just YYYY from both fields and slowly slowly try adding mm and dd etc..
THanks
I have created a report using crystal reports and the template has a field that is formatted with (PrintTime) and another field(File Creation Time). When i export this report to .doc file( using VC++ code) I can see the these fields properly. But when i export to .xls file I get ###### in these fields instead of the actual value. These "######" appear only for the time fields and not for the date fields. Also when the cell is formatted to hold a general value , the cell shows a long number.
Can you help as to what would have caused this problem and how i can rectify this?The "problem" you have is not really a problem, it's how Excel was designed to work.
Excel shows "####" when the column isn't wide enough to show the entire contents.
Excel treats dates as long numbers (probably the number of seconds from a certain date) and it's up to the user to make sure the Cell is formatted to display properly.
As for how to fix it, I'm not sure. You can try Crystal's website to see if you can find an article on formatting Excel Cells and Columns.
http://support.businessobjects.com/search/advsearch.asp|||I have increased the cell size and formatted it for showing time.
The ##### still exists. When i change the cell format to general(a long number) is displayed but in the time format these hashes appear|||You may may not be increasing the width of the column enough. In Excel, assuming that you have the date in cell A1, if you double-click the line that separates the column headers "A" and "B", Excel will automatically resize column "A" to fit the width of the longest Cell in the column. I'm not sure if it will help you in Crystal Reports, but in VB I can achieve this with the following line of code:
xlApp.ActiveSheet.Columns("A:A").EntireColumn.AutoFit|||Try printing Printtime and FileCreationDateTIme in different lines. Maybe it's a data issue. I hope there are no special characters in data. Also try displaying Just YYYY from both fields and slowly slowly try adding mm and dd etc..
THanks
Refreshing report problem
Hi,
I did my report under a schema called billing and the new data is in schema called inteltest. Even i connect to the crystal reports using inteltest in the sql query it shows schema as billing4 . please help meHi, In the report goto File and see "Save Data wtih Report" option. If it is checked then uncheck it and save the report
Madhivanan
I did my report under a schema called billing and the new data is in schema called inteltest. Even i connect to the crystal reports using inteltest in the sql query it shows schema as billing4 . please help meHi, In the report goto File and see "Save Data wtih Report" option. If it is checked then uncheck it and save the report
Madhivanan
Refresh with jsp doesnt work
Hi!
I've created a simple jsp page with a crystal report viewer on it. I used Crystal Reports Developer to design the report, as db I use access and IBM WSED to create and run the jsp file on a server. That works fine, but when I would refresh the report it shows no recordset (and also no error message appears). Why I can't refresh the data?
The code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@. page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,com.crystaldecisions.sdk.occa.report.reportsource.IReportSource"
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
CrystalTest.jsp
<%
try {
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
String report = "/CrystalReport/Report1.rpt";
Object reportSource = rptSrcFactory.createReportSource(report, request.getLocale())
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setOwnPage(true);
viewer.setTop(80);
viewer.setDisplayGroupTree(false);
viewer.setHasLogo(false);
viewer.setHasRefreshButton(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
viewer.dispose();
} catch(Exception e)
{
out.println("CrystalTest: "+e);
}
%>
</BODY
</HTML>hi there!
I've now solved the problem with a jdbc/db2 connection.
The solution is, that I must connect the Crystal Report with jdbc/db2 to the database and also connect in java/jsp to the database as the follows (only samplecode from helpfile):
setDbLogonViewReport.jsp
<%@. page import= "com.crystaldecisions.report.web.viewer.*,
com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.report.web.viewer.*" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%
Object reportSource = session.getAttribute("reportSource");
if (reportSource == null)
{
String report = "/reports/sample.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = rptSrcFactory.createReportSource(report, request.getLocale());
session.setAttribute("reportSource", reportSource);
}
ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("reportLogin");
connInfo1.setPassword("");
connInfos.add(connInfo1);
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
&n bsp; viewer.setEnableLogonPrompt(false);
viewer.setDatabaseLogonInfos(connInfos);
if (session.getAttribute("refreshed") == null)
{
viewer.refresh();
session.setAttribute("refreshed", "true");
}
viewer.setOwnPage(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
%>
Ask if you've more questions to that.
I've created a simple jsp page with a crystal report viewer on it. I used Crystal Reports Developer to design the report, as db I use access and IBM WSED to create and run the jsp file on a server. That works fine, but when I would refresh the report it shows no recordset (and also no error message appears). Why I can't refresh the data?
The code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@. page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,com.crystaldecisions.sdk.occa.report.reportsource.IReportSource"
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
CrystalTest.jsp
<%
try {
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
String report = "/CrystalReport/Report1.rpt";
Object reportSource = rptSrcFactory.createReportSource(report, request.getLocale())
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setOwnPage(true);
viewer.setTop(80);
viewer.setDisplayGroupTree(false);
viewer.setHasLogo(false);
viewer.setHasRefreshButton(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
viewer.dispose();
} catch(Exception e)
{
out.println("CrystalTest: "+e);
}
%>
</BODY
</HTML>hi there!
I've now solved the problem with a jdbc/db2 connection.
The solution is, that I must connect the Crystal Report with jdbc/db2 to the database and also connect in java/jsp to the database as the follows (only samplecode from helpfile):
setDbLogonViewReport.jsp
<%@. page import= "com.crystaldecisions.report.web.viewer.*,
com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.report.web.viewer.*" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%
Object reportSource = session.getAttribute("reportSource");
if (reportSource == null)
{
String report = "/reports/sample.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = rptSrcFactory.createReportSource(report, request.getLocale());
session.setAttribute("reportSource", reportSource);
}
ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("reportLogin");
connInfo1.setPassword("");
connInfos.add(connInfo1);
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
&n bsp; viewer.setEnableLogonPrompt(false);
viewer.setDatabaseLogonInfos(connInfos);
if (session.getAttribute("refreshed") == null)
{
viewer.refresh();
session.setAttribute("refreshed", "true");
}
viewer.setOwnPage(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
%>
Ask if you've more questions to that.
Friday, March 23, 2012
Refresh problem in Crystal Viewer control
Dear Guru's
I am using Crystal viewer control in my VC++ application project. Here i am facing report refresh problem. If i call viewer control Refresh method directly the application is crashing. I am calling that inside OnPaint( ) .
The problem is the report data is not displaying first time the user has to click refresh button.
Please help me how to use "Refresh " method.
Thanks
arunNot sure if this will help, but make sure 'Save Data with Report' is NOT checked. Otherwise, have you tried calling Refresh as soon as the report is displayed (instead of waiting for the user to do it)?|||I am trying to refresh the report through code only using Viewer control 'Refresh' method.
If report displayed with blank then how user came to know that he has to refresh the report by clicking refresh button.
I am using Crystal viewer control in my VC++ application project. Here i am facing report refresh problem. If i call viewer control Refresh method directly the application is crashing. I am calling that inside OnPaint( ) .
The problem is the report data is not displaying first time the user has to click refresh button.
Please help me how to use "Refresh " method.
Thanks
arunNot sure if this will help, but make sure 'Save Data with Report' is NOT checked. Otherwise, have you tried calling Refresh as soon as the report is displayed (instead of waiting for the user to do it)?|||I am trying to refresh the report through code only using Viewer control 'Refresh' method.
If report displayed with blank then how user came to know that he has to refresh the report by clicking refresh button.
Refresh of Data in Crystal Report
Hello,
I'm developing Crystal Report and data is being fetched using Query. Now each time I "run" report, I get stale data. I tested query several times and that is working fine.
I also checked that,
1. File->Report Options-> Save Data with Report is UNChecked.
2. File->Options->Reporting->Save Data with Report is UNChecked.
3. File->Options->Reporting->Discard Saved Data while Loading Report is Checked.
Whenever I open report, I only see Design tab and no Preview tab. however, on running report, I get stale data. Please let me know if you know solution to this problem.
Thanks a lot in Advance,
Regards,
RupeshI am having a very similar problem. I just gave one of our users a new computer. She was running windows 2000 and she is now running windows xp. I installed crystal reports for her and imported all of her ODBC settings from the old computer to the new computer. There are two crystal reports that when she opens them, it only shows the "design tab", but no "preview tab". When I go back and open those two reports from her old computer, they open fine. I see that nobody responded to your post. Did you ever find a solution to the problem?
Thanks - Jeff|||Rupsan,
What do you mean by stale data?
Also what Ver are you using?
Texasman,
The reason your preview tab does not show up is because the savedata box is not checked in report options.|||ya exactly dear when you uncheck the save data you don't find any preview tab if you want preview click on print preview in report you will find it.
and rupsan i also don't understand what stale data means.
thanks|||I have the same issue. I have unchecked (and checked) the appropriate boxes as did the OP. On open, I do not get a preview tab (This is what I expected). However, on refresh the data on my report is last weeks data. I looked directly at the data table and there have been several additional entries that are not shown on the report. I have disconnected and reconnected to the databse, all to no avail. Can anyone figure this out?? Thanks.
I'm developing Crystal Report and data is being fetched using Query. Now each time I "run" report, I get stale data. I tested query several times and that is working fine.
I also checked that,
1. File->Report Options-> Save Data with Report is UNChecked.
2. File->Options->Reporting->Save Data with Report is UNChecked.
3. File->Options->Reporting->Discard Saved Data while Loading Report is Checked.
Whenever I open report, I only see Design tab and no Preview tab. however, on running report, I get stale data. Please let me know if you know solution to this problem.
Thanks a lot in Advance,
Regards,
RupeshI am having a very similar problem. I just gave one of our users a new computer. She was running windows 2000 and she is now running windows xp. I installed crystal reports for her and imported all of her ODBC settings from the old computer to the new computer. There are two crystal reports that when she opens them, it only shows the "design tab", but no "preview tab". When I go back and open those two reports from her old computer, they open fine. I see that nobody responded to your post. Did you ever find a solution to the problem?
Thanks - Jeff|||Rupsan,
What do you mean by stale data?
Also what Ver are you using?
Texasman,
The reason your preview tab does not show up is because the savedata box is not checked in report options.|||ya exactly dear when you uncheck the save data you don't find any preview tab if you want preview click on print preview in report you will find it.
and rupsan i also don't understand what stale data means.
thanks|||I have the same issue. I have unchecked (and checked) the appropriate boxes as did the OP. On open, I do not get a preview tab (This is what I expected). However, on refresh the data on my report is last weeks data. I looked directly at the data table and there have been several additional entries that are not shown on the report. I have disconnected and reconnected to the databse, all to no avail. Can anyone figure this out?? Thanks.
Friday, March 9, 2012
Reference Book Needed
I'm a consultant with 20+ years of experience. With Crystal Report Writer,
I just sat down and starting playing with it to figure it out, but now I am
confronted with using SQL Reporting Services 2005.
It is definitely giving me a shot of humility because I am finding it the
most frustrating experience ever. I purchased a pretty good book written by
Brian Larson, but it is presented in a procedural format, and is not being
very helpful when I have something specific to accomplish. I'm also trying
to use the online help and newsgroups, but the process is painstakingly
slow.
My challenge of the moment is in constructing a date range expression, but I
am also stuck on the parameters of the format function. I loved Crystal in
that I could use the wizard to give me a jump start with the formatting, and
then could edit it into more advanced queries.
Can anyone offer any suggestions on where I could find a good SQL Reporting
Services reference? I'm open to anything at this point -- website, book,
notes scribbled on a napkin...I know what you mean about books with references instead of walking through
the procedures. I bought Hitchhiker's Guide to SQL Server 2000 Reporting
Services by Peter Blackburn, William R. Vaughn , because I've read some good
reviews about it, and I liked the title and SQL Server 2000 Reporting
Services Step by Step Book/cd Package by S Misner because it came cheap with
the other one. I think I bought them too late, as they focus on how to do
the things I already knew how to do, and the references are poor. But when I
go through them, I can find things that I didn't know. Out of the two, only
one has been updated, "SQL Server 2005 Reporting Services Step by Step" by
S. Misner.
http://www.amazon.co.uk/Server-2005-Reporting-Services-Step/dp/0735622507/sr=1-1/qid=1160306842/ref=sr_1_1/026-7617136-7864435?ie=UTF8&s=books
You might want to check any reviews for it first, as it seems to be a
beginner's book.
My main source of information about Reporting Services has been articles
written by William E. Pearson, III
http://www.databasejournal.com/article.php/1459531
I started reading his articles when I started working with RS in 2004, and
got most of the basics from him. The first tutorials are based on SQL Server
2000 and RS 2000, but the later ones are based on RS 2005. Most of what he
writes about the 2000 edition still holds for 2005, though, so they're not
entirely useless.
I also find Brian Welcker's blog "Direct Reports" usefull
http://blogs.msdn.com/bwelcker/default.aspx
And from his blog you find links to other good RS blogs like Tudor's weblog
(http://blogs.msdn.com/bwelcker/default.aspx) and Chris Hay's Sleazy Hacks
(very usefull, http://blogs.msdn.com/ChrisHays/)
But whenever I need help to find out how to do something, I use the RS news
group. I know there's a forum for it as well, but it wasn't very active when
I started working with RS, and it's hard to teach old dogs new tricks. A lot
of answers can be found in old ng posts, and if you can't find it, ask and
you might get an answer. It's slow, I know, but when you figure out the
basics and the differences from Crystal Reports, it gets better.
Kaisa M. Lindahl Lervik
"Cindy Mikeworth" <CindyMikeworth@.newsgroups.nospam> wrote in message
news:uXbqlNk6GHA.4496@.TK2MSFTNGP05.phx.gbl...
> I'm a consultant with 20+ years of experience. With Crystal Report
> Writer, I just sat down and starting playing with it to figure it out, but
> now I am confronted with using SQL Reporting Services 2005.
> It is definitely giving me a shot of humility because I am finding it the
> most frustrating experience ever. I purchased a pretty good book written
> by Brian Larson, but it is presented in a procedural format, and is not
> being very helpful when I have something specific to accomplish. I'm also
> trying to use the online help and newsgroups, but the process is
> painstakingly slow.
> My challenge of the moment is in constructing a date range expression, but
> I am also stuck on the parameters of the format function. I loved Crystal
> in that I could use the wizard to give me a jump start with the
> formatting, and then could edit it into more advanced queries.
> Can anyone offer any suggestions on where I could find a good SQL
> Reporting Services reference? I'm open to anything at this point --
> website, book, notes scribbled on a napkin...
>
I just sat down and starting playing with it to figure it out, but now I am
confronted with using SQL Reporting Services 2005.
It is definitely giving me a shot of humility because I am finding it the
most frustrating experience ever. I purchased a pretty good book written by
Brian Larson, but it is presented in a procedural format, and is not being
very helpful when I have something specific to accomplish. I'm also trying
to use the online help and newsgroups, but the process is painstakingly
slow.
My challenge of the moment is in constructing a date range expression, but I
am also stuck on the parameters of the format function. I loved Crystal in
that I could use the wizard to give me a jump start with the formatting, and
then could edit it into more advanced queries.
Can anyone offer any suggestions on where I could find a good SQL Reporting
Services reference? I'm open to anything at this point -- website, book,
notes scribbled on a napkin...I know what you mean about books with references instead of walking through
the procedures. I bought Hitchhiker's Guide to SQL Server 2000 Reporting
Services by Peter Blackburn, William R. Vaughn , because I've read some good
reviews about it, and I liked the title and SQL Server 2000 Reporting
Services Step by Step Book/cd Package by S Misner because it came cheap with
the other one. I think I bought them too late, as they focus on how to do
the things I already knew how to do, and the references are poor. But when I
go through them, I can find things that I didn't know. Out of the two, only
one has been updated, "SQL Server 2005 Reporting Services Step by Step" by
S. Misner.
http://www.amazon.co.uk/Server-2005-Reporting-Services-Step/dp/0735622507/sr=1-1/qid=1160306842/ref=sr_1_1/026-7617136-7864435?ie=UTF8&s=books
You might want to check any reviews for it first, as it seems to be a
beginner's book.
My main source of information about Reporting Services has been articles
written by William E. Pearson, III
http://www.databasejournal.com/article.php/1459531
I started reading his articles when I started working with RS in 2004, and
got most of the basics from him. The first tutorials are based on SQL Server
2000 and RS 2000, but the later ones are based on RS 2005. Most of what he
writes about the 2000 edition still holds for 2005, though, so they're not
entirely useless.
I also find Brian Welcker's blog "Direct Reports" usefull
http://blogs.msdn.com/bwelcker/default.aspx
And from his blog you find links to other good RS blogs like Tudor's weblog
(http://blogs.msdn.com/bwelcker/default.aspx) and Chris Hay's Sleazy Hacks
(very usefull, http://blogs.msdn.com/ChrisHays/)
But whenever I need help to find out how to do something, I use the RS news
group. I know there's a forum for it as well, but it wasn't very active when
I started working with RS, and it's hard to teach old dogs new tricks. A lot
of answers can be found in old ng posts, and if you can't find it, ask and
you might get an answer. It's slow, I know, but when you figure out the
basics and the differences from Crystal Reports, it gets better.
Kaisa M. Lindahl Lervik
"Cindy Mikeworth" <CindyMikeworth@.newsgroups.nospam> wrote in message
news:uXbqlNk6GHA.4496@.TK2MSFTNGP05.phx.gbl...
> I'm a consultant with 20+ years of experience. With Crystal Report
> Writer, I just sat down and starting playing with it to figure it out, but
> now I am confronted with using SQL Reporting Services 2005.
> It is definitely giving me a shot of humility because I am finding it the
> most frustrating experience ever. I purchased a pretty good book written
> by Brian Larson, but it is presented in a procedural format, and is not
> being very helpful when I have something specific to accomplish. I'm also
> trying to use the online help and newsgroups, but the process is
> painstakingly slow.
> My challenge of the moment is in constructing a date range expression, but
> I am also stuck on the parameters of the format function. I loved Crystal
> in that I could use the wizard to give me a jump start with the
> formatting, and then could edit it into more advanced queries.
> Can anyone offer any suggestions on where I could find a good SQL
> Reporting Services reference? I'm open to anything at this point --
> website, book, notes scribbled on a napkin...
>
Subscribe to:
Posts (Atom)