You can't retrieve the code from it, but you can write new code for it with: ActiveDocument.Sections["yourSection"].Columns.ModifyComputed(yourColumn ...
I am trying to format a date field. My date field is coming in as 20,040,402 I need it be be in the form mm/dd/yy, I tried to change it but it isn't working I...
Go into your request item, click "Options" and change the datatype to date. Hope that helps! Adam Franz Independent Consultant Phone: 603-661-6194 Fax:...
I'm trying to schedule a job, to include all activity from yesterday's date. The date field I am using is in mm/dd/yyyy HH:MM format (it includes the time) ...
You're probably going to want to go with a CustomSQL limit instead or a regular variable limit set at schedule time. The syntax would vary depending on the...
hey guys: not sure how i got in this group. i have been trying to figure out what you guys are talking about. anyway. i am posting out. but you should all...
Hi, I'm having the following problem. I have a query with a variable date. When I run the query from within Brio manually with the date between "05/01/04...
It may be a different question, but it might have the same answer, hehehe. Anyway, the problem is that: between "First of Previous Month" and "Last of Previous...
Thanks for your quick response Adam. I still have 2 issues though. 1. NOW I'm really confused on which dateframe to use if I want all the records from last...
Okay, to answer your questions... 1) You have to decide that. Do you just want data from the previous month or do you want it for the previous month AND the...
Hi, 1) I don't want the first of the current month included, just all data from the previous month. 2) I have this SQL statement: Application.Applicationdate...
I solved it! for anyone who was wondering, the custom SQL statement should be: MONTH(Application.Applicationdate) = MONTH(DateAdd(month, -1, GETDATE ())) AND...
Dear all, I want to do the hierarchical query in Brio. The database server is db2. The example is as below, Sales table company quarter current_quarter_amt ......
HI, we are doing a drug research study, that requires volunteers to have their blood drawn periodically. Each visit number is assigned a number ( 0100, 0200...
Hi, You can add a computed item wherein u define it as Visit0300 - Visti0200 to get the difference in days. SN. ... __________________________________ Do you...
I've created an EIS that I use as a viewer for a line chart. With a couple of dropdowns I control the limits for the underlying data and refresh the chart. I...
Hello, IŽd be pleased if thereŽs anyone having a bit more experience using SQL in Brio. I trying to pull orders that are less of x amount (i.e. 1000 USD) as...
I have a question. Can I have a limit on my Pivot section.? There is a computed item(Flag) in the pivot which gives me a value 'Yes' or 'No'. I would like to...
I have a results section where I am using the Next Function to determine if their are duplicate pricing records for a Customer's product. If there is, I...
create another table off the one with the computed items and then you can limit on it. bqy size growth will be minimal. gary I have a results section where I...
Hi, I have not seen a response so this is how I have solved the problem in SQL -- Select 1 Select company, quarter, current_quarter_amt, 0 Last_quarter_amt ...
Recently, database managers have been concerned about I/O loads on a particular database. In our company there are three known entities that query this...
Adam, What are the \r\n for in the examples you have given below? I am still trying to figure out how to add the multiple selections from the listbox to my...
I think you're still missing the overall concept. You're not adding anything to a limit object or working with a limit object at all. You're using the values...
Hi all: I am not able to remove duplicate rows from results. I have tried goin into Query ->Query Options -> Check Return Unique Rows and then process then...
Are you sure they're duplicates? They might just look like dupes. A good example would be a timestamp that has only the date portion displayed, or a number...
What Version are you on? Why not use PreProcess and PostProcess Events of the Datamodel to send inserts/updates to an Audit table. -Wayne Van Sluys KeyPulse ...
Try this: Create a table: CREATE TABLE LIBNAME.TABLENAME ( RPTNAME VARCHAR(50) NOT NULL, RUNDATE DATE NOT NULL, USERNAME VARCHAR(20) NOT NULL, QRYNAME...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
