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: jwaldner
  • Content: Threads
  • Order by date
  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

    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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. jwaldner

    Programmatic way to view or change no printer flag

    I am generating and exporting distributing reports as pdfs via a Service and the problem is the dialog boxes that can pop up if some report options are set. I would like to check for or change these flags. Anyone know of a way?
  12. jwaldner

    Problems showing data on same page

    I have been trying to figure this out for hours now. Can't seem to solve it. This should be simple, but I can't get the output I want. I have a report with this layout: grp1 [cust id] grp2 [category] grp3 [Date time] Then details gfooter gfooter gfooter Always the report displays like this...
  13. jwaldner

    repeat group header on each page question

    I have a report group that has a header that has two sections [A and B] 'A' holds the customer name and account that I want to show on each page. B is a summary of all data for that customer. I want to be able to suppress that summary which is why I split the header into two sections. The...
  14. jwaldner

    Group by date is sorting like a string

    I have a report that I am working on that insists on sorting a date field that I am grouping by like its a string. I have confirmed over and over that it is in fact a date field and that it has no display formulas being used that might output as a string. I have tried taking the group out and...
  15. jwaldner

    Way to allow user to pick what fields get added to cross tab

    Does anyone know of a way that I could the user pick the summarized fields that get added to the cross tab without editing the report? I am running out of room for all the fields my users want. I thought maybe I could have a list of parameters available to a user that would somehow tie into...
  16. jwaldner

    suppress a grouping based on parameter

    I thought I had this working in a report by using the section expert to add a formula similar to this in the formula to suppress a header or footer and suppress the drill down: {?Grouping Options} <> 1 the header or footer cannot be seen but the drill down still shows the groups I am trying...
  17. jwaldner

    showing distinct members of a group

    I have data that is grouped by 'teams'. each individual is a member of a team. the grouping is fine but I would like a formula to use as a header of sorts that shows each distinct member of a given team. I do not want the names reflected in the grouping of the report. it's purely informational...
  18. jwaldner

    Put group header and footer on same page

    Is there a way to do this? I see a separate checkbox for each not both together. I thought maybe I needed to use a formula for this.
  19. jwaldner

    new odbc system dsn not showing up in Chrystal reports

    not sure why this is happening but I needed to pick a new dsn depending on circumstances and it is not showing up on the list when I try and add a new one in the database expert. Any ideas?
  20. jwaldner

    New to charts, need a pie

    I have a report thats essentially a list of customers, minutes spent on a specific task with sums at the bottom no groups. I need a pie showing the percentage of time at each task. I can't figure out the expert. It seems to expect groups in order to work. Charts suck!

Part and Inventory Search

Back
Top