Thanks for the response.
I've got both VS2010 and VS2015 with the CR for VS runtimes installed, on separate machines. I could potentially have any version with my licensing.
It's very difficult to find accurate documentation about the SDK and what's in the Crystal Decisions library, etc.
Using a .NET web application, is there a way to dynamically load a Crystal Report, say from a dropdown list, then have the CrystalReportViewer take care of prompting for any parameters? When I've tried to do this previously it doesn't seem to work so I had to build the parameters into my page...
Just incase anyone finds this, I fixed it via the following code
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ReportSource"] != null)
CrystalReportViewer1.ReportSource = (ReportDocument)Session["ReportSource"];
}
protected void...
I've got a CrystalReportViewer which is showing a report. I'm passing two parameters to it which change the data. This works, unless you try to drill down into the report further, at which point it resets to the default parameters.
It's a bit like the reportviewer element refreshes itself and...
I have always found the performance considerably better when using the SQL command directly (rather than letting Crystal build it). It might be worth a try.
The syntax would be something like this;
select part_no, etc, etc
from inventory_part
where inventory_part.part_no in ({?PART_NO})
Hi,
If you look at the thread I posted recently, I had a similar issue. Some of the formulas there should apply to you as well: http://www.tek-tips.com/viewthread.cfm?qid=1764023
Is there a way to embed database credentials into a report?
My report always prompts for a password when it's first opened, I don't want this to happen.
The other information (database server, database name, username, etc) are populated already. The connection is using the 'Microsoft OLE DB...
I can see why you would think that :)
The criteria is to ensure that results always include records from the very start of the {?Start} date and to the very end of the {?End} date.
For instance if I run the report at 10:05:33 and select the following criteria:
{?Start} = 01/01/2016 10:05:33...
Hi Skip,
My SQL is as follows:
select
CONVERT(varchar(11),[6007EventTime]) as Date
,[6000UserName]
,min([6007EventTime]) as EntryTime
,max([6007EventTime]) as ExitTime
,departmentname
,CONVERT(VARCHAR(12), DATEADD(MS, DATEDIFF(MS, min([6007EventTime]), max([6007EventTime])), 0), 114) AS...
Hi,
Is it possible to set a datetime parameter to always use a particular time?
I have two parameters used in a SQL query which are datetime. It defaults to the current system time of the user selecting the datetime which can cause data to be missing from the report.
I would like {?Start} to...
Pete - thank you that's great!
I've managed to sum the relevant fields now and converted it from seconds using this formula.
WhilePrintingRecords;
Local NumberVar seconds := {@Seconds};
ToText(Truncate(seconds/3600), '#') + ' hour(s), ' + ToText(Remainder(seconds, 3600)/60, '#') + ' minute(s)'
Hi,
Thanks for your help so far.
I've tried this out. The first formula works in terms of bringing back a decimal of the time difference between the two dates. I am able to insert a sum of this and it appears correct. However, I can't get the 2nd formula to work as expected. Either option just...
Hi,
I have a Crystal Report which uses SQL to return some data about swipe in/out times.
My intention is to sum the time difference column in order to see how many hours someone worked over a given time period. However, I'm unable to do this because Crystal won't sum datetime fields (I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.