I have a query in MS Access that is linked to a searchable report which is linked to a form. Part of the report ask users to include two reasons that will be used as criteria for a query. Currently, the report (screenshot) below does not allow for users to simply enter in 1 reason. Users must enter in 2
Tag: report
How to schedule biweekly SSRS subscription on 2017 report server
I would like my report to be sent biweekly on a Monday. Right now, I created two different subscriptions that sends the report on every 2nd and 4th week. I am not sure it would be accurate considering, I would like the send the report Monday after Pay period ends. What’s a best way to approach to this? Answer A
SQL Report Builder: Issue with SUM in VarChar Column
I’m back with what is probably a very simple question but (as a SQL newbie) I can’t seem to figure it out. I’m basically running a fairly simple report for a hospital. They want a report that details …
Problem with connecting Crystal Reports to SQL Server
I have a problem I am a project worker vb.net 2015 with sql After I cleared the project and tried the project at the client An error appears when the reports are shown by the crystal Report whereas mserver = server mdb = the name of the database muser = username sql mpass = sql password They are retrieved from
How can I count rows into more than one ‘then’ of a Postgres searched case expression? (reporting)
Background I have a Postgres 11 database running on RDS. I need to produce a report which shows counts of events over a certain period, grouping, renaming, and counting them based on description …
Using a query for Single field in Access Report
I am new to access. I have a report with a query(Q1) as its data source. Is it possible to use another query(Q2) only for one field in the same report? My main query is: My report’s structure is like this: As you can see, in the report I group my data using the Lastname column then I show details