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!

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

Recent content by jwaldner

  1. jwaldner

    programmatic access to the no printer flag

    I print reports using a windows service and the invalid printer pop ups cause an exception. Setting the view [no printer option] fixes this but it is easy to miss. is there a way to do this in c#? ReportDocument _report; string _reportPath; string _reportPath; _report = new ReportDocument()...
  2. jwaldner

    editing command query removes parameter descriptions

    I have a report where if I edit the command and save it the parameter values and descriptions get removed; even if I do not edit them at all. I am using XI.5. it would not be a big deal but there are 19 to fill in each time I edit the report. it sucks! I have not noticed this before.
  3. jwaldner

    Access what the default value is for a parameter in code

    Using c# I can get to the list of values for a parameter. is there a way to find out which one of those is the default [in code] so I can set it? thanks!
  4. jwaldner

    Google maps 2 Android 4.1.2 blank

    I am using the maps api and google play services. I have a debug key, I think i have followed all the steps to use the api but my map is blank. Has anyone used the maps api and gotten this? ex: In a class that extends SupportMapFragment: private GoogleMap mGoogleMap; mGoogleMap= getMap()...
  5. jwaldner

    'ARITHABORT

    INSERT failed because the following SET options have incorrect settings: 'ARITHABORT... i get an error only when i run the report in Chrystal Reports. if I run the query in sql it works fine. has anyone ever seen this?
  6. jwaldner

    running total on formula result

    Thanks, this looks like it is just what I need. I'll take it for a spin!
  7. jwaldner

    running total on formula result

    I have a formula like this: DateDiff('s', Minimum({Command.StartTimeStamp}, {Command.KEY}), Maximum({Command.EndTimeStamp}, {Command.KEY})) it returns the seconds between the start and end of an event i have. Works great. but i need a total of this time so I can do average time [in the...
  8. jwaldner

    Datediff Questions

    wow, that's awesome, [60 years] thanks![bigsmile]
  9. jwaldner

    Datediff Questions

    I need precision to be seconds if possible, but the range between the dates could be days... anyone know what the limits are and have ideas on what the best strategies are for dealing with this. I have no problem checking if the time difference is weeks or months and then using a bugger...
  10. jwaldner

    Group data by hour fill data gaps

    That is exactly what I ended up doing, i used a union because I had no unique field to use as a join. but it worked: Thanks for the confirmation! -- loop used to create a table of dates for schedules that span days declare @day datetime declare @hour int set @day = CONVERT(datetime...
  11. jwaldner

    Group data by hour fill data gaps

    I have reports that need to do this, and I know how to do it based on a datetime as long as there is data for the hour in question: So report grouping is based on the hour of the date time then grouped each hour [8.9.10.11.12.1.2,3,4,5,6,7,8] works great. Where i start to have issues is if...
  12. jwaldner

    pie chart problem

    I have a pie chart in an existing report and the legend for it only shows the first series label for each of the colors on the pie. the properties show five items in the list. not sure at all how to fix this, I am fairly new to MSRS and this is a report I did not create, so any help would be...
  13. jwaldner

    distinct count of field where > o

    not sure what you mean, I assume you pick the formula on the summary section, but if my field is an integer and nulls for that field are zeros in the report that would increment the distinct count. If the fields are msgId histId 1, 1 1, 2 1, 3 2, 4 2...
  14. jwaldner

    distinct count of field where > o

    The query does return the right data the problem is that the summary totals are off by a count of each customer that has no message because that customer has a row. I need the distinct count because the results can have more than one row for each message and customer
  15. jwaldner

    distinct count of field where > o

    I have a report that has a totals field that is a distinct count of a particular field in a data set. Works great, but I needed to make changes to the query that resulted in an empty row per client for clients that do not have data. [So clients with no data at least list] Great! but this throws...
See more

Part and Inventory Search

Back
Top