Stack Overflow
Stack Overflow

Questions tagged [infomaker]

InfoMaker is a reporting tool to query databases and create custom reports of data.

15 questions
2
votes
0 answers

Encrypt, secure a .ini file for INFOMAKER

I would like to secure or at least hide my server credentials from the .ini file generated when creating an executable file from INFOMAKER. I do not think that I can do anything about the coding of the executables generated from the Infomaker. I am…
Rb Kudo
  • 21
  • 2
1
vote
2 answers

SQL - Omitting/Hide Specific Search Values

I've been having an issue with reports at work lately that we need to pull data but omit a specific sport type from the results. We still need the names and other information to pull, just not a specific sport. We have the report showing: 'Student'…
Jacob Kleiman
  • 13
  • 2
1
vote
1 answer

building sql reports

I’m looking for a report that shows me the bookings summary by location, the data I’m wanting to see is sale amount, Sales order (gm) and Profit %. In a format similar to this Sales Orders - Source Loc ID Sales Orders - Sales Location Sale…
SoTech
  • 41
  • 1
  • 7
1
vote
1 answer

Oracle Week Number from a Date

I am brand new to Oracle. I have figured out most of what I need but one field is driving me absolutely crazy. Seems like it should be simple but I think my brain is fried and I just can't get my head around it. I am trying to produce a Sales…
Jeff
  • 35
  • 3
1
vote
1 answer

Infomaker/Sybase Sum not working

If in sybase - infomaker file - I don't have any groups but since I'm using this to build pages in my software I need to be able to sum values. See attached screenshot. . I would like the totals to be unique (or grouped by the id_key value). The…
YelizavetaYR
  • 1,611
  • 6
  • 21
  • 37
1
vote
1 answer

How to find the future date using SQL query?

I have over 50K people in my system with their DOB under a tablename as Employee and column_name as Birthdate. i have report to generete to find how many people did actually turned 65 until todays date,and somebody turning 65 in future months (…
user255826
  • 41
  • 8
0
votes
0 answers

Sybase Infomaker -- Interdependent Menus, How do I link them?

The infomaker application connects to the SQL Server database. This is where the data comes from (there is a table lets call it LT_DATA). LT_DATA has the following ID PROGRAM Curriculum 1 Elementary Europe 2 Elementary …
YelizavetaYR
  • 1,611
  • 6
  • 21
  • 37
0
votes
0 answers

Migrate Report files from Infomaker/Sybase to SSRS?

How do I export a sybase (infomaker) file pbl file to SSRS file. Basically want to migrate a bunch of infomaker reports to SSRS. Is this possible?
YelizavetaYR
  • 1,611
  • 6
  • 21
  • 37
0
votes
0 answers

I cant figure out what date time format to use for expiration hours

I'm completely new to this and have no background in IT or anything. I don't know how to use SQL although I am currently reading to learn. I'm using infomaker to create a report for work. Currently I'm using existing reports and making modifications…
Greg Chau
  • 11
0
votes
1 answer

Concatenating text data in a column using SQL

Does anyone know how to concatenate all the values of a column in a query using SQL only? I know that there are ways using database specific tools such as pivot, but I don't think I have access to something like that in infomaker. I am using…
Graham Anderson
  • 1,209
  • 10
  • 17
0
votes
1 answer

How should my procedure let the DataWindow know it's not dead?

I have an InfoMaker report that gets results from a stored procedure, but this procedure stalls for a few seconds (intentionally) before returning the result set. When I run and view the report, this causes the PowerBuilder application to freeze…
NReilingh
  • 1,730
  • 17
  • 32
0
votes
1 answer

Only making part of text bold in Powerbuilder expression

Is it possible to make only a specific part of a string bold in a computed field or text object.
Drencrom
  • 31
  • 7
0
votes
2 answers

can i get table name in join select query form ResultSetMetaData

Can I get table name from ResultSetMetaData query is join of multiple tables example select * from table1 , table 2 when I am going to try to retrieve table name from ResultSetMetaData I always founds empty value. Note : I am using informix…
Sharjeel Afzal
  • 145
  • 11
0
votes
1 answer

SQL Summarizing data in final row

I have a query that generates rows of detail information about checks that are issued. In the final output, the data is all concatenated and put into one column (long story short, it needs to be run from Infomaker and exported to text with no…
Jana
  • 61
  • 1
  • 3
  • 9
0
votes
1 answer

Displaying an InfoMaker sub report

I need to display an InfoMaker sub report even when there is no data. The idea is for my customer, who would like to see the header even if there is no data so that they can see that the section has no data. If I hard code the header into the main…
Randy Worrell
  • 33
  • 6