Search found 10 matches

by ssteketee
Thu Dec 19, 2019 5:09 pm
Forum: Stimulsoft Reports.Flex
Topic: Sub-report with "Use External Report" cannot get to work
Replies: 3
Views: 11385

Sub-report with "Use External Report" cannot get to work

Hi, all. I have a simple report, calling just a couple fields from a table, the where statement filters the data to just one record, the fields placed in to the databand and a sub-report placed in the databand that has been set to "not assigned," a URL to the subreport entered, and use ext...
by ssteketee
Tue Nov 05, 2019 8:04 pm
Forum: Stimulsoft Reports.Flex
Topic: "Save a copy" of datasource with alias
Replies: 5
Views: 12597

Re: "Save a copy" of datasource with alias

To copy the source databand, I open the SQL statement and click the "make a copy" box. This creates a copy of the databand and it is automatically named as Source1Copy with source1Copy also as the alias. But when I next copy the original databand, the fields are not update to include "...
by ssteketee
Fri Oct 25, 2019 2:36 pm
Forum: Stimulsoft Reports.Flex
Topic: "Save a copy" of datasource with alias
Replies: 5
Views: 12597

Re: "Save a copy" of datasource with alias

Thank you for your reply! These are the steps: 1. Create report with a datasource called source1 and with the datasource alias as data 2. In SQL statement, select field from source1 called field1 3. Retrieve or create field1 4. Place field1 in databand of source1 5. Field1 is placed as "source1...
by ssteketee
Fri Oct 18, 2019 4:38 pm
Forum: Stimulsoft Reports.Flex
Topic: "Save a copy" of datasource with alias
Replies: 5
Views: 12597

"Save a copy" of datasource with alias

Hi. I am a novice user and am trying to use the "save a copy" feature in the "edit data source" window to make multiple copies of a datasource in a report. What I would like to be able to do is copy the fields on the original databand to the new databand without having to update ...
by ssteketee
Thu Aug 15, 2019 1:04 am
Forum: Stimulsoft Reports.Flex
Topic: Date expression in conditional format
Replies: 1
Views: 10278

Date expression in conditional format

What would be the expression in a conditional format expression to say display the STATUS field in red text if the STARTDATE field is up to two days before today or today or any day after today? I thought it would be something like: source.STARTDATE > dateadd(dd,-3,datediff(dd,0,getdate())) . But th...
by ssteketee
Tue Jan 22, 2019 2:00 am
Forum: Stimulsoft Reports.Flex
Topic: Connection/data source from local SQL Server
Replies: 7
Views: 20348

Connection/data source from local SQL Server

I am a novice in working with Stimulsoft and SQL but so far so good, have made some great reports so far. Am trying to add a second data source to a report and this second data source is located on my local workstation currently. I have the data in several different formats just trying to get someth...
by ssteketee
Tue Jan 15, 2019 1:27 am
Forum: Stimulsoft Reports.NET
Topic: Data Source Parameter size reverts to zero
Replies: 1
Views: 884

Data Source Parameter size reverts to zero

Hi. When I create a parameter from the "Edit Data Source" window, no matter what type of parameter I select, when I change the size from the default of zero to another size and exit the size field, the number in the size field reverts to zero. Specifically, I am trying to set the size to 6...
by ssteketee
Tue Jan 15, 2019 1:17 am
Forum: Stimulsoft Reports.NET
Topic: Easier way to generate list of all fields in a table than SELECT * and placing
Replies: 3
Views: 1394

Re: Easier way to generate list of all fields in a table than SELECT * and placing

Thank you for your reply! Maybe I posted in the wrong area because my Stimulsoft Report Writer screens don't look like anything on the schema wizard link in your post. I am working in Stimulsoft Reports v 2018.1.8 from 19 February 2018, ASP.NET, Flex . When I click to add a data source, I don't have...
by ssteketee
Mon Jan 14, 2019 1:12 am
Forum: Stimulsoft Reports.NET
Topic: Easier way to generate list of all fields in a table than SELECT * and placing
Replies: 3
Views: 1394

Easier way to generate list of all fields in a table than SELECT * and placing

I am a very novice SQL and Stimulsoft person. I would like to create a reference of all the fields in each database with the field type and length. I can do a SELECT * on each database and then place all retrieved fields on a report manually. But is that the only way? Some of the databases have hund...