Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jf111
  • Order by date
  1. jf111

    .NET Crystal Report Library

    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.
  2. jf111

    .NET Crystal Report Library

    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...
  3. jf111

    CrystalReportViewer forgetting parameters when drilling down

    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...
  4. jf111

    CrystalReportViewer forgetting parameters when drilling down

    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...
  5. jf111

    Report prompting for password every time

    Windows authentication isn't possible with this database unfortunately. I'll have to try and write a .net application... yay :) Thanks
  6. jf111

    Select record condition with 'IN' affect the speed of my report

    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})
  7. jf111

    Crytstal 2013

    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
  8. jf111

    Report prompting for password every time

    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...
  9. jf111

    Datetime parameter - default times

    Yes I can! That worked perfectly, I don't know why I didn't think of it before. Thank you
  10. jf111

    Datetime parameter - default times

    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...
  11. jf111

    Datetime parameter - default times

    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...
  12. jf111

    Datetime parameter - default times

    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...
  13. jf111

    Calculations using datetime fields

    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)'
  14. jf111

    Calculations using datetime fields

    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...
  15. jf111

    Calculations using datetime fields

    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...

Part and Inventory Search

Back
Top